Excel - Create a PivotTable report manually Video
In this video, you will learn how to create a PivotTable report manually using Microsoft 365. Pivot table reports are a powerful way to summarize, analyze, explore, and present your data in a report.
This video will guide you through the process of creating a PivotTable and analyzing your data.
By following the steps, you will be able to make sense of your data, especially when you have a large amount of it.
This will help you gain insights and make informed decisions based on your data.
- 4:59
- 2271 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3303 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3055 times
-
3D Maps
- 1:41
- Viewed 2673 times
-
Manage conditional formatting
- 4:30
- Viewed 2651 times
-
Create a combo chart
- 1:47
- Viewed 2534 times
-
The SUMIF function
- 5:27
- Viewed 2531 times
-
Functions and formulas
- 3:24
- Viewed 2439 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2421 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2411 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2395 times
-
The SUM function
- 4:37
- Viewed 2386 times
-
More complex formulas
- 4:17
- Viewed 2372 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2370 times
-
Using functions
- 5:12
- Viewed 2367 times
-
Manage drop-down lists
- 6:12
- Viewed 2356 times
-
Advanced formulas and references
- 4:06
- Viewed 2350 times
-
More print options
- 5:59
- Viewed 2347 times
-
Introduction to Excel
- 0:59
- Viewed 2340 times
-
Customize charts
- 4:28
- Viewed 2325 times
-
New Chart types
- 1:52
- Viewed 2322 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2267 times
-
Start using Excel
- 4:22
- Viewed 2263 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2254 times
-
Freeze panes in detail
- 3:30
- Viewed 2253 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2243 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2238 times
-
AutoFilter details
- 3:27
- Viewed 2235 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2234 times
-
AutoFill
- 2:55
- Viewed 2227 times
-
Drop-down list settings
- 4:14
- Viewed 2226 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2218 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2214 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2211 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2203 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2199 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2191 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2178 times
-
Header and footer details
- 3:41
- Viewed 2162 times
-
Add numbers
- 2:54
- Viewed 2161 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2158 times
-
Operator order
- 2:04
- Viewed 2148 times
-
A first look at Excel 2016
- 3:22
- Viewed 2148 times
-
Sort details
- 4:46
- Viewed 2148 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2141 times
-
IF with AND and OR
- 3:35
- Viewed 2140 times
-
Assign a button to a macro
- 2:49
- Viewed 2132 times
-
A closer look at the ribbon
- 3:55
- Viewed 2130 times
-
Work with macros
- 4:40
- Viewed 2120 times
-
Advanced filter details
- 4:13
- Viewed 2112 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2112 times
-
Insert columns and rows
- 4:16
- Viewed 2109 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2109 times
-
Insert headers and footers
- 2:02
- Viewed 2108 times
-
One click Forecasting
- 1:01
- Viewed 2106 times
-
Basic math
- 2:28
- Viewed 2105 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2105 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2102 times
-
Use conditional formatting
- 2:02
- Viewed 2099 times
-
Ink Equation
- 0:41
- Viewed 2085 times
-
AVERAGEIF function
- 3:04
- Viewed 2074 times
-
Save your macro
- 2:59
- Viewed 2072 times
-
Improved version history
- 0:51
- Viewed 2052 times
-
Input and error messages
- 2:52
- Viewed 2050 times
-
Subtract time
- 3:58
- Viewed 2047 times
-
Copy a chart
- 2:59
- Viewed 2044 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2025 times
-
Cell references
- 1:34
- Viewed 2022 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2022 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2012 times
-
IFS
- 1:05
- Viewed 1993 times
-
Conditionally format dates
- 2:38
- Viewed 1989 times
-
TEXTJOIN
- 0:47
- Viewed 1987 times
-
Get going fast
- 1:38
- Viewed 1977 times
-
Conditionally format text
- 2:12
- Viewed 1975 times
-
Add formulas and references
- 2:52
- Viewed 1974 times
-
Copying formulas
- 3:00
- Viewed 1973 times
-
Freeze or lock panes
- 1:06
- Viewed 1945 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1943 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1941 times
-
Save, publish, and share
- 2:22
- Viewed 1939 times
-
Weighted average
- 2:06
- Viewed 1920 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1910 times
-
Average a group of numbers
- 2:01
- Viewed 1896 times
-
Use slicers to filter data
- 1:25
- Viewed 1894 times
-
How to create a table
- 2:11
- Viewed 1890 times
-
Share documents
- 1:13
- Viewed 1881 times
-
How things are organized
- 1:58
- Viewed 1875 times
-
Drop-down lists
- 0:55
- Viewed 1872 times
-
Advanced IF functions
- 3:22
- Viewed 1870 times
-
Create a chart
- 0:52
- Viewed 1859 times
-
CONCAT
- 0:51
- Viewed 1840 times
-
Edit a macro
- 3:29
- Viewed 1833 times
-
Flash Fill
- 2:59
- Viewed 1813 times
-
Sort and filter data
- 1:38
- Viewed 1796 times
-
SWITCH
- 1:03
- Viewed 1786 times
-
Nested IF functions
- 3:30
- Viewed 1784 times
-
Page numbers in depth
- 3:06
- Viewed 1759 times
-
Microsoft Search
- 0:34
- Viewed 1757 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1711 times
-
Map Chart in Excel
- 0:31
- Viewed 1704 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1700 times
-
Funnel Chart
- 0:33
- Viewed 1541 times
-
Accessibility in Excel
- 1:12
- Viewed 1510 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1454 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1199 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1172 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1140 times
-
Change chart type
- 1:29
- Viewed 1138 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1108 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1097 times
-
Text before & after Function
- 4:57
- Viewed 1090 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1042 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 816 times
-
Creating a Report
- 2:54
- Viewed 5113 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2243 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2214 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2173 times
-
Recovering your Data from different sources
- 3:26
- Viewed 2166 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 2008 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1978 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1973 times
-
Creating your Datasets
- 2:26
- Viewed 1951 times
-
Customising your Visuals
- 2:58
- Viewed 1870 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1827 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1816 times
-
Improved version history
- 0:51
- Viewed 1815 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1723 times
-
Customising your Report
- 3:12
- Viewed 1694 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1172 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1147 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1140 times
-
Check and share your form results
- 2:42
- Viewed 1136 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1042 times
-
Manage video settings
- 1:27
- Viewed 942 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 884 times
-
Analyze your network and communication habits
- 2:17
- Viewed 777 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 760 times
-
Analyze Team Dynamics
- 1:19
- Viewed 109 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 105 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 110 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 107 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 118 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 115 times
-
Managing permissions of a document library
- 2:01
- Viewed 102 times
-
Create a permission group
- 2:11
- Viewed 148 times
-
SharePoint permission levels
- 2:16
- Viewed 108 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 113 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 144 times
-
Create a SharePoint Lists
- 2:18
- Viewed 155 times
-
Create a document library
- 1:56
- Viewed 152 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 159 times
-
Customise my site Homepage
- 3:03
- Viewed 113 times
-
Configure the global Theme and logo
- 2:26
- Viewed 159 times
-
Delete a SharePoint site
- 1:12
- Viewed 106 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 111 times
-
Create a SharePoint site
- 1:57
- Viewed 158 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 102 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 115 times
-
Prevent comments on modern pages
- 1:15
- Viewed 149 times
-
Disable subsite creation
- 0:53
- Viewed 106 times
-
Set the proper time zone
- 0:44
- Viewed 109 times
-
Define site storage limits
- 1:42
- Viewed 102 times
-
Disable site creation
- 0:52
- Viewed 109 times
-
Access the admin center
- 0:52
- Viewed 154 times
-
Work together on the same document
- 1:48
- Viewed 114 times
-
Create a folder or a file in a library
- 1:46
- Viewed 157 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 123 times
-
Use the filter pane in a library
- 2:00
- Viewed 108 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 107 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 105 times
-
Use version history
- 1:57
- Viewed 106 times
-
Open and work on a document
- 2:42
- Viewed 110 times
-
Rename and find a document
- 2:00
- Viewed 100 times
-
Create a SharePoint site
- 2:58
- Viewed 163 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 161 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 114 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 109 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 107 times
-
Participate in a Town Hall
- 0:53
- Viewed 102 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 105 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 112 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 105 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 110 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 108 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 109 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 117 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 120 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 111 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 108 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 161 times
-
Send an Email to a Team
- 0:38
- Viewed 167 times
-
Analyze Team Dynamics
- 1:19
- Viewed 109 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 151 times
-
Create Approval Templates
- 2:06
- Viewed 159 times
-
Manage Document Approval
- 0:56
- Viewed 108 times
-
Make a New Approval Request
- 1:26
- Viewed 156 times
-
Use Templates for Document Creation
- 1:03
- Viewed 112 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 110 times
-
Filter Your Document Display
- 1:10
- Viewed 104 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 115 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 111 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 110 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 117 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 109 times
-
Add and Explore Workflows
- 1:35
- Viewed 110 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 107 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 104 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 109 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 110 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 159 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 127 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 104 times
-
Manage Conversation Options
- 1:35
- Viewed 114 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 106 times
-
Schedule Message Delivery
- 0:58
- Viewed 148 times
-
Finding Help?
- 0:56
- Viewed 414 times
-
Chancing Your Status
- 0:40
- Viewed 453 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 400 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 460 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 394 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 626 times
-
File Management
- 1:04
- Viewed 415 times
-
Managing Teams and Channels
- 2:15
- Viewed 408 times
-
Posting in a Channel
- 2:15
- Viewed 437 times
-
Creating a Channel
- 2:05
- Viewed 383 times
-
Creating or Joining a Team
- 1:11
- Viewed 614 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 403 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 597 times
-
Starting a Conversation
- 0:53
- Viewed 432 times
-
Searching for Items or People
- 0:30
- Viewed 383 times
-
Interface Overview
- 1:10
- Viewed 459 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 461 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 432 times
-
Change application settings
- 2:53
- Viewed 442 times
-
Manage accessibility settings
- 1:33
- Viewed 645 times
-
Manage privacy settings
- 1:00
- Viewed 454 times
-
Set up and customize your teams
- 2:02
- Viewed 397 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 443 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 410 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 447 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 476 times
-
Generate a presence report
- 1:23
- Viewed 401 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 409 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 418 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 630 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 473 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 422 times
-
Following your activities and your team's activities
- 1:26
- Viewed 401 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 411 times
-
Manage team files
- 1:28
- Viewed 431 times
-
Invite external guests
- 1:19
- Viewed 452 times
-
Create private and shared channels
- 1:52
- Viewed 632 times
-
Manage your teams
- 2:38
- Viewed 462 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 625 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 412 times
-
Store files in conversations
- 1:38
- Viewed 388 times
-
Isolate a conversation window
- 0:50
- Viewed 421 times
-
Use and co-edit files
- 2:06
- Viewed 436 times
-
View events
- 2:21
- Viewed 576 times
-
Take notes in meetings
- 0:35
- Viewed 517 times
-
Manage a meeting
- 2:08
- Viewed 524 times
-
Start an instant meeting
- 1:33
- Viewed 589 times
-
Join a meeting as a participant
- 2:13
- Viewed 836 times
-
Automatically record a meeting
- 1:12
- Viewed 590 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 562 times
-
Share content in meetings
- 2:44
- Viewed 510 times
-
Use a background image during a video call
- 1:19
- Viewed 469 times
-
Schedule private or team meetings
- 2:17
- Viewed 628 times
-
Synchronize only one channel
- 0:56
- Viewed 657 times
-
Pin a channel to your favorites
- 1:04
- Viewed 591 times
-
Add channels and tabs
- 1:40
- Viewed 617 times
-
Interact in a conversation
- 2:03
- Viewed 445 times
-
Edit and enhance messages
- 1:57
- Viewed 823 times
-
Create a team using a template
- 1:03
- Viewed 781 times
-
Create a team and add members
- 1:37
- Viewed 709 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 744 times
-
Interact in conversations
- 1:30
- Viewed 622 times
-
Private and small group chats
- 2:03
- Viewed 532 times
-
Overview of conversations
- 1:02
- Viewed 592 times
-
Define your status message
- 2:13
- Viewed 901 times
-
Customize notifications
- 2:05
- Viewed 644 times
-
Edit photo in Teams
- 0:42
- Viewed 497 times
-
Find content and people
- 0:59
- Viewed 598 times
-
Presentation of the desktop application
- 2:16
- Viewed 482 times
-
Introduction to Teams
- 1:25
- Viewed 475 times
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
- 870 Views