Excel - Create a PivotTable and analyze your data Tutorial
In this video, you will learn how to create a PivotTable and analyze your data using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.
The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.
You can preview each recommendation to see how your data will look.
The video also shows how to format the numbers in the PivotTable as currency.
This tutorial will help you gain a better understanding of your data and make informed decisions.
- 1:35
- 2070 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3155 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2922 times
-
3D Maps
- 1:41
- Viewed 2514 times
-
Manage conditional formatting
- 4:30
- Viewed 2504 times
-
Create a combo chart
- 1:47
- Viewed 2376 times
-
The SUMIF function
- 5:27
- Viewed 2355 times
-
Functions and formulas
- 3:24
- Viewed 2303 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2275 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2267 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2256 times
-
The SUM function
- 4:37
- Viewed 2241 times
-
More complex formulas
- 4:17
- Viewed 2230 times
-
Advanced formulas and references
- 4:06
- Viewed 2222 times
-
More print options
- 5:59
- Viewed 2216 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2215 times
-
Introduction to Excel
- 0:59
- Viewed 2214 times
-
Using functions
- 5:12
- Viewed 2207 times
-
Customize charts
- 4:28
- Viewed 2199 times
-
Manage drop-down lists
- 6:12
- Viewed 2193 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2125 times
-
New Chart types
- 1:52
- Viewed 2118 times
-
Freeze panes in detail
- 3:30
- Viewed 2113 times
-
Start using Excel
- 4:22
- Viewed 2109 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2105 times
-
AutoFill
- 2:55
- Viewed 2101 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2097 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2094 times
-
AutoFilter details
- 3:27
- Viewed 2090 times
-
Drop-down list settings
- 4:14
- Viewed 2090 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2060 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2057 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2057 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2055 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2051 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2050 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2041 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2041 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2035 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2029 times
-
Header and footer details
- 3:41
- Viewed 2026 times
-
Operator order
- 2:04
- Viewed 2007 times
-
Sort details
- 4:46
- Viewed 2006 times
-
IF with AND and OR
- 3:35
- Viewed 2001 times
-
Assign a button to a macro
- 2:49
- Viewed 2001 times
-
A closer look at the ribbon
- 3:55
- Viewed 1996 times
-
Work with macros
- 4:40
- Viewed 1986 times
-
A first look at Excel 2016
- 3:22
- Viewed 1976 times
-
Advanced filter details
- 4:13
- Viewed 1976 times
-
Add numbers
- 2:54
- Viewed 1972 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1971 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1970 times
-
Insert columns and rows
- 4:16
- Viewed 1969 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1965 times
-
Basic math
- 2:28
- Viewed 1963 times
-
Use conditional formatting
- 2:02
- Viewed 1959 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1958 times
-
One click Forecasting
- 1:01
- Viewed 1957 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1952 times
-
Insert headers and footers
- 2:02
- Viewed 1950 times
-
Ink Equation
- 0:41
- Viewed 1920 times
-
Improved version history
- 0:51
- Viewed 1910 times
-
Input and error messages
- 2:52
- Viewed 1906 times
-
Copy a chart
- 2:59
- Viewed 1903 times
-
Subtract time
- 3:58
- Viewed 1898 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1896 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1889 times
-
Save your macro
- 2:59
- Viewed 1889 times
-
AVERAGEIF function
- 3:04
- Viewed 1881 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1875 times
-
Cell references
- 1:34
- Viewed 1873 times
-
Add formulas and references
- 2:52
- Viewed 1864 times
-
IFS
- 1:05
- Viewed 1864 times
-
Copying formulas
- 3:00
- Viewed 1838 times
-
Get going fast
- 1:38
- Viewed 1836 times
-
Conditionally format text
- 2:12
- Viewed 1826 times
-
Freeze or lock panes
- 1:06
- Viewed 1823 times
-
Conditionally format dates
- 2:38
- Viewed 1822 times
-
TEXTJOIN
- 0:47
- Viewed 1820 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1806 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1806 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1800 times
-
Weighted average
- 2:06
- Viewed 1783 times
-
Save, publish, and share
- 2:22
- Viewed 1783 times
-
Average a group of numbers
- 2:01
- Viewed 1760 times
-
Share documents
- 1:13
- Viewed 1757 times
-
How to create a table
- 2:11
- Viewed 1750 times
-
Use slicers to filter data
- 1:25
- Viewed 1747 times
-
Drop-down lists
- 0:55
- Viewed 1733 times
-
Advanced IF functions
- 3:22
- Viewed 1726 times
-
How things are organized
- 1:58
- Viewed 1725 times
-
Create a chart
- 0:52
- Viewed 1718 times
-
CONCAT
- 0:51
- Viewed 1709 times
-
Edit a macro
- 3:29
- Viewed 1707 times
-
Flash Fill
- 2:59
- Viewed 1691 times
-
Sort and filter data
- 1:38
- Viewed 1666 times
-
SWITCH
- 1:03
- Viewed 1658 times
-
Nested IF functions
- 3:30
- Viewed 1655 times
-
Microsoft Search
- 0:34
- Viewed 1637 times
-
Page numbers in depth
- 3:06
- Viewed 1620 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1592 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1581 times
-
Map Chart in Excel
- 0:31
- Viewed 1578 times
-
Funnel Chart
- 0:33
- Viewed 1434 times
-
Accessibility in Excel
- 1:12
- Viewed 1372 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1333 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1065 times
-
Change chart type
- 1:29
- Viewed 1058 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1034 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1011 times
-
Text before & after Function
- 4:57
- Viewed 985 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 974 times
-
Create dynamic drop down lists
- 3:26
- Viewed 968 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 886 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 719 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 96 times
-
Format Data with Copilot
- 1:52
- Viewed 91 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 89 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 88 times
-
Creating a Report
- 2:54
- Viewed 4658 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2105 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2057 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2041 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2031 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1990 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1845 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1832 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1814 times
-
Creating your Datasets
- 2:26
- Viewed 1795 times
-
Customising your Visuals
- 2:58
- Viewed 1719 times
-
Improved version history
- 0:51
- Viewed 1679 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1664 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1642 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1589 times
-
Customising your Report
- 3:12
- Viewed 1573 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1034 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1033 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1011 times
-
Check and share your form results
- 2:42
- Viewed 991 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 886 times
-
Manage video settings
- 1:27
- Viewed 834 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 777 times
-
Analyze your network and communication habits
- 2:17
- Viewed 681 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 676 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 96 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 93 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 91 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 90 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 88 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 86 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 83 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 80 times
-
Creating a Form with Copilot
- 1:57
- Viewed 89 times
-
What can Copilot do for you ?
- 2:37
- Viewed 92 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 89 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 96 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 88 times
-
Format Data with Copilot
- 1:52
- Viewed 91 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 89 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 93 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 114 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 115 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 95 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 94 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 83 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 85 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 90 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 133 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 86 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 88 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 84 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 93 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 88 times
-
Draft an Email with Copilot
- 2:35
- Viewed 100 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 91 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 80 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 96 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 90 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 84 times
-
How to Access Copilot
- 1:32
- Viewed 120 times
-
Manage priority people
- 0:24
- Viewed 121 times
-
Finding Help?
- 0:56
- Viewed 325 times
-
Chancing Your Status
- 0:40
- Viewed 348 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 312 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 343 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 304 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 485 times
-
File Management
- 1:04
- Viewed 321 times
-
Managing Teams and Channels
- 2:15
- Viewed 318 times
-
Posting in a Channel
- 2:15
- Viewed 350 times
-
Creating a Channel
- 2:05
- Viewed 297 times
-
Creating or Joining a Team
- 1:11
- Viewed 471 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 318 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 467 times
-
Starting a Conversation
- 0:53
- Viewed 329 times
-
Searching for Items or People
- 0:30
- Viewed 295 times
-
Interface Overview
- 1:10
- Viewed 355 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 338 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 335 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 322 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 439 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1104 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 380 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 356 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 349 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 511 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 412 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 527 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 411 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 340 times
-
Change application settings
- 2:53
- Viewed 341 times
-
Manage accessibility settings
- 1:33
- Viewed 508 times
-
Manage privacy settings
- 1:00
- Viewed 350 times
-
Set up and customize your teams
- 2:02
- Viewed 311 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 342 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 326 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 344 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 383 times
-
Generate a presence report
- 1:23
- Viewed 314 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 318 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 331 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 495 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 362 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 339 times
-
Following your activities and your team's activities
- 1:26
- Viewed 317 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 322 times
-
Manage team files
- 1:28
- Viewed 338 times
-
Invite external guests
- 1:19
- Viewed 352 times
-
Create private and shared channels
- 1:52
- Viewed 483 times
-
Manage your teams
- 2:38
- Viewed 372 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 485 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 323 times
-
Store files in conversations
- 1:38
- Viewed 306 times
-
Isolate a conversation window
- 0:50
- Viewed 334 times
-
Use and co-edit files
- 2:06
- Viewed 350 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 400 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 620 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 627 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 463 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 580 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 336 times
-
AI and Automated Assessment
- 4:55
- Viewed 432 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 472 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 632 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 425 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 428 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 361 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 347 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 417 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 437 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 609 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 463 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 438 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 403 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 468 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 414 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 391 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 485 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 403 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 477 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 442 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 485 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 485 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 511 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 512 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 441 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 469 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 557 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 480 times
-
History of Generative AI
- 5:27
- Viewed 497 times
-
What is Generative AI ?
- 2:40
- Viewed 554 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 307 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 487 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 223 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 390 times
-
Search and tag people with “@”
- 2:15
- Viewed 289 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 322 times
-
Creating your new workspace
- 1:24
- Viewed 461 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 320 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 371 times
-
View events
- 2:21
- Viewed 474 times
-
Take notes in meetings
- 0:35
- Viewed 427 times
-
Manage a meeting
- 2:08
- Viewed 421 times
-
Start an instant meeting
- 1:33
- Viewed 480 times
-
Join a meeting as a participant
- 2:13
- Viewed 681 times
-
Automatically record a meeting
- 1:12
- Viewed 482 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 455 times
-
Share content in meetings
- 2:44
- Viewed 403 times
-
Use a background image during a video call
- 1:19
- Viewed 385 times
-
Schedule private or team meetings
- 2:17
- Viewed 510 times
-
Synchronize only one channel
- 0:56
- Viewed 535 times
-
Pin a channel to your favorites
- 1:04
- Viewed 489 times
-
Add channels and tabs
- 1:40
- Viewed 503 times
-
Interact in a conversation
- 2:03
- Viewed 362 times
-
Edit and enhance messages
- 1:57
- Viewed 675 times
-
Create a team using a template
- 1:03
- Viewed 622 times
-
Create a team and add members
- 1:37
- Viewed 569 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 625 times
-
Interact in conversations
- 1:30
- Viewed 495 times
-
Private and small group chats
- 2:03
- Viewed 432 times
-
Overview of conversations
- 1:02
- Viewed 494 times
-
Define your status message
- 2:13
- Viewed 730 times
-
Customize notifications
- 2:05
- Viewed 525 times
-
Edit photo in Teams
- 0:42
- Viewed 397 times
-
Find content and people
- 0:59
- Viewed 489 times
-
Presentation of the desktop application
- 2:16
- Viewed 400 times
-
Introduction to Teams
- 1:25
- Viewed 388 times
RELATED COURSES This tutorial is part of the following courses
Video Training Microsoft Excel - Intermediate level
Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!
- Your trainer for this course
- Cours E-learning
- 721 Views