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

Session Dates: 
Wednesday, November 13, 2019 - 8:30am to 4:30pm
Thursday, February 27, 2020 - 8:30am to 4:30pm
Topic: