This course runs for a duration of 2 days.
The class will run daily from 8:00 AM CST to 4:00 PM CST.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
Course Overview
Organizations that rely on instinct often miss key opportunities. The ones that trust their data? They win more customers, keep them longer, and earn more in the process. In fact, data-driven organizations are 23 times more likely to acquire customers, six times more likely to retain them, and 19 times more likely to be profitable.
This course shows you how to use Microsoft Excel to make sense of data and communicate it clearly. You’ll learn how to organize, clean, and analyze datasets, build dashboards that update with a click, and present insights using tools like PivotTables, Power Pivot, and geospatial charts. For professionals responsible for reporting, forecasting, or decision support, this training delivers practical, real-world skills you can apply right away.
Course Objectives
This course gives you the tools to move beyond rows and columns and start driving decisions with data. You’ll build confidence using Excel to solve real business problems—turning raw data into insight, and insight into action.
Who Should Attend?
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function
1 – Data Analysis Fundamentals
2 – Visualizing Data with Excel
3 – Analyzing Data with Formulas and Functions
4 – Analyzing Data with PivotTables
5 – Building Dashboards in Excel
6 – Geospatial Visualizations
7 – Performing Statistical Analysis
8 – Getting and Transforming Data
9 – Modeling Data with Power Pivot
10 – Presenting Insights with Reports (Optional)
Excel - Part 1 & 2 or equivalent experience