Lynda.COM Migrating from Excel 2008 for Mac to Excel 2011

Author:
David Rivers

Duration:
01h 10m

Released on:
2/2/2011

Exercise files:
Yes

Software works on:
Mac only


In Migrating from Excel 2008 for Mac to Excel 2011, David Rivers shows Excel 2008 for Mac users how to make the transition to Excel 2011. The course reviews the key differences between the two versions, including the new Ribbon interface, and demonstrates how common Excel 2008 tasks are performed in Excel 2011. The course also covers working in a mixed Excel environment and dealing with file compatibility issues. Exercise files are included with the course.
Topics include:

    Using keyboard shortcuts
    Understanding file format differences
    Staying compatible with the Compatibility Report
    Working with 2011 functions
    Using templates
    Recording VBA macros
    Creating PivotTable reports
    Protecting cells in a workbook
    Sharing a workbook




Introduction
Welcome           00m 58s
Using the exercise files           00m 48s

1. Getting Started
Understanding the reasons to switch           01m 53s
Exploring the new Ribbon interface           03m 54s
Controlling Excel 2011 with keyboard shortcuts           03m 57s
Understanding file formats           03m 43s

2. Using Excel 2011 in a Mixed Environment
Saving Excel 2011 workbooks to earlier versions of Excel           03m 34s
Staying compatible with the Compatibility Report           03m 21s
Using older workbooks in Excel 2011           03m 25s
Changing the default file format in Excel 2011           04m 20s
Best practices for managing files in a mixed environment           01m 52s

3. Performing Common Excel 2008 Tasks in Excel 2011
Working with Excel 2011 functions           04m 15s
Using Excel templates           03m 07s
Working with macro-enabled workbooks           04m 27s
Recording VBA macros in Excel 2011           06m 13s
Working with tables           07m 19s
Creating PivotTable reports           04m 53s
Protecting cells in a workbook           04m 05s
Sharing your workbooks           04m 10s

Conclusion
Next steps           00m 43s