If you have large amounts of data that you want to extract key information from, this training on Excel pivot tables will make your life easier. Pivot tables allow you to sort data for optimal presentation and analysis. The associated graphs make it easy to visualize and understand according to your business or presentation needs.
Objectives
To provide the knowledge and skills required to use the different Microsoft Excel graphics and dynamic pivot table features.
Is it for you ?
Any audience.
Prerequisite
Basic knowledge of Excel. This training is not suitable for users with Mac computers.
Content
Being able to extract relevant information from a database is essential. This is
precisely what Excel's pivot tables (or DCTs) allow you to do, by offering the
user the possibility to perform various types of data cross-referencing and
synthesis, as needed.
This training on pivot tables and dynamic graphs gives you concrete ways to use
them to get the most out of your data, in a concise manner.
Pivot tables
- Why and when to use a DCT
- Data sources that can be used to design a DCT
- Choosing and preparing the data source
- Designing, modifying and embellishing
- Filtering and grouping data
- Creating copies
- Refreshing your data
- Performing calculations in a DCT
- Protection of information
Détails + / -
Graphics
- Creating a dynamic cross tabbed chart
- Appropriate chart types
- Preparing source data to create charts
- Formatting
- The chart area
- Axes
- Number Formats
- Legend and title
- Data series
- Adding data to an existing graph
- Adding a curve to a histogram chart
- Modifying data axes
- Resizing
- Creating various types of charts
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote