Excel 2016: Dashboards

Upon successful completion of this course, you will be able to create dashboards in Excel 2016.

You will:
•     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.

Course Content


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

If you require interpreting services, please contact cpd@rit.edu as soon as possible.

Facilitator Information: 

New Horizons