(888) 804-1132

Excel PivotTables Master Class

Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today

Need Private Training for Your Group?

Choose your timezone

$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
Have more than 6 people for a course? Call us at (888) 804-1132 and ask about our group rates.

    Sorry, we do not currently have a class scheduled.

Request a date to run this course.
Suggest a date & time

Want to run this as a private class for your team?
Enquire about running this event as a private class

These are the topics covered in our Excel PivotTables Master Course. 

  • Data List/Range Vs Data Table
  • Converting A Data List/Range Into A Data Table
  • Converting a range into a table
  • Sorting And Filtering The Data
  • Why Do We Gather Data?
  • What Is A Pivot Table
  • What Does A PivotTable Look Like?
  • How A PivotTable Creates A Summary
  • Data Sources
  • Preparing Data
  • Categorical Vs Calculable Data
  • Creating The PivotTable
  • PivotTable from local data source
  • PivotTable from external data source
  • PivotTable From Multiple Worksheets
  • The 4 Areas Of The PivotTable
  • Subtotals – 2 or more fields placed
    in one of the 4 areas
  • Filtering By Row And Column Fields
  • Filtering By The Filter Field
  • Working With Slicers
  • Why Is It Called A Pivot Table?
  • Adding And Refreshing Data
  • Adding Data To A Range
  • Adding Data To A Table
  • Changing From The Default Sum
    Function Calculation
  • Drill-Down To Detailed Values
  • Calculated Fields
  • Inserting a calculated field
  • Deleting a calculated field
  • Built-In Calculations
  • Data Structure
  • Determining Which Field Goes Into Which
    Area Of The PivotTable
  • The categorical/textual store field
  • The categorical/textual pizza-type field:
  • The calculable price field:
  • The calculable cost field:
  • The calculable quantity, gross, and profit fields
  • Insert A Timeline With A PivotTable Contextual Tabs
  • PivotTable Analyze Contextual Tab:
  • Design Contextual Tab
  • The Layout Group
  • Subtotals Button
  • Grand Totals Button
  • Report Layout Button
  • Blank Rows Button
  • PivotTable Style Option
  • PivotTable Styles 

Download the Brochure for More Details

Dive Deeper into Excel: Our PivotTables Masterclass is specifically tailored for those with a solid foundation in Excel, who are ready to take their skills to the next level. This course is ideal for:

  • Experienced Business Professionals: If you're already proficient in Excel and routinely work with large datasets, this advanced course is the perfect opportunity to deepen your data manipulation and analytical skills. Decision-makers in finance, sales, or other data-intensive roles will benefit from this.

  • Academics in Advanced Research Roles: If your work involves deep statistical analysis or the processing of vast amounts of research data, this course will equip you with the necessary advanced skills for efficient and effective data interpretation.

  • Senior Project Managers: If you're managing large-scale projects and rely on data-driven strategies to measure progress, troubleshoot issues, and forecast outcomes, this course will enhance your project tracking and reporting abilities.

  • Excel Power Users: If you're already an avid Excel user and want to delve into its more complex functionalities, this course is your next step. Mastering PivotTables and PivotCharts will give you an edge, letting you handle larger datasets and complex data structures with ease.

  • Professional Freelancers: If you're a data analysis or project management consultant and want to offer more advanced services to your clients, this course will augment your capabilities and, consequently, your market value.

In essence, this advanced masterclass is designed for those ready to push the boundaries of what they can achieve with Excel, leveraging the full power of PivotTables for data management and analysis.

Michel is an experienced corporate trainer with 20 years of experience and a bachelor’s degree in Business Management. He takes pride in having a unique training style, focusing as much on the ‘What’ and ‘Why’ as it is on the ‘How to’ factor. Michel’s classes showcase real-life examples, comparisons, and analogies that all audiences can relate to and benefit from the simplicity of the presented material.

What if I have learners that have different skills sets, some beginners and some more advanced?

Your training specialist will assist you with developing a curriculum that will ensure that no one is left behind. Depending on group size, your consultant may suggest delivering multi sessions so that beginning students don’t feel pressured and more advanced learners don’t feel like the pace is too slow.

Because every situation is different, it is best to discuss this with your Tech Touch Training Specialist, who will help you to come up with a plan that is both economical and efficient.

Where does the training take place?

Your customized training can be delivered either online via Zoom or Webex, or we can bring the training to your location. If you don’t have a space at your site and would prefer not to attend the training online, we can find a location near you, for example at a hotel conference room or similar location.

Talk to your Tech Touch Training Specialist about your options, and we will find a suitable option that best fits your needs and that of your team.

What version do you teach?

Our team of expert instructors can deliver training in any version, so you will be able to learn on the exact version you are using for your projects.

Most businesses have access to the Microsoft 365 Business plans, which allows staff to download the latest version. The most recent version is what we recommend, as you will have the latest features and capabilities.

Tech Touch instructors keep up-to-date on the latest tools for each program in the Microsoft suite. Because our instructors are Microsoft Certified, they often get access to the latest version of these programs in advance of them being made available to the public, so they have familiarized themselves with the latest tools before you have access to them. Therefore, we are able to deliver your best training experience when you are.

Is the training with a live instructor?

Absolutely! Whether you attend the training online or at your location, there is a live instructor delivering your class. No video recordings here.

Having a live instructor available so your team can ask questions and get real-time assistance, is the best training model for learning programs in the Microsoft Office Suite. At Tech Touch, we want you to have the best learning experience possible, so live instruction is a must.

What are the training times?

Most of our clients prefer to have class times starting at 9 am and ending at 4 pm, with a 1-hour lunch period.  This is something your Training Specialist will discuss with you based on your needs and availability.

Do we have to attend an all-day session, or can they be broken up into smaller sessions?

This is one of the biggest reasons Tech Touch offers customized training solutions. Your time is valuable and your team may not be available to leave their work for an entire day. We can offer half-day options and/or break your training sessions up over multiple consecutive or non-consecutive days.

Be sure to discuss your options with your Training Specialist.

$150 – $550 / Person / Session
*based on number of people

Advanced

For Groups Up to 15
*larger groups accommodated with multiple sessions

Virtual or In-person Private Training with a Live Instructor
*no public classes

Unlock the Power of Microsoft Excel with our PivotTables Masterclass!

Businessman working on pivot tables.Ever felt lost in the avalanche of data that Microsoft Excel can handle? Are you faced with the challenge of managing vast amounts of data and creating insightful summaries that can drive intelligent business decisions? You’re not alone!

Enter PivotTables, Excel’s secret weapon. At first sight, PivotTables might seem like an intimidating beast. But fear not, for beneath the complex exterior lies an incredibly simple and highly effective tool just waiting for you to uncover.

This course, designed by industry experts, will make your journey with PivotTables smooth and enlightening. We use relatable analogies to unravel the concept behind PivotTables and their myriad functionalities, proving that mastering PivotTables is not a mountainous task, but rather an achievable feat.


By the end of this comprehensive course, you’ll gain an in-depth understanding of PivotTables and learn the intricacies of PivotCharts. You’ll be a data wizard, knowing how to clean, prepare, and present your data.

Become a master of creating and customizing PivotTables and amaze everyone with visually stunning PivotCharts. Get ready to reshape your Excel experience and redefine your business decisions. Hop on board and let the magic of PivotTables transform your data analysis journey!

Ready to Learn More?

Reach out below to get started on your customized Excel PivotTables Master Class training course.

The
Tech Touch
Difference

With decades of experience in corporate training, we’re proven time and again that customized training programs are far more effective than cookie-cutter classes.

We put in the work beforehand to ensure that our programs meet your individual needs and goals with a laser-focus on exactly what you need to get YOUR job done.

At Tech Touch, we operate with integrity and passion. As such, we want to be your trusted training partner, not just a training company delivering a service.

Request a Quote

Fields marked with an * are required
error: Alert: Content selection is disabled!!