Complete EXCEL Training — Pivot Tables (PT) 🎯! [part 3/4]
🔍 Do you know the basics of Excel but get stuck when it comes to analyzing your data?
📊 Don't worry, you're not alone. Even at a beginner level, pivot tables can seem complex, even intimidating. Yet, they're one of the most effective tools for understanding your numbers without spending hours creating formulas.
✅ In this video, you'll learn how to create a pivot table, customize it, and, most importantly, use it to analyze your data in a flash. Once you understand how it works, you'll never want to live without it.
Discover the other chapters of our free Excel Beginner training:
👉🏻 Part 1/4: • Formation EXCEL 2026 complète 💥 Ce que vou...
👉🏻 Part 2/4: • Formation EXCEL Complète — consolider vos ...
👉🏻 Part 4/4: • Formation EXCEL Complète — RECHERCHEV, REC...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🎁 OUR FREE RESOURCES TO DOWNLOAD:
⇢ PDF of the 25 FUNCTIONS Most commonly used EXCEL exercises! https://www.morpheus-formation.fr/blo...
⇢ Online Excel placement test with answers. Beginner, intermediate, or advanced? https://www.morpheus-formation.fr/blo...
⇢ PDF of the 20 best Excel shortcuts to remember: https://www.morpheus-formation.fr/blo...
⇢ 12 XLSX exercises to go from beginner to expert in Excel:
https://www.morpheus-formation.fr/blo...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🎓 TRAINING:
⇢ Excel training from beginner/intermediate to expert:
https://www.morpheus-formation.fr/for...
⇢ Excel training for experts:
https://www.morpheus-formation.fr/for...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
MORPHEUS TRAINING is the only training organization capable of training you on the latest Excel features: Excel 2.0.
Have your company and your profession evolved over the past 15 years? Has Excel evolved too!
New features (EXLOOKUP, FILTER, INCOL, AGGREGATE, etc.), new tools (Power Query, Power Pivot, AI, etc.), and a new ecosystem (Power BI, Power Automate, Power Apps, etc.).
We've harnessed all our expertise and passion to create CPF-eligible training courses that allow you to take advantage of these new features and double your productivity. ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
💡 CHAPTERS
0:00 - Intro
0:30 - Introduction to the video and PPTs
1:06 - Why PPTs are useful even for beginners
2:05 - Analysis problem without PPTs
3:15 - Creating a PPT step by step
4:23 - Explanation of PPT areas (filters, columns, rows, values)
6:14 - Example: Dragging data into the correct areas
7:22 - Analysis by month with PPTs
8:28 - Adding amounts as Values
9:34 - Interpreting PDC Results
10:07 - Changing the Calculation Type (Average, Number, etc.)
11:11 - Why PDC is “Dynamic”
12:22 - Updating PDC after Data Modification
13:31 - Bonus: Files + Videos Included in the Description
13:58 - Filtering with Interactive Segments
16:08 - Filtering with a Timeline
17:53 - Filtering by Quarter or Year
18:26 - Another Filter Method Directly in PDC
19:31 - Displaying Values as Percentages
21:10 - Example of Analysis with Percentages
22:25 - Introduction to Pivot Charts
22:58 - Creating a Chart Linked to PDC
24:04 - Dynamics Between the Chart and PDC
25:06 - Customizing the Chart Display
25:40 - Conclusion + tips for progress