CH166

MS Excel: Graphs and Dynamic Pivot Tables

Learn to master real-time data analysis.

90%

overall satisfaction for this course

?Average calculated from scores obtained from 1032 participants who took this course.
See the training dates
  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Virtual Classroom
  • 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.

Training Details

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 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.

Customer Testimonials

Very interesting, this course is going to increase my productivity.

Alexandre B. / Formateur, Groupe Informatique Technologia

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Virtual Classroom

    September 28 2020 - 2013 / 2016 version - CONFIRMED

  • Virtual Classroom

    October 14 2020 - 2013 / 2016 english version

  • Virtual Classroom

    November 16 2020 - 2013 / 2016 version

  • Virtual Classroom

    December 7 2020 - 2013 / 2016 version

  • Virtual Classroom

    January 12 2021 - 2013 / 2016 version

Trainer(s) assigned(s)