Microsoft Excel Advanced 2 : Pivot Tables
Perfect your use of Excel by going further.
Create, modify and reorganize a Pivot Table
Analyze and aggregate data to get a good report
Training options
Videos
Online and On-Demand
at your rythm
- Instant Access 24/7
Unlimided viewings for 1 year - Flexible: follow every course at your own rythm and schedule
- Training manual and exercice files provided
- Official Attestation given after course completion
Remotely
Public Classes
with Live Teacher
- Online classes with live teacher
- max 10 participants
- Training manual and exercice 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
- In online classes or at your office
- Standard or custom-made syllabus
- Live, private Teacher
- Training manual and exercice files provided
- Official Attestation given after course completion
Microsoft Excel Advanced 2 : Pivot Tables
from:$149.99 /pers.
Demander une formation privée
Contact
We'll get back to you within one business day.
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.
Advanced
Basic knowledge of Excel’s functions.
- Create, modify and reorganize a Pivot Table
- Analyze and aggregate data to get a good report
- Perform a VLOOKUP and HLOOKUP
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
Need to assess your level?
Select the right course for you using the Formation CAD Auto-Assessment tool
Related courses
Formations apparentées
- 1 year Support
- Official Certificate
approved
- 1 year Support
- Official Certificate
approved
- 1 year Support
- Official Certificate
approved