Excel - Create a PivotTable report manually Tutorial
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
- 2101 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3150 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2916 times
-
3D Maps
- 1:41
- Viewed 2508 times
-
Manage conditional formatting
- 4:30
- Viewed 2499 times
-
Create a combo chart
- 1:47
- Viewed 2371 times
-
The SUMIF function
- 5:27
- Viewed 2349 times
-
Functions and formulas
- 3:24
- Viewed 2299 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2271 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2260 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2251 times
-
The SUM function
- 4:37
- Viewed 2236 times
-
More complex formulas
- 4:17
- Viewed 2224 times
-
Advanced formulas and references
- 4:06
- Viewed 2216 times
-
More print options
- 5:59
- Viewed 2210 times
-
Introduction to Excel
- 0:59
- Viewed 2210 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2208 times
-
Using functions
- 5:12
- Viewed 2201 times
-
Customize charts
- 4:28
- Viewed 2194 times
-
Manage drop-down lists
- 6:12
- Viewed 2189 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2119 times
-
New Chart types
- 1:52
- Viewed 2113 times
-
Freeze panes in detail
- 3:30
- Viewed 2107 times
-
Start using Excel
- 4:22
- Viewed 2103 times
-
AutoFill
- 2:55
- Viewed 2098 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2089 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2088 times
-
AutoFilter details
- 3:27
- Viewed 2086 times
-
Drop-down list settings
- 4:14
- Viewed 2084 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2063 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2054 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2051 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2050 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2050 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2047 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2044 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2037 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2035 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2028 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2025 times
-
Header and footer details
- 3:41
- Viewed 2019 times
-
Operator order
- 2:04
- Viewed 2003 times
-
Sort details
- 4:46
- Viewed 2000 times
-
Assign a button to a macro
- 2:49
- Viewed 1994 times
-
IF with AND and OR
- 3:35
- Viewed 1993 times
-
A closer look at the ribbon
- 3:55
- Viewed 1991 times
-
Work with macros
- 4:40
- Viewed 1980 times
-
Advanced filter details
- 4:13
- Viewed 1971 times
-
A first look at Excel 2016
- 3:22
- Viewed 1970 times
-
Add numbers
- 2:54
- Viewed 1969 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1966 times
-
Insert columns and rows
- 4:16
- Viewed 1965 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1962 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1962 times
-
Basic math
- 2:28
- Viewed 1957 times
-
Use conditional formatting
- 2:02
- Viewed 1954 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1954 times
-
One click Forecasting
- 1:01
- Viewed 1952 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1947 times
-
Insert headers and footers
- 2:02
- Viewed 1944 times
-
Ink Equation
- 0:41
- Viewed 1917 times
-
Improved version history
- 0:51
- Viewed 1905 times
-
Input and error messages
- 2:52
- Viewed 1900 times
-
Copy a chart
- 2:59
- Viewed 1896 times
-
Subtract time
- 3:58
- Viewed 1892 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1889 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1884 times
-
Save your macro
- 2:59
- Viewed 1884 times
-
AVERAGEIF function
- 3:04
- Viewed 1877 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1871 times
-
Cell references
- 1:34
- Viewed 1869 times
-
IFS
- 1:05
- Viewed 1859 times
-
Add formulas and references
- 2:52
- Viewed 1858 times
-
Copying formulas
- 3:00
- Viewed 1833 times
-
Get going fast
- 1:38
- Viewed 1831 times
-
Freeze or lock panes
- 1:06
- Viewed 1818 times
-
Conditionally format text
- 2:12
- Viewed 1818 times
-
Conditionally format dates
- 2:38
- Viewed 1817 times
-
TEXTJOIN
- 0:47
- Viewed 1816 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1800 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1800 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1796 times
-
Weighted average
- 2:06
- Viewed 1777 times
-
Save, publish, and share
- 2:22
- Viewed 1776 times
-
Average a group of numbers
- 2:01
- Viewed 1755 times
-
Share documents
- 1:13
- Viewed 1754 times
-
How to create a table
- 2:11
- Viewed 1744 times
-
Use slicers to filter data
- 1:25
- Viewed 1743 times
-
Drop-down lists
- 0:55
- Viewed 1729 times
-
Advanced IF functions
- 3:22
- Viewed 1721 times
-
How things are organized
- 1:58
- Viewed 1718 times
-
Create a chart
- 0:52
- Viewed 1714 times
-
CONCAT
- 0:51
- Viewed 1703 times
-
Edit a macro
- 3:29
- Viewed 1700 times
-
Flash Fill
- 2:59
- Viewed 1687 times
-
Sort and filter data
- 1:38
- Viewed 1662 times
-
SWITCH
- 1:03
- Viewed 1654 times
-
Nested IF functions
- 3:30
- Viewed 1649 times
-
Microsoft Search
- 0:34
- Viewed 1632 times
-
Page numbers in depth
- 3:06
- Viewed 1614 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1588 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1576 times
-
Map Chart in Excel
- 0:31
- Viewed 1573 times
-
Funnel Chart
- 0:33
- Viewed 1430 times
-
Accessibility in Excel
- 1:12
- Viewed 1369 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1327 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1060 times
-
Change chart type
- 1:29
- Viewed 1054 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1031 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1007 times
-
Text before & after Function
- 4:57
- Viewed 981 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 968 times
-
Create dynamic drop down lists
- 3:26
- Viewed 963 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 882 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 715 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 94 times
-
Format Data with Copilot
- 1:52
- Viewed 89 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 87 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 86 times
-
Creating a Report
- 2:54
- Viewed 4641 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2063 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2050 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2037 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 2027 times
-
Recovering your Data from different sources
- 3:26
- Viewed 1984 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 1839 times
-
Introduction to the Query Editor
- 2:33
- Viewed 1828 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 1808 times
-
Creating your Datasets
- 2:26
- Viewed 1790 times
-
Customising your Visuals
- 2:58
- Viewed 1714 times
-
Improved version history
- 0:51
- Viewed 1675 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 1658 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 1637 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 1584 times
-
Customising your Report
- 3:12
- Viewed 1568 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1031 times
-
Manage life cycle of a topic
- 1:44
- Viewed 1029 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1007 times
-
Check and share your form results
- 2:42
- Viewed 986 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 882 times
-
Manage video settings
- 1:27
- Viewed 829 times
-
Optimize Meetings with Viva Insights
- 1:58
- Viewed 773 times
-
Analyze your network and communication habits
- 2:17
- Viewed 678 times
-
Receiving a briefing email from Viva Insights
- 0:54
- Viewed 673 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 94 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 91 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 89 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 88 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 85 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 83 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 80 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 78 times
-
Creating a Form with Copilot
- 1:57
- Viewed 87 times
-
What can Copilot do for you ?
- 2:37
- Viewed 90 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 87 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 94 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 86 times
-
Format Data with Copilot
- 1:52
- Viewed 89 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 87 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 90 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 112 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 113 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 93 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 92 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 80 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 83 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 88 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 131 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 83 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 85 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 82 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 91 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 86 times
-
Draft an Email with Copilot
- 2:35
- Viewed 98 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 89 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 78 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 94 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 88 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 81 times
-
How to Access Copilot
- 1:32
- Viewed 117 times
-
Manage priority people
- 0:24
- Viewed 118 times
-
Finding Help?
- 0:56
- Viewed 321 times
-
Chancing Your Status
- 0:40
- Viewed 344 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 307 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 339 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 298 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 480 times
-
File Management
- 1:04
- Viewed 319 times
-
Managing Teams and Channels
- 2:15
- Viewed 313 times
-
Posting in a Channel
- 2:15
- Viewed 345 times
-
Creating a Channel
- 2:05
- Viewed 293 times
-
Creating or Joining a Team
- 1:11
- Viewed 467 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 313 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 461 times
-
Starting a Conversation
- 0:53
- Viewed 323 times
-
Searching for Items or People
- 0:30
- Viewed 290 times
-
Interface Overview
- 1:10
- Viewed 349 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 333 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 331 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 318 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 432 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1099 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 376 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 352 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 345 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 507 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 407 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 522 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 406 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 337 times
-
Change application settings
- 2:53
- Viewed 335 times
-
Manage accessibility settings
- 1:33
- Viewed 503 times
-
Manage privacy settings
- 1:00
- Viewed 347 times
-
Set up and customize your teams
- 2:02
- Viewed 305 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 338 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 321 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 338 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 378 times
-
Generate a presence report
- 1:23
- Viewed 310 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 313 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 326 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 490 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 357 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 334 times
-
Following your activities and your team's activities
- 1:26
- Viewed 312 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 318 times
-
Manage team files
- 1:28
- Viewed 335 times
-
Invite external guests
- 1:19
- Viewed 348 times
-
Create private and shared channels
- 1:52
- Viewed 480 times
-
Manage your teams
- 2:38
- Viewed 367 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 482 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 319 times
-
Store files in conversations
- 1:38
- Viewed 301 times
-
Isolate a conversation window
- 0:50
- Viewed 331 times
-
Use and co-edit files
- 2:06
- Viewed 345 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 395 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 614 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 621 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 459 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 576 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 331 times
-
AI and Automated Assessment
- 4:55
- Viewed 428 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 469 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 628 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 422 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 424 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 356 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 339 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 413 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 433 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 606 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 459 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 434 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 398 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 463 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 410 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 386 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 480 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 400 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 472 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 437 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 480 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 480 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 506 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 507 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 437 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 464 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 551 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 475 times
-
History of Generative AI
- 5:27
- Viewed 492 times
-
What is Generative AI ?
- 2:40
- Viewed 547 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 303 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 483 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 219 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 386 times
-
Search and tag people with “@”
- 2:15
- Viewed 285 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 319 times
-
Creating your new workspace
- 1:24
- Viewed 458 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 316 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 367 times
-
View events
- 2:21
- Viewed 471 times
-
Take notes in meetings
- 0:35
- Viewed 422 times
-
Manage a meeting
- 2:08
- Viewed 416 times
-
Start an instant meeting
- 1:33
- Viewed 475 times
-
Join a meeting as a participant
- 2:13
- Viewed 677 times
-
Automatically record a meeting
- 1:12
- Viewed 477 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 450 times
-
Share content in meetings
- 2:44
- Viewed 398 times
-
Use a background image during a video call
- 1:19
- Viewed 380 times
-
Schedule private or team meetings
- 2:17
- Viewed 505 times
-
Synchronize only one channel
- 0:56
- Viewed 529 times
-
Pin a channel to your favorites
- 1:04
- Viewed 484 times
-
Add channels and tabs
- 1:40
- Viewed 498 times
-
Interact in a conversation
- 2:03
- Viewed 358 times
-
Edit and enhance messages
- 1:57
- Viewed 670 times
-
Create a team using a template
- 1:03
- Viewed 618 times
-
Create a team and add members
- 1:37
- Viewed 564 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 621 times
-
Interact in conversations
- 1:30
- Viewed 489 times
-
Private and small group chats
- 2:03
- Viewed 428 times
-
Overview of conversations
- 1:02
- Viewed 489 times
-
Define your status message
- 2:13
- Viewed 725 times
-
Customize notifications
- 2:05
- Viewed 521 times
-
Edit photo in Teams
- 0:42
- Viewed 392 times
-
Find content and people
- 0:59
- Viewed 483 times
-
Presentation of the desktop application
- 2:16
- Viewed 395 times
-
Introduction to Teams
- 1:25
- Viewed 383 times
RELATED COURSES This tutorial 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
- 717 Views