Microsoft Office Master Specialist (Mos 2007)

Microsoft Office Word 2007: Level 1
 
Lesson 1: Creating a Basic Document
·         Explore the User Interface
·         Open and View a Document
·         Customize the Word Environment
·         Obtain Help
·         Enter Text
·         Save a Document
·         Preview and Print a Document
 
Lesson 2: Editing a Document
·         Navigate and Select Text in a Document
·         Insert, Delete, or Rearrange Text
·         Undo Changes
·         Search and Replace Text
 
Lesson 3: Formatting Text
·         Change Font Appearance
·         Highlight Text
 
Lesson 4: Formatting Paragraphs
·         Set Tabs to Align Text
·         Control Paragraph Layout
·         Add Borders and Shading
·         Apply Styles
·         Create Lists
·         Manage Formatting
 
Lesson 5: Adding Tables
·         Create a Table
·         Modify the Table Structure
·         Format a Table
·         Add Visual Effects Using Symbols and Special Characters
·         Insert Illustrations
 
Lesson 7: Controlling Page Appearance
·         Control Page Layout
·         Apply a Page Border and Color
·         Add Watermarks
·         Add Headers and Footers
 
Lesson 8: Proofing a Document
·         Check Spelling, Grammar and Word Count
·         Enhance Textual Meaning Using the Thesaurus
·         Customize AutoCorrect Options
 
 
Microsoft Office Word 2007: Level 2
 
Lesson 1: Managing Lists
·         Sort a List
·         Renumber a List
·         Customize Lists
 
Lesson 2: Customizing Tables and Charts
·         Sort Table Data
·         Control Cell Layout
·         Perform Calculations in a Table
·         Create Charts
Lesson 3: Customizing Formatting with Styles and Themes
·         Create or Modify a Text Style
·         Create a Custom List or Table Style
·         Apply Default and Customized Document Themes
 
Lesson 4: Modifying Pictures
·         Resize a Picture
·         Adjust Picture Appearance Settings
·         Wrap Text Around a Picture
 
Lesson 5: Creating Customized Graphic Elements
·         Create Text Boxes and Pull Quotes
·         Draw Shapes
·         Add WordArt and Other Special Effects to Text
·         Create Complex Illustrations with SmartArt
 
Lesson 6: Inserting Content Using Quick Parts
·         Insert Building Blocks
·         Create Building Blocks
·         Modify Building Blocks
·         Insert Fields Using Quick Parts
 
Lesson 7: Controlling Text Flow
·         Control Paragraph Flow
·         Insert Section Breaks
·         Insert Columns
·         Link Text Boxes to Control Text Flow
 
Lesson 8: Using Templates to Automate Document Creation
·         Create a Document Based on a Template
·         Create a Template
 
Lesson 9: Automating Mail Merges
·         Perform a Mail Merge
·         Mail Merge Envelopes and Labels
·         Use Word to Create a Data Source
 
Lesson 10: Using Macros to Automate Tasks
·         Perform a Task Automatically Using a Macro
·         Create a Macro
 
 
Microsoft Office Excel 2007: Level 1
 
Lesson 1: Creating a Basic Worksheet
·         Explore the User Interface and the Ribbon
·         Navigate and Select in Excel
·         Obtain Help
·         Enter Data and Save a Workbook
·         Customize the Quick Access Toolbar
 
Lesson 2: Performing Calculations
·         Create Basic Formulas
·         Calculate with Functions
·         Copy Formulas and Functions
 
Lesson 3: Modifying a Worksheet
·         Manipulate Data
·         Insert and Delete Cells, Columns, and Rows
·         Search for Data in a Worksheet
·         Spell Check a Worksheet
 
Lesson 4: Formatting a Worksheet
·         Modify Fonts
·         Add Borders and Color to Cells
·         Change Column Width and Row Height
·         Apply Number Formats
·         Position Cell Contents
·         Apply Cell Styles
 
Lesson 5: Printing Workbook Contents
·         Print Workbook Contents Using Default Print Options
·         Set Print Options
·         Set Page Breaks
 
 
Lesson 6: Managing Large Workbooks
·         Format Worksheet Tabs
·         Manage Worksheets in a Workbook
·         Manage the View of Large Worksheets
 
Microsoft Office Excel 2007: Level 2
 
Lesson 1: Calculating Data with Advanced Formulas
·         Manage Cell and Range Names
·         Calculate Data Across Worksheets
·         Use Specialized Functions
·         Analyze Data with Logical and Lookup Functions
 
Lesson 2: Organizing Worksheet and Table Data
·         Create and Modify Tables
·         Format Tables
·         Sort or Filter Worksheet or Table Data
·         Calculate Data in a Table or Worksheet
 
Lesson 3: Presenting Data Using Charts
·         Create a Chart
·         Modify Charts
·         Format Charts
 
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
·         Create a PivotTable Report
·         Analyze Data Using PivotCharts
 
Lesson 5: Inserting Graphic Objects
·         Insert and Modify Pictures and ClipArt
·         Draw and Modify Shapes
·         Illustrate Workflow Using SmartArt Graphics
·         Layer and Group Graphic Objects
 
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
·         Customize the Excel Environment
·         Customize Workbooks
·         Manage Themes
·         Create and Use Templates
 
Microsoft Office PowerPoint 2007: Level 1
 
Lesson 1: Getting Started with PowerPoint
·         Explore the User Interface
·         Navigate and View a Presentation
·         Use Microsoft PowerPoint Help
·         Enter Text
·         Save a Presentation
Lesson 2: Creating a Presentation
·         Create a Presentation
·         Edit Text
·         Add Slides to a Presentation
·         Arrange Slides
·         Work with Themes
 
Lesson 3: Formatting Text on Slides
·         Apply Character Formats
·         Apply Paragraph Formats
·         Format Text Placeholders
 
Lesson 4: Adding Graphical Objects to a Presentation
·         Insert Clip Art and Pictures
·         Draw Shapes
·         Insert WordArt
 
Lesson 5: Modifying Objects
·         Work with Objects
·         Change Object Orientation
·         Format Objects
·         Group and Ungroup Objects
·         Arrange Objects
 
Lesson 6: Adding Tables to a Presentation
·         Create a Table
·         Format Tables
·         Insert a Table from Microsoft Word
 
Lesson 7: Inserting Charts in a Presentation
·         Create a Chart
·         Edit Chart Data
·         Modify a Chart
·         Paste a Chart from Microsoft Excel
 
Lesson 8: Preparing to Deliver a Presentation
·         Review Content
·         Add Transitions
·         Apply an Animation Effect
·         Create Speaker Notes
·         Print a Presentation
 
Microsoft Office PowerPoint 2007: Level 2
 
Lesson 1: Customizing the PowerPoint Environment
·         Customize the Quick Access Toolbar
·         Personalize the PowerPoint Interface
·         Customize Save Options
·         Apply Advanced Customization Options
Lesson 2: Customizing a Design Template
·         Set Up a Slide Master
·         Customize Slide Layouts
·         Create Custom Themes
·         Add Headers and Footers
·         Modify the Notes Master
·         Modify the Handout Master
 
Lesson 3: Adding Diagrams to a Presentation
·         Create Diagrams
·         Modify Diagrams
 
Lesson 4: Adding Special Effects to Presentations
·         Add Multimedia Elements
·         Customize Slide Component Animation
 
Lesson 5: Customizing a Slide Show Presentation
·         Set Up a Custom Show
·         Annotate a Presentation
·         Create a Presenter-Independent Slide Show
·         Set Up a Slide Show to Repeat Automatically
 
Lesson 6: Collaborating on a Presentation
·         Review a Presentation
·         Publish Slides to a Slide Library
·         Share a Presentation
 
Lesson 7: Securing and Distributing a Presentation
·         Secure Presentations
·         Package a Presentation
·         Publish a Presentation as a Web Page
 
 
Microsoft Office Outlook 2007: Level 1
                      
Lesson 1: Getting Started with Outlook
·         Explore the Outlook Interface
·         Send a Simple Message
·         Reading Messages
·         Reply to and Forward a Message
·         Print a Message
·         Delete a Message
 
Lesson 2: Composing Messages
·         Address a Message
·         Format a Message
·         Check Spelling and Grammar
·         Attach a File
 
Lesson 3: Organizing Messages
·         Open and Save an Attachment
·         Flag a Message
·         Organize Content with Folders
 
Lesson 4: Managing Contacts
·         Add a Contact
·         Sort and Find Contacts
·         Find the Geographical Location of a Contact
·         Manage Contacts
 
Lesson 5: Scheduling Appointments
·         Explore the Outlook Calendar
·         Schedule an Appointment
·         Assign Categories and Edit Appointments
 
Lesson 6: Scheduling Meetings
·         Schedule a Meeting
·         Reply to a Meeting Request
·         iPropose a New Meeting Time
·         Manage Meetings
·         Print the Calendar
 
Lesson 7: Managing Tasks and Notes
·         Create a Task
·         Edit and Update a Task
·         Create a Note
·         Edit a Note
·         Display a Note on the Desktop
 
Microsoft Office Outlook 2007: Level 2
 
Lesson 1: Setting Calendar Options
·         Set Work Days and Times
·         Display an Additional Time Zone
·         Set Availability Options
 
Lesson 2: Customizing Message Options
·         Modify Message Settings
·         Modify Delivery Options
·         Change the Message Format
·         Notify Others That You will be Out of the Office
·         Create a Distribution List
·         Insert a Hyperlink
 
Lesson 3: Tracking Work Activities Using the Journal
·         Automatically Record a Journal Entry
·         Manually Record a Journal Entry
·         Modify a Journal Entry
Lesson 4: Managing Tasks
·         Assign a Task
·         Reply to a Task Request
·         Send a Task Update
·         Track Assigned Tasks
 
Lesson 5: Sharing Folder Information
·         Specify Folder Permissions
·         Delegate Access to Folders
·         Access Another User's Folder
·         Send Calendar Information in an Email Message
 
Lesson 6: Customizing the Outlook Environment
·         Customize the Toolbar
·         Create a New Toolbar
·         Customize the Menu Bar
·         Customize the Quick Access Toolbar
·         Customize the To-Do Bar
·         Create a Folder Home Page
 
Lesson 7: Locating Outlook Items
·         Topic 7A: Sort Messages Using Multiple Criteria
·         Find Messages
·         Find Outlook Items Using Multiple Criteria
·         Filter Messages
·         Organize Messages
·         Manage Junk Email
 
Lesson 8: Working with Public Folders
·         Create a Public Folder
·         Add Users to a Public Folder
·         Post Information in a Public Folder
·         Send an Email Message to a Public Folder