Module 1: INTRODUCTION TO MS OFFICE

• What is Microsoft Office?
• Versions in Microsoft Office
• Microsoft Office Edition Comparison
• Applications in Microsoft Office
• Using and Customizing the Microsoft Office Interface

Module 2: MS WORD BASICS

• Microsoft Office Word Document Interface
• Document Views and Zooming, Multiple Document Windows
• Entering, Editing, and Formatting Text
• Entering and Selecting Text
• Inserting Special Characters
• Date and Time
• Entering Hyperlinks
• Applying Text Formatting
• Working with Styles
• Cut, Copy, and Paste
• Using the Clipboard with Office Programs
• Using Office Themes

Module 3: ADVANCED MS WORD FEATURES

• Finding and Replacing Text and Formatting
• Navigating Document
• Checking Spelling
• Using Tabs
• Adding Headers and Footers, and Page Numbers

Module 4: MS WORD ILLUSTRATIONS AND PICTURES

• Working with Illustrations and Pictures, and WordArt

Module 5: ADVANCED DOCUMENTATION IN MS WORD

• Formatting Columns and Sections
• Working with Tables
• Inserting References to Other Parts of a Document
• Drop Cap

Module 6: MAIL MERGE IN MS WORD

• Mail Merge
• Print a Document
• Using Building Block, Auto Text
• Comments
• Tracking and Highlighting Changes Made to Document
• Protecting a Document

Module 7: FILE MANAGEMENT IN MS WORD

• Managing Office Files
• Supported File Formats in Word 2010
• Checking for Compatibility with Earlier Office Versions
• Open and Save Documents
• Using Templates to Streamline Document Creation
• Organizing Microsoft Office Documents Using File Properties and Details
• Backup and Recovery Option
• Restoring Previous Versions Saved by Auto Recover

Module 8: MS EXCEL BASICS

• Microsoft Office Excel
• Document and Interface Entering and Filling in Data and Series and Custom List
• Inserting and Hiding Rows, Columns, and Sheets
• Using Formulas and Functions
• Define Name
• Cell References
• Formatting Cells and Ranges, Applying Styles
• Number Formatting

Module 9: ADVANCED MS EXCEL

• Mastering Excel’s Built-in Functions (Text, Logical, Financial, Lookup, etc.)

Module 10: CHART AND DATA ANALYSIS IN MS EXCEL

• Creating and Customizing Chart
• Advanced Chart Formatting Options
• Using Conditional Formatting

Module 11: LIST AND DATA MANAGEMENT IN MS EXCEL

• Managing Lists and Data
• Sorting, Filtering, and Outlining Data
• Creating and Formatting Tables

Module 12: PIVOT TABLES IN MS EXCEL

• Creating and Customizing PivotTable Reports
• Importing, Exporting, and Connecting Data Sources

Module 13: ADVANCED FEATURES IN MS EXCEL

• Finding, Editing, Moving, Copying, and Paste Special
• Data Validation
• Customizing the Worksheet View
• Arranging Worksheet Windows
• Splitting, Freezing, and Locking Panes
• Printing a Worksheet
• Advanced Protection for the Document
• Supported File Formats in Excel 2010

Module 14: MS POWERPOINT BASICS

• Microsoft Office PowerPoint and Interface
• Entering the
• Presentation Text
• Presentation View Options
• Adding Action Buttons
• Master View

Module 15: GRAPHICS AND THEMES IN MS POWERPOINT

• Adding Graphics and Video Clips
• Applying Themes
• Adding Backgrounds

Module 16: ANIMATIONS AND TRANSITIONS IN MS POWERPOINT

• Adding Animations
• Setting Animation Timing and Options
• Using Transitions Between Slides
• Recording Narrations
• Navigating in Slideshow View

Module 17: PRINTING AND ADDITIONAL FEATURES IN MS POWERPOINT

• Printing Presentations
• Creating Notes and Handouts
• Printing Notes and Handouts
• Creating Photo Albums
• Creating Video from Presentation
• Supported File Formats in PowerPoint 2010
• Save Options and Compressing File

Module 18: MS OUTLOOK BASICS

• Microsoft Office Outlook and Interface
• Outlook Items
• E-mail Messages, Appointments, Meetings, Contacts
• Task, Notes, Personalizing Interface
• Customizing the Navigation Pane
• Organizing To-Do Bar, Setting Up Mail Accounts
• Sending and Receiving Messages
• Managing Contacts and Groups

Module 19: CALENDAR AND DATA MANAGEMENT IN MS OUTLOOK

• Managing Your Calendar
• Adding and Editing Email Signature
• Managing Outlook Data Files and Folders
• Managing Data Files
• Mastering Outlook Search
• Using Rules to Manage Messages Automatically

Module 20: ADVANCED FEATURES IN MS OUTLOOK

• Setting Follow-up Flags and Reminders
• Sharing Contacts and Calendars Items via Email
• Working with Meeting Invitations
• Importing and Exporting Outlook Data
• Archiving Outlook Data
• Changing Default Formatting for New E-mail Message

For information update on the schedule, please contact +971 4 342 3400 or email at info@filipinoacademyae.com