18 Hours
Course Description
This module includes the knowledge and skills required to perform functions common to all Microsoft Windows applications with an emphasis on the common functionality between the three Microsoft Office applications: Microsoft Word, Excel, and PowerPoint. Elements include the ability to start and exit either the Word, Excel, or PowerPoint application, modify the display of toolbars and other on-screen elements, use online help, and perform file management, editing, formatting and printing functions common to most Windows applications.
Unit 1: Common Elements
Lesson 1: Getting Started with Programs
- Sharing Common Elements
- Starting Word/Excel/ PowerPoint
- Exiting Word/Excel/PowerPoint
- Looking at the Screen
- Using the Quick Access Toolbar
- Using the Ribbon
- Getting Help
- Working with Files
- Printing Files
Unit 2: Using Microsoft Office Word 2007
Lesson 1: Creating Documents
- Entering and Editing Text
- Working with Documents
- Starting a New Document
- Closing a Document
- Opening a Document
- Switching Between Documents
- Saving Files in Different Formats
Lesson 2: Manipulating Text
- Selecting Text
- Customizing the View
- Adjusting the Zoom
- Editing Text
- Using Cut, Copy and Paste
Lesson 3: Formatting Text
- Formatting Text Characters
- Using the Format Painter
- Aligning Text
- Adding Borders and Shading
Lesson 4: Setting Tabs
- Understanding Tab Settings
Lesson 5: Indenting Paragraphs
- Working with Indents
- Using the Paragraph Command
- Adding Bullets and Numbering
Lesson 6: Proofing Your Document
- Checking the Spelling and Grammar
- Using the Thesaurus
- Finding Items
- Replacing Items
Lesson 7: Using Additional Formatting Features
- Changing the Line Spacing
- Setting the Paragraph Spacing
- Changing the Paper Size
- Changing the Orientation
- Changing Margins
- Adding Special Characters
- Inserting the Date and Time
Lesson 8: Printing Documents
- Previewing the Document
- Printing a Document
Lesson 9: Working with Headers and Footers
- Adding Page Numbering
- Using Section Breaks
- Using Headers and Footers
Lesson 10: Using Publishing Format Tools
- What are Publishing Format Tools?
- Working with Styles
- Outlining a Document
- Working with Footnotes or Endnotes
Lesson 11: Working with Pictures
- What are Illustrations?
- Inserting Pictures
- Inserting Clip Art
- Manipulating Pictures
Lesson 12: Working with Objects
- Drawing Objects
- Inserting Text Boxes
- Editing Shapes
Lesson 13: Working with Tables
- Understanding How Tables Work
- Drawing a Table
- Inserting a Table
- Selecting Items in the Table
- Formatting the Table
- Modifying the Borders and Shading
- Adjusting the Width or Height
- Changing the Alignment
- Inserting & Deleting Rows/Columns/Cells
- Merging and Splitting Cells
- Splitting a Table
- Converting Text or Tables
- Sorting Information in a Table
Lesson 14: Working with Others
- Sharing Information with Others
- Working with Comments
- Tracking Changes
Unit 3: Using Microsoft Office Excel 2007
Lesson 1: Getting Started
- Understanding Basic Terminology
- Creating a New Blank Workbook
- Opening Workbooks
- Closing a Workbook
- Saving Workbooks
- Managing Your Files
- Entering Data in the Worksheet
- Moving Around the Worksheet
Lesson 2: Manipulating the Information
- Selecting Cells
- Making Changes to the Contents
- Using Undo, Redo, or Repeat
- Copying and Moving Data
- Using AutoFill
- Changing the Column Widths
- Adjusting the Row Height
- Inserting or Deleting Rows, Columns, or Cells
- Managing Worksheets
Lesson 3: Working with Formulas
- Creating Simple Formulas
- Using Common Built-In Functions
- Using Absolute & Relative Addresses
- Being Careful with Formulas
Lesson 4: Formatting a Worksheet
- What Does Formatting Mean?
- Formatting Numbers and Decimal Digits
- Changing Cell Alignment
- Changing Fonts and Sizes
- Applying Cell Borders
- Applying Colors and Patterns
- Using Styles
- Using the Format Painter
Lesson 5: Using Miscellaneous Tools
- Using the Spell Checker
- Sorting Data
Lesson 6: Working with Charts
Lesson 7: Getting Ready to Print
- Previewing the Worksheet
- Adding Page Breaks
- Customizing the Printout
- Printing the Worksheet
Unit 4: Using Microsoft Office PowerPoint 2007
Lesson 1: Getting Started
- What is a Presentation Manager?
- What is PowerPoint?
- What is a Presentation?
- Creating Presentations
- Displaying Information in the Presentation
Lesson 2: Setting Up the Presentation
- Creating a Master Slide
- Inserting Headers and Footers
- Managing the Slides
Lesson 3: Working with Text
- Selecting Text Objects
- Manipulating Text
- Checking the Spelling
Lesson 4: Formatting Text
- What Does Formatting Mean?
- Aligning Text
- Changing Bulleted Information
Lesson 5: Working with Objects
- Inserting Clip Art Images
- Inserting Graphics from Other Sources
- Creating and Using Tables
- Formatting the Table
- Creating a Chart
- Creating Objects
Lesson 6: Enhancing the Presentation
- Changing the Background Color
- Animating Objects
- Customizing the Animation
- Applying Slide Transitions
Lesson 7: Bringing It All Together
- Printing the Presentation
- Creating Notes and Handouts
- Running the Slide Show
|