About Excel Dashboards and Data Visualization 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.Excel Dashboards and Data Visualization 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
What Basic Knowledge Required to Learn MS Excel Dashboard Course?
- Excel knowledge helps! Intermediate/Advanced level
Excel Dashboards and Data Visualization Course Curriculum
- 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
Agenda
- 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
