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.