Data Analysis and Visualization with Microsoft Excel
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelGeneral Workforce
Virtual | Live Trainer4 hours/day, 2 Days
In-Person | Onsite6 hours/day, 2 Days
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General Workforce(this course)Develops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
FundamentalsBuilds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
AdvancedDeepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 2 DaysLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 2 DaysEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
Course Overview
This course is designed for students who already have foundational knowledge and skills in Microsoft Excel and who wish to perform robust and advanced data and statistical analysis with Excel. You will learn to use tools such as Power Pivot and the Data Analysis ToolPak to analyze and visualize data and insights.
Learning Objectives
Perform data analysis fundamentals.
Visualize data with Excel.
Analyze data with formulas, functions & PivotTables.
Present visual insights with dashboards in Excel.
Create geospatial visualization with Excel.
Perform statistical analysis and transform data.
Model and analyze data with Power Pivot.
Who It's For
Excel users with foundational knowledge who want to develop advanced data analysis skills.
Data analysts and business analysts who work with spreadsheets and business data.
Finance, accounting, operations, and reporting professionals who need to analyze and interpret data.
Managers and decision-makers who want to present data insights through charts and dashboards.
Professionals interested in statistical analysis, data modeling, and advanced Excel tools such as Power Pivot.
Course Agenda
Ten modules · 28 topics
1Data Analysis Fundamentals Topics 1–3
Introduction to Data Science
Create and Modify Tables
Sort and Filter Data
2Visualizing Data with ExcelTopics 4–6
Visualize Data with Charts
Modify and Format Charts
Best Practices in Chart Design
3Analyzing with Formulas & FunctionsTopics 7–10
Formulas and Named Ranges
Functions
Data Validation, Forms, and Controls
Conditional Visualizations with Lookup
4Analyzing Data with PivotTablesTopics 11–12
Create a PivotTable
Analyze PivotTable Data
5Visual Insights with DashboardsTopics 13–15
Visualize Data with PivotCharts
Filter Data Using Slicers and Timelines
Create a Dashboard in Excel
6Creating Geospatial VisualizationsTopics 16–17
Create Map Charts in Excel
Customize Map Charts in Excel
7Performing Statistical AnalysisTopics 18–19
Visualize Trendlines and Sparklines
Analyze Data with the Data Analysis ToolPak
8Getting and Transforming DataTopics 20–22
Connect to Data with Queries
Clean and Combine Data
Shape and Transform Data
9Modeling & Analyzing with Power PivotTopics 23–26
Install Power Pivot in Excel
Create Data Models with Power Pivot
Create Power Pivots
Advanced-Data Analysis and Visualization
10Presenting Insights with ReportsTopics 27–28
Plan a Report
Create a Report
About our Trainers
Our Mission
Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.
What is the Data Analysis and Visualization with Microsoft Excel course?
This course teaches participants how to use Microsoft Excel for advanced data analysis, statistical analysis, and data visualization. It covers formulas, functions, PivotTables, dashboards, geospatial visualizations, Power Pivot, and the Data Analysis ToolPak.
Do I need prior Excel knowledge to attend this course?
Yes. The course is designed for participants who already have foundational knowledge and skills in Microsoft Excel. It focuses on developing advanced data analysis and visualization capabilities.
Will I learn how to create charts and visualizations in Excel?
Yes. The course covers creating, modifying, and formatting charts, along with chart design best practices. Participants also explore PivotCharts, trendlines, sparklines, and map charts.
Does the course cover Excel formulas and functions?
Yes. Participants learn about formulas, named ranges, functions, data validation, forms, controls, and conditional visualizations with lookup. These tools support more effective data analysis within Excel.
How can I create dashboards in Microsoft Excel?
The course covers visualizing data with PivotCharts, filtering information using slicers and timelines, and creating an Excel dashboard to present important data insights.
What is the Data Analysis ToolPak in Excel?
The Data Analysis ToolPak is an Excel add-in that provides tools for performing statistical analysis. The course introduces how to use it to analyze data and support statistical insights.
Will I learn how to prepare reports using Excel?
Yes. The course includes planning and creating reports to help participants present their findings and communicate data insights effectively.
Data Analysis and Visualization with Microsoft Excel
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.