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.
Duration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
Objectives of the training
To provide the knowledge and skills required to use the different Microsoft Excel graphics and dynamic pivot table features.Targeted audience
Any audience.Prerequisite
Basic knowledge of Excel.
Course architecture
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
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
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$340
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote