logo-slvexpert

VOTRE

FORMATION

Excel training workshop – Pivot table for controller and analyst
$ 395
AF3490
Brossard, Laval, Montréal, Pointe-claire
6 heures (9h à 16h)
Anglais
En classe

Résumé :

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

VOS FORMATEURS:

CALENDRIER :

04/12/20186700 Route Transcanadienne, Pointe-ClaireFrançois Jasmin CPA, CA
11/12/20183095 boul. de la Concorde Est, LavalFrançois Jasmin CPA, CA
21/02/20196185 boul. Taschereau, BrossardFrançois Jasmin CPA, CA
14/03/20197378 rue Lajeunesse, MontréalFrançois Jasmin CPA, CA