Changes in Office 2010

This course will cover the Ribbon-based interface as well as the Backstage view and new features and changes to Word, Excel, Outlook, and PowerPoint.

Course Outline

Course Description This course is designed for students who are already proficient in Microsoft Office and who have recently upgraded to the Office 2010 suite. This course will cover the Ribbon-based interface as well as the Backstage view and new features and changes to Word, Excel, Outlook, and PowerPoint.

Course Content What’s New in Office 2010?
Working in Office 2010
What’s what in Office 2010?
Using the Ribbon
Using Galleries and Lists
Using Shortcut Menus and Dialog Boxes
Using Only the Keyboard
Moving and Copying Content
Working with Backstage View
Getting Help
Saving Your Work
Office’s File Formats
Managing Files in a Mixed Environment
Working with Old Documents
Inserting Pictures
Changing the Size of a Picture
Editing a Picture
Inserting a SmartArt Diagram

Word
Viewing and Editing Text in Word
What’s Where in Word 2010?
Exploring the New Ribbon and Backstage View
Controlling Word 2010 with Keyboard Shortcuts
Creating a New Document
Navigating Your Document
Correcting Your Spelling and Grammar
Correcting Text Automatically
Adding Page Numbers

Performing Common Word 2003 Tasks in Word 2010
Customizing the Quick Access Toolbar
Creating Documents with Building Blocks
Formatting the Mini Toolbar
Converting Word Documents to PDF and XPS
Searching for Content Using the Navigation Pane

Collaboration and Saving
Returning to a Previous Version of a Document
Recovering Unsaved Documents
Understanding the New File Formats
Saving Word 2010 files in the Word 97-2003 file format
Changing the default file format in Word 2010
Managing Word 2003 files in Compatibility Mode

Formatting in Word
Formatting Text with Styles
Using Advanced Test Formatting Features
Reusing Advanced Formatting with Styles
Adjusting Paragraph Line Spacing
Creating a Bulleted or Numbered List
Formatting a Table from Scratch
Formatting a Table

Working with Special Content in Word
Inserting a Watermark
Mail Merge: The Power and the Pain
Correcting Images with the Improved Picture Correction Tools

Excel
Working in Excel
What’s where in Excel 2010?
Exploring the New Ribbon and Backstage View
Controlling Excel 2010 with Keyboard Shortcuts
Understanding the New File Formats
Converting Older Spreadsheets to Excel 2010
Formatting Cells
Adding and Viewing Comments

Analyzing and Presenting Data in Excel
Working with Formulas and Functions
Using Excel to Manage Lists of Data
Formatting a Workbook
Using Conditional Formatting
Customizing the Ribbon and the Quick Access Toolbar
Creating Macro-Enabled Workbooks and Templates
Troubleshooting Formulas
Charting Your Data
Formatting a Chart

File Tab, AKA Backstage View
Changing the File Type and Converting to Adobe PDF

Collaboration Tools
Setting Document Permissions
Sharing a Document by Email

Data Tools
Filtering a Table by Searching

Graphic Features
Inserting Sparklines
Formatting Math Equations with the Improved Equation Tools

Pivot Tables
Using the Slicer to make PivotTables more Interactive
Analyzing Data from Multiple Sources using the PowerPivot Plug-in

PowerPoint
Creating a PowerPoint Presentation
What’s where in PowerPoint 2010?
Exploring the New Ribbon and Backstage View
Controlling PowerPoint 2010 with Keyboard Shortcuts
Understanding the New File Formats
Saving PowerPoint 2010 files in 97-2003 file format
Formatting a Slide
Adding Headers and Footers
Reusing Slides
Creating a Photo Album

Performing Common PowerPoint 2003 Tasks in PowerPoint 2010
Changing Views with the View Tab
Customizing the Quick Access Toolbar
Quickly Accessing Common Features with Mini Toolbars
Creating Your Own Custom Layouts
Creating Diagrams with SmartArt
Animating a Presentation with Transitions and Animations
Saving a Presentation to Video

Presenting a PowerPoint Slide Show
Exploring Your Presentation Options
Adding Speaker Notes
Customizing the Presentation
Packaging Your Presentation
Saving Your Presentation as a Video

Outlook
Getting Started
Interface Changes
Using the Outlook Ribbon
Exploring the File Tab

Navigating
Creating Quick Steps
Viewing Schedules
Using the Improved Search Options
Viewing Emails as Conversations

Working with Messages in Outlook
What’s Where in Outlook Messages?
Formatting Email Messages
Managing Messages with Quick Steps
Signing Your E-Mail

Organizing with Outlook
Sharing Calendars
Viewing Your Group’s Schedule
Creating and E-Mailing Contact Business Cards

New Functionality
Cleaning the Inbox
Understanding Mail Alerts

Additional Details

Pre-Requisites

Word 2003/2007- Level I, Excel 2003/2007 - Level I, PowerPoint 2003/2007 - Level I, Outlook 2003/2007 - Level I, or equivalent knowledge/experience

Certificates offered

Certificate of Completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton, Alberta
Canada   T6G 2J8

Reviews

 

   

One more hour would allow for more hands-on training.

Reviewed by Kerstin M. 2011