Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data Tutorial
In this video, you will learn about using slicers, timelines, and PivotCharts to analyze your PivotTable data.
The video covers how to set up your data sources, create a PivotTable, filter data, edit summary formulas, change header names, and display data in the desired order.
It also explains the benefits of using slicers in Excel.
This knowledge will help you showcase your data effectively and make accurate summaries.
- 3:38
- 368 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 2607 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2383 times
-
3D Maps
- 1:41
- Viewed 1919 times
-
Manage conditional formatting
- 4:30
- Viewed 1887 times
-
Create a combo chart
- 1:47
- Viewed 1818 times
-
Introduction to Excel
- Viewed 1716 times
-
The SUMIF function
- 5:27
- Viewed 1693 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 1675 times
-
The SUM function
- 4:37
- Viewed 1621 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 1606 times
-
Customize charts
- 4:28
- Viewed 1598 times
-
Functions and formulas
- 3:24
- Viewed 1598 times
-
AutoFill
- 2:55
- Viewed 1586 times
-
Advanced formulas and references
- 4:06
- Viewed 1563 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 1561 times
-
Using functions
- 5:12
- Viewed 1552 times
-
Drop-down list settings
- 4:14
- Viewed 1548 times
-
New Chart types
- 1:52
- Viewed 1547 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 1513 times
-
More complex formulas
- 4:17
- Viewed 1507 times
-
Assign a button to a macro
- 2:49
- Viewed 1506 times
-
Manage drop-down lists
- 6:12
- Viewed 1503 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 1499 times
-
AutoFilter details
- 3:27
- Viewed 1487 times
-
Operator order
- 2:04
- Viewed 1485 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 1483 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 1478 times
-
Sort details
- 4:46
- Viewed 1473 times
-
Basic math
- 2:28
- Viewed 1465 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 1465 times
-
Freeze panes in detail
- 3:30
- Viewed 1460 times
-
Start using Excel
- 4:22
- Viewed 1452 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 1448 times
-
Look up values on a different worksheet
- 2:39
- Viewed 1446 times
-
More print options
- 5:59
- Viewed 1445 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 1431 times
-
One click Forecasting
- 1:01
- Viewed 1427 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 1425 times
-
Add numbers
- 2:54
- Viewed 1422 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1418 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 1400 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 1399 times
-
Work with macros
- 4:40
- Viewed 1399 times
-
Improved version history
- 0:51
- Viewed 1396 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1391 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 1388 times
-
Create a PivotTable report manually
- 4:59
- Viewed 1386 times
-
Insert columns and rows
- 4:16
- Viewed 1381 times
-
Insert headers and footers
- 2:02
- Viewed 1373 times
-
Input and error messages
- 2:52
- Viewed 1372 times
-
Ink Equation
- 0:41
- Viewed 1370 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1369 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1360 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1357 times
-
A closer look at the ribbon
- 3:55
- Viewed 1352 times
-
IF with AND and OR
- 3:35
- Viewed 1352 times
-
A first look at Excel 2016
- 3:22
- Viewed 1351 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1351 times
-
Advanced filter details
- 4:13
- Viewed 1347 times
-
Header and footer details
- 3:41
- Viewed 1345 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1344 times
-
Add formulas and references
- 2:52
- Viewed 1344 times
-
Subtract time
- 3:58
- Viewed 1340 times
-
IFS
- 1:05
- Viewed 1340 times
-
Copying formulas
- 3:00
- Viewed 1339 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1334 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1330 times
-
Freeze or lock panes
- 1:06
- Viewed 1327 times
-
AVERAGEIF function
- 3:04
- Viewed 1326 times
-
Use conditional formatting
- 2:02
- Viewed 1321 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 1309 times
-
Copy a chart
- 2:59
- Viewed 1299 times
-
Weighted average
- 2:06
- Viewed 1295 times
-
Cell references
- 1:34
- Viewed 1293 times
-
Share documents
- 1:13
- Viewed 1288 times
-
Save your macro
- 2:59
- Viewed 1288 times
-
Get going fast
- 1:38
- Viewed 1278 times
-
Average a group of numbers
- 2:01
- Viewed 1268 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1258 times
-
Drop-down lists
- 0:55
- Viewed 1253 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1245 times
-
TEXTJOIN
- 0:47
- Viewed 1233 times
-
Conditionally format text
- 2:12
- Viewed 1231 times
-
How to create a table
- 2:11
- Viewed 1225 times
-
Save, publish, and share
- 2:22
- Viewed 1211 times
-
Sort and filter data
- 1:38
- Viewed 1209 times
-
Advanced IF functions
- 3:22
- Viewed 1206 times
-
Edit a macro
- 3:29
- Viewed 1202 times
-
How things are organized
- 1:58
- Viewed 1200 times
-
Translate your Excel spreadsheets
- Viewed 1199 times
-
CONCAT
- 0:51
- Viewed 1198 times
-
Conditionally format dates
- 2:38
- Viewed 1197 times
-
Flash Fill
- 2:59
- Viewed 1189 times
-
Use slicers to filter data
- 1:25
- Viewed 1189 times
-
SWITCH
- 1:03
- Viewed 1169 times
-
Create a chart
- 0:52
- Viewed 1164 times
-
Microsoft Search
- 0:34
- Viewed 1159 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1138 times
-
Nested IF functions
- 3:30
- Viewed 1117 times
-
Page numbers in depth
- 3:06
- Viewed 1097 times
-
Map Chart in Excel
- 0:31
- Viewed 1081 times
-
Funnel Chart
- 0:33
- Viewed 1065 times
-
Check Accessibility in Excel
- Viewed 908 times
-
Accessibility in Excel
- Viewed 895 times
-
Change chart type
- Viewed 739 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 614 times
-
XLOOKUP (Basic metrics)
- Viewed 611 times
-
Text before & after Function
- Viewed 598 times
-
Insert an image in a cell with image function
- Viewed 577 times
-
XLOOKUP (Advanced metrics)
- Viewed 563 times
-
Create dynamic drop down lists
- Viewed 518 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 511 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 356 times
-
Creating a Report
- 2:54
- Viewed 2184 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 1425 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 1400 times
-
Create a PivotTable report manually
- 4:59
- Viewed 1386 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 1337 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1310 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 1309 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1234 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1222 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1221 times
-
Creating your Datasets
- 2:26
- Viewed 1202 times
-
Improved version history
- 0:51
- Viewed 1166 times
-
Customising your Visuals
- 2:58
- Viewed 1155 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1107 times
-
Customising your Report
- 3:12
- Viewed 1096 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1095 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1054 times
-
Manage life cycle of a topic
- Viewed 638 times
-
XLOOKUP (Basic metrics)
- Viewed 611 times
-
XLOOKUP (Advanced metrics)
- Viewed 563 times
-
Check and share your form results
- Viewed 487 times
-
Manage video settings
- Viewed 444 times
-
Optimize Meetings with Viva Insights
- Viewed 339 times
-
Receiving a briefing email from Viva Insights
- Viewed 327 times
-
Analyze your network and communication habits
- Viewed 323 times
-
View events
- Viewed 50 times
-
Take notes in meetings
- Viewed 59 times
-
Manage a meeting
- Viewed 58 times
-
Start an instant meeting
- Viewed 51 times
-
Join a meeting as a participant
- Viewed 66 times
-
Automatically record a meeting
- Viewed 54 times
-
Presentation of different tools in a meeting
- Viewed 54 times
-
Share content in meetings
- Viewed 59 times
-
Use a background image during a video call
- Viewed 52 times
-
Schedule private or team meetings
- Viewed 57 times
-
Synchronize only one channel
- Viewed 54 times
-
Pin a channel to your favorites
- Viewed 54 times
-
Add channels and tabs
- Viewed 51 times
-
Interact in a conversation
- Viewed 56 times
-
Edit and enhance messages
- Viewed 63 times
-
Create a team using a template
- Viewed 62 times
-
Create a team and add members
- Viewed 70 times
-
Plan a meeting based on a conversation
- Viewed 56 times
-
Interact in conversations
- Viewed 51 times
-
Private and small group chats
- Viewed 54 times
-
Overview of conversations
- Viewed 51 times
-
Define your status message
- Viewed 76 times
-
Customize notifications
- Viewed 56 times
-
Edit photo in Teams
- Viewed 54 times
-
Find content and people
- Viewed 53 times
-
Presentation of the desktop application
- Viewed 54 times
-
Introduction to Teams
- Viewed 59 times
-
Receiving a briefing email from Viva Insights
- Viewed 327 times
-
Preparing for time away from the office
- Viewed 344 times
-
Respecting your colleagues disconnection times
- Viewed 345 times
-
Analyze your network and communication habits
- Viewed 323 times
-
Optimize Meetings with Viva Insights
- Viewed 339 times
-
Stay connected with colleagues using Microsoft Insight
- Viewed 381 times
-
Using relaxation modules
- Viewed 313 times
-
Set up a period of quiet and focus
- Viewed 333 times
-
Upholding your right to disconnect with Viva Insights
- Viewed 307 times
-
Setting your working hours
- Viewed 372 times
-
Exploring the viva insights interface
- Viewed 289 times
-
Using Microsoft Viva Insights In Teams
- Viewed 331 times