1. Creating a Worksheet and a Chart.
2. Formulas, Functions, and Formatting.
3. Working with Large Worksheets, Charting, and What-If Analysis.
4. Financial Functions, Data Tables, and Amortization Schedules.
5. Working with Multiple Worksheets and Workbooks.
6. Creating, Sorting, and Querying a Table.
7. Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.
8. Working with Trendlines, PivotTable Reports, PivotChart Reports, and Slicers.
9. Formula Auditing, Data Validation, and Complex Problem Solving.
10. Data Analysis with Power Tools and Creating Macros.
11. User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel.