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
- 2062 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3147 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2908 times
-
3D Maps
- 1:41
- Viewed 2505 times
-
Manage conditional formatting
- 4:30
- Viewed 2495 times
-
Create a combo chart
- 1:47
- Viewed 2366 times
-
The SUMIF function
- 5:27
- Viewed 2346 times
-
Functions and formulas
- 3:24
- Viewed 2295 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2268 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2260 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2249 times
-
The SUM function
- 4:37
- Viewed 2232 times
-
More complex formulas
- 4:17
- Viewed 2222 times
-
Advanced formulas and references
- 4:06
- Viewed 2215 times
-
Introduction to Excel
- 0:59
- Viewed 2207 times
-
More print options
- 5:59
- Viewed 2206 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2204 times
-
Using functions
- 5:12
- Viewed 2196 times
-
Customize charts
- 4:28
- Viewed 2192 times
-
Manage drop-down lists
- 6:12
- Viewed 2185 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2114 times
-
New Chart types
- 1:52
- Viewed 2108 times
-
Freeze panes in detail
- 3:30
- Viewed 2101 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2099 times
-
Start using Excel
- 4:22
- Viewed 2097 times
-
AutoFill
- 2:55
- Viewed 2096 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2086 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2085 times
-
AutoFilter details
- 3:27
- Viewed 2084 times
-
Drop-down list settings
- 4:14
- Viewed 2082 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2049 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2049 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2047 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2047 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2045 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2041 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2033 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2033 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2026 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2020 times
-
Header and footer details
- 3:41
- Viewed 2015 times
-
Sort details
- 4:46
- Viewed 2000 times
-
Operator order
- 2:04
- Viewed 1999 times
-
Assign a button to a macro
- 2:49
- Viewed 1990 times
-
IF with AND and OR
- 3:35
- Viewed 1988 times
-
A closer look at the ribbon
- 3:55
- Viewed 1986 times
-
Work with macros
- 4:40
- Viewed 1977 times
-
Advanced filter details
- 4:13
- Viewed 1967 times
-
A first look at Excel 2016
- 3:22
- Viewed 1965 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1963 times
-
Add numbers
- 2:54
- Viewed 1961 times
-
Insert columns and rows
- 4:16
- Viewed 1961 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1958 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1957 times
-
Basic math
- 2:28
- Viewed 1956 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1953 times
-
Use conditional formatting
- 2:02
- Viewed 1949 times
-
One click Forecasting
- 1:01
- Viewed 1948 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1946 times
-
Insert headers and footers
- 2:02
- Viewed 1937 times
-
Ink Equation
- 0:41
- Viewed 1915 times
-
Improved version history
- 0:51
- Viewed 1902 times
-
Copy a chart
- 2:59
- Viewed 1895 times
-
Subtract time
- 3:58
- Viewed 1891 times
-
Input and error messages
- 2:52
- Viewed 1891 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1887 times
-
Save your macro
- 2:59
- Viewed 1882 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1880 times
-
AVERAGEIF function
- 3:04
- Viewed 1872 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1868 times
-
Cell references
- 1:34
- Viewed 1864 times
-
IFS
- 1:05
- Viewed 1858 times
-
Add formulas and references
- 2:52
- Viewed 1855 times
-
Get going fast
- 1:38
- Viewed 1831 times
-
Copying formulas
- 3:00
- Viewed 1828 times
-
Conditionally format text
- 2:12
- Viewed 1816 times
-
Freeze or lock panes
- 1:06
- Viewed 1815 times
-
TEXTJOIN
- 0:47
- Viewed 1815 times
-
Conditionally format dates
- 2:38
- Viewed 1810 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1799 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1796 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1794 times
-
Weighted average
- 2:06
- Viewed 1774 times
-
Save, publish, and share
- 2:22
- Viewed 1771 times
-
Share documents
- 1:13
- Viewed 1753 times
-
Average a group of numbers
- 2:01
- Viewed 1753 times
-
How to create a table
- 2:11
- Viewed 1741 times
-
Use slicers to filter data
- 1:25
- Viewed 1739 times
-
Drop-down lists
- 0:55
- Viewed 1726 times
-
How things are organized
- 1:58
- Viewed 1718 times
-
Advanced IF functions
- 3:22
- Viewed 1715 times
-
Create a chart
- 0:52
- Viewed 1713 times
-
CONCAT
- 0:51
- Viewed 1700 times
-
Edit a macro
- 3:29
- Viewed 1699 times
-
Flash Fill
- 2:59
- Viewed 1687 times
-
Sort and filter data
- 1:38
- Viewed 1659 times
-
SWITCH
- 1:03
- Viewed 1651 times
-
Nested IF functions
- 3:30
- Viewed 1647 times
-
Microsoft Search
- 0:34
- Viewed 1631 times
-
Page numbers in depth
- 3:06
- Viewed 1609 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1585 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1576 times
-
Map Chart in Excel
- 0:31
- Viewed 1571 times
-
Funnel Chart
- 0:33
- Viewed 1425 times
-
Accessibility in Excel
- 1:12
- Viewed 1364 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1322 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1060 times
-
Change chart type
- 1:29
- Viewed 1049 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1028 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1006 times
-
Text before & after Function
- 4:57
- Viewed 979 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 968 times
-
Create dynamic drop down lists
- 3:26
- Viewed 961 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 880 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 713 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 90 times
-
Format Data with Copilot
- 1:52
- Viewed 83 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 83 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 82 times
-
Creating a Report
- 2:54
- Viewed 4634 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2099 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2047 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2033 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2025 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1982 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1836 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1822 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1803 times
-
Creating your Datasets
- 2:26
- Viewed 1788 times
-
Customising your Visuals
- 2:58
- Viewed 1710 times
-
Improved version history
- 0:51
- Viewed 1672 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1657 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1633 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1580 times
-
Customising your Report
- 3:12
- Viewed 1564 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1028 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1025 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1006 times
-
Check and share your form results
- 2:42
- Viewed 986 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 880 times
-
Manage video settings
- 1:27
- Viewed 827 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 767 times
-
Analyze your network and communication habits
- 2:17
- Viewed 671 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 666 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 87 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 87 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 84 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 83 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 81 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 79 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 76 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 73 times
-
Creating a Form with Copilot
- 1:57
- Viewed 81 times
-
What can Copilot do for you ?
- 2:37
- Viewed 86 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 83 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 90 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 82 times
-
Format Data with Copilot
- 1:52
- Viewed 83 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 80 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 86 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 108 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 109 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 87 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 87 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 76 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 77 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 83 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 127 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 79 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 81 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 78 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 87 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 80 times
-
Draft an Email with Copilot
- 2:35
- Viewed 93 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 84 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 73 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 87 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 83 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 76 times
-
How to Access Copilot
- 1:32
- Viewed 113 times
-
Manage priority people
- 0:24
- Viewed 116 times
-
Finding Help?
- 0:56
- Viewed 315 times
-
Chancing Your Status
- 0:40
- Viewed 338 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 303 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 333 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 294 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 476 times
-
File Management
- 1:04
- Viewed 313 times
-
Managing Teams and Channels
- 2:15
- Viewed 310 times
-
Posting in a Channel
- 2:15
- Viewed 340 times
-
Creating a Channel
- 2:05
- Viewed 288 times
-
Creating or Joining a Team
- 1:11
- Viewed 462 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 306 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 458 times
-
Starting a Conversation
- 0:53
- Viewed 320 times
-
Searching for Items or People
- 0:30
- Viewed 287 times
-
Interface Overview
- 1:10
- Viewed 345 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 330 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 323 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 314 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 426 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1090 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 367 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 346 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 339 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 502 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 399 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 516 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 402 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 332 times
-
Change application settings
- 2:53
- Viewed 331 times
-
Manage accessibility settings
- 1:33
- Viewed 499 times
-
Manage privacy settings
- 1:00
- Viewed 342 times
-
Set up and customize your teams
- 2:02
- Viewed 299 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 334 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 318 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 334 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 376 times
-
Generate a presence report
- 1:23
- Viewed 307 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 307 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 321 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 485 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 351 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 331 times
-
Following your activities and your team's activities
- 1:26
- Viewed 309 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 314 times
-
Manage team files
- 1:28
- Viewed 330 times
-
Invite external guests
- 1:19
- Viewed 343 times
-
Create private and shared channels
- 1:52
- Viewed 471 times
-
Manage your teams
- 2:38
- Viewed 363 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 477 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 312 times
-
Store files in conversations
- 1:38
- Viewed 297 times
-
Isolate a conversation window
- 0:50
- Viewed 325 times
-
Use and co-edit files
- 2:06
- Viewed 340 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 390 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 608 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 616 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 454 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 569 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 328 times
-
AI and Automated Assessment
- 4:55
- Viewed 422 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 463 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 622 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 412 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 420 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 353 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 335 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 408 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 428 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 600 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 454 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 427 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 393 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 457 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 404 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 383 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 475 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 395 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 468 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 431 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 474 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 474 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 502 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 503 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 431 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 458 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 546 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 471 times
-
History of Generative AI
- 5:27
- Viewed 487 times
-
What is Generative AI ?
- 2:40
- Viewed 542 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 300 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 482 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 216 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 385 times
-
Search and tag people with “@”
- 2:15
- Viewed 282 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 314 times
-
Creating your new workspace
- 1:24
- Viewed 455 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 315 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 364 times
-
View events
- 2:21
- Viewed 464 times
-
Take notes in meetings
- 0:35
- Viewed 416 times
-
Manage a meeting
- 2:08
- Viewed 411 times
-
Start an instant meeting
- 1:33
- Viewed 472 times
-
Join a meeting as a participant
- 2:13
- Viewed 673 times
-
Automatically record a meeting
- 1:12
- Viewed 472 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 447 times
-
Share content in meetings
- 2:44
- Viewed 392 times
-
Use a background image during a video call
- 1:19
- Viewed 376 times
-
Schedule private or team meetings
- 2:17
- Viewed 502 times
-
Synchronize only one channel
- 0:56
- Viewed 525 times
-
Pin a channel to your favorites
- 1:04
- Viewed 481 times
-
Add channels and tabs
- 1:40
- Viewed 494 times
-
Interact in a conversation
- 2:03
- Viewed 352 times
-
Edit and enhance messages
- 1:57
- Viewed 664 times
-
Create a team using a template
- 1:03
- Viewed 614 times
-
Create a team and add members
- 1:37
- Viewed 560 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 616 times
-
Interact in conversations
- 1:30
- Viewed 479 times
-
Private and small group chats
- 2:03
- Viewed 422 times
-
Overview of conversations
- 1:02
- Viewed 484 times
-
Define your status message
- 2:13
- Viewed 717 times
-
Customize notifications
- 2:05
- Viewed 518 times
-
Edit photo in Teams
- 0:42
- Viewed 386 times
-
Find content and people
- 0:59
- Viewed 479 times
-
Presentation of the desktop application
- 2:16
- Viewed 389 times
-
Introduction to Teams
- 1:25
- Viewed 378 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
- 711 Views