Optimize Data Analysis Using Pivot Tables and Graphs

Become an expert in pivot tables with this training. Optimize your existing tables and create new ones that are more efficient.
Microsoft Partner

Upcoming sessions

Show all sessions
Guaranteed to run
  • Duration: 0.5 days
  • Regular price: $215
  • Preferential price: $190

Course outline

Schedule : 1:00pm to 4:30pm

Our scheduled sessions are offered in French. Private sessions are available to you in English, contact us for more info.

Pivot tables and graphs are essential for quickly and accurately analyzing data. Pivot tables make it possible to cross-analyze data in just a few clicks. Pivot graphs are easy to create and, because they are visually compelling, enhance understanding. Creating slicers makes both tables and graphs more dynamic as well as easier to adapt to the user’s needs.
Practical and packed with tips, this training will help you improve your existing pivot tables and graphs, and create even more effective ones in the future. Quite simply essential for boosting your organization’s business intelligence, this training will benefit anyone who handles data lists and tables.

Audience

Intermediate Excel users or anyone who has taken the “Excel Essentials” or the “Discover Power Query and Dynamically Connect Data in Excel” training.

Duration

3.5 hours of theoretical presentation and demonstrations.
Versions taught

Excel 2013 | 2016

Objectives

Thanks to this training, you will be able to
  • understand when, why, and how to create a pivot table;
  • analyze, calculate, and organise your data;
  • create a pivot graph.
Contents
Pivot tables
  • convert a normal range into a table
  • create a pivot table
  • use the field list function
  • create a report filter
  • use filters
  • update a pivot table
  • understand hidden or public segments
  • change the combine functions
  • group or ungroup data
  • display values as percentages
Creating formulas in a pivot table
  • fields calculated
  • elements calculated
Pivot graphs
  • create a graph
  • change the appearance of graphs

Surround yourself with the best

Sylvain Richer
Sylvain Richer
Trainer and Desktop Application Consultant
Passionate about knowledge transfer and unparalleled in his ability to make complex information easy to understand, Sylvain is a professional efficiency trainer whose expertise is requested again and again.
Leif Martin Bédard
Leif Martin Bédard
Trainer and Desktop Application Consultant
Specialized in the Microsoft suite and with a background in accelerated learning, Leif is a trainer whose communication approach and adaptability are always fully appreciated
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Ghislain Parent
Ghislain Parent
Trainer and Professional Efficiency Consultant
With more than 25 years of experience, Ghislain thrives on the challenge of improving your work team’s efficiency.