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 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 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 build a gauge meter

Who is the Excel Data Visualization Course Target Audience?

• Beginner, Intermediate, and Advanced Excel users

What Basic Knowledge Required to Learn MS Excel Dashboard Course?

• Excel knowledge helps! Intermediate/Advanced level