Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories
Certifications
Data + Analytics
Design + UX
Dev + Engineer
Finance
HR + Recruiting
Marketing
Operations
Power Apps
Project
Project Management
Sales
SharePoint
software assurance
System Center
Technology
Training & Education
Virtual Training
Windows 10
Windows 7
Windows 8
Windows Server 2

Data Analysis and Visualization with Microsoft Excel

Instructor‑Led: $590 | Duration: 2 Days

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
12/29/2025 12/30/2025
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$590
2/9/2026 2/10/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$590
3/23/2026 3/24/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$590
4/29/2026 4/30/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$590
6/9/2026 6/10/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$590
START DATE : 12/29/2025
END DATE : 12/30/2025
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $590
START DATE : 2/9/2026
END DATE : 2/10/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $590
START DATE : 3/23/2026
END DATE : 3/24/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $590
START DATE : 4/29/2026
END DATE : 4/30/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $590
START DATE : 6/9/2026
END DATE : 6/10/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $590

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

Data Analysis and Visualization with Microsoft Excel Course Outline

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.

Microsoft? Excel? is designed for this purpose. 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. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Who Should Attend this Course?

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

PREREQUISITES

Excel – Part 1 & 2 or equivalent experience

1 – DATA ANALYSIS FUNDAMENTALS

  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data

2 – VISUALIZING DATA WITH EXCEL

  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design

3 – ANALYZING DATA WITH FORMULAS AND FUNCTIONS

  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions

4 – ANALYZING DATA WITH PIVOTTABLES

  • Create a PivotTable
  • Analyze PivotTable Data

5 – PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL

  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel

6 – CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL

  • Create Map Charts in Excel
  • Customize Map Charts in Excel

7 – PERFORMING STATISTICAL ANALYSIS

  • Visualize Trendlines and Sparklines with Excel
  • Analyze Data with the Data Analysis ToolPa

8 – GETTING AND TRANSFORMING DATA

  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data

9 – MODELING AND ANALYZING DATA WITH POWER PIVOT

  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots
  • Perform Advanced Data Analysis and Visualization

10 – PRESENTING INSIGHTS WITH REPORTS (OPTIONAL)

  • Plan a Report
  • Create a Report

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Explore Related Training Courses

What Our Students Are Saying

IT Certification Training Course Reviews