Microsoft Office Excel 2016: Dashboards Masterclass

Lesson 1: Creating Advanced Formulas ——————————2 hours 30 min Topic A: Use Range Names in Formulas Topic B: Use Specialized Functions Lesson 2: Automating Workbook Functionality——2 hours 30 min Topic A: Apply Data Validation Topic B: Work with Forms and Controls Lesson 3: Applying Conditional Logic ——————————2 hours 30 min Topic A: Use Lookup Functions Topic B: Combine Functions Lesson 4: Visualizing Data with Basic Charts ———————2 hours 30 min Topic A: Create Charts Topic B: Modify and Format Charts Lesson 5: Advanced Charting Techniques —————————3 hours Topic A: Use Advanced Chart Features Topic B: Create Sparklines Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts —–3 hours 30 min Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Slicers

Leave a Reply

Your email address will not be published. Required fields are marked *

Our Clients