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
- 1442 views
-
Excel - Create a PivotTable report manually
- 4:59
- Viewed 1448 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 1350 times
-
Excel - Use slicers to filter data
- 1:25
- Viewed 1226 times
-
Excel - Functions and formulas
- 3:24
- Viewed 1631 times
-
Excel - How to create a table
- 2:11
- Viewed 1277 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 1504 times
-
Excel - Freeze or lock panes
- 1:06
- Viewed 1368 times
-
Excel - COUNTIFS and SUMIFS
- 5:30
- Viewed 1605 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 2667 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2444 times
-
3D Maps
- 1:41
- Viewed 1998 times
-
Manage conditional formatting
- 4:30
- Viewed 1980 times
-
Create a combo chart
- 1:47
- Viewed 1856 times
-
The SUMIF function
- 5:27
- Viewed 1755 times
-
Introduction to Excel
- Viewed 1744 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 1733 times
-
The SUM function
- 4:37
- Viewed 1672 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 1645 times
-
Customize charts
- 4:28
- Viewed 1639 times
-
Functions and formulas
- 3:24
- Viewed 1631 times
-
AutoFill
- 2:55
- Viewed 1618 times
-
Advanced formulas and references
- 4:06
- Viewed 1612 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 1605 times
-
Using functions
- 5:12
- Viewed 1604 times
-
New Chart types
- 1:52
- Viewed 1590 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 1585 times
-
Drop-down list settings
- 4:14
- Viewed 1584 times
-
More complex formulas
- 4:17
- Viewed 1550 times
-
Assign a button to a macro
- 2:49
- Viewed 1547 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 1545 times
-
Manage drop-down lists
- 6:12
- Viewed 1539 times
-
Start using Excel
- 4:22
- Viewed 1528 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 1523 times
-
AutoFilter details
- 3:27
- Viewed 1522 times
-
Operator order
- 2:04
- Viewed 1521 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 1520 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 1508 times
-
Sort details
- 4:46
- Viewed 1507 times
-
Freeze panes in detail
- 3:30
- Viewed 1504 times
-
Basic math
- 2:28
- Viewed 1500 times
-
Look up values on a different worksheet
- 2:39
- Viewed 1490 times
-
More print options
- 5:59
- Viewed 1486 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 1483 times
-
One click Forecasting
- 1:01
- Viewed 1475 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 1474 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 1471 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 1465 times
-
Add numbers
- 2:54
- Viewed 1464 times
-
Improved version history
- 0:51
- Viewed 1455 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1450 times
-
Create a PivotTable report manually
- 4:59
- Viewed 1448 times
-
Work with macros
- 4:40
- Viewed 1437 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 1432 times
-
Ink Equation
- 0:41
- Viewed 1424 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1423 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1419 times
-
Insert columns and rows
- 4:16
- Viewed 1412 times
-
Advanced filter details
- 4:13
- Viewed 1411 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1410 times
-
Insert headers and footers
- 2:02
- Viewed 1410 times
-
A first look at Excel 2016
- 3:22
- Viewed 1408 times
-
Input and error messages
- 2:52
- Viewed 1407 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1403 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1402 times
-
A closer look at the ribbon
- 3:55
- Viewed 1388 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1387 times
-
Copying formulas
- 3:00
- Viewed 1385 times
-
IF with AND and OR
- 3:35
- Viewed 1384 times
-
Use conditional formatting
- 2:02
- Viewed 1380 times
-
Add formulas and references
- 2:52
- Viewed 1378 times
-
Header and footer details
- 3:41
- Viewed 1377 times
-
Subtract time
- 3:58
- Viewed 1372 times
-
IFS
- 1:05
- Viewed 1370 times
-
Freeze or lock panes
- 1:06
- Viewed 1368 times
-
AVERAGEIF function
- 3:04
- Viewed 1366 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1366 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1358 times
-
Share documents
- 1:13
- Viewed 1353 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 1350 times
-
Copy a chart
- 2:59
- Viewed 1341 times
-
Weighted average
- 2:06
- Viewed 1335 times
-
Save your macro
- 2:59
- Viewed 1335 times
-
Get going fast
- 1:38
- Viewed 1331 times
-
Cell references
- 1:34
- Viewed 1324 times
-
Average a group of numbers
- 2:01
- Viewed 1309 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1303 times
-
Drop-down lists
- 0:55
- Viewed 1302 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1290 times
-
How to create a table
- 2:11
- Viewed 1277 times
-
Conditionally format text
- 2:12
- Viewed 1270 times
-
TEXTJOIN
- 0:47
- Viewed 1268 times
-
CONCAT
- 0:51
- Viewed 1261 times
-
Save, publish, and share
- 2:22
- Viewed 1260 times
-
Conditionally format dates
- 2:38
- Viewed 1258 times
-
Advanced IF functions
- 3:22
- Viewed 1256 times
-
How things are organized
- 1:58
- Viewed 1250 times
-
Sort and filter data
- 1:38
- Viewed 1247 times
-
Edit a macro
- 3:29
- Viewed 1246 times
-
Use slicers to filter data
- 1:25
- Viewed 1226 times
-
Translate your Excel spreadsheets
- Viewed 1224 times
-
Flash Fill
- 2:59
- Viewed 1222 times
-
SWITCH
- 1:03
- Viewed 1209 times
-
Create a chart
- 0:52
- Viewed 1197 times
-
Microsoft Search
- 0:34
- Viewed 1193 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1182 times
-
Nested IF functions
- 3:30
- Viewed 1167 times
-
Page numbers in depth
- 3:06
- Viewed 1147 times
-
Map Chart in Excel
- 0:31
- Viewed 1143 times
-
Funnel Chart
- 0:33
- Viewed 1103 times
-
Check Accessibility in Excel
- Viewed 937 times
-
Accessibility in Excel
- Viewed 933 times
-
Change chart type
- Viewed 792 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 661 times
-
XLOOKUP (Basic metrics)
- Viewed 645 times
-
Text before & after Function
- Viewed 636 times
-
XLOOKUP (Advanced metrics)
- Viewed 621 times
-
Insert an image in a cell with image function
- Viewed 608 times
-
Create dynamic drop down lists
- Viewed 556 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 545 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 422 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 382 times
-
Creating a Report
- 2:54
- Viewed 2227 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 1474 times
-
Create a PivotTable report manually
- 4:59
- Viewed 1448 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 1382 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1355 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 1350 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1293 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1276 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1258 times
-
Customising your Visuals
- 2:58
- Viewed 1248 times
-
Creating your Datasets
- 2:26
- Viewed 1228 times
-
Improved version history
- 0:51
- Viewed 1218 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1174 times
-
Customising your Report
- 3:12
- Viewed 1124 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1124 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1106 times
-
Manage life cycle of a topic
- Viewed 655 times
-
XLOOKUP (Basic metrics)
- Viewed 645 times
-
XLOOKUP (Advanced metrics)
- Viewed 621 times
-
Check and share your form results
- Viewed 513 times
-
Manage video settings
- Viewed 461 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 422 times
-
Optimize Meetings with Viva Insights
- Viewed 372 times
-
Receiving a briefing email from Viva Insights
- Viewed 371 times
-
Analyze your network and communication habits
- Viewed 338 times