Excel training workshop – Pivot table for controller and analyst 

ACTIVITY OFFERED IN PARTNERSHIP

  • Partner: SLV Expert inc.
  • Registration/cancellation: Follow the Order’s normal procedure.
  • Final registration confirmation sent by: SLV Expert inc.
  • Price: Please see the schedule fee below. Prices are subject to change without notice.
  • Location: Verify your registration confirmation. You will receive it in the days following your registration or in the days preceding the course.
  • Lunch: Not included

Description

This training was specifically developed for CPA working in companies within the finance and accounting department. Our Excel training was developed with the tasks and responsibilities of these professionals in mind.

PivotTables (PT) are interactive tables that allow the user to group and synthesize large amounts of data in a concise table format. Using PT, you will be able to drill data interactively.

After this training, you will be able to master all the options available to you. You will be able to customize it and ensure the integrity of your data.

Technical information

SLV Expert inc. will provide the laptop needed for this course.

Content

  • Introduction
  • Start the PivotTables Wizard
    • Creating a table        
    • Creating the pivot table
  • Display mode
  • PivotTables options
    • Layout and formatting
    • Totals and filters
    • Viewing
    • Impression
    • Data
    • Replacement text
  • Grouping data
    • Date
    • Number
  • Filtering data
    • Inside the PivotTable
    • With the use of segments and chronological segments
  • Formatting PivotTables
    • Parameters of the values fields
    • Field settings
    • Layout and printing
  • Custom Calculated Fields Preprogrammed Calculated Fields (14) 
    • Custom Formatting
    • Color
    • Conditional formatting
    • Spacing
  • Pivot charts

Target clientele

This training is intended for participants who have no experience with PT or current users who want to demystify some 

Description complète


Brossard – SLV Expert - Brossard


Séance(s)
Pour tous

Saison de formation : 2019-2020
No de séance : 7480
Date de début : 2020-01-30, 09:00
Date de fin : 2020-01-30, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

7 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Laval – SLV Expert inc.


Séance(s)
Pour tous

Saison de formation : 2019-2020
No de séance : 6015
Date de début : 2019-11-21, 09:00
Date de fin : 2019-11-21, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

6 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Pour tous

Saison de formation : 2019-2020
No de séance : 6279
Date de début : 2020-03-06, 09:00
Date de fin : 2020-03-06, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

8 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Séance(s)
Pour tous

Saison de formation : 2019-2020
No de séance : 6143
Date de début : 2019-12-13, 09:00
Date de fin : 2019-12-13, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

5 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Aucune formation à distance trouvée.

1.0.0.0