Information Technology
MS Office
CH166
MS Excel: Graphs and Dynamic Pivot Tables
Learn to master real-time data analysis.
89%
overall satisfaction for this course
?Average calculated from scores obtained from 784 participants who took this course.- Duration 1 day
- Regular fee 350 $
- Preferential fee 300 $ ?
-
Locations
- Quebec City
- Montreal
- Top pick
-
Laboratory
course
Objectives
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.
Customer Testimonials
Very interesting, this course is going to increase my productivity.
Alexandre B. / Formateur, Groupe Informatique Technologia
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
General Note
Note: This course is presented using Excel 2016 and also covers features available in Excel 2007, 2010 and 2013. The version of the course presented using Excel 2003 is available upon request.
Trainer(s) assigned(s)
Other course(s) in this category
-
CH167
MS Office
MS Excel Functions
-
CH128
MS Office
The Essentials of MS Excel for Managers