Lynda.com Excel 2010 New Features

Author: Bob Flisser
Duration (hr:min): 01:51
Released on: 5/12/2010
Exercise files: Yes
Software works on: Windows only

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.

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

Content:

Introduction - 04:38

    Welcome - 1:13 - 7.6 MB
    Comparing Excel 2007 and Excel 2010 - 2:46 - 26.9 MB
    Using the exercise files - 0:39 - 0.6 MB

1. File Tab, AKA Backstage View - 38:07

    Customizing the Ribbon bar - 6:59 - 10.8 MB
    Looking at Backstage view - 3:34 - 3.7 MB
    Maintaining compatibility - 5:28 - 7.2 MB
    Making templates easier - 5:16 - 6.5 MB
    Handling document versions - 4:15 - 5.3 MB
    Changing the file type and converting to Adobe PDF - 3:11 - 4.9 MB
    Preparing to share a document - 5:18 - 6.8 MB
    Making printing easier - 4:06 - 4.5 MB

2. Collaboration Tools - 20:56

    Setting document permissions - 3:18 - 4.0 MB
    Sharing a document by email - 3:30 - 4.0 MB
    Sharing a document on the free Microsoft SkyDrive web site - 8:59 - 10.3 MB
    Sharing a document through a Microsoft SharePoint portal - 5:09 - 6.9 MB

3. Data Tools - 06:06

    Using enhanced smart tags and the Paste preview - 3:16 - 3.7 MB
    Filtering a table by searching - 2:50 - 3.1 MB

4. Graphic Features - 18:41

    Inserting Sparklines - 4:45 - 6.1 MB
    Applying the enhanced conditional formatting features - 3:51 - 5.1 MB
    Formatting math equations with the improved equation tools - 6:01 - 7.0 MB
    Editing pictures with the improved picture tools - 4:04 - 5.6 MB

5. Pivot Tables - 14:37

    Using the Slicer to make PivotTables more interactive - 2:14 - 2.6 MB
    Analyzing data from multiple sources using the PowerPivot plug-in - 12:23 - 15.0 MB

6. Going Beyond the Desktop - 08:13

    Editing a worksheet in the Excel Web App - 8:13 - 10.4 MB

Conclusion - 00:14

    Goodbye - 0:14 - 0.2 MB