Data Analysis and Visualization with Microsoft Excel

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 Details

Price:

$590.00

Days:

Location:

Virtual

Course Overview

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. Clean and prepare data using tables, formulas, and functions Analyze trends and patterns with PivotTables and PivotCharts Build interactive dashboards with slicers and timelines Use geospatial and statistical tools to deepen your analysis Model data using Power Pivot and connect multiple sources

Excel – Part 1 & 2 or equivalent experience

1 – Data Analysis Fundamentals

Introduction to data science
Create and modify tables
Sort and filter datasets

2 – Visualizing Data with Excel

Create charts to represent trends and comparisons
Format and style visualizations for clarity
Apply best practices in chart design

3 – Analyzing Data with Formulas and Functions

Use formulas and named ranges for efficient analysis
Apply logical and lookup functions
Build forms, use data validation, and automate inputs

4 – Analyzing Data with PivotTables

Build PivotTables from raw data
Analyze, filter, and summarize results

5 – Building Dashboards in Excel

Use PivotCharts to visualize dynamic data
Add slicers and timelines for interactivity
Combine visual elements into a dashboard

6 – Geospatial Visualizations

Create map charts to show data by location
Customize and interpret map-based visuals

7 – Performing Statistical Analysis

Use sparklines and trendlines to show patterns
Apply the Data Analysis ToolPak for statistical insights

8 – Getting and Transforming Data

Connect to outside data sources with queries
Clean, combine, and shape raw data for analysis

9 – Modeling Data with Power Pivot

Enable Power Pivot and load data models
Use DAX formulas for advanced calculations
Create relationships between datasets

10 – Presenting Insights with Reports (Optional)

Plan and build formatted Excel reports for stakeholders

Class Dates & Times


06/26/2025 - 06/27/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
07/17/2025 - 07/18/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
08/11/2025 - 08/12/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
09/03/2025 - 09/04/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
09/25/2025 - 09/26/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
10/20/2025 - 10/21/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
11/11/2025 - 11/12/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
12/29/2025 - 12/30/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
12/02/2025 - 12/03/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →