Excel 2010 Essential Training ~ iLearn

Lynda.com - Excel 2010 Essential Training(Included Files Exercise)

In Excel 2010 Essential Training(Included Files Exercise), Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting.

It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Topics include:
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cell ranges
Formatting data and worksheets
Finding and replacing data
Creating SmartArt diagrams
Creating charts and PivotTables
Recording macros
Sharing workbooks
Exercise files:

Screenshot: