4-Hour Live Virtual Training on Excel Dashboards and Data Visualization

Understand the ways of using Excel Dashboards and how to create Data Visualization in Excel
Duration: 1 Day
Hours: 4 Hours
Training Level: All Level
Virtual Class Id: 50011
Recorded
Single Attendee
$199.00 $332.00
6 month Access for Recorded
Have Any Queries

Call Us : +1-888-880-0589

support@virtualtrainings.com

About the Course:
Business analytics is all around and not going away. The question is how do we show that data to represent in a way that will help our team or stakeholders make decisions or just be informed quickly? This class will be show you the foundation for how to make your data shine and illustrate how to create your own professional looking dashboard. Learn the proper way to arrange your data to make it easier to read. We will start off by discussing the various charts available to you in Excel and the best practices for using them. Then we will take those skills and utilize the data or charts in dashboards without using any code and you don’t have to be a graphic designer to present your data to communicate value. Students will walk away with a strong knowledge of visualization concepts, as well as how to implement them to their fullest in Excel

Course Objective:
Learn best practices for designing your charts
See examples of various types of charts available in Excel
Create an Interactive Dashboards using multiple charts
Create a Travel Costs Dashboard using a variety of techniques to communicate your data effectively
Create a Pivot Table and Pivot Chart from data and use the Pivot Chart in a dashboard
Create a combination chart to builds a gauge meter

Who is the Target Audience:
Beginner, Intermediate and Advanced Excel users     

Basic Knowledge:
Excel knowledge helps! Intermediate/Advanced level

Curriculum
Total Duration: 4 Hours
3 Key questions to ask about your data
Components of a Chart
Forecasting with Charts
Build Several Charts and learn when to use each style effectively
Build Interactive Charts in your Dashboards
Use of Timelines
What are Sparklines
Using Slicers Effectively