What is this course about?

This course covers the features in Word, Excel and PowerPoint that help to increase your productivity. You learn to connect to, analyse and present information using Microsoft Office. A special focus is on how these programs work together and developing the skills to expedite everyday tasks.

Which version of Microsoft Office is used in the course?

This course uses both the 2007 and 2010 versions of Microsoft Office. The course exercises can be completed in either version.

Who will benefit from this course?

Business professionals, PAs (personal assistants), administrative professionals, IT personnel (especially helpdesk), managers and executives benefit from this course.

What background do I need?

A general knowledge of Microsoft Office is assumed.

My company is using Office 2003. Will this course still be helpful to me?

The user interface is significantly different in Office 2007 and 2010, however much of the functionality is the same in both 2003, 2007 and 2010. There are many new features in Office 2007 and 2010, however the basic principles in the course apply to 2003 users.

Will we be exploring in detail the Fluent User Interface?

Yes, we will be exploring the user interface in detail and the expanded formatting functionality in Word, Excel and PowerPoint.

Will we be covering Master pages in PowerPoint?

Yes, we will be covering in detail how to create and modify the Master page. In addition, focus will be given to creating design templates.

Will I learn how to use MS Query?

Yes, you learn how to use the MS Query Wizard to retrieve external data, but we do not cover the Query By Example (QBE) grid or OLAP cubes.

Will I learn how to program with macros or VBA in this course?

No, this course focuses on application skills without coding. Please see Course 209, VBA Programming: A Comprehensive Hands-On Introduction, for more information.

Does this course cover Outlook and Access in detail?

No, this course focuses on Word, Excel and PowerPoint. Please see the Access and Outlook curriculum for more information.

How much time is spent on each topic?

How much time is devoted to the hands-on exercises?

Approximately 45% of class time is spent on hands-on exercises. These exercises are designed to provide you with practical, real-world experience using the more advanced features of Office. Exercises include:

• Customising Office 2007/2010
• Designing documents with styles, themes and tables
• Implementing the TOC, headers and footers in Word
• Analysing data with PivotTables and PivotCharts
• Applying conditional formatting and SmartArt
• Refining the data with formulas in Excel
• Creating PowerPoint presentations with Master layouts and design masters
• Tracking and versioning Word documents

How detailed are the PivotTable and PivotChart topics covered in this course?

A basic introduction to these topics is covered in this course, which can be used as fundamental knowledge for Course 195, Power Excel^®: Analysing Data to Make Business Decisions.

How does this course relate to other Learning Tree courses?

The following courses may be of interest:

• 195, Power Excel®: Analysing Data to Make Business Decisions 
• 209, VBA Programming: A Comprehensive Hands-On Introduction 
• 194, Hands-On Visio®: Designing Effective Visual Solutions 
• 970, Microsoft Access®: A Comprehensive Hands-On Introduction 
• 971, Building Applications with Microsoft Access®: Hands-On 
• 538, SharePoint® 2007 Technologies: A Comprehensive Hands-On Introduction 
• 345, Delivering Dynamic Presentations 
• 286, Project Risk Management 
• 196, Making Effective Decisions with Business Statistics 
• 1361, Microsoft Excel®: A Comprehensive Hands-On Introduction 
• 1310, Microsoft Outlook®: Redefining How People Work