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
- 2270 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3301 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3054 times
-
3D Maps
- 1:41
- Viewed 2671 times
-
Manage conditional formatting
- 4:30
- Viewed 2650 times
-
Create a combo chart
- 1:47
- Viewed 2533 times
-
The SUMIF function
- 5:27
- Viewed 2528 times
-
Functions and formulas
- 3:24
- Viewed 2437 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2419 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2411 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2393 times
-
The SUM function
- 4:37
- Viewed 2384 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2369 times
-
More complex formulas
- 4:17
- Viewed 2368 times
-
Using functions
- 5:12
- Viewed 2363 times
-
Manage drop-down lists
- 6:12
- Viewed 2353 times
-
Advanced formulas and references
- 4:06
- Viewed 2347 times
-
More print options
- 5:59
- Viewed 2346 times
-
Introduction to Excel
- 0:59
- Viewed 2340 times
-
Customize charts
- 4:28
- Viewed 2324 times
-
New Chart types
- 1:52
- Viewed 2318 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2265 times
-
Start using Excel
- 4:22
- Viewed 2261 times
-
Freeze panes in detail
- 3:30
- Viewed 2252 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2251 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2242 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2233 times
-
AutoFilter details
- 3:27
- Viewed 2233 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2233 times
-
AutoFill
- 2:55
- Viewed 2227 times
-
Drop-down list settings
- 4:14
- Viewed 2224 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2215 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2213 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2207 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2199 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2195 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2189 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2184 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2172 times
-
Header and footer details
- 3:41
- Viewed 2160 times
-
Add numbers
- 2:54
- Viewed 2158 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2156 times
-
Sort details
- 4:46
- Viewed 2146 times
-
Operator order
- 2:04
- Viewed 2144 times
-
A first look at Excel 2016
- 3:22
- Viewed 2143 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2139 times
-
IF with AND and OR
- 3:35
- Viewed 2138 times
-
Assign a button to a macro
- 2:49
- Viewed 2131 times
-
A closer look at the ribbon
- 3:55
- Viewed 2127 times
-
Work with macros
- 4:40
- Viewed 2120 times
-
Advanced filter details
- 4:13
- Viewed 2111 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2110 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2108 times
-
Insert columns and rows
- 4:16
- Viewed 2107 times
-
Insert headers and footers
- 2:02
- Viewed 2106 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2104 times
-
One click Forecasting
- 1:01
- Viewed 2103 times
-
Basic math
- 2:28
- Viewed 2101 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2101 times
-
Use conditional formatting
- 2:02
- Viewed 2096 times
-
Ink Equation
- 0:41
- Viewed 2083 times
-
AVERAGEIF function
- 3:04
- Viewed 2068 times
-
Save your macro
- 2:59
- Viewed 2068 times
-
Improved version history
- 0:51
- Viewed 2050 times
-
Input and error messages
- 2:52
- Viewed 2047 times
-
Subtract time
- 3:58
- Viewed 2046 times
-
Copy a chart
- 2:59
- Viewed 2043 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2023 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2020 times
-
Cell references
- 1:34
- Viewed 2019 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2011 times
-
IFS
- 1:05
- Viewed 1992 times
-
Conditionally format dates
- 2:38
- Viewed 1987 times
-
TEXTJOIN
- 0:47
- Viewed 1987 times
-
Get going fast
- 1:38
- Viewed 1976 times
-
Copying formulas
- 3:00
- Viewed 1972 times
-
Add formulas and references
- 2:52
- Viewed 1972 times
-
Conditionally format text
- 2:12
- Viewed 1971 times
-
Freeze or lock panes
- 1:06
- Viewed 1945 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1940 times
-
Save, publish, and share
- 2:22
- Viewed 1936 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1936 times
-
Weighted average
- 2:06
- Viewed 1919 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1910 times
-
Average a group of numbers
- 2:01
- Viewed 1893 times
-
Use slicers to filter data
- 1:25
- Viewed 1892 times
-
How to create a table
- 2:11
- Viewed 1887 times
-
Share documents
- 1:13
- Viewed 1879 times
-
How things are organized
- 1:58
- Viewed 1872 times
-
Drop-down lists
- 0:55
- Viewed 1869 times
-
Advanced IF functions
- 3:22
- Viewed 1869 times
-
Create a chart
- 0:52
- Viewed 1854 times
-
CONCAT
- 0:51
- Viewed 1840 times
-
Edit a macro
- 3:29
- Viewed 1830 times
-
Flash Fill
- 2:59
- Viewed 1811 times
-
Sort and filter data
- 1:38
- Viewed 1796 times
-
SWITCH
- 1:03
- Viewed 1785 times
-
Nested IF functions
- 3:30
- Viewed 1783 times
-
Microsoft Search
- 0:34
- Viewed 1757 times
-
Page numbers in depth
- 3:06
- Viewed 1756 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1709 times
-
Map Chart in Excel
- 0:31
- Viewed 1699 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1698 times
-
Funnel Chart
- 0:33
- Viewed 1540 times
-
Accessibility in Excel
- 1:12
- Viewed 1509 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1453 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1198 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1168 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1138 times
-
Change chart type
- 1:29
- Viewed 1137 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1106 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1095 times
-
Text before & after Function
- 4:57
- Viewed 1089 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1041 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 816 times
-
Creating a Report
- 2:54
- Viewed 5112 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2242 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2213 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 2165 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
-
Improved version history
- 0:51
- Viewed 1815 times
-
Consulting and using a Dashboard
- 3:08
- 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 1168 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1147 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1138 times
-
Check and share your form results
- 2:42
- Viewed 1135 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1041 times
-
Manage video settings
- 1:27
- Viewed 942 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 883 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 107 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 103 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 109 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 106 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 116 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 113 times
-
Managing permissions of a document library
- 2:01
- Viewed 102 times
-
Create a permission group
- 2:11
- Viewed 147 times
-
SharePoint permission levels
- 2:16
- Viewed 106 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 111 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 144 times
-
Create a SharePoint Lists
- 2:18
- Viewed 154 times
-
Create a document library
- 1:56
- Viewed 150 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 159 times
-
Customise my site Homepage
- 3:03
- Viewed 111 times
-
Configure the global Theme and logo
- 2:26
- Viewed 157 times
-
Delete a SharePoint site
- 1:12
- Viewed 104 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 110 times
-
Create a SharePoint site
- 1:57
- Viewed 156 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 101 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 112 times
-
Prevent comments on modern pages
- 1:15
- Viewed 148 times
-
Disable subsite creation
- 0:53
- Viewed 105 times
-
Set the proper time zone
- 0:44
- Viewed 108 times
-
Define site storage limits
- 1:42
- Viewed 100 times
-
Disable site creation
- 0:52
- Viewed 107 times
-
Access the admin center
- 0:52
- Viewed 152 times
-
Work together on the same document
- 1:48
- Viewed 112 times
-
Create a folder or a file in a library
- 1:46
- Viewed 155 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 122 times
-
Use the filter pane in a library
- 2:00
- Viewed 107 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 104 times
-
Use version history
- 1:57
- Viewed 104 times
-
Open and work on a document
- 2:42
- Viewed 108 times
-
Rename and find a document
- 2:00
- Viewed 99 times
-
Create a SharePoint site
- 2:58
- Viewed 162 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 159 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 113 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 109 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 106 times
-
Participate in a Town Hall
- 0:53
- Viewed 101 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 104 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 108 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 105 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 108 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 116 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 120 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 108 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 106 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 157 times
-
Send an Email to a Team
- 0:38
- Viewed 164 times
-
Analyze Team Dynamics
- 1:19
- Viewed 107 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 150 times
-
Create Approval Templates
- 2:06
- Viewed 157 times
-
Manage Document Approval
- 0:56
- Viewed 107 times
-
Make a New Approval Request
- 1:26
- Viewed 154 times
-
Use Templates for Document Creation
- 1:03
- Viewed 110 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 108 times
-
Filter Your Document Display
- 1:10
- Viewed 104 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 113 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 109 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 108 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 115 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 108 times
-
Add and Explore Workflows
- 1:35
- Viewed 109 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 105 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 101 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 108 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 109 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 156 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 126 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 102 times
-
Manage Conversation Options
- 1:35
- Viewed 109 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 106 times
-
Schedule Message Delivery
- 0:58
- Viewed 147 times
-
Finding Help?
- 0:56
- Viewed 414 times
-
Chancing Your Status
- 0:40
- Viewed 452 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 399 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 459 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 392 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 625 times
-
File Management
- 1:04
- Viewed 414 times
-
Managing Teams and Channels
- 2:15
- Viewed 407 times
-
Posting in a Channel
- 2:15
- Viewed 435 times
-
Creating a Channel
- 2:05
- Viewed 382 times
-
Creating or Joining a Team
- 1:11
- Viewed 614 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 401 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 596 times
-
Starting a Conversation
- 0:53
- Viewed 430 times
-
Searching for Items or People
- 0:30
- Viewed 382 times
-
Interface Overview
- 1:10
- Viewed 457 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 458 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 432 times
-
Change application settings
- 2:53
- Viewed 441 times
-
Manage accessibility settings
- 1:33
- Viewed 645 times
-
Manage privacy settings
- 1:00
- Viewed 452 times
-
Set up and customize your teams
- 2:02
- Viewed 396 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 408 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 445 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 475 times
-
Generate a presence report
- 1:23
- Viewed 399 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 407 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 417 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 630 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 471 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 420 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 410 times
-
Manage team files
- 1:28
- Viewed 431 times
-
Invite external guests
- 1:19
- Viewed 450 times
-
Create private and shared channels
- 1:52
- Viewed 631 times
-
Manage your teams
- 2:38
- Viewed 462 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 624 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 411 times
-
Store files in conversations
- 1:38
- Viewed 387 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 574 times
-
Take notes in meetings
- 0:35
- Viewed 516 times
-
Manage a meeting
- 2:08
- Viewed 523 times
-
Start an instant meeting
- 1:33
- Viewed 588 times
-
Join a meeting as a participant
- 2:13
- Viewed 835 times
-
Automatically record a meeting
- 1:12
- Viewed 589 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 560 times
-
Share content in meetings
- 2:44
- Viewed 509 times
-
Use a background image during a video call
- 1:19
- Viewed 467 times
-
Schedule private or team meetings
- 2:17
- Viewed 627 times
-
Synchronize only one channel
- 0:56
- Viewed 655 times
-
Pin a channel to your favorites
- 1:04
- Viewed 590 times
-
Add channels and tabs
- 1:40
- Viewed 616 times
-
Interact in a conversation
- 2:03
- Viewed 443 times
-
Edit and enhance messages
- 1:57
- Viewed 823 times
-
Create a team using a template
- 1:03
- Viewed 780 times
-
Create a team and add members
- 1:37
- Viewed 708 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 744 times
-
Interact in conversations
- 1:30
- Viewed 620 times
-
Private and small group chats
- 2:03
- Viewed 530 times
-
Overview of conversations
- 1:02
- Viewed 592 times
-
Define your status message
- 2:13
- Viewed 901 times
-
Customize notifications
- 2:05
- Viewed 642 times
-
Edit photo in Teams
- 0:42
- Viewed 494 times
-
Find content and people
- 0:59
- Viewed 597 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
- 868 Views