Download Presentation File

Download Workshop Files

Key Attributes of a Dashboard

Data Table Layouts

Define the Purpose of the Dashboard and Dashboard Types

Choose Relevant KPI's

Define Layout and Prioritize

Understanding Excel Chart Elements

Chart Types and Best Practices

Line chart

Two Data Sets

Area Chart

Logarithmic Scale

Column Chart Part 1

Column Chart Part 2 - Highlight Top Column Dynamically

Bar Chart

Combo Chart using Secondary Axis

Pie Chart

Doughnut Chart

Progress Doughnut

In-cell Charts Sparkline

Top and Bottom Ranking

Grade Distribution

Target vs Actual vs Variance Chart

Median Chart

Bullet Chart

Scatter

Bubble

Bubble

Waterfall Chart

Treemap

Sunburst

Histogram

Pareto

Part 1 - Introduction

Part 2 - Create Pivot Reports

Part 3 - Continue with Pivot Reports

Part 4 - Create Pivot Charts

Part 5 - Create the Dashboard

Part 6 - Add Slicers and Make it Dynamic

Final Exam

Course Evaluation تقييم الدورة

Congratulations