top of page
Introductory Notes.
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
Reasons to communicate
1. Questions & Inquiries
2. Handouts & Exercicses
Your Trainer
LVL 2 - Intermediate Excel
Training Schedule.
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Intro to pivots
Tables
Data Best Practices
Data Best Practices
15 minutes before - Welcome to the zoom (Optional)
First 45 minutes -
Last 15 minutes - Question Period & Class Review
Get the recordings
No Dates
Available
DAY 1
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Intro to pivots
Tables
Data Best Practices
DAY 2
08:30 to 09:00 - Welcome to the zoom (Optional)
09:00 to 10:00 -
10:00 to 11:00 - Break & practice period
11:00 to 12:00 -
12:00 to 13:00 - Lunch period
13:00 to 14:00 -
14:00 to 15:00 - Break & practice period
15:00 to 15:30 - Final note and conclusion
15:30 to 16:00 - Question Period & Class Review
Macros with Pivots
Cross tables and Name lists
Building a Report
FIRST HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
Tables
Data Best Practices
SECOND HALF
13:00 to 13:15 - Welcome to the CLASS (Optional)
13:15 to 14:15 -
14:15 to 14:30 - Break
14:30 to 15:30 -
15:30 to 16:00 - Question Period
Cross tables and Name lists
Building a Report
bottom of page