Microsoft Office 2007: Streamlining Tasks for Improved Productivity

Frequently Asked Questions

What is this course about? This course covers the features in Word, Excel and PowerPoint 2007 that help to increase your productivity. You learn to connect to, analyze and present information using Office 2007. A special focus is on how these programs work together and developing the skills to expedite everyday tasks. 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, however much of the functionality is the same in both 2003 and 2007. There are many new features in Office 2007, however the basic principles in the course apply to 2003 users. Will we be exploring in detail the Fluent User Interface (The Ribbon)? 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 and slide libraries. 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 curriculum for more information. How much time is spent on each topic? Content Hours Introducing Microsoft Office 2007 2.0 Creating professional documents in Word 3.0 Referencing and navigating documents 2.0 Producing rapid results with Excel 3.0 Integrating data sources 2.0 Developing PowerPoint presentations 3.0 Document security and collaboration 2.0 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. 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 2007. Exercises include: Customizing Office 2007 Designing documents with styles, themes and tables Implementing the TOC, headers and footers in Word Analyzing data with PivotTables and PivotCharts Applying conditional formatting and SmartArt Refining the data with formulas in Excel Creating PowerPoint presentations with Master layouts, slide libraries 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®: Analyzing 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®: Analyzing Data to Make Business Decisions  209, VBA Programming: A Comprehensive Hands-On Introduction  194, Hands-On Visio®: Designing Effective Visual Solutions  970, Access™ 2007: A Comprehensive Hands-On Introduction  971, Building Applications with Access™ 2007: Hands-On  538, SharePoint® Technologies: A Comprehensive Hands-On Introduction  345, Delivering Dynamic Presentations  286, Project Risk Management  196, Introduction to Statistics: Making Better Business Decisions

Microsoft is a registered trademark of Microsoft Corporation.