CH166

MS Excel: Graphs and Dynamic Pivot Tables

90%

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
SUMMARY
DETAILS

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

Qualified and dynamic trainer.

Benoit C. / Chef gestion de catégorie, Coca-Cola

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.

DATES*

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

    December 12 2016 - 2016 version

  • Montreal

    January 30 2017 - 2010 version

  • Montreal

    March 13 2017 - 2013 version

  • Montreal

    May 3 2017 - 2016 version

  • Quebec City

    May 25 2017 - 2016 version

  • Montreal

    June 12 2017 - 2013 version

Trainer(s) assigned(s)