Module 1: Getting Started With Excel: Tracking Miscellaneous Expenses for a Conference. Module 2: Formatting Workbook Text and Data: Creating a Sales Report. Module 3: Performing Calculations With Formulas and Functions: Staffing a Call Center. Module 4: Analyzing and Charting Financial Data: Preparing an Investment Report. Module 5: Generating Reports From Multiple Worksheets and Workbooks: Summarizing Profit and Loss Statements. Module 6: Managing Data With Data Tools: Analyzing Employment Data. Module 7: Summarizing Data With PivotTables: Preparing A Social Media Marketing Report. Module 8: Performing What-If Analyses: Maximizing Profits With the Right Product Mix.
Module 9: Exploring Financial Tools and Functions: Analyzing. Module 10: Analyzing Data With Business Intelligence Tools: Presenting Sales and Revenue Data. Module 11: Exploring PivotTable Design: Summarizing Sales and Revenue Data. Module 12: Developing an Excel Application: Creating a Data Entry App.