This course provides a comprehensive overview of the four main MS - Office applications. The main focus of the course will be ‘using the right tool for the job’. As each application is explored, participants will learn • Core techniques • Productivity tips and keyboard shortcuts. • MS Office application best practices

Topics Covered

Microsoft Word 1. Getting Started in Microsoft Office 2007 Training for Word 2. New Documents in Word 2007 3. Editing Existing Documents 4. Essential Word 2007 Skills 5. Formatting Text and Paragraphs 6. Proofing Tools 7. Changing Your Page Appearance 8. Managing Microsoft Office Documents 9. Additional Editing Tools 10. Paragraph Formatting 11. Introduction to Graphics 12. Document Formatting 13. Tables 14. Mail Merge 15. Macros 16. Office 2007 Themes 17. Smart Art 18. Long or Complex Documents 19. Collaborating 20. Using Word 2007 with Other Programs Microsoft Excel 1. Getting Started in Microsoft Office 2007 Training for Excel 2007 2. Entering Data 3. Changing Worksheet Layout 4. Entering Formulas 5. Formatting 6. Office 2007 Themes and Styles 7. Printing 8. Charts 9. Managing Excel Workbooks 10. Tables and Data Management 11. Using Excel with Other Applications 12. Scenarios and Watching Cells 13. PivotTables and Pivot Charts 14. Collaborating 15. Advanced Formulas and Functions 16. Data Consolidation 17. Data Validation and Conditional Formatting 18. Macros Microsoft PowerPoint 1. Getting Started with Microsoft Office 2007 Training for 2. PowerPoint 3. Opening a New Presentation 4. Viewing Presentations 5. Modifying an Existing Presentation 6. Preparing a Presentation for Delivery 7. Slide Outlines 8. Pictures and Shapes 9. Presentation Colors 10. Animation 11. Organizing and Enhancing Your Presentation 12. Managing Presentations 13. Tables 14. Charts 15. WordArt and Smart Art 16. Templates, Masters and Custom Layouts 17. Saving Presentations for the Web 18. Collaboration 19. Advanced Presentation Delivery Options Microsoft Outlook 1. Getting Started in Microsoft Office 2007 Training for Outlook 2. Reading and Sending E-mail in Outlook 2007 3. Replying to and Forwarding Messages 4. Formatting Messages 5. Working with E-mail Addresses 6. Managing Mail 7. Printing E-mail Messages 8. The Outlook 2007 Calendar 9. Planning Meetings and Appointments 10. Contact Options 11. Outlook Tasks 12. Outlook Notes 13. Mail Message Options 14. Filtering, Finding and Flagging Messages 15. Archiving Outlook 2007 Data 16. Personal File Folders 17. Organizing Your Outlook 2007 Items 18. Pictures and Shapes 19. WordArt and Smart Art

Who should attend

Anyone who wants to learn MS-Offce Package

Pre-requisites

General familiarity with Windows operating system is expected but no assumption of knowledge of specific tools or techniques is assumed.

What you need to bring

Online Training

Key Takeaways

Upon completion of this course students will be able to: • Demonstrate an advanced knowledge of the Word Processing package, MS Office and a knowledge of howto design & create effective and structured documents like technical reports, letters, brochures, etc.,