Excel - Sort, filter, summarize and calculate your PivoteTable data Tutorial
In this video, you will learn how to sort, filter, summarize, and calculate your PivotTable data.
The video covers various ways to analyze PivotTable data, including sorting it to quickly identify trends, filtering it to focus on specific criteria, and using slicers to efficiently filter the data.
Additionally, the video demonstrates how to summarize the data using different functions and display it in various formats, such as percentages.
This knowledge will help you effectively analyze and understand your PivotTable data, enabling you to make informed decisions.
- 3:49
- 2023 views
-
Excel - Create a PivotTable report manually
- 4:59
- Viewed 2092 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 2053 times
-
Excel - Use slicers to filter data
- 1:25
- Viewed 1730 times
-
Excel - Functions and formulas
- 3:24
- Viewed 2286 times
-
Excel - How to create a table
- 2:11
- Viewed 1730 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 2092 times
-
Excel - IF with AND and OR
- 3:35
- Viewed 1975 times
-
Excel - Freeze or lock panes
- 1:06
- Viewed 1806 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3136 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2898 times
-
3D Maps
- 1:41
- Viewed 2498 times
-
Manage conditional formatting
- 4:30
- Viewed 2483 times
-
Create a combo chart
- 1:47
- Viewed 2356 times
-
The SUMIF function
- 5:27
- Viewed 2333 times
-
Functions and formulas
- 3:24
- Viewed 2286 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2255 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2253 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2238 times
-
The SUM function
- 4:37
- Viewed 2220 times
-
More complex formulas
- 4:17
- Viewed 2211 times
-
Advanced formulas and references
- 4:06
- Viewed 2205 times
-
Introduction to Excel
- 0:59
- Viewed 2197 times
-
More print options
- 5:59
- Viewed 2196 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2194 times
-
Using functions
- 5:12
- Viewed 2185 times
-
Customize charts
- 4:28
- Viewed 2183 times
-
Manage drop-down lists
- 6:12
- Viewed 2175 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2106 times
-
New Chart types
- 1:52
- Viewed 2097 times
-
Freeze panes in detail
- 3:30
- Viewed 2092 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2092 times
-
Start using Excel
- 4:22
- Viewed 2087 times
-
AutoFill
- 2:55
- Viewed 2084 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2078 times
-
AutoFilter details
- 3:27
- Viewed 2074 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2074 times
-
Drop-down list settings
- 4:14
- Viewed 2072 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2053 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2040 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2039 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2037 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2037 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2037 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2034 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2023 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2017 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2010 times
-
Header and footer details
- 3:41
- Viewed 2009 times
-
Operator order
- 2:04
- Viewed 1992 times
-
Sort details
- 4:46
- Viewed 1987 times
-
Assign a button to a macro
- 2:49
- Viewed 1979 times
-
A closer look at the ribbon
- 3:55
- Viewed 1977 times
-
IF with AND and OR
- 3:35
- Viewed 1975 times
-
Work with macros
- 4:40
- Viewed 1966 times
-
A first look at Excel 2016
- 3:22
- Viewed 1957 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1957 times
-
Advanced filter details
- 4:13
- Viewed 1952 times
-
Insert columns and rows
- 4:16
- Viewed 1952 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1952 times
-
Add numbers
- 2:54
- Viewed 1950 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1949 times
-
Basic math
- 2:28
- Viewed 1945 times
-
Use conditional formatting
- 2:02
- Viewed 1942 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1941 times
-
One click Forecasting
- 1:01
- Viewed 1938 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1933 times
-
Insert headers and footers
- 2:02
- Viewed 1931 times
-
Ink Equation
- 0:41
- Viewed 1907 times
-
Improved version history
- 0:51
- Viewed 1889 times
-
Copy a chart
- 2:59
- Viewed 1886 times
-
Input and error messages
- 2:52
- Viewed 1882 times
-
Subtract time
- 3:58
- Viewed 1881 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1873 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1869 times
-
Save your macro
- 2:59
- Viewed 1868 times
-
AVERAGEIF function
- 3:04
- Viewed 1863 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1856 times
-
Cell references
- 1:34
- Viewed 1852 times
-
IFS
- 1:05
- Viewed 1848 times
-
Add formulas and references
- 2:52
- Viewed 1847 times
-
Get going fast
- 1:38
- Viewed 1818 times
-
Copying formulas
- 3:00
- Viewed 1814 times
-
Conditionally format text
- 2:12
- Viewed 1810 times
-
TEXTJOIN
- 0:47
- Viewed 1807 times
-
Freeze or lock panes
- 1:06
- Viewed 1806 times
-
Conditionally format dates
- 2:38
- Viewed 1803 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1791 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1788 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1783 times
-
Save, publish, and share
- 2:22
- Viewed 1765 times
-
Weighted average
- 2:06
- Viewed 1762 times
-
Share documents
- 1:13
- Viewed 1745 times
-
Average a group of numbers
- 2:01
- Viewed 1743 times
-
How to create a table
- 2:11
- Viewed 1730 times
-
Use slicers to filter data
- 1:25
- Viewed 1730 times
-
Drop-down lists
- 0:55
- Viewed 1711 times
-
How things are organized
- 1:58
- Viewed 1709 times
-
Advanced IF functions
- 3:22
- Viewed 1707 times
-
Create a chart
- 0:52
- Viewed 1703 times
-
CONCAT
- 0:51
- Viewed 1692 times
-
Edit a macro
- 3:29
- Viewed 1688 times
-
Flash Fill
- 2:59
- Viewed 1676 times
-
Sort and filter data
- 1:38
- Viewed 1648 times
-
SWITCH
- 1:03
- Viewed 1642 times
-
Nested IF functions
- 3:30
- Viewed 1634 times
-
Microsoft Search
- 0:34
- Viewed 1620 times
-
Page numbers in depth
- 3:06
- Viewed 1603 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1576 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1567 times
-
Map Chart in Excel
- 0:31
- Viewed 1563 times
-
Funnel Chart
- 0:33
- Viewed 1415 times
-
Accessibility in Excel
- 1:12
- Viewed 1355 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1312 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1052 times
-
Change chart type
- 1:29
- Viewed 1044 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1021 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 999 times
-
Text before & after Function
- 4:57
- Viewed 972 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 962 times
-
Create dynamic drop down lists
- 3:26
- Viewed 952 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 871 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 704 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 83 times
-
Format Data with Copilot
- 1:52
- Viewed 76 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 76 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 72 times
-
Creating a Report
- 2:54
- Viewed 4625 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2092 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2053 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2037 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2014 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1974 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1827 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1815 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1792 times
-
Creating your Datasets
- 2:26
- Viewed 1781 times
-
Customising your Visuals
- 2:58
- Viewed 1702 times
-
Improved version history
- 0:51
- Viewed 1660 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1649 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1624 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1570 times
-
Customising your Report
- 3:12
- Viewed 1556 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1021 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1017 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 999 times
-
Check and share your form results
- 2:42
- Viewed 976 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 871 times
-
Manage video settings
- 1:27
- Viewed 820 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 759 times
-
Analyze your network and communication habits
- 2:17
- Viewed 663 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 660 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 81 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 81 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 79 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 76 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 75 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 72 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 70 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 68 times
-
Creating a Form with Copilot
- 1:57
- Viewed 74 times
-
What can Copilot do for you ?
- 2:37
- Viewed 79 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 76 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 83 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 72 times
-
Format Data with Copilot
- 1:52
- Viewed 76 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 76 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 80 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 103 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 103 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 80 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 79 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 70 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 71 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 78 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 121 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 72 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 76 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 73 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 81 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 75 times
-
Draft an Email with Copilot
- 2:35
- Viewed 87 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 79 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 68 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 81 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 75 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 71 times
-
How to Access Copilot
- 1:32
- Viewed 106 times
-
Manage priority people
- 0:24
- Viewed 111 times
-
Finding Help?
- 0:56
- Viewed 307 times
-
Chancing Your Status
- 0:40
- Viewed 329 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 297 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 326 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 287 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 468 times
-
File Management
- 1:04
- Viewed 306 times
-
Managing Teams and Channels
- 2:15
- Viewed 303 times
-
Posting in a Channel
- 2:15
- Viewed 334 times
-
Creating a Channel
- 2:05
- Viewed 281 times
-
Creating or Joining a Team
- 1:11
- Viewed 455 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 300 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 452 times
-
Starting a Conversation
- 0:53
- Viewed 312 times
-
Searching for Items or People
- 0:30
- Viewed 280 times
-
Interface Overview
- 1:10
- Viewed 336 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 324 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 317 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 307 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 415 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1071 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 358 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 337 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 332 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 493 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 390 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 507 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 394 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 325 times
-
Change application settings
- 2:53
- Viewed 323 times
-
Manage accessibility settings
- 1:33
- Viewed 492 times
-
Manage privacy settings
- 1:00
- Viewed 334 times
-
Set up and customize your teams
- 2:02
- Viewed 293 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 327 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 311 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 325 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 369 times
-
Generate a presence report
- 1:23
- Viewed 299 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 301 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 312 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 478 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 344 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 324 times
-
Following your activities and your team's activities
- 1:26
- Viewed 301 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 306 times
-
Manage team files
- 1:28
- Viewed 322 times
-
Invite external guests
- 1:19
- Viewed 337 times
-
Create private and shared channels
- 1:52
- Viewed 464 times
-
Manage your teams
- 2:38
- Viewed 356 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 470 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 305 times
-
Store files in conversations
- 1:38
- Viewed 290 times
-
Isolate a conversation window
- 0:50
- Viewed 319 times
-
Use and co-edit files
- 2:06
- Viewed 333 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 383 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 602 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 608 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 448 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 562 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 322 times
-
AI and Automated Assessment
- 4:55
- Viewed 415 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 455 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 614 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 405 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 413 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 348 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 329 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 402 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 421 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 593 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 448 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 421 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 386 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 453 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 398 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 375 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 468 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 390 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 461 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 422 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 466 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 467 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 493 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 495 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 424 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 449 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 536 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 462 times
-
History of Generative AI
- 5:27
- Viewed 477 times
-
What is Generative AI ?
- 2:40
- Viewed 532 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 296 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 478 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 212 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 380 times
-
Search and tag people with “@”
- 2:15
- Viewed 278 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 309 times
-
Creating your new workspace
- 1:24
- Viewed 452 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 311 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 359 times
-
View events
- 2:21
- Viewed 454 times
-
Take notes in meetings
- 0:35
- Viewed 409 times
-
Manage a meeting
- 2:08
- Viewed 404 times
-
Start an instant meeting
- 1:33
- Viewed 466 times
-
Join a meeting as a participant
- 2:13
- Viewed 667 times
-
Automatically record a meeting
- 1:12
- Viewed 466 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 439 times
-
Share content in meetings
- 2:44
- Viewed 386 times
-
Use a background image during a video call
- 1:19
- Viewed 368 times
-
Schedule private or team meetings
- 2:17
- Viewed 495 times
-
Synchronize only one channel
- 0:56
- Viewed 518 times
-
Pin a channel to your favorites
- 1:04
- Viewed 475 times
-
Add channels and tabs
- 1:40
- Viewed 487 times
-
Interact in a conversation
- 2:03
- Viewed 345 times
-
Edit and enhance messages
- 1:57
- Viewed 658 times
-
Create a team using a template
- 1:03
- Viewed 606 times
-
Create a team and add members
- 1:37
- Viewed 552 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 609 times
-
Interact in conversations
- 1:30
- Viewed 471 times
-
Private and small group chats
- 2:03
- Viewed 413 times
-
Overview of conversations
- 1:02
- Viewed 475 times
-
Define your status message
- 2:13
- Viewed 708 times
-
Customize notifications
- 2:05
- Viewed 510 times
-
Edit photo in Teams
- 0:42
- Viewed 376 times
-
Find content and people
- 0:59
- Viewed 470 times
-
Presentation of the desktop application
- 2:16
- Viewed 383 times
-
Introduction to Teams
- 1:25
- Viewed 371 times