Upon successful completion of this course, you will be able to create dashboards in Excel 2016.
• Create range names and advanced formulas.
• Automate workbook functionality.
• Apply conditional logic.
• Visualize data by creating basic charts.
• Create trendline and sparkline charts.
• Use PivotTables, PivotCharts, and slicers to create a dashboard.
Lesson 1: Using Names in Formulas and Functions
Topic A: Examine Dashboards
Topic B: Use Range Names in Formulas
Topic C: Use Specialized Functions
Lesson 2: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Lesson 3: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions
Lesson 4: Visualizing Data with Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Lesson 5: Using Advanced Charting Techniques
Topic A: Create Dual-Axis Charts and Trendlines
Topic B: Create Sparklines
Lesson 6: Analyzing Data with PivotTables, PivotCharts, and Slicers
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Slicers