Live workshopMicrosoft Office training for teams
Microsoft Excel PivotTables
- Built around your actual work
- Live online, or on-site by request
- Training careers nationwide since 2006
Workshop brief
Microsoft Excel PivotTables
- Duration
- 7 hrs (2 sessions)
- Tuition
- $359.00per participant; team and private pricing by quote
- Delivery
- Live onlineOn-site, in person, by request
- Included
- Certificate of completionFor every participant
The answer is in the data. It is forty thousand rows down.
A PivotTable is the highest return per hour of anything in Excel. Someone spending a day a month building summaries by hand can usually replace it with about twenty minutes of work, and most people have either never been shown or tried once and got a mess.
The mess is almost always the source data, which is the part skipped in every tutorial. This workshop starts there, because a pivot built on badly structured data will produce a confident wrong answer rather than an error.
Operations, finance, and reporting leaders use this where staff are manually summarizing data that a pivot would handle. It is the most requested Excel topic at DWC for a reason. Participants work on their own datasets and leave with working reports.
Content, datasets, and examples are built around your actual work before delivery. Most groups train live online, and on-site in-person delivery is available by request. This workshop is available by request only, with a three participant minimum, and sits alongside our other data analytics and data literacy workshops.
Why teams book DWC
- Content, datasets, and examples built around your work before delivery
- Live online with a real instructor, or on-site at your location
- Invoicing and purchase order documentation for your organization
What your team gets
This course includes
- Live, instructor led workshop delivered in two sessions
- Hands on work on your own datasets, including fixing the source
- Grouping, slicing, filtering, and interactive exploration
- Techniques for spotting a pivot that is quietly wrong
- Digital learning materials and take home reference guides
- Certificate of completion for every participant
Course outline
How the workshop runs
Every session is live with a real instructor, and the exercises are built around your team's work.
The first session is source data and the basics, in that order. Participants learn what a pivot needs in order to work and why the layout most people build by instinct will not, then fix their own data and build their first real summary. Most see the day pay for itself in the first hour.
The rest of the first session and into the second is control. Participants learn to slice by any dimension without rebuilding, group dates and values into the buckets that matter, filter interactively so a manager can explore rather than request, and lay out a pivot for a reader rather than an analyst.
The second session closes on calculation and trust. Participants learn to calculate inside the pivot, and, more importantly, when a pivot is quietly misleading them: the filter they forgot, the blank that is being counted, the total that is not the sum of what is shown. They leave able to check a pivot rather than assume it.
Outcomes
What You'll Learn at a Glance
- Structure source data so a PivotTable will actually work
- Summarize tens of thousands of rows in seconds
- Slice by any dimension without rebuilding the report
- Group dates and values into the buckets that matter
- Build interactive filtering so managers explore instead of request
- Calculate inside a PivotTable
- Recognize when a PivotTable is quietly giving you the wrong number
Duration
Prerequisites
Participants should be comfortable entering data and navigating a spreadsheet. Formula experience helps but is not required. Those new to Excel should start with Microsoft Excel Beginners (Level 1).
Format
Online for most groups; on-site delivery by request.
Dates and options
Join a public session or book your teamBook this workshop for your team
Public sessions
Train your team privately
Schedule this workshop for your team, live online or on-site, with content built around your work. Tell us your group size, goals, and target dates.
How team training works
From first call to trained team
- 20,000+Participants trained
- 90%Completion rate
- 1,500+Organizations served
Scope it
A short call about your team, your tools, and what needs to change after the session.
Customize it
Your instructor builds examples, exercises, and datasets around your actual work before delivery.
Deliver it live
Live online for most groups, or on-site at your location, scheduled around your team.
Make it stick
Every participant leaves with reference materials and a certificate of completion.
Pricing
Tuition and ways to buy
$359.00 per participant
Microsoft Excel PivotTables is available by request only, scheduled around your team.
- $359 per participant, with a three participant minimum
- Private training: request a custom quote. One on one sessions and teams below the three participant minimum are priced case by case
- Larger groups: request a custom quote. We price larger cohorts case by case based on group size, schedule, and delivery format
Request a quote and we will build pricing around your team.
- Per participant
Enroll a few employees at the per-participant rate.
- Private team session
Your group only, built around your data, tools, and schedule.
- Invoice your organization
DWC invoices your company directly and provides purchase order documentation.
- Multi-workshop programs
Combine workshops into a series for a department or a cohort of new managers.
Microsoft Office training
Microsoft Office training for employees
Excel is the tool most teams use every day and the one fewest people were ever taught. DWC builds Microsoft Office training for employees in levels, from beginner foundations through advanced Excel, Word, Outlook, PowerPoint, SharePoint, and Power BI, so each person starts where they are and every session uses your own files.
Combine workshops into a Microsoft Office skills program for new hires, a single department, or a whole team moving work into Microsoft 365.
Can you customize this workshop for our team?
Yes. Content, datasets, and examples are built around your actual work before delivery, so participants practice on the files, tools, and situations they deal with every day.
Is the training online or on-site?
Most groups train live online with a real instructor. On-site, in-person delivery is available by request.
Is there a minimum group size?
Most workshops booked for a team have a three participant minimum, and the Tuition section on each workshop page lists its exact terms. One-on-one sessions and smaller groups are priced case by case, and larger groups are quoted based on group size, schedule, and delivery format.
Can employees at different skill levels attend?
Most Microsoft Office workshops come in levels, from beginner through advanced, so you can place each employee in the right session. We can help you sort your team by level before you book.
Can you train our team on Excel, Word, and Outlook together?
Yes. Workshops can be combined into a multi-workshop program for a department or a new hire group, scheduled around your team and built around the files you use.
Do participants receive a certificate?
Yes. Every participant receives a certificate of completion, along with digital learning materials and take-home reference guides.
Can we pay by invoice or purchase order?
Yes. DWC invoices your organization directly and provides purchase order documentation.
Can individual employees join a public session?
When a workshop has public dates, they appear in the Dates section of this page with a registration button. If none are listed, request a quote and we will share your options.
Bring this workshop to your team
Tell us about your group and your goals. A training advisor follows up within one business day with options and pricing.