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
- 3153 views
-
Excel - Create a PivotTable report manually
- 4:59
- Viewed 3525 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 3178 times
-
Excel - Use slicers to filter data
- 1:25
- Viewed 2807 times
-
Excel - Functions and formulas
- 3:24
- Viewed 3350 times
-
Excel - How to create a table
- 2:11
- Viewed 2873 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 3180 times
-
Excel - IF with AND and OR
- 3:35
- Viewed 3172 times
-
Excel - Freeze or lock panes
- 1:06
- Viewed 2769 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4260 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3962 times
-
3D Maps
- 1:41
- Viewed 3712 times
-
Manage conditional formatting
- 4:30
- Viewed 3571 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3525 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3482 times
-
Create a combo chart
- 1:47
- Viewed 3421 times
-
The SUMIF function
- 5:27
- Viewed 3420 times
-
New Chart types
- 1:52
- Viewed 3398 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3366 times
-
Functions and formulas
- 3:24
- Viewed 3350 times
-
A closer look at the ribbon
- 3:55
- Viewed 3349 times
-
Using functions
- 5:12
- Viewed 3326 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3324 times
-
Manage drop-down lists
- 6:12
- Viewed 3317 times
-
More complex formulas
- 4:17
- Viewed 3299 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3283 times
-
The SUM function
- 4:37
- Viewed 3273 times
-
Advanced formulas and references
- 4:06
- Viewed 3256 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3246 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3245 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3244 times
-
More print options
- 5:59
- Viewed 3224 times
-
Start using Excel
- 4:22
- Viewed 3218 times
-
Customize charts
- 4:28
- Viewed 3211 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3196 times
-
A first look at Excel 2016
- 3:22
- Viewed 3195 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3193 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3193 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3189 times
-
Ink Equation
- 0:41
- Viewed 3181 times
-
Freeze panes in detail
- 3:30
- Viewed 3180 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3178 times
-
AVERAGEIF function
- 3:04
- Viewed 3177 times
-
IF with AND and OR
- 3:35
- Viewed 3172 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3172 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3169 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3157 times
-
Add numbers
- 2:54
- Viewed 3149 times
-
AutoFilter details
- 3:27
- Viewed 3131 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3112 times
-
Drop-down list settings
- 4:14
- Viewed 3110 times
-
AutoFill
- 2:55
- Viewed 3109 times
-
Header and footer details
- 3:41
- Viewed 3093 times
-
Sort details
- 4:46
- Viewed 3071 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3069 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3068 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3064 times
-
Advanced filter details
- 4:13
- Viewed 3059 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3057 times
-
Assign a button to a macro
- 2:49
- Viewed 3054 times
-
Insert headers and footers
- 2:02
- Viewed 3044 times
-
Operator order
- 2:04
- Viewed 3041 times
-
Save your macro
- 2:59
- Viewed 3038 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3038 times
-
Work with macros
- 4:40
- Viewed 3037 times
-
Insert columns and rows
- 4:16
- Viewed 3033 times
-
Introduction to Excel
- 0:59
- Viewed 3027 times
-
Subtract time
- 3:58
- Viewed 2994 times
-
Input and error messages
- 2:52
- Viewed 2986 times
-
Conditionally format dates
- 2:38
- Viewed 2968 times
-
Basic math
- 2:28
- Viewed 2964 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2954 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 2941 times
-
TEXTJOIN
- 0:47
- Viewed 2924 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2923 times
-
Copy a chart
- 2:59
- Viewed 2915 times
-
Copying formulas
- 3:00
- Viewed 2911 times
-
Improved version history
- 0:51
- Viewed 2905 times
-
One click Forecasting
- 1:01
- Viewed 2897 times
-
Cell references
- 1:34
- Viewed 2896 times
-
Advanced IF functions
- 3:22
- Viewed 2890 times
-
IFS
- 1:05
- Viewed 2878 times
-
Use conditional formatting
- 2:02
- Viewed 2875 times
-
How to create a table
- 2:11
- Viewed 2873 times
-
Add formulas and references
- 2:52
- Viewed 2863 times
-
Get going fast
- 1:38
- Viewed 2861 times
-
Conditionally format text
- 2:12
- Viewed 2861 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2848 times
-
Save, publish, and share
- 2:22
- Viewed 2843 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 2833 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2821 times
-
Use slicers to filter data
- 1:25
- Viewed 2807 times
-
Nested IF functions
- 3:30
- Viewed 2791 times
-
Freeze or lock panes
- 1:06
- Viewed 2769 times
-
How things are organized
- 1:58
- Viewed 2767 times
-
CONCAT
- 0:51
- Viewed 2727 times
-
Weighted average
- 2:06
- Viewed 2722 times
-
Average a group of numbers
- 2:01
- Viewed 2718 times
-
Drop-down lists
- 0:55
- Viewed 2717 times
-
Create a chart
- 0:52
- Viewed 2712 times
-
Edit a macro
- 3:29
- Viewed 2676 times
-
SWITCH
- 1:03
- Viewed 2668 times
-
Flash Fill
- 2:59
- Viewed 2661 times
-
Sort and filter data
- 1:38
- Viewed 2630 times
-
Map Chart in Excel
- 0:31
- Viewed 2608 times
-
Share documents
- 1:13
- Viewed 2582 times
-
Microsoft Search
- 0:34
- Viewed 2581 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2548 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2490 times
-
Page numbers in depth
- 3:06
- Viewed 2470 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2376 times
-
Accessibility in Excel
- 1:12
- Viewed 2309 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2252 times
-
Funnel Chart
- 0:33
- Viewed 2203 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2042 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1907 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1902 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1899 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1840 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1831 times
-
Text before & after Function
- 4:57
- Viewed 1724 times
-
Change chart type
- 1:29
- Viewed 1556 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1440 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 773 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 754 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 700 times
-
Format Data with Copilot
- 1:52
- Viewed 641 times
-
Creating a Report
- 2:54
- Viewed 7867 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3525 times
-
Recovering your Data from different sources
- 3:26
- Viewed 3180 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3178 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3169 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 3045 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 2959 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 2921 times
-
Introduction to the Query Editor
- 2:33
- Viewed 2891 times
-
Creating your Datasets
- 2:26
- Viewed 2873 times
-
Customising your Visuals
- 2:58
- Viewed 2823 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 2716 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 2688 times
-
Improved version history
- 0:51
- Viewed 2525 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 2478 times
-
Customising your Report
- 3:12
- Viewed 2409 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2042 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1902 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1831 times
-
Check and share your form results
- 2:42
- Viewed 1824 times
-
Manage video settings
- 1:27
- Viewed 1579 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 1554 times
-
Analyze your network and communication habits
- 2:17
- Viewed 1374 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 1170 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 918 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 707 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 691 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 664 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 648 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 640 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 600 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 590 times
-
Analyze Team Dynamics
- 1:19
- Viewed 548 times
-
Manage Storage Space
- 02:08
- Viewed 32 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 30 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 30 times
-
Make a File Request
- 01:24
- Viewed 34 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 31 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 30 times
-
Modify Sharing Rules
- 00:53
- Viewed 31 times
-
Check Granted Shares
- 00:48
- Viewed 35 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 29 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 29 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 30 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 29 times
-
Search for Documents
- 01:31
- Viewed 29 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 31 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 29 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 30 times
-
Edit, Delete a Share
- 02:16
- Viewed 33 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 32 times
-
Power and Manage OneDrive
- 01:36
- Viewed 29 times
-
What is OneDrive ?
- 01:14
- Viewed 31 times
-
Personality and tone for a realistic rendering
- 01:18
- Viewed 125 times
-
Format and example for optimal results
- 01:50
- Viewed 134 times
-
The importance of context in your requests
- 01:44
- Viewed 149 times
-
Precise task in conversational AI
- 01:55
- Viewed 150 times
-
Basics of prompting with conversational AI
- 02:29
- Viewed 128 times
-
What is a prompt ?
- 01:14
- Viewed 130 times
-
Survey Consumer Satisfaction Panel
- 02:38
- Viewed 192 times
-
Promote Your Product on Social Networks with Copilot
- 02:41
- Viewed 177 times
-
Write a Product Description with Copilot
- 02:36
- Viewed 188 times
-
Structure Your Product Launch Project
- 02:15
- Viewed 180 times
-
Initiate a Market Study with Copilot
- 03:15
- Viewed 193 times
-
Create a Business Presentation Report with ChatGPT
- 02:00
- Viewed 272 times
-
Boost Your Proposal with ChatGPT
- 02:19
- Viewed 251 times
-
Generating an Executive Summary with ChatGPT
- 01:47
- Viewed 255 times
-
Writing a Business Proposal with ChatGPT
- 02:22
- Viewed 243 times
-
Analyzing a Specification Document with ChatGPT
- 02:15
- Viewed 257 times
-
Create a Business Presentation Report with Copilot
- 03:02
- Viewed 291 times
-
Boost Your Proposal with Copilot Coaching for Outlook
- 02:18
- Viewed 278 times
-
Generating an Executive Summary with Copilot
- 01:46
- Viewed 265 times
-
Writing a Business Proposal with Copilot
- 03:40
- Viewed 257 times
-
Analyzing a Specification Document with Copilot
- 02:59
- Viewed 268 times
-
Creating a Welcome Presentation with ChatGPT
- 1:51
- Viewed 403 times
-
Creating a Welcome Presentation with Copilot
- 2:30
- Viewed 375 times
-
Debriefing a Job Interview with ChatGPT
- 1:54
- Viewed 386 times
-
Debriefing a Job Interview with Copilot
- 4:28
- Viewed 538 times
-
Analyze a resume with ChatGPT
- 1:52
- Viewed 387 times
-
Analyze a resume with Copilot
- 2:07
- Viewed 422 times
-
Responding to a Job Application Email with ChatGPT
- 1:38
- Viewed 434 times
-
Draft a Personalized Thank you Email
- 2:09
- Viewed 357 times
-
Draft a job offer with ChatGPT
- 1:49
- Viewed 396 times
-
Draft a job offer with Copilot
- 2:00
- Viewed 361 times
-
Add interactivity to your videos
- 1:20
- Viewed 413 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 524 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 525 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 560 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 522 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 581 times
-
Managing permissions of a document library
- 2:01
- Viewed 518 times
-
Create a permission group
- 2:11
- Viewed 659 times
-
SharePoint permission levels
- 2:16
- Viewed 520 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 561 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 667 times
-
Create a SharePoint Lists
- 2:18
- Viewed 675 times
-
Create a document library
- 1:56
- Viewed 668 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 705 times
-
Customise my site Homepage
- 3:03
- Viewed 549 times
-
Configure the global Theme and logo
- 2:26
- Viewed 734 times
-
Delete a SharePoint site
- 1:12
- Viewed 567 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 516 times
-
Create a SharePoint site
- 1:57
- Viewed 693 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 522 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 567 times
-
Prevent comments on modern pages
- 1:15
- Viewed 727 times
-
Disable subsite creation
- 0:53
- Viewed 520 times
-
Set the proper time zone
- 0:44
- Viewed 577 times
-
Define site storage limits
- 1:42
- Viewed 546 times
-
Disable site creation
- 0:52
- Viewed 579 times
-
Access the admin center
- 0:52
- Viewed 716 times
-
Work together on the same document
- 1:48
- Viewed 530 times
-
Create a folder or a file in a library
- 1:46
- Viewed 730 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 553 times
-
Use the filter pane in a library
- 2:00
- Viewed 502 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 524 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 517 times
-
Use version history
- 1:57
- Viewed 523 times
-
Open and work on a document
- 2:42
- Viewed 502 times
-
Rename and find a document
- 2:00
- Viewed 493 times
-
Create a SharePoint site
- 2:58
- Viewed 741 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 749 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 508 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 517 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 535 times
-
Participate in a Town Hall
- 0:53
- Viewed 513 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 530 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 548 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 512 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 564 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 505 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 512 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 517 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 561 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 549 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 513 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 690 times
-
Send an Email to a Team
- 0:38
- Viewed 732 times
-
Analyze Team Dynamics
- 1:19
- Viewed 548 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 686 times
-
Create Approval Templates
- 2:06
- Viewed 718 times
-
Manage Document Approval
- 0:56
- Viewed 547 times
-
Make a New Approval Request
- 1:26
- Viewed 739 times
-
Use Templates for Document Creation
- 1:03
- Viewed 548 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 503 times
-
Filter Your Document Display
- 1:10
- Viewed 516 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 514 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 519 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 507 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 528 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 513 times
-
Add and Explore Workflows
- 1:35
- Viewed 537 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 544 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 519 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 555 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 567 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 724 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 568 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 494 times
-
Manage Conversation Options
- 1:35
- Viewed 510 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 556 times
-
Schedule Message Delivery
- 0:58
- Viewed 705 times
-
Creating a Form with Copilot
- 1:57
- Viewed 608 times
-
What can Copilot do for you ?
- 2:37
- Viewed 626 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 773 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 754 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 700 times
-
Format Data with Copilot
- 1:52
- Viewed 641 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 620 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 676 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 805 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 861 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 612 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 786 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 691 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 752 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 578 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 874 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 918 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 648 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 606 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 707 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 619 times
-
Draft an Email with Copilot
- 2:35
- Viewed 750 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 640 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 590 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 664 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 600 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 599 times
-
How to Access Copilot
- 1:32
- Viewed 853 times
-
Manage priority people
- 0:24
- Viewed 430 times