Learn to master real-time data analysis.
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.
Is it for you ?
Any audience.
Prerequisites
Basic knowledge of Excel.
Training content
- Creating a dynamic pivot table
- Modifying and organizing table fields
- Creating new calculated fields
- Modifying source data, and updating
- Grouping functions for text and dates
- Extracting the source data from a result
- Formatting a dynamic pivot table
- Creating a dynamic graph
- Modifying and positioning a graph
- Using different types of graphs
- Using a secondary axis
- Adding trend curves
Keep in Mind
Note: This course is presented using Excel 2019 and also covers features available in Excel 2007, 2010, 2013 and 2016. The version of the course presented using Excel 2003 is available upon request.
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
