Lynda.com Excel 2010 New Features

Bob Flisser

Software works on:

Windows only

Topics include:

• 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

Introduction
Welcome           01:13
Comparing Excel 2007 and Excel 2010           02:46
Using the exercise files           00:39
38:07 1. File Tab, AKA Backstage View
Customizing the Ribbon bar           06:59
Looking at Backstage view           03:34
Maintaining compatibility           05:28
Making templates easier           05:16
Handling document versions           04:15
Changing the file type and converting to Adobe PDF           03:11
Preparing to share a document           05:18
Making printing easier           04:06
20:58 2. Collaboration Tools
Setting document permissions           03:18
Sharing a document by email           03:30
Sharing a document on the free Microsoft SkyDrive web site           09:01
Sharing a document through a Microsoft SharePoint portal           05:09
06:06 3. Data Tools
Using enhanced smart tags and the Paste preview           03:16
Filtering a table by searching           02:50
18:41 4. Graphic Features
Inserting Sparklines           04:45
Applying the enhanced conditional formatting features           03:51
Formatting math equations with the improved equation tools           06:01
Editing pictures with the improved picture tools           04:04
14:37 5. Pivot Tables
Using the Slicer to make PivotTables more interactive           02:14
Analyzing data from multiple sources using the PowerPivot plug-in           12:23
08:13 6. Going Beyond the Desktop
Editing a worksheet in the Excel Web App           08:13
00:14 Conclusion
Goodbye           00:14