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