Optimizing 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

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 0.5 days
  • Regular price: $285
  • Preferential price: $255

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

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.
Marc Maisonneuve
Marc Maisonneuve
Trainer and Professional Efficiency Consultant
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Be aware of trends, innovations and best practices, every month.
Confidentiality
Training center accredited by Emploi-Québec, Accreditation : 0051460
GST : 141582528 – QST : 1019557738
© 2021 AFI
AFI Expertise

The AFI experience brought to you by Edgenda

At AFI, our focus is to offer you relevant training and impactful learning experiences in line with your transformation approach. Do you need support for your approach? Check out Edgenda’s services: Edgenda.com