top of page
Information Générale.
Pivot Tables
Practically: Learning how to keep information and data to make out fresh reports about it!
Outcomes: You will learn how to look at single table data in a fresh new way from sales, people lists, project data and even survey results. You will be able to find information that would require complicated math in 2-3 swift clicks. The magic of Pivots is waiting just for you!
James Dupuis-Howard
Raisons de communiquer
1. Questions et demandes
2. Documents et exercices
Votre formateur
LVL 2 - Intermediate Excel
Horaire de formation.
08:30 to 09:00 - Bienvenue au Zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause & Exercice
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause & Exercice
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Questions & Évaluation
Intro to pivots
Tables
Data Best Practices
Data Best Practices
15 minutes avant - Bienvenue au Zoom (Optionnel)
Premières 45 minutes -
Dernières 15 minutes - Questions
DATES à VENIR
No Dates
Available
JOUR 1
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 1
11:00 to 12:00 -
12:00 to 13:00 - Le lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercices 2 & 3
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & évaluation
Intro to pivots
Tables
Data Best Practices
JOUR 2
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 4
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercice 5&6
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & Évaluation
Macros with Pivots
Cross tables and Name lists
Building a Report
JOUR 1
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 1
11:00 to 12:00 -
12:00 to 13:00 - Le lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercices 2 & 3
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & évaluation
Tables
Data Best Practices
JOUR 2
08:30 to 09:00 - Bienvenue au zoom (Optionnel)
09:00 to 10:00 -
10:00 to 11:00 - Pause et exercice 4
11:00 to 12:00 -
12:00 to 13:00 - Le Lunch
13:00 to 14:00 -
14:00 to 15:00 - Pause et exercice 5&6
15:00 to 15:30 - Conclusion
15:30 to 16:00 - Question & Évaluation
Cross tables and Name lists
Building a Report
bottom of page