WORD BASICS: MICROSOFT OFFICE GETTING STARTED View our full schedule, handouts, and additional tutorials on our website: echecs16.info What's New in Word Microsoft Word you can create your own training .. PDF format allows you to share your document with users on any platform. Save documents as PDF (Portable Document Format) files. You may want also Word Tutorials Microsoft Word Quick Styles and Quick Style Sets.
|Language:||English, Spanish, French|
|ePub File Size:||21.45 MB|
|PDF File Size:||18.14 MB|
|Distribution:||Free* [*Register to download]|
resources for you. To participate in a brief online survey, please visit: www. echecs16.info What do you think of this book?. intermediate level guide, Microsoft Word An Intermediate Guide. . Type training tutorial on the IT Services PCs (you can also download a copy for a personal. Microsoft Word Course Contents: • Lesson 1: Get to know the Ribbon. • Lesson 2: Find everyday commands. The lesson includes a list of suggested tasks.
General Information. Cell Reference Relative, Absolute, Mixed iv. PDF created with pdfFactory trial version www. ISBN: Click cash.
To apply a drop cap, first place your cursor anywhere in the paragraph that you want the drop cap to appear. Then, click the Insert tab. Next, click the Drop Cap button and choose Dropped which places it in the paragraph or Margin which places it beside the text.
To remove a drop cap, place your cursor in the paragraph, click the Insert tab, choose Drop Cap, and click None. Applying a Quick Style So far, we have talked about many types of formatting. However, one of the great new features of Microsoft Office Word is the styles built right in. A style can include fonts, formatting, colors, and borders and shading. There are two parts to the styles in Word. The first part is the Quick Style Gallery, which we have used already. This is composed of the styles that you can see on the Styles group of the Home tab.
Word places the most frequently used styles here for quick access. To apply any of these styles, simply select the text that you want to format and click a style. There are many more styles available than the ones you see here. The first option, Style Set, lets you choose another group of styles.
The second option lets you choose another color scheme. The third option lets you choose another font scheme. Note that fonts and colors will not work with all style sets. You can choose a different color scheme from the Colors list to easily customize the style. You will find these buttons on the Paragraph group of the Home tab. Each type of alignment indicates which margin the text lines up with. From left to right, you can apply left alignment, center alignment, right alignment, or justification where the text is spread out to take up the whole line.
Simply select the text that you want to apply the alignment to, and then click the appropriate button. Note that one type of alignment must be selected at all times. Note how the justified paragraph looks very similar to the left aligned paragraph. Look closer, however, at the second line. A font is a complete set of characters with typeface and style that you use to type. Some fonts are all capitals. Other fonts are all symbols. Fonts are really customizable: you can change their size, type, colour, spacing, and effects.
The fonts that you have available in Word depend on what other applications you have installed and if you have installed any extra font packages. Remember that font settings types, sizes, effects, spacing, etc. Choosing a Font Type To choose a font type, first select the text that you want to apply the font to. Then, click the Font drop- down menu and select the font that you want to apply. As you scroll over the font, you will see a preview being applied to your text. Choosing these fonts will help keep your document consistent.
Word also stores your recently used fonts near the top of the list. If you know what font you want, you can type it into the drop-down list. Word will automatically complete the font name for you; press Enter to accept its selection.
The font face commands are also available on the mini toolbar. Changing the Font Size You can change your font size the same way: select a size from the menu or type a size in the box. If you choose to use the menu, you will see a preview as you scroll through the sizes.
The font size commands are also available on the mini toolbar.
Applying Font Color To change your font color, select the text that you want to change. Then, pick a color from the list.
Once again, you will see a preview of the color applied to your text. Once you see a color you like, click it to apply it. This can help you keep your document looking consistent and professional. You can also choose a standard color or click More Colors to pick a custom color. As you might expect, the Font Color command is also available on the mini toolbar. Applying Highlighting In addition to the main font color, you can also apply highlighting to text.
Create and edit charts and graphics. If you do find a slight difference between what you see in the Video Lectures that use Excel and your Excel user interface, post a message to me in theand advanced features available in Microsoft Excel Course goals: Provide high level of understanding and practical hands on experience using basic and advanced Excel capabilities, from standard usage, cell formatting, function, charts, pivot tables and up to the basic usage of Macros.
Results 1 - 12 of 12 1 Creating a new excel workbook. Microsoft Excel is much more than a quick way to add up numbers. Candidates can download the syllabus in PDF format from the official website. Spreadsheets Syllabus 6. Creating Workbooks and Organizing Data 1. Course syllabus. Renaming A Worksheet 5. Function Basics. Microsoft Office Specialist exams are provided by a third-party vendor.
Beginning Microsoft Office Spring Any late assignments, receive an automatic five point reduction for each day the assignment is late. How to open an existing document. Contents: Unit — I. Start MS Excel , Basics b. All tutorials are super practical and include free exercises. MS Excel. Share and review shared document files. Manonmaniam Sundaranar University Syllabus This lesson plan template for Microsoft Excel is a contribution from Debra Miller. Such a structure is called a Spreadsheet.
Part B. Objectives: The objectives of this course are to provide delegates with a brief review of Microsoft Excel basics and then introduce the intermediate features of Excel. Step 3: If you are sure of which chart you have to use, you can choose a Chart and proceed. Microsoft Excel , Excel , Excel Your course syllabus is found in the table below. If you havent used Excel before, try our Basic course, or the beginner to advanced lessons in our combined Basic and Advanced course.
It was first launched by Bill Gates on 19th November soon after the launch of Microsoft Windows. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.
Our course authors have drawn on their experience in accountancy, analysis, business strategy and leadership to select a focused, practical syllabus. Examine word processing concepts and explore the Microsoft Office Word environment. For example, a serial number that is when converted to a date represents 7 Dec, Insert clip art and pictures to documents. Part C. Searching And Replacing Data 5. For Microsoft Word. Mastering Microsoft Office Made Easy features video lessons with over 42 hours of introductory through advanced instruction.
Jpeg, mp3, pdf. Browse the exam list to find details about skills measured, and then click the buttons or exam names to connect to preparation materials or schedule an appointment to take the exam with an exam provider. Students will learn to manage workbooks as well as how to manipulate and format data.
The questions computer networks answers pdf State of Vermont ap. Sub Topic. Most things for this statistics class will not change between the two versions. Excel will search for functions that might perform the job; or b If you prefer, and if you know the name of the function, you can drop down a list and select a category.
The cell is highlighted and 18 appears in the formula bar. So you need Microsoft Excel lesson plans for middle school students? Microsoft Excel is the most commonly used spreadsheet application.
What you get with this Microsoft Excel course: modules of training full syllabus below , covering the most business-relevant areas of Microsoft Excel. Asm study manual for exam mlc pdf examgetnet, weishaus asm study include a formula sheet, digital flashcards, an Actuarial Excel Skills webinar, free. Course Syllabus. Advance Excel syllabus. Successful candidates for the Microsoft Office Specialist Excel fundamental understanding of the Excel environment and the ability to complete tasks.
When you type a time into a cell in Excel, the underlying value is a fraction, but Excel interpretsBasic Formulas in Excel. Please use this syllabus as a reference only until the professor opens the classroom and you have access to the updated course syllabus.
Ctrl Tab Move between two or more open Excel files. Advanced Business Productivity Software. During this 10 hour Excel tutorial, our expert instructor shows how to effectively create and format spreadsheets, charts, pivot tables and much more.
Learn to use functions and formulas. This tutorial cover in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.
However, I managed to find a few Microsoft Excel projects, lessons, and resources that are pretty current. In the File Name list, type or select a name for the file.
Microsoft Office is used by nearly every employer in the world and the more extensive your skills with the application suite, the more attractive a candidate you are when applying for jobs. Page 1 of Theyre in PowerPoint format, so you can customize them for group training or view them on your desktop. Read this tutorial carefully 1. Office Excel. Move the mouse pointer to the formula bar and click once to the right of Microsoft Office is a closed-source software office suite containing different applications.
Android and Apple related news. Right below you find tutorials for Excel Windows. OF MS Excel. It was first coined in MS Access. This course is designed to give users a good introduction to the basic concepts of Excel. Range of Cells ii.
MS Word. MS Project. Identify and utilize the appropriate formatting for data in Excel 4. Importance of a Cell, Range of Cells i. We have nearly 1 million students in total, k of those have had MS Excel. With Excel, you can create visually appealing content that represents your data.
The syllabus is the very important part of the examination to prepare well and score good marks in the examination. This is an ultimate guide to learn Excel VBA. The equivalent of MS Excel Chapter 3 from a different book, review and continuation: Performing calculations on data.
Lecture, 2 hours per week; lab, 2 hours per week. Course Objective: You will create and edit basic Microsoft Office Excel worksheets and workbooks. Types of reference. But you also dont want to overload students with so many options that they forget everything they learn.
To get back to this view, you can click the Print Layout button on the View tab or on the right hand side of the status bar. As you might imagine, full screen reading layout is best used when you want to read a document.
Like other views, you can switch to it using the status bar or the View tab. You also have a Tools button that offers a menu of editing commands. In the middle, you can see which screen you are on and navigate through the screens. Then, on the right, you have a menu of view options and a Close command. If you close this view, you will return to Print Layout.
This command shows you what your document will look like if it was published as a Web page. You can switch to Outline View the same way we have switched to other views: You can see that our text box has been removed, for example. You can also see that we have a new Outlining tab.
We will take a closer look at all of these tools in the Expert manual. Another handy tool is Zoom. This tool lets zoom in or out of your document to see it close up or far away. First, we will look at the Zoom commands on the View tab.
To use any of these commands, simply click the icon. In the last lesson, we learned that the first five buttons change the type of view you are in. You can also use the slider to zoom in or out of the document. Or, click the plus or minus buttons to zoom in or out respectively by ten per cent increments.
If you want to set advanced zoom options, click the Zoom button on the View tab, or click the percentage in the status bar. You can choose a percentage, page width, or number of pages from the top of the dialog.
Or, you can type a percentage in the text box. No matter what your choice, you will see a preview at the bottom of the dialog. Typically, the small arrows at the bottom of the vertical scroll bar let you browse from page to page. Or navigating through comments? To change what the browse arrows look through, click the small dot between them.
There is a special module of the View tab that lets you customize what elements appear on your screen. We have already worked with the ruler when adding tabs and indents. You can also add gridlines to the screen; this can help when arranging objects. The next item is the message bar. This pane literally gives you a map of your document based on headings. In this sample, we can see that we have Octopi, Habitat, Appearance, and Relatives as main topics in this document.
There are two ways you can view thumbnails. If you have the document map open, you can choose Thumbnails from the task pane menu. If you have a lot of pages in your document, you can use the scroll bar to scroll up and down in the list.
When you type anything, even a space, a character appears on the screen. The symbols for certain characters such as spaces and paragraph marks are usually hidden. This will then make all the hidden characters in your document appear.
Although creating documents in Word is great, there will be times when you want to print out a paper copy. Before you print, however, you should make sure that everything looks OK. Note that all default tabs have disappeared, but you still have the status bar and the scroll bar. Print Print Opens the Print dialog, which we will look at shortly.
Options Opens the Display module of. Page Setup Margins Change the white spacearound the edge of the page. Orientation Change the direction that text. Size Change the size of the page. Option button Opens the Page Setup dialog. Zoom Zoom Opens the Zoom dialog. Page Width View the page width. Magnifier Turns your cursor into a. Next Page Goes to the next page. Previous Page Goes to the previous page. To move through the pages in your document in print preview, you can use a few different tools.
Like the editing window, you can use the browse arrows, scroll bars, or the scroll wheel on your mouse to move between pages. To close Print Preview and return to editing view, press the Esc key on your keyboard, or click Close Print Preview on the Preview group of the tab.
In the last lesson, we learned how to look at your document. But what if there are some changes you need to make? Click this button to see a menu of preset margins. You can also click Custom Margins to open the Page Setup dialog.
Click this button to see a menu of preset paper sizes. Insert line, page, or module breaks. We will learn about these tools in the Intermediate manual. To change the margins, click the Margins button on the Page Setup group and pick a preset size. As you can see, with portrait orientation the paper would be printed on with the long side vertically. With landscape orientation, the paper would be printed on with the long side horizontally.
If you want to change this, however, you can do so using the Size command. Simply click the Size button on the Page Setup group and click the size that you want. As we saw, you can open it from the Size or Margin menus. You can also open it by clicking the option button in the bottom right hand corner of the group.
Set the paper size and source.
Set advanced options including module options, header and footer configuration, and page alignment. This tab also contains commands for line numbers and page borders. Each tab also has a preview area where you can see the effects of your changes before you apply them and a Default button so that you can make every new document have the current page settings.
There are a few ways you can print your document. The Quick Print icon will send the document directly to the printer, while the Print icon will open the Print dialog. The more conventional method is to use the Print module of the Office menu. Clicking the Print command in the main menu or the sub-menu will open the Print dialog.
Clicking Quick Print will send the document directly to the printer without specifying any options. Clicking Print Preview will open that window, which we looked at in Lesson 6. Our first set of options is Printer. Here, you can choose your printer, choose to print to a file, or choose manual duplex print pages on both sides manually.
The next set of options is Page Range. Here you can choose to print all pages, the current page, or just a selection. You can also click the Pages command and enter page numbers.
You can also combine these commands. For example, you could type 1,3,5,, to print pages one, three, five; pages nine to eleven; and page seventeen to the end of the document. Our next module lets you choose the number of copies you want to print and if you want to collate keep each copy of the document together them. Our last module lets you zoom into or scale pages.
You may have noticed an Options button at the bottom of the Print dialog. Clicking that button will open the Word Options dialog:. As you can see, you can choose to print or hide particular elements of your document. These options are particularly useful when printing drafts.
To set options specific to your printer, click the Properties command in the top right hand corner of the Print dialog.. Typically, you will have options for color settings, page size, and paper type. Flag for inappropriate content. Related titles. Jump to Page. Search inside document. This is where you will create your document. Use this bar to scroll up and down in your document.
Interacting with Word We talked a little bit about the different ways to use the different parts of the interface above. Icons Just like icons on your desktop, Word icons are small buttons with pictures that represent actions. If you put your mouse over an icon, a small box will pop up telling you what it does, like this: Drop-down menus: The Basics of Selecting Text Selecting text simply means to highlight or identify text.
Navigating Using the Mouse To navigate using your mouse, simply click where you want to place your focus. Navigating Using the Keyboard You can also use keyboard shortcuts to navigate. Four of these keys have special functions: The first is by clicking the arrow next to the Find button on the Home tab and clicking Go To: First, select your text. Then, follow the steps for the type of formatting you want to apply: You can also click the format command to turn it on before you type text.
Now, click the format command again to turn it off. Here is what they look like. Strikethrough Subscript Super script Their application is the same as the basic effects: If we click the Undo button, the text will be removed. Removing Formatting We just used Undo to clear all the formatting from our text. Working with Your Document So far, we have learned how to create documents, but we have been creating documents from scratch. Saving Files To save a file for the first time, you can click the Save icon on the Quick Access toolbar, press the Ctrl and S keys, or click the Office menu and click Save.
Any of these options will open the Save As dialog: Opening Files There are a few ways to open Word documents. The first is to find the file and double-click it. To unpin the document, simply click the pin again. Switching Between Open Files If you have several Word documents open at once, there are a few ways to switch between them.
Note Remember that if you close a document without saving it, you will be prompted to do so. Using the Office Menu In the last module, we used the Office menu to open, close, and save files.
For example, if we hover our mouse over Save As, we will get a menu of options: We can click Save As to open the Save As dialog, or we can choose one of the other options.
Open a Word document. Save the current file. Send your document via e-mail or fax. Publish your document to a blog, document management server, or SharePoint workspace. Close the current document. Word Options: Opens the Options dialog, where you can configure how Word works. Exit Word: Close Microsoft Office Word Using the Status Bar: You may have noticed the mini toolbar pop up as you were doing so: Dropdown menus Just like tab drop-down menus, you can type in the box or click the down arrow to choose from a list of values.
Radio buttons Use these buttons to choose from a list. Text boxes These boxes must be filled out by typing in them. Buttons Some buttons open more dialog boxes and allow you to specify advanced settings. Keyboard Shortcuts Another way to implement commands in Word is by using shortcut keys. Using the Toolbar By default, there are three icons on the toolbar. You can also right-click almost any command and click Add to Quick Access Toolbar.
Moving the Quick Access Toolbar If you like, you can use the drop-down menu to move the Quick Access toolbar below the tab: This will open the Customize tab of the Options dialog. We will discuss these tabs in general in the next module and in depth as we encounter them. About Groups Each tab is composed of groups of commands. These separations are useful as it helps you quickly and easily find commands.
Minimizing the Tab If you would like, you can hide the commands and just leave the tabs. Clipboard Commands The first group of the Home tab is the Clipboard module. Font Commands The next group is one that we have already worked with: Paragraph Commands Our third group contains paragraph tools. Editing Commands Our last group focuses on editing. These options let you find and replace text, as well as select objects. The Insert Tab The next tab we are going to look at is the Insert tab.
Pages Commands Our first group is Pages. Tables Commands Our next group is Tables. Illustration Commands I think this next group is the most exciting. Link Commands The fourth group of the Insert tab lets you create links to Web sites called hyperlinks and other places in your document bookmarks and cross-references.
Text Commands Our next group contains a variety of items. When clicked, each item will display a menu of choices.
You can see that inserting a complicated equation is as easy as two clicks! Zoom Tools Our next group lets us zoom in and zoom out of the page. Macro Commands The last button on the View tab lets you open the Macros dialog box. The Page Layout Tab In our last module, we went over the basics of the new interface and discussed the three tabs that you will probably use most often. Page Setup Commands This group will let you control every aspect of your page. Page Background Commands As you might expect, this group controls what goes on your page, behind your text.
You can choose a watermark, a solid color, or a page border. Paragraph Commands This group is like the Paragraph group on the Home tab, except it has fewer options. Click it to see Developer commands. Selecting Text At the very beginning of this manual, we learned how to select text with the mouse.
Selecting Text with the Mouse We already know that we can use the mouse to click and drag over text to select it. Here are a few tips and tricks to get you started: Cutting, Copying, and Pasting Text Cut, copy, and paste are fundamental skills. Once you have pasted text, you will see the paste icon at the end of the text. If you click on it, you will get some options: Keep Source Formatting: Keep the formatting from the original text.
Set Default Paste: Opens the Options dialog so you can control how future paste operations work. Just click the option you want for it to be applied! Using the Office Clipboard Earlier, we mentioned that the paste command will only insert the last item that was cut or copied.
Now, if you cut or copy an item, it will automatically appear in the clipboard. Then, right-click the item and click Paste Note that you can also delete the item from the clipboard using this menu. Dragging and Dropping Text You can also drag text around in your document. Finding Text If you have a long document, it can be useful to have a tool to search through it. Opens advanced options, which we will cover later on. Find Next: Finds the next instance of the word or phrase.
Closes the dialog box without making any changes. Using the Format Painter Word has a neat trick that allows you to copy formats within or between documents. The new text will take the format of the old text. The format painter captures all kinds of formats, including: Applying a Quick Style So far, we have talked about many types of formatting. Choosing a Font Type To choose a font type, first select the text that you want to apply the font to. The font face commands are also available on the mini toolbar.
Changing the Font Size You can change your font size the same way: The font size commands are also available on the mini toolbar. Applying Font Color To change your font color, select the text that you want to change.
Applying Highlighting In addition to the main font color, you can also apply highlighting to text. Applying Advanced Underlining In the first module, we learned how to apply basic underlining.
If you click the drop-down arrow next to the underline command, you will see a menu of underline styles: Changing Case Have you ever typed a long title just to realize it should be all in caps? The Font Dialog In our last lesson, we learned about using the Home tab and the mini toolbar to apply font type, size, color, and underlining. Opening the Font Dialog To open the Font dialog, click the option button in the bottom right corner of the Font group in the Home tab.
You can also use the following shortcuts: To proceed, click Yes. To cancel, click No. To return to the Font dialog, click Cancel. You will see the Embed option at the bottom of the dialog: Once you have checked the option to embed the font, click the OK button. Types of Tabs Tabs are pre-defined places within your document. Right Tabs: Text will start at this point and flow to the left when you use this type of tab. Center Tabs: If you use this type of tab, your text is centered on this point.
Decimal Tabs: Use this tab to align numbers around a decimal point. Using Tabs: Setting Tabs: Clicking this button will cycle through the different tab types: Indenting Using the Home Tab If you want to indent the entire paragraph, use the indent buttons on the Paragraph group of the Home tab.
Note that you can see a preview of each color as you scroll over it. Then, you will see this dialog. This view should be very familiar to you by now: Using Full Screen Reading As you might imagine, full screen reading layout is best used when you want to read a document. This view removes many of the toolbars to devote as much space to text as possible. Using Web Layout This command shows you what your document will look like if it was published as a Web page. The main change you will see in this view is that margins and white space are removed.
However, this view is a little different from the other views we have looked at. Using Draft View Our last view is Draft view.