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, 1 Day
In-Person | Onsite6 hours/day, 1 Day
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, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, 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
The need to analyze data and gain actionable insight is greater than ever. This course will teach you to harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. You will not only be able to summarize data for analysis but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.
Learning Objectives
Prepare data and build PivotTables from multiple sources
Analyze data by using PivotTables
How to work with PivotCharts
Who It's For
Business professionals who regularly work with data and need to generate meaningful insights.
Data analysts and reporting professionals who summarize and organize information for business decisions.
Managers and team leaders who use data to monitor performance and support planning.
Administrative and finance professionals who prepare reports from multiple data sources.
Excel users who want to develop practical skills in PivotTables and PivotCharts for data analysis.
Course Agenda
Three modules · 12 topics
1Preparing Data and Creating PivotTablesTopics 1–4
Organizing Data for Your Workflow
Create a PivotTable from a Local Data Source
Create a PivotTable from Multiple Local Data Sources
Create a PivotTable from an External Data Source
2Analyzing Data by Using PivotTablesTopics 5–9
Summarize PivotTable Data
Organize PivotTable Data
Filter PivotTable Data
Format a PivotTable
Refresh and Change PivotTable Data
3Working with PivotChartsTopics 10–12
Create a PivotChart
Manipulate PivotChart Data
Format a PivotChart
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 Microsoft Excel: Data Analysis with PivotTables course about?
This course teaches participants how to use Excel PivotTables and PivotCharts to summarize, organize, analyze, and present data. It covers creating PivotTables from different data sources, analyzing information, and building visual reports to support better business decisions.
What are the key learning objectives of this PivotTables course?
Participants will learn how to prepare data, create PivotTables from multiple sources, analyze information using PivotTable features, and work with PivotCharts to present data visually.
What is a PivotTable in Microsoft Excel?
A PivotTable is an Excel feature that helps summarize, organize, filter, and analyze large sets of data. It allows users to rearrange information and view important details without manually creating multiple summaries.
What are the benefits of using PivotTables for data analysis?
PivotTables make it easier to identify patterns, compare information, summarize large datasets, and organize data for reporting. They help turn raw information into insights that can support informed business decisions.
How can I summarize data using PivotTables?
PivotTables allow you to group and summarize information to make large datasets easier to understand. You can arrange data into meaningful categories and review important totals or comparisons for analysis.
What is a PivotChart in Microsoft Excel?
A PivotChart is a chart connected to a PivotTable that visually represents summarized data. It helps users identify patterns, compare values, and communicate findings more clearly.
What is the difference between a PivotTable and a PivotChart?
A PivotTable organizes and summarizes data in a structured table, while a PivotChart presents that summarized information visually. Both features help analyze data, but they serve different purposes in reporting and presentation.
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.