|
|
The basic level Microsoft course covers the following content areas: Word 2003, Excel 2003, Power Point 2003
Creating Content -
- Inserting symbols and special characters,
- Editing and deleting text,
- Moving and copying text,
- Checking spelling ad grammar,
- Using the thesaurus to find the best word,
- Inserting frequently used and predefined text,
- Using AutoCorrect,
- Using AutoText,
- Inserting the date and time,
- Navigating to specific content,
- Finding and replacing text,
- Jumping to a specific item,
- Inserting, positioning and sizing graphics, text boxes and shapes,
- Inserting and formatting diagrams and organizational charts,
- Using the Research Service to locate and insert information.
Organizing Content -
- Inserting tables,
- Converting text to tables,
- Changing table structure,
- Formatting tables manually,
- Applying predefined formats to tables,
- Creating and customizing bulleted lists, numbered lists, and outlines,
- Inserting hyperlinks to documents, web pages, and e-mail addresses,
- Editing and removing hyperlinks.
Formatting Content -
- Applying common character formatting,
- Finding and replacing character formatting,
- Working with styles,
- Highlighting text,
- Applying text effects,
- Modifying character spacing,
- Indenting, spacing and aligning paragraphs,
- Applying borders and shading to paragraphs,
- Setting, removing and modifying tab stops,
- Setting up multiple columns,
- Formatting columns,
- Creating and modifying content in headers and footers,
- Inserting and formatting page numbers,
- inserting and deleting breaks,
- modifying page margins and page orientation.
Collaborating -
- Sending a document for review,
- sending a document as an e-mail attachment,
- Comparing and merging documents,
- Viewing changes in a merged document,
- Inserting and reviewing comments,
- Editing comments,
- Tracking changes to a document,
- Locating and managing document changes.
Formatting and Managing Documents -
- Creating a new document based on a template,
- Reviewing and modifying summary information,
- Checking word, paragraph, and character counts,
- Creating a folder in which to store a document,
- Renaming or deleting a document or folder,
- Saving a document for use in another program,
- Saving a document as a web page,
- Printing a document,
- Printing an envelope or label,
- Previewing a document before printing,
- Previewing a web page for publication,
- Switching views,
- Working in Print Layout View,
- Working in Reading Layout View,
- Arranging and splitting windows.
Creating Data and Content -
- Entering text, numbers and symbols,
- Entering cell content by using the fill handle,
- Editing and clearing cell contents,
- Finding cell content of formatting,
- Navigating by using the Go To command,
- Using the thesaurus to find the best word,
- Using the Research Tool to locate and insert supporting information,
- Inserting and positioning graphics,
- Sizing graphics.
Analyzing Data -
- Displaying rows with a specific entry in a specific columns,
- Displaying rows that match certain criteria,
- Sorting on one column,
- Sorting on Two or Three columns,
- Doing simple arithmetic,
- Using a function in a formula,
- Using cell and range references in a formula,
- Using statistical functions in formulas,
- Using date and time functions in formulas,
- Using financial functions in formulas,
- Using logical functions in formulas,
- Creating, modifying, and positioning diagrams and charts.
Formatting Data and Content -
- Changing the look of cells and cell entries,
- Changing cell alignment,
- Applying an AutoFormat,
- Changing the format of cell entries,
- Copying formatting,
- Applying and modifying a style,
- Adjusting column widths and row heights,
- Hiding and revealing columns and rows,
- Inserting and deleting columns and rows,
- Changing a worksheet's name, tab, and background,
- Hiding and revealing a worksheet.
Collaborating -
- Attaching a comment to a worksheet cell,
- Editing or deleting a comment.
Managing Workbooks -
- Creating a workbook based on a template,
- Inserting and deleting cells,
- Copying and moving entries,
- Controlling for Excel pastes,
- Inserting a hyperlink,
- Editing a hyperlink,
- Inserting and deleting worksheets,
- Moving a worksheet,
- Previewing a worksheet that will be printed,
- Previewing a web workbook,
- Splitting a window,
- Freezing a column or row,
- Arranging windows,
- Hiding and revealing workbooks,
- Specifying a print area,Controlling what appears on each page,
- Adding a header or a footer,
- Printing selections, worksheets, and workbooks,
- Creating a folder in which to store a workbook,
- Renaming or deleting a workbook or folder,
- Saving a workbook for use in another program,
- Saving a selection, worksheet, or workbook as a web page.
Creating Content -
- Creating a presentation by using the AutoContent Wizard or a Design Template,
- Adding and editing text,
- Changing the hierarchical level of text,
- Importing text from other sources,
- Checking spelling and style,
- Using the thesaurus to find the best word,
- Creating tables, charts, and diagrams,
- Adding clip art, pictures, shapes, and WordArt,
- Inserting a Word table, Excel worksheet, or media clip.
Formatting Content -
- Changing the font, size, and font style of text,
- Modifying text colors,
- Changing text alignment,
- Finding and replacing fonts,
- Sizing and cropping graphics, Adjusting the color of graphics,
- Aligning, connecting, and rotating graphics,
- Adding effects to shapes,
- Coloring and shading a slide background,
- Modifying the slide layout,
- Using a design template to make a presentation look consistent,
- Setting the slide size and orientation,
- Animating slides,
- Applying transition effects,
- Saving a presentation as a template,
- Changing a presentation's masters,
- Adding, Deleting, and modifying placeholders,
- Inserting content in headers and footers.
Collaborating -
- Viewing tracked changes,
- Accepting and rejecting changes,
- Adding comments,
- Working with comments,
- Comparing and merging presentations.
Managing and Delivering Presentations -
- Working with different views,
- Organizing and deleting slides,
- Adding and viewing notes,
- Adding Hyperlinks,
- Creating a custom slide show,
- Working with action buttons,
- Working with hidden slides,
- Setting slide timings,
- Rehearsing a presentation,
- Delivering a slide show,
- Using tools for emphasis,
- Packaging a presentation for CD storage,
- Saving an entire publication or a single slide,
- Saving and publishing a presentation as a web page,
- Previewing and printing a presentation,
- Sending a presentation to Microsoft Word.











