Information Technology
MS Office
CH166
MS Excel: Graphs and Dynamic Pivot Tables
89%
overall satisfaction for this course
?Average calculated from scores obtained from 576 participants who took this course.- Duration 1 day
- Regular fee 350 $
- Preferential fee 295 $ ?
-
Locations
- Montreal
- Quebec City
- Top pick
-
Laboratory
course
Objectives
To provide the knowledge and skills required to use graphics and dynamic pivot tables with Microsoft Excel.
Targeted audience
Any audience.
Prerequisite
Basic knowledge of Excel.
Customer Testimonials
Always very enriching courses with Mr Tremblay. I goes by fast, we learn so much and it is very dynamic.
Karen F. / Coordonnatrice, soutien aux ventes, Stablex Canada inc.
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: the course is presented with Excel 2016 and 2013 and also covers features available in Excel 2007-2010. The version of the course presented with Excel 2003 is available on demand.
