Excel 2010

Part 1: Worksheet basics. Creating your first spreadsheet

Adding information to worksheets

Moving data

Managing worksheets

Formatting cells

Smart formatting tricks

Viewing and printing worksheets

Part 2: Formulas and functions. Building basic formulas

Math and statistical functions

Financial functions

Manipulating dates, times, and text

Lookup, reference, and information functions

Advanced formula writing and troubleshooting

Part 3: Organizing worksheets. Tables: list management made easy

Grouping and outlining data

Templates

Part 4: Charts and graphics. Creating basic charts

Formatting and perfecting charts

Inserting graphics

Part 5: Advanced data analysis. Visualizing your data

Scenarios and goal seeking

Pivot tables

Analyzing databases, XML, and web pages

Part 6: Sharing data with the rest of the world. Protecting your workbooks

Worksheet collaboration

Using Excel on the web

Exchanging data with other programs

Part 7: Programming Excel. Automating tasks with macros

Programming spreadsheets with VBA

Part 8: Appendix. Customizing the ribbon.