In Excel 2010 New Features author Bob Flisser demonstrates the powerful new characteristics and capabilities in Excel 2010. This course covers Excel's Backstage view, improved sharing and collaboration capabilities, its graphics features, and enhanced data analysis and visualization tools. Exercise files accompany the course.
Using the Slicer feature for dynamic PivotTable filtering
Sharing workbooks via e-mail, the Excel Web App, and SharePoint
Using Paste Preview for more effecient copying and pasting
Inserting Sparklines to see patterns in data
Taking advantage of enhancements to the Conditional Formatting feature
Analyzing data from multiple sources using the PowerPivot for Excel add-in
Maintaining file compatibility with older versions