Course Overview
This course covers those features of Microsoft Office 2010 that are new to the Office system, with dedicated units for the new features of each application. In Word, students will learn to use the Navigation pane and apply new text effects. In Excel, they will use Sparklines, filter data with slicers, and create a PivotChart. In PowerPoint, they will organize slides into sections, edit movie clips, apply animation effects, and learn how to broadcast slide shows. In Outlook, they will manage email conversations, create Quick Steps, and use the People pane. In Access, they will learn how to use the tabbed document window, create Lookup list fields, and use the data type gallery. In addition, students will learn about Ribbon customization, the Backstage view, saving a file as a PDF, and the benefits and features of the new XML file format. This course includes everything needed to work effectively within the new suite of applications.
Course Objectives
What's New Across Office 2010, New Features in Microsoft Excel 2010, New Features in Outlook 2010, New Features in Microsoft PowerPoint 2010, New Features in Microsoft Word 2010, New Features in Microsoft Access 2010, What's New Across Office 2010, New Features in Microsoft Excel 2010, New Features in Outlook 2010, New Features in Microsoft PowerPoint 2010, New Features in Microsoft Word 2010, New Features in Microsoft Access 2010
Course Prerequisites
There are no prerequisites for this course.
Agenda
1 - Introduction
2 - What's New Across Office 2010
- Using the Ribbon
- Understanding Contextual Tabs
- Understanding Galleries and Live Preview
- Using Dialog Box Launchers
- Using Zoom and Views
- Customizing the Status Bar
- Using the Mini Toolbar
- Customizing the Quick Access Toolbar and the Ribbon
- Using Backstage View
- Printing and Print Preview
- Understanding the New XML File Format
3 - New Features in Microsoft Excel 2010
- Understanding the New Worksheet Size
- Using Conditional Formatting
- Creating Sparklines
- Charting
- Using the New Table Improvements
- Creating PivotTables
- Adding Slicers
4 - New Features in Outlook 2010
- Unserstanfding the New Interface
- Using Conversations
- Utilizing Quick Steps
- Using Outlook Search Features
- Working with Calendars
- Working with Color Categories
- Using the Out of Office Assistant
- Managing Contacts
5 - New Features in Microsoft PowerPoint 2010
- Applying New Themes, Masters, and Layouts
- Creating Sections
- Working with Video
- Creating SmartArt Graphics
- Adding Animation and Transition Effects
- Broadcasting a Slideshow
6 - New Features in Microsoft Word 2010
- Working with Formatting
- Using the Navigation Pane
- Creating Quick Parts
- Inserting Objects
7 - New Features in Microsoft Access 2010
- Using the Backstage View
- Utilizing New Database Templates Including Web Databases
- Using New Table Features
- Working with the Improved Macro Designer
- Creating Data Macros (Table Triggers)
- Understanding New Form and Report Features
8 - Conclusion