Skip to content
  • Remote Classes and online courses for professionals and businesses. Official Attestations approved by Emploi Québec and professional associations

    • +1 (877) 260-6888
    • Français
    • +1 (877) 260-6888
    • Français
Formation CADFormation CAD
  • 0
    Cart
    No products in the cart.
    • Courses and Trainings
      • Autodesk
        • Autocad
        • Revit
      • Microsoft
        • Access
        • Copilot
        • Excel
        • OneDrive
        • OneNote
        • Outlook
        • Power Automate
        • Power BI
        • Planner
        • PowerPoint
        • Project
        • SharePoint
        • Teams
        • To do
        • Word
        • Microsoft 365
      • Microsoft Bundles
        • Microsoft 365 Complete CoursesCollaboration with Teams, Outlook, OneDrive, SharePoint, from beginner to advanced
        • Microsoft Office Complete CoursesExcel, Word, PowerPoint, Outlook from beginner to expert
        • Microsoft Office Basics CoursesExcel, Word, PowerPoint, Outlook, base levels
        • Excel Complete CoursesFrom Beginner to Expert
        • Word Complete CoursesFrom Beginner to Advanced
      • AI Artificial Intelligence
        • Copilot
      • Security
        • Cybersecurity
  • About
    • Formation CAD Advantage
  • Contact
  • 0
    • No products in the cart.
  • Free assessment
  • Menu
Home » Courses and Trainings » Microsoft Courses » Microsoft Excel
Filter

Home » Courses and Trainings » Microsoft Courses » Microsoft Excel

Microsoft Excel Advanced 2 : Pivot Tables

Microsoft Excel Advanced 2 : Pivot Tables

Courses in English customized office course excel

Perfect your use of Excel by going further.

Create, modify and reorganize a Pivot Table

Analyze and aggregate data to get a good report

Microsoft Excel Advanced 2 : Pivot Tables

Emploi Québec

Microsoft Excel Advanced 2 : Pivot Tables

from:$149.99 /pers.

Advanced

3hrs (course+practice)

97.7% statisfaction rate

Excel Advanced 1 and 2 for 199$
Choose a course

Training options

Videos

Online and On-Demand
at your rythm

from:$149.99 /pers.

Instant Access 24/7
Buy the Video Course
  • Instant Access 24/7
    Unlimited viewings for 1 year
  • Flexible: follow every course at your own rhythm and schedule
  • Training manual and exercise files provided
  • Official Attestation given after course completion

Remotely

Public Classes
with Live Teacher

from:$149.99 /pers.

Next classes schedule
View available dates
  • Online classes with live teacher
  • max 10 participants
  • Training manual and exercise files provided
  • Live Q&As during classes and coaching during practice sessions.
  • Official Attestation given after course completion

Private

Online or at your Office
tailored to your schedule

get a quote:

price per team

Reply and custom quote within a business day
Contact Us
  • In online classes or at your office
  • Standard or custom-made syllabus
  • Live, private Teacher
  • Training manual and exercise files provided
  • Official Attestation given after course completion

Microsoft Excel Advanced 2 : Pivot Tables

Select the class of your choice :

date_rangeTuesday 3 June 2025
watch_later13:00 - 16:00
date_rangeTuesday 15 July 2025
watch_later13:00 - 16:00
date_rangeThursday 21 August 2025
watch_later13:00 - 16:00
date_rangeTuesday 7 October 2025
watch_later13:00 - 16:00
date_rangeThursday 13 November 2025
watch_later13:00 - 16:00
date_rangeThursday 18 December 2025
watch_later13:00 - 16:00
/ /

Want to watch again part of or the entire course you participated in?
Get a video recording (on-demand streaming) of the class you attended:

Microsoft Excel Advanced 2 : Pivot Tables

from:$149.99 /pers.

Acheter les vidéosVoir les dates disponibles
Demander une formation privée

Contact

We'll get back to you within one business day.

  • This field is for validation purposes and should be left unchanged.
Description

Deepen your skills with our Microsoft Office Excel certified training. This tool allows you to specify your numbers and data through multiple possibilities according to your needs. Master the most complex features of Excel software and impress your team and employer with name management, data protection, and validation!

In this advanced-level course, you will have the necessary knowledge to create, modify and reorganize a Pivot Table

See an overview of the lesson details by referring to the course outline.

With this advanced knowledge of Excel software, take your business to the next level with more in-depth analysis and more relevant data.

Duration
3 hours (course+practice)
Level

Advanced

Prerequisites

Basic knowledge of Excel’s functions.

Goals
  • Create, modify and reorganize a Pivot Table
  • Analyze and aggregate data to get a good report
  • Perform a VLOOKUP and HLOOKUP
Syllabus

PIVOT TABLE

field List

  • Arrange fields in the right place
  • In rows and/or columns
  • Use the report filter
  • Choose the right summary and format in Values

TOOLS tab

  • Choose the right layout
  • Add or remove totals and subtotals
  • Choose a style to enhance the Pivot Table

Options (ANALYSIS)

  • Change the source and refresh the data
  • Show percentage values
  • Use segments with its views
  • Group selection: (Date, number)
  • Insert a Pivot Table
  • Create a Simple Calculated Field (Depending on the time)

 

NAME MANAGER

  • Define a name
  • Edit, delete a name

RESEARCH

  • Create, use and understand VLOOKUP
    and HLOOKUP

FORMULA VERIFICATION

  • Identify dependents and precedents
  • View formulas

Questions & Answers

Downloadable PDF Syllabus

Excel Advanced 2 Syllabus

Download

Need to assess your level?

Select the right course for you using the Formation CAD Auto-Assessment tool

Free Assessment
Microsoft Excel Advanced 2 : Pivot Tables
Microsoft Excel Advanced 2 : Pivot Tables

Related courses

Formations apparentées

Microsoft Excel Expert
Microsoft Excel

Microsoft Excel Expert

Expert

3.5 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$199.00 /pers.
Microsoft Excel Basics 2
Microsoft Excel

Microsoft Excel Basics 2

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$199.99 /pers.
Microsoft Excel Basics 1
Microsoft Excel

Microsoft Excel Basics 1

Beginner

6 hours
Video
Online Classes
Private
Included with this course:
  • 1 year Support
  • Official Certificate
Emploi Québec
approved
from:$199.99 /pers.
Formation CAD
Autocad, Autodesk, and Microsoft Office 365 courses. Online classes with live, accredited teachers. Training center offering tailor-made courses for companies and administrations everywhere in Canada.
Tools
  • Online classroom connection information
  • Assess your level prior to choosing a course
    • Microsoft Office Assessment
    • Autodesk Assessment
  • Training Subsidies
    • Training Subsidies Discovery Tool
    • All available Training Subsidies
  • Terms and Conditions
Online Courses
  • AI Artificial Intelligence
  • Autodesk Courses
    • Autocad
    • Revit
  • In-Office Training
  • Microsoft Courses
    • Custom Courses and In-Office Training
    • Microsoft 365 (Office) Courses
    • Microsoft Copilot
    • Microsoft Courses Bundles
    • Microsoft Excel
    • Microsoft OneDrive
    • Microsoft OneNote
    • Microsoft Outlook
    • Microsoft Planner
    • Microsoft Power Automate
    • Microsoft PowerPoint
    • Microsoft Project
    • Microsoft SharePoint
    • Microsoft Teams
    • Microsoft To do
    • Microsoft Visio
    • Microsoft Windows
    • Microsoft Word
  • Security Courses
Newsletter

Get tools, advice and specials from Formation CAD directly in your inbox!

  • This field is for validation purposes and should be left unchanged.
Copyright 2025 © Formation CAD
  • Courses and Trainings
    • Autodesk
      • Autocad
      • Revit
    • Microsoft
      • Access
      • Copilot
      • Excel
      • OneDrive
      • OneNote
      • Outlook
      • Power Automate
      • Power BI
      • Planner
      • PowerPoint
      • Project
      • SharePoint
      • Teams
      • To do
      • Word
      • Microsoft 365
    • Microsoft Bundles
      • Microsoft 365 Complete Courses
      • Microsoft Office Complete Courses
      • Microsoft Office Basics Courses
      • Excel Complete Courses
      • Word Complete Courses
    • AI Artificial Intelligence
      • Copilot
    • Security
      • Cybersecurity
  • About
    • Formation CAD Advantage
  • Contact
  • Login / Register
  • Free assessment
    • Français

Login

Lost your password?