Office Online - PivotTable Insertions Tutorial
In this video, you will learn about PivotTable insertions.
The video covers how to start from an unformatted table and use the Insertion tab to select the data you want to filter.
It also demonstrates how to use filters to easily find your data.
This tutorial will help you understand and utilize PivotTable insertions effectively in Microsoft 365.
- 0:43
- 2282 views
-
Office Online - PivotTable Insertions
- 0:43
- Viewed 2282 times
-
Word - Locate your documents
- 0:20
- Viewed 2862 times
-
Teams - Inviting Other People to an Ongoing Call
- 0:45
- Viewed 2321 times
-
Teams - Transferring a Call
- 1:50
- Viewed 2387 times
-
PowerPoint - On-Slide 3D Model Animation
- 0:45
- Viewed 3077 times
-
Excel - Chat with your co-editors in real-time
- 0:28
- Viewed 3457 times
-
Excel - Work simultaneously with others on a workbook
- 0:43
- Viewed 2771 times
-
Teams - Receiving Phone Calls on the Mobile Application
- 1:10
- Viewed 2277 times
-
Office 365 overview
- 2:27
- Viewed 2775 times
-
Office Online Apps
- 1:27
- Viewed 2769 times
-
Access your Office Online App
- 0:43
- Viewed 2760 times
-
Check your day planning
- 0:30
- Viewed 2587 times
-
Discover Excel Online
- 2:34
- Viewed 2554 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2446 times
-
Discover PowerPoint Online
- 2:35
- Viewed 2443 times
-
Manage your profile privacy settings
- 1:01
- Viewed 2435 times
-
Presentation of the interface of your profile
- 1:41
- Viewed 2399 times
-
Access to your recent documents
- 1:14
- Viewed 2378 times
-
Discover Word Online
- 2:34
- Viewed 2373 times
-
Manage our recent documents
- 2:24
- Viewed 2312 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2274 times
-
Run a search in Office365 Portal
- 1:09
- Viewed 2273 times
-
Change the theme of your Office portal
- 0:33
- Viewed 2246 times
-
Change your profile picture
- 1:09
- Viewed 2174 times
-
Install Office on your smartphone
- 1:02
- Viewed 2099 times
-
Manage language and time zone
- 0:52
- Viewed 2003 times
-
Overall view of your licences and subscription
- 0:46
- Viewed 1975 times
-
Install Office on 5 devices
- 1:53
- Viewed 1917 times
-
Change your password
- 0:36
- Viewed 1748 times
-
Morph transition
- 0:43
- Viewed 5601 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3637 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3457 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3417 times
-
TEXTJOIN
- 0:47
- Viewed 3233 times
-
IFS
- 1:05
- Viewed 3226 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3188 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3186 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3163 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3077 times
-
CONCAT
- 0:51
- Viewed 3012 times
-
Map Chart in Excel
- 0:31
- Viewed 2999 times
-
SWITCH
- 1:03
- Viewed 2980 times
-
How to search a file in all channels
- 0:29
- Viewed 2958 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 2930 times
-
Display 3 time zones
- 0:37
- Viewed 2909 times
-
Locate your documents
- 0:20
- Viewed 2862 times
-
Reusing slides
- 0:37
- Viewed 2859 times
-
Quickly sort emails
- 0:27
- Viewed 2854 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2846 times
-
Microsoft Search
- 0:34
- Viewed 2838 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 2804 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2771 times
-
Insert icons
- 0:43
- Viewed 2764 times
-
Identify meeting members
- 0:26
- Viewed 2757 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 2723 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 2707 times
-
Use dictate to type in Word
- 0:27
- Viewed 2695 times
-
3D Models
- 0:42
- Viewed 2675 times
-
Icon insertion
- 0:54
- Viewed 2665 times
-
How to set quiet hours
- 0:32
- Viewed 2618 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2580 times
-
Edit document with natural gestures
- 0:34
- Viewed 2536 times
-
Funnel Chart
- 0:33
- Viewed 2529 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 2518 times
-
Translate your Word documents into any language
- 0:33
- Viewed 2512 times
-
Embed fonts in presentations
- 0:40
- Viewed 2500 times
-
New tab "Recording"
- 0:43
- Viewed 2365 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2253 times
-
Removing the background of a picture
- 0:41
- Viewed 2227 times
-
Make screenshots easier
- 3:59
- Viewed 2116 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2072 times
-
Work on multiple windows
- 1:21
- Viewed 1973 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1718 times
-
Use the narrative Builder
- 01:31
- Viewed 17 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 15 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 15 times
-
Share a document with copilot
- 00:36
- Viewed 13 times
-
Configurate a page with copilot
- 01:47
- Viewed 13 times
-
Use Copilot with Right-Click
- 00:58
- Viewed 14 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 24 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 28 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 32 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 47 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 50 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 54 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 58 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 27 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 64 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 36 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 38 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 79 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 30 times
-
Share Power Automate Flows
- 02:20
- Viewed 32 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 34 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 33 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 32 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 39 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 31 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 59 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 65 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 62 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 58 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 43 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 25 times
-
Discover the “Build Space”
- 02:26
- Viewed 30 times
-
The Power Automate Mobile App
- 01:39
- Viewed 26 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 31 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 30 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 32 times
-
Access Power Automate for the Web
- 01:25
- Viewed 31 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 35 times
-
Add a third-party application
- 02:40
- Viewed 55 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 41 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 45 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 42 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 37 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 49 times
-
Share a document securely with Outlook
- 02:21
- Viewed 44 times
-
Block a sender
- 01:54
- Viewed 60 times
-
Identify a fraudulent email
- 02:06
- Viewed 38 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 41 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 35 times
-
Protect an email by encrypting
- 01:10
- Viewed 33 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 32 times
-
Recover deleted items
- 01:09
- Viewed 82 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 47 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 36 times
-
Use a Shared Mailbox
- 01:18
- Viewed 55 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 44 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 51 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 36 times
-
Calendar Delegation Setup
- 01:21
- Viewed 53 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 88 times
-
Making changes to a text
- 00:38
- Viewed 37 times
-
Consult the adoption of Copilot through Viva Insights
- 00:52
- Viewed 51 times
-
Search from emails with Copilot
- 00:53
- Viewed 98 times
-
Using Copilot in OneNote with Right-Click
- 01:21
- Viewed 35 times
-
Organizing OneNote with Copilot
- 00:46
- Viewed 43 times
-
Tracking changes in a Loop page with Copilot
- 01:16
- Viewed 35 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 42 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 37 times
-
Send invitations or reminders with Copilot
- 00:53
- Viewed 52 times
-
Generate formulas from a concept
- 01:02
- Viewed 37 times
-
Analyzing a OneDrive file with Copilot
- 01:25
- Viewed 40 times
-
Analyzing multiple OneDrive documents with Copilot
- 01:01
- Viewed 48 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 56 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 52 times
-
Create a Meeting Poll
- 02:48
- Viewed 38 times
-
Display Three Time Zones
- 01:52
- Viewed 30 times
-
View Other Calendars
- 00:50
- Viewed 29 times
-
Open a Shared Calendar
- 01:29
- Viewed 41 times
-
Share Your Calendar
- 01:54
- Viewed 40 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 31 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 37 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 36 times
-
Translate Emails in Outlook
- 01:32
- Viewed 40 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 38 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 51 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 37 times
-
Improve Email Accessibility
- 02:02
- Viewed 40 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 36 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 39 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 32 times
-
Delay Email Delivery
- 01:10
- Viewed 44 times
-
Use Conversation View
- 01:47
- Viewed 39 times
-
Clean Up Your Inbox
- 01:18
- Viewed 50 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 105 times
-
Use Categories
- 02:51
- Viewed 36 times
-
Easily Sort Your Mails
- 01:38
- Viewed 40 times
-
Automate Routine Actions
- 02:19
- Viewed 43 times
-
Create an Email Template
- 01:40
- Viewed 46 times
-
Create a task from a message
- 02:00
- Viewed 87 times
-
Share a task list
- 03:10
- Viewed 89 times
-
Create a task or reminder
- 01:50
- Viewed 88 times
-
Task Module Overview
- 01:56
- Viewed 97 times
-
Manage Teams online meeting options
- 01:56
- Viewed 77 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 105 times
-
Create a reminder for yourself
- 01:59
- Viewed 86 times
-
Respond to a meeting
- 01:00
- Viewed 87 times
-
Create an appointment or meeting
- 01:44
- Viewed 95 times
-
Create different types of events
- 01:46
- Viewed 89 times
-
Edit and customize views
- 01:55
- Viewed 105 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 103 times
-
Search options
- 01:23
- Viewed 83 times
-
Sort and filter emails
- 02:51
- Viewed 92 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 122 times
-
The Bcc Field in Detail
- 01:53
- Viewed 91 times
-
Save and Print a Message
- 01:48
- Viewed 93 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 117 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 99 times
-
Process an incoming message
- 01:53
- Viewed 81 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 96 times
-
Organize into Folders
- 01:57
- Viewed 99 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 87 times
-
Create and add a signature to messages
- 01:26
- Viewed 93 times
-
Manage new message notifications
- 01:40
- Viewed 86 times
-
Change the default font of your emails
- 01:05
- Viewed 95 times
-
Manage Views
- 02:36
- Viewed 79 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 119 times
-
Explore the Interface
- 03:22
- Viewed 86 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 89 times
-
Survey Consumer Satisfaction Panel with ChatGPT
- 01:55
- Viewed 190 times
-
Enhance Your Product on Social Media with ChatGPT
- 02:13
- Viewed 199 times
-
Write a Product Description with ChatGPT
- 02:30
- Viewed 178 times
-
Structure Your Product Launch Project
- 01:51
- Viewed 199 times
-
Initiate a Market Research Study with ChatGPT
- 02:08
- Viewed 164 times
-
Manage Storage Space
- 02:08
- Viewed 206 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 191 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 197 times
-
Make a File Request
- 01:24
- Viewed 210 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 206 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 220 times
-
Modify Sharing Rules
- 00:53
- Viewed 214 times
-
Check Granted Shares
- 00:48
- Viewed 196 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 215 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 187 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 217 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 211 times
-
Search for Documents
- 01:31
- Viewed 184 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 218 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 208 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 198 times
-
Edit, Delete a Share
- 02:16
- Viewed 206 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 211 times
-
Power and Manage OneDrive
- 01:36
- Viewed 204 times
-
What is OneDrive ?
- 01:14
- Viewed 297 times
-
Personality and tone for a realistic rendering
- 01:18
- Viewed 277 times
-
Format and example for optimal results
- 01:50
- Viewed 292 times
-
The importance of context in your requests
- 01:44
- Viewed 294 times
-
Precise task in conversational AI
- 01:55
- Viewed 304 times
-
Basics of prompting with conversational AI
- 02:29
- Viewed 298 times
-
What is a prompt ?
- 01:14
- Viewed 295 times
-
Survey Consumer Satisfaction Panel
- 02:38
- Viewed 377 times
-
Promote Your Product on Social Networks with Copilot
- 02:41
- Viewed 330 times
-
Write a Product Description with Copilot
- 02:36
- Viewed 362 times
-
Structure Your Product Launch Project
- 02:15
- Viewed 362 times
-
Initiate a Market Study with Copilot
- 03:15
- Viewed 361 times
-
Create a Business Presentation Report with ChatGPT
- 02:00
- Viewed 435 times
-
Boost Your Proposal with ChatGPT
- 02:19
- Viewed 414 times
-
Generating an Executive Summary with ChatGPT
- 01:47
- Viewed 516 times
-
Writing a Business Proposal with ChatGPT
- 02:22
- Viewed 421 times
-
Analyzing a Specification Document with ChatGPT
- 02:15
- Viewed 404 times
-
Create a Business Presentation Report with Copilot
- 03:02
- Viewed 458 times
-
Boost Your Proposal with Copilot Coaching for Outlook
- 02:18
- Viewed 437 times
-
Generating an Executive Summary with Copilot
- 01:46
- Viewed 580 times
-
Writing a Business Proposal with Copilot
- 03:40
- Viewed 418 times
-
Analyzing a Specification Document with Copilot
- 02:59
- Viewed 461 times
Objectifs :
This video aims to teach viewers how to filter data in a table using the Insertion tab in a spreadsheet application. It provides step-by-step instructions to simplify data management and enhance productivity.
Chapitres :
-
Introduction to Data Filtering
In this section, we will explore the importance of data filtering in managing large datasets. Filtering allows users to focus on specific information, making it easier to analyze and draw conclusions. -
Starting with an Unformatted Table
Begin by creating or selecting an unformatted table in your spreadsheet application. An unformatted table is simply a collection of data organized in rows and columns without any specific styling or formatting applied. -
Accessing the Insertion Tab
To filter your data, first navigate to the Insertion tab located in the toolbar at the top of the application. This tab contains various tools and options for managing your data effectively. -
Selecting Data for Filtering
Once you are in the Insertion tab, select the range of data you wish to filter. This can be done by clicking and dragging your mouse over the desired cells. Ensure that you include all relevant columns and rows to get accurate filtering results. -
Applying Filters
After selecting your data, look for the Filters option within the Insertion tab. Click on it to enable filtering for your selected data range. This will add filter dropdowns to the headers of your columns, allowing you to easily find and sort your data. -
Using Filters to Find Data
With filters applied, you can now click on the dropdown arrows in the column headers to specify criteria for filtering. For example, you can filter by specific values, ranges, or even conditions such as 'greater than' or 'less than'. This feature simplifies the process of locating specific data points within your table. -
Conclusion
In summary, filtering data in a table is a powerful tool that enhances your ability to manage and analyze information. By following the steps outlined in this video, you can efficiently filter your data, making it easier to focus on what matters most.
FAQ :
What is the purpose of the Insertion tab?
The Insertion tab allows users to add various elements to their documents, such as tables, charts, and images, enhancing the visual representation of data.
How do I use filters in a spreadsheet?
To use filters, select the data you want to filter, go to the Insertion tab, and apply the filter option. This will allow you to view only the data that meets your specified criteria.
Can I filter multiple criteria at once?
Yes, most spreadsheet applications allow you to apply multiple filters simultaneously, enabling you to narrow down your data based on various conditions.
What types of data can I filter?
You can filter various types of data, including numerical values, text entries, dates, and more, depending on the capabilities of the software you are using.
Quelques cas d'usages :
Data Analysis in Business
Businesses can use filters to analyze sales data by region, product type, or time period, allowing them to make informed decisions based on specific trends.
Academic Research
Researchers can filter large datasets to focus on specific variables or results, streamlining their analysis and improving the efficiency of their research process.
Project Management
Project managers can filter task lists to view only overdue tasks or tasks assigned to specific team members, helping them prioritize and manage workloads effectively.
Glossaire :
Insertion tab
A section in software applications, particularly in spreadsheet programs like Microsoft Excel, where users can add various elements such as tables, charts, and images to their documents.
Filters
Tools used in data management applications that allow users to display only the data that meets certain criteria, making it easier to analyze and find specific information.
Data
Information that is collected and stored for analysis, which can include numbers, text, or other types of information.