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 295?
  • Locations
    • Quebec City
    • Montreal
  • Top pick
  • Laboratory
    course
SUMMARY
DETAILS

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

Everything I saw was unknown to me while I have been using Excel for 20 years. Bravo! Sir, you are an excellent teacher.

François C., Curateur public du Québec

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.

DATES*

*Unless stated otherwise, all sessions are in French.
  • Quebec City

    September 13 2018 - 2013 / 2016 version

  • Montreal

    October 10 2018 - 2013 / 2016 version

  • Quebec City

    November 27 2018 - 2013 / 2016 version

Trainer(s) assigned(s)