Modules. 1. Getting Started with Excel: Tracking Miscellaneous Expenses for a Conference. 2. Formatting Workbook Text and Data: Creating a Sales Report. 3. Performing Calculations with Formulas and Functions: Staffing a Call Center. 4.

Analyzing and Charting Financial Data: Preparing an Investment Report. 5. Generating Reports from Multiple Worksheets and Workbooks: Summarizing Profit and Loss Statements. 6. Managing Data with Data Tools: Analyzing Employment Data. 7. Summarizing Data with PivotTables: Developing a Customer Relationship Management Workbook. 8.

Performing What-If Analyses: Maximizing Profits with the Right Product Mix. 9. Exploring Financial Tools and Functions: Analyzing a Business Plan. 10. Managing Data with Business Intelligence Tools. 11. Exploring PivotTable Design: Summarizing Sales and Revenue Data. 12.

Developing an Excel Application: Creating a Data Entry App.