How to create a pivot table in Excel? - Interactive exercise
🚨 Test your Excel skills (with answers) and receive exclusive resources 🎯
➜ https://www.morpheus-formation.fr/blo...
🎁 Take our free Excel training → https://www.morpheus-formation.fr/for...
🏆 Excel training eligible for CPF (French Social Security Fund) – Up to 100% fundable, all levels, 100% personalized → https://www.morpheus-formation.fr/for...
💡 ABOUT THIS VIDEO
📊 Create a pivot table like a pro in 15 minutes!
Are you struggling with pivot tables in Excel? 😅 Does the name alone scare you? Don't panic! In this video, we'll go over everything from the beginning, step by step, with a practical exercise to help you analyze your data effectively.
What are pivot tables and why are they essential?
A pivot table allows you to organize, filter, and summarize a database in just a few clicks. But you still need to know where to start!
In this video, our trainer Nicolas shows you:
• How to select your data and create a pivot table.
• How to calculate sums, averages, and other indicators.
• How to add segments, filters, and calculated fields to make the right decisions.
🏢 WHO ARE WE?
Morpheus Formation is an organization 100% specialized in Excel and its latest innovations.
Have your company and your profession evolved over the past 15 years? Has Excel changed too! With a satisfaction rating of 9.8/10 in 2024, we have already supported more than 500 learners and 50 companies, including Pernod Ricard, Cartier, and Orange.
Our Excel training courses are suitable for both businesses and individuals, with personalized support for your own files.
🎓 OUR EXCEL TRAINING COURSES
1️⃣ Personalized training, delivered live by an expert trainer, who adapts to your needs.
2️⃣ Exclusive exercise materials and the ability to work on your files during sessions.
3️⃣ An ultra-flexible schedule (weekdays, holidays, weekends, etc.).
📌 Excel Training for All Levels → https://www.morpheus-formation.fr/for...
💡 CHAPTERS
0:00 - Intro
0:05 - Video Presentation and Objectives
0:31 - How to Download the Exercise File
0:58 - What is a Pivot Table (PPT)?
1:28 - Selecting Data for the Pivot Table
2:01 - Creating a Pivot Table in a New Sheet
2:28 - Exploring the Pivot Table Interface
3:03 - Pivot Table Fields and Areas
3:34 - Understanding Rows and Values in a Pivot Table
4:33 - Example: Sum of Salaries by Gender
5:32 - Adding Data to Columns and Improving Readability
6:02 - Question 1: Number of Employees per Site
7:37 - Interpreting Results and Making Decisions
8:10 - Question 2: Sum of Salaries by Qualification
9:09 - Formatting Cells in Accounting
9:38 - Question 3: Average Salaries by Gender and Qualification
10:47 - Filtering by Site and Adjusting Parameters
11:51 - Question 4: Maximum Salary by Qualification, Gender, and Site
12:47 - The Concept of Issues (Ordering Columns in the TCD)
13:54 - Question 5: Average age and number of employees by qualification
14:49 - Insert a segment to filter sites
15:50 - Add a timeline to filter by date
17:53 - Question 6: Minimum and maximum age by salary bracket
19:01 - Create salary brackets (grouping)
20:31 - The importance of updating TCD data
21:34 - Detect errors and anomalies in data
23:05 - Double-click to explore cell details
24:07 - Question 7: Minimum salary, number of employees by gender, site, and age bracket
25:47 - Combine segments and filters to refine results
27:30 - Question 8: Analyze the impact of a 10% salary increase
28:31 - Create a calculated field to add dynamic data
30:04 - Adjust formats for a clear presentation
31:16 - Insert a pivot chart
31:52 - Conclusion: What is a pivot table used for?
32:21 - Call to Action: Questions, Subscriptions, and Upcoming Videos
🎁 OTHER FREE RESOURCES
📂 20 Excel Exercises to Improve Quickly → https://www.morpheus-formation.fr/blo...
📥 Free PDF: 25 Essential Excel Functions → https://www.morpheus-formation.fr/blo...
⌨️ 20 Excel Keyboard Shortcuts to Remember → https://www.morpheus-formation.fr/blo...
📬 FOLLOW US
🌐 Official Website → https://www.morpheus-formation.fr/
💼 LinkedIn → / morpheus-formation