In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

1. •

   Upload a document using the free online version of Microsoft Office 365

2. •

   Create PivotTables in Microsoft Excel

3. •

   Create and format a Line Chart in Microsoft Excel to represent sales profits by month

4. •

   Create and format a Bar Chart in Microsoft Excel to represent sales profits by Salesperson

5. •

   Create and format Pie Charts in Microsoft Excel to represent sales percentages by product category and city

6. •

   Create a Dashboard in Microsoft Excel containing charts and tables