Excel - Create a PivotTable and analyze your data Video
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
- 3431 views
-
Excel - Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3401 times
-
Excel - Use slicers to filter data
- 1:25
- Viewed 3078 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2140 times
-
Excel - Functions and formulas
- 3:24
- Viewed 3634 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 3474 times
-
Excel - Create a PivotTable report manually
- 4:59
- Viewed 3778 times
-
Excel - How to create a table
- 2:11
- Viewed 3151 times
-
Excel - COUNTIFS and SUMIFS
- 5:30
- Viewed 3873 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4569 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4221 times
-
3D Maps
- 1:41
- Viewed 4123 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3873 times
-
Ink Equation
- 0:41
- Viewed 3853 times
-
Manage conditional formatting
- 4:30
- Viewed 3852 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3778 times
-
Start using Excel
- 4:22
- Viewed 3761 times
-
Create a combo chart
- 1:47
- Viewed 3750 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3735 times
-
The SUMIF function
- 5:27
- Viewed 3710 times
-
More complex formulas
- 4:17
- Viewed 3706 times
-
Manage drop-down lists
- 6:12
- Viewed 3683 times
-
A closer look at the ribbon
- 3:55
- Viewed 3660 times
-
New Chart types
- 1:52
- Viewed 3659 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3642 times
-
Functions and formulas
- 3:24
- Viewed 3634 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3631 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3608 times
-
Using functions
- 5:12
- Viewed 3605 times
-
The SUM function
- 4:37
- Viewed 3583 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3568 times
-
Advanced formulas and references
- 4:06
- Viewed 3542 times
-
AVERAGEIF function
- 3:04
- Viewed 3541 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3524 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3501 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3498 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3491 times
-
Customize charts
- 4:28
- Viewed 3482 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3481 times
-
More print options
- 5:59
- Viewed 3475 times
-
Freeze panes in detail
- 3:30
- Viewed 3474 times
-
IF with AND and OR
- 3:35
- Viewed 3467 times
-
Add numbers
- 2:54
- Viewed 3456 times
-
A first look at Excel 2016
- 3:22
- Viewed 3453 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3446 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3443 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3435 times
-
AutoFilter details
- 3:27
- Viewed 3432 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3430 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3429 times
-
AutoFill
- 2:55
- Viewed 3418 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3401 times
-
Drop-down list settings
- 4:14
- Viewed 3397 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3394 times
-
Advanced filter details
- 4:13
- Viewed 3388 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3376 times
-
Header and footer details
- 3:41
- Viewed 3376 times
-
Work with macros
- 4:40
- Viewed 3376 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3375 times
-
Input and error messages
- 2:52
- Viewed 3370 times
-
Insert columns and rows
- 4:16
- Viewed 3367 times
-
Subtract time
- 3:58
- Viewed 3365 times
-
Insert headers and footers
- 2:02
- Viewed 3357 times
-
Sort details
- 4:46
- Viewed 3346 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3345 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3316 times
-
Assign a button to a macro
- 2:49
- Viewed 3311 times
-
Conditionally format dates
- 2:38
- Viewed 3309 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3307 times
-
Save your macro
- 2:59
- Viewed 3307 times
-
Operator order
- 2:04
- Viewed 3286 times
-
Basic math
- 2:28
- Viewed 3282 times
-
How things are organized
- 1:58
- Viewed 3270 times
-
Copying formulas
- 3:00
- Viewed 3246 times
-
Introduction to Excel
- 0:59
- Viewed 3241 times
-
Improved version history
- 0:51
- Viewed 3211 times
-
Advanced IF functions
- 3:22
- Viewed 3207 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3204 times
-
Copy a chart
- 2:59
- Viewed 3193 times
-
TEXTJOIN
- 0:47
- Viewed 3173 times
-
Use conditional formatting
- 2:02
- Viewed 3170 times
-
IFS
- 1:05
- Viewed 3156 times
-
How to create a table
- 2:11
- Viewed 3151 times
-
Cell references
- 1:34
- Viewed 3149 times
-
Conditionally format text
- 2:12
- Viewed 3146 times
-
One click Forecasting
- 1:01
- Viewed 3137 times
-
Save, publish, and share
- 2:22
- Viewed 3110 times
-
Add formulas and references
- 2:52
- Viewed 3105 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3102 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3094 times
-
Get going fast
- 1:38
- Viewed 3087 times
-
Use slicers to filter data
- 1:25
- Viewed 3078 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3061 times
-
Nested IF functions
- 3:30
- Viewed 3047 times
-
Freeze or lock panes
- 1:06
- Viewed 3028 times
-
Weighted average
- 2:06
- Viewed 3018 times
-
Drop-down lists
- 0:55
- Viewed 2990 times
-
Average a group of numbers
- 2:01
- Viewed 2962 times
-
Flash Fill
- 2:59
- Viewed 2958 times
-
CONCAT
- 0:51
- Viewed 2952 times
-
Create a chart
- 0:52
- Viewed 2941 times
-
Edit a macro
- 3:29
- Viewed 2935 times
-
SWITCH
- 1:03
- Viewed 2926 times
-
Map Chart in Excel
- 0:31
- Viewed 2912 times
-
Sort and filter data
- 1:38
- Viewed 2898 times
-
Share documents
- 1:13
- Viewed 2837 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2791 times
-
Microsoft Search
- 0:34
- Viewed 2769 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2711 times
-
Page numbers in depth
- 3:06
- Viewed 2668 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2584 times
-
Accessibility in Excel
- 1:12
- Viewed 2513 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2475 times
-
Funnel Chart
- 0:33
- Viewed 2456 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2280 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2140 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2107 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2104 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2048 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2025 times
-
Text before & after Function
- 4:57
- Viewed 1916 times
-
Change chart type
- 1:29
- Viewed 1686 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1657 times
-
Creating a Report
- 2:54
- Viewed 8673 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3778 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3446 times
-
Recovering your Data from different sources
- 3:26
- Viewed 3436 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3401 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 3258 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3188 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3168 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3134 times
-
Creating your Datasets
- 2:26
- Viewed 3111 times
-
Customising your Visuals
- 2:58
- Viewed 3035 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 2953 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 2920 times
-
Improved version history
- 0:51
- Viewed 2697 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 2660 times
-
Customising your Report
- 3:12
- Viewed 2580 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2280 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2140 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2025 times
-
Check and share your form results
- 2:42
- Viewed 1997 times
-
Manage video settings
- 1:27
- Viewed 1759 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 1738 times
-
Analyze your network and communication habits
- 2:17
- Viewed 1561 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 1276 times
-
Analyze Team Dynamics
- 1:19
- Viewed 648 times
-
Organize into Folders
- 01:57
- Viewed 69 times
-
Sort and filter emails
- 02:51
- Viewed 62 times
-
Process an incoming message
- 01:53
- Viewed 53 times
-
Manage Views
- 02:36
- Viewed 51 times
-
Clean Up Your Inbox
- 01:18
- Viewed 16 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 9 times
-
Use Categories
- 02:51
- Viewed 8 times
-
Easily Sort Your Mails
- 01:38
- Viewed 7 times
-
Add a third-party application
- 02:40
- Viewed 15 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 14 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 12 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 11 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 10 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 11 times
-
Share a document securely with Outlook
- 02:21
- Viewed 14 times
-
Block a sender
- 01:54
- Viewed 16 times
-
Identify a fraudulent email
- 02:06
- Viewed 10 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 14 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 13 times
-
Protect an email by encrypting
- 01:10
- Viewed 7 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 12 times
-
Recover deleted items
- 01:09
- Viewed 10 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 13 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 11 times
-
Use a Shared Mailbox
- 01:18
- Viewed 10 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 13 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 16 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 11 times
-
Calendar Delegation Setup
- 01:21
- Viewed 14 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 13 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 14 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 16 times
-
Create a Meeting Poll
- 02:48
- Viewed 8 times
-
Display Three Time Zones
- 01:52
- Viewed 4 times
-
View Other Calendars
- 00:50
- Viewed 6 times
-
Open a Shared Calendar
- 01:29
- Viewed 8 times
-
Share Your Calendar
- 01:54
- Viewed 10 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 7 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 8 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 9 times
-
Translate Emails in Outlook
- 01:32
- Viewed 13 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 7 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 12 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 10 times
-
Improve Email Accessibility
- 02:02
- Viewed 8 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 14 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 6 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 6 times
-
Delay Email Delivery
- 01:10
- Viewed 8 times
-
Use Conversation View
- 01:47
- Viewed 5 times
-
Clean Up Your Inbox
- 01:18
- Viewed 16 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 9 times
-
Use Categories
- 02:51
- Viewed 8 times
-
Easily Sort Your Mails
- 01:38
- Viewed 7 times
-
Automate Routine Actions
- 02:19
- Viewed 10 times
-
Create an Email Template
- 01:40
- Viewed 11 times
-
Create a task from a message
- 02:00
- Viewed 55 times
-
Share a task list
- 03:10
- Viewed 65 times
-
Create a task or reminder
- 01:50
- Viewed 61 times
-
Task Module Overview
- 01:56
- Viewed 59 times
-
Manage Teams online meeting options
- 01:56
- Viewed 55 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 77 times
-
Create a reminder for yourself
- 01:59
- Viewed 51 times
-
Respond to a meeting
- 01:00
- Viewed 56 times
-
Create an appointment or meeting
- 01:44
- Viewed 65 times
-
Create different types of events
- 01:46
- Viewed 60 times
-
Edit and customize views
- 01:55
- Viewed 59 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 69 times
-
Search options
- 01:23
- Viewed 57 times
-
Sort and filter emails
- 02:51
- Viewed 62 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 60 times
-
The Bcc Field in Detail
- 01:53
- Viewed 62 times
-
Save and Print a Message
- 01:48
- Viewed 64 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 75 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 66 times
-
Process an incoming message
- 01:53
- Viewed 53 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 64 times
-
Organize into Folders
- 01:57
- Viewed 69 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 57 times
-
Create and add a signature to messages
- 01:26
- Viewed 60 times
-
Manage new message notifications
- 01:40
- Viewed 59 times
-
Change the default font of your emails
- 01:05
- Viewed 65 times
-
Manage Views
- 02:36
- Viewed 51 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 82 times
-
Explore the Interface
- 03:22
- Viewed 57 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 58 times
-
Manage Storage Space
- 02:08
- Viewed 177 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 161 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 170 times
-
Make a File Request
- 01:24
- Viewed 182 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 180 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 189 times
-
Modify Sharing Rules
- 00:53
- Viewed 181 times
-
Check Granted Shares
- 00:48
- Viewed 168 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 181 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 156 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 185 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 177 times
-
Search for Documents
- 01:31
- Viewed 150 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 180 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 179 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 168 times
-
Edit, Delete a Share
- 02:16
- Viewed 176 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 182 times
-
Power and Manage OneDrive
- 01:36
- Viewed 174 times
-
What is OneDrive ?
- 01:14
- Viewed 258 times
-
Add interactivity to your videos
- 1:20
- Viewed 539 times
DiLeaP AI: THIS MIGHT BE HELPFUL
RELATED COURSES This video 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
- 1750 Views