Target Audience For individuals new to the Microsoft Excel or upgrading to Microsoft Excel 2010 from previous versions.
Duration: 50 minutes
Master the new components of Excel by going backstage to customize and enable some of your favorite features. Learn to connect multiple PivotTables® and discover just how easy it is to solve multi-variable equations with today’s most popular spreadsheet program.
How to Go Backstage
In this lesson, you’ll learn about three new features in the Backstage area: How to recover unsaved documents, configure Protected View and manage trusted documents.
How to Customize the Ribbon
See how to customize the Ribbon and enable some of your favorite features from earlier versions of Excel! In this segment, you’ll learn how to recover the “old” PivotTable® Wizard and “Send As E-mail” options.
How to Create Sparklines
Learn how to create Line, Column and Win/Loss Sparklines. You’ll even find out how to customize and troubleshoot Sparklines in Excel 2010.
How to Create Slicers
Discover the new way to filter PivotTables and how to connect multiple PivotTables and PivotCharts® to the same slicer.
How to Use the New Conditional Formatting Features
Learn how to show negative data bars and how to customize icon sets.
How to Use the New PivotTable Features
See how to configure repeated labels. Show Values As and PivotChart buttons in Excel 2010.
How to Use PowerPivot®
If you love PivotTable reports but would like to do more…this is the lesson for you. Learn how to install and configure this powerful new add-in for Excel 2010 published by Microsoft Labs.