Learn
Connect
Blog
Resource hub
Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast

Data Analysis & Visualizations with Excel

Course Summary

The Data Analysis & Visualizations with Excel training course is designed to advance the skills of participants who are already familiar with Microsoft Excel. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports.

The course begins with a review of data analysis fundamentals and then dives into visualizing and analyzing data with Formulas, functions and PivotTables. Next, participants are introduced to presenting visual insights with dashboards and creating geospatial visualizations. The course concludes with performing statistical analysis, transforming data, and modeling and analyzing data with Power Pivot.

Purpose
Learn how to use Excel for data analysis to present data into visual insights
Audience
Data Analysts who need to be able to effectively present and communicate data in visually compelling ways
Role
Business Analyst | Data Engineer | Data Scientist | Project Manager | Q/A | Technical Manager
Skill Level
Intermediate
Style
Lecture | Hands-on Activities
Duration
2 Days
Related Technologies
Data Visualization | Excel

 

Learning Objectives
  • Perform data analysis fundamentals
  • Visualize data with Excel
  • Analyze data with formulas and functions
  • Analyze data with PivotTables
  • Present visual insights with dashboards in Excel
  • Create geospatial visualization with Excel
  • Perform statistical analysis
  • Get and transform data
  • Model and analyze data with Power Pivot
  • Present insights with reports

What You'll Learn:

In the Data Analysis & Visualizations with Excel training course, you'll learn:

Data Analysis Fundamentals

  • Data analysis scenarios
  • Tables
  • Sort and filter data

Visualizing Data with Excel

  • Visualize data with charts
  • Modify and format charts
  • Best practices for selecting charts

Analyzing Data with Formulas and Functions

  • Analyze data with formulas
  • Analyze data with functions
  • Analyze data with data validation, forms, and controls
  • Create conditional visualization with Lookup functions

Analyzing Data with PivotTables

  • Create a PivotTable
  • Analyze PivotTable data

Presenting Visual Insights with Dashboards in Excel

  • Visualize data with PivotCharts
  • Filter Data using Slicers
  • Create a dashboard in Excel

Creating Geospatial Visualizations with Excel

  • Create map charts in Excel
  • Format and customize map charts in Excel

Performing Statistical Analysis

  • Visualize trendlines and sparklines with Excel
  • Analyze data with the data analysis toolpak

Getting and Transforming Data

  • Connect to data with queries
  • Clean and combine
  • Shape and transform data

Modeling and Analyzing Data with PowerPivot

  • Install PowerPivot in Excel
  • Create data models with PowerPivot
  • Create PowerPivots
  • Perform advanced data analysis and visualization

Presenting Insights with Reports

  • Planning a report
  • Creating a report
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By clicking submit, you agree to our Privacy Policy and Terms of Use, and consent to receive marketing emails from Pluralsight.
Related Pages