Excel: Data Visualization and Dashboarding
Duration15'
No. of mini-lessons8
ResourcesTranscript
Duration 15'
No. of mini-lessons 8
Resources Transcript
Course overview
Staring at a spreadsheet full of numbers rarely helps your employees understand what’s going on. Viewing the data visually, such as in a graph, makes it much easier for them to interpret at a glance. Doing this directly in the program that captures the data also speeds up the process.
This course will show your employees how to use Excel to visualize their data and create dashboards. It focuses on creating graphs and charts and taking this a step further by building dashboards. Each video covers a specific graph, chart, or the dashboard itself, allowing them to choose what they want to learn at a pace that suits them.
What's covered
Basic charts: bar and column
Line, area, pie, and doughnut charts
Scatter plots and bubble charts
Combining charts
Advanced chart customization
Creating basic dashboards
Dynamic data visualization using pivot tables & charts
Interactive dashboard with slicers and timelines
Why your teams need this course
This course is ideal for anyone who’s familiar with Excel and wants to visualize their data and create dashboards to communicate what their data shows. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
