Microsoft Office Master Specialist (Mos 2007) en México D.F.

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