Office Online - PivotTable Insertions Video
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
- 2394 views
-
Office Online - PivotTable Insertions
- 0:43
- Viewed 2394 times
-
Word - Locate your documents
- 0:20
- Viewed 2993 times
-
Teams - Inviting Other People to an Ongoing Call
- 0:45
- Viewed 2460 times
-
Teams - Transferring a Call
- 1:50
- Viewed 2517 times
-
PowerPoint - On-Slide 3D Model Animation
- 0:45
- Viewed 3203 times
-
Excel - Chat with your co-editors in real-time
- 0:28
- Viewed 3588 times
-
Excel - Work simultaneously with others on a workbook
- 0:43
- Viewed 2912 times
-
Teams - Receiving Phone Calls on the Mobile Application
- 1:10
- Viewed 2388 times
-
Office 365 overview
- 2:27
- Viewed 2901 times
-
Office Online Apps
- 1:27
- Viewed 2888 times
-
Access your Office Online App
- 0:43
- Viewed 2879 times
-
Discover Excel Online
- 2:34
- Viewed 2689 times
-
Check your day planning
- 0:30
- Viewed 2677 times
-
Discover PowerPoint Online
- 2:35
- Viewed 2588 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2574 times
-
Manage your profile privacy settings
- 1:01
- Viewed 2558 times
-
Presentation of the interface of your profile
- 1:41
- Viewed 2515 times
-
Discover Word Online
- 2:34
- Viewed 2492 times
-
Access to your recent documents
- 1:14
- Viewed 2468 times
-
Manage our recent documents
- 2:24
- Viewed 2424 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2388 times
-
Run a search in Office365 Portal
- 1:09
- Viewed 2359 times
-
Change the theme of your Office portal
- 0:33
- Viewed 2352 times
-
Change your profile picture
- 1:09
- Viewed 2297 times
-
Install Office on your smartphone
- 1:02
- Viewed 2195 times
-
Manage language and time zone
- 0:52
- Viewed 2098 times
-
Overall view of your licences and subscription
- 0:46
- Viewed 2042 times
-
Install Office on 5 devices
- 1:53
- Viewed 2013 times
-
Change your password
- 0:36
- Viewed 1845 times
-
Morph transition
- 0:43
- Viewed 6687 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4001 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3613 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3588 times
-
TEXTJOIN
- 0:47
- Viewed 3395 times
-
IFS
- 1:05
- Viewed 3368 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3366 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3333 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3307 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3203 times
-
Map Chart in Excel
- 0:31
- Viewed 3191 times
-
CONCAT
- 0:51
- Viewed 3147 times
-
SWITCH
- 1:03
- Viewed 3118 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3096 times
-
How to search a file in all channels
- 0:29
- Viewed 3071 times
-
Display 3 time zones
- 0:37
- Viewed 3021 times
-
Quickly sort emails
- 0:27
- Viewed 3001 times
-
Locate your documents
- 0:20
- Viewed 2993 times
-
Reusing slides
- 0:37
- Viewed 2984 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2981 times
-
Insert icons
- 0:43
- Viewed 2969 times
-
Microsoft Search
- 0:34
- Viewed 2952 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 2930 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2912 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 2897 times
-
Identify meeting members
- 0:26
- Viewed 2890 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 2834 times
-
3D Models
- 0:42
- Viewed 2802 times
-
Use dictate to type in Word
- 0:27
- Viewed 2790 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 2772 times
-
Icon insertion
- 0:54
- Viewed 2772 times
-
How to set quiet hours
- 0:32
- Viewed 2764 times
-
Funnel Chart
- 0:33
- Viewed 2742 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2687 times
-
Translate your Word documents into any language
- 0:33
- Viewed 2666 times
-
Edit document with natural gestures
- 0:34
- Viewed 2659 times
-
Embed fonts in presentations
- 0:40
- Viewed 2602 times
-
New tab "Recording"
- 0:43
- Viewed 2477 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2365 times
-
Removing the background of a picture
- 0:41
- Viewed 2352 times
-
Make screenshots easier
- 3:59
- Viewed 2241 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2201 times
-
Work on multiple windows
- 1:21
- Viewed 2065 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1854 times
-
Action Function
- 04:18
- Viewed 46 times
-
Search Function
- 03:42
- Viewed 65 times
-
Date and Time Function
- 02:53
- Viewed 56 times
-
Logical Function
- 03:14
- Viewed 86 times
-
Text Function
- 03:25
- Viewed 71 times
-
Basic Function
- 02:35
- Viewed 47 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 69 times
-
Introduction to Power Fx
- 01:09
- Viewed 48 times
-
The New Calendar
- 03:14
- Viewed 97 times
-
Sections
- 02:34
- Viewed 57 times
-
Customizing Views
- 03:25
- Viewed 48 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 101 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 65 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 56 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 71 times
-
Retrieve Data from a Web Page and Include it in Excel
- 04:35
- Viewed 233 times
-
Create a Desktop Flow with Power Automate from a Template
- 03:12
- Viewed 169 times
-
Understand the Specifics and Requirements of Desktop Flows
- 02:44
- Viewed 93 times
-
Dropbox: Create a SAS Exchange Between SharePoint and Another Storage Service
- 03:34
- Viewed 178 times
-
Excel: List Files from a Channel in an Excel Workbook with Power Automate
- 04:51
- Viewed 107 times
-
Excel: Link Excel Scripts and Power Automate Flows
- 03:22
- Viewed 102 times
-
SharePoint: Link Microsoft Forms and Lists in a Power Automate Flow
- 04:43
- Viewed 250 times
-
SharePoint: Automate File Movement to an Archive Library
- 05:20
- Viewed 88 times
-
Share Power Automate Flows
- 02:20
- Viewed 75 times
-
Manipulate Dynamic Content with Power FX
- 03:59
- Viewed 93 times
-
Leverage Variables with Power FX in Power Automate
- 03:28
- Viewed 77 times
-
Understand the Concept of Variables and Loops in Power Automate
- 03:55
- Viewed 86 times
-
Add Conditional “Switch” Actions in Power Automate
- 03:58
- Viewed 114 times
-
Add Conditional “IF” Actions in Power Automate
- 03:06
- Viewed 76 times
-
Create an Approval Flow with Power Automate
- 03:10
- Viewed 183 times
-
Create a Scheduled Flow with Power Automate
- 01:29
- Viewed 345 times
-
Create an Instant Flow with Power Automate
- 02:18
- Viewed 162 times
-
Create an Automated Flow with Power Automate
- 03:28
- Viewed 156 times
-
Create a Simple Flow with AI Copilot
- 04:31
- Viewed 131 times
-
Create a Flow Based on a Template with Power Automate
- 03:20
- Viewed 99 times
-
Discover the “Build Space”
- 02:26
- Viewed 77 times
-
The Power Automate Mobile App
- 01:39
- Viewed 78 times
-
Familiarize Yourself with the Different Types of Flows
- 01:37
- Viewed 85 times
-
Understand the Steps to Create a Power Automate Flow
- 01:51
- Viewed 105 times
-
Discover the Power Automate Home Interface
- 02:51
- Viewed 79 times
-
Access Power Automate for the Web
- 01:25
- Viewed 115 times
-
Understand the Benefits of Power Automate
- 01:30
- Viewed 99 times
-
Add a third-party application
- 02:40
- Viewed 122 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 131 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 114 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 111 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 84 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 147 times
-
Share a document securely with Outlook
- 02:21
- Viewed 93 times
-
Block a sender
- 01:54
- Viewed 136 times
-
Identify a fraudulent email
- 02:06
- Viewed 85 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 94 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 106 times
-
Protect an email by encrypting
- 01:10
- Viewed 94 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 74 times
-
Recover deleted items
- 01:09
- Viewed 188 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 110 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 79 times
-
Use a Shared Mailbox
- 01:18
- Viewed 123 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 91 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 121 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 89 times
-
Calendar Delegation Setup
- 01:21
- Viewed 111 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 175 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 183 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 123 times
-
Create a Meeting Poll
- 02:48
- Viewed 132 times
-
Display Three Time Zones
- 01:52
- Viewed 91 times
-
View Other Calendars
- 00:50
- Viewed 101 times
-
Open a Shared Calendar
- 01:29
- Viewed 104 times
-
Share Your Calendar
- 01:54
- Viewed 112 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 103 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 98 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 104 times
-
Translate Emails in Outlook
- 01:32
- Viewed 101 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 92 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 127 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 94 times
-
Improve Email Accessibility
- 02:02
- Viewed 96 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 103 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 109 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 72 times
-
Delay Email Delivery
- 01:10
- Viewed 106 times
-
Use Conversation View
- 01:47
- Viewed 101 times
-
Clean Up Your Inbox
- 01:18
- Viewed 107 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 377 times
-
Use Categories
- 02:51
- Viewed 89 times
-
Easily Sort Your Mails
- 01:38
- Viewed 81 times
-
Automate Routine Actions
- 02:19
- Viewed 96 times
-
Create an Email Template
- 01:40
- Viewed 122 times
-
Create a task from a message
- 02:00
- Viewed 144 times
-
Share a task list
- 03:10
- Viewed 148 times
-
Create a task or reminder
- 01:50
- Viewed 160 times
-
Task Module Overview
- 01:56
- Viewed 251 times
-
Manage Teams online meeting options
- 01:56
- Viewed 149 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 268 times
-
Create a reminder for yourself
- 01:59
- Viewed 167 times
-
Respond to a meeting
- 01:00
- Viewed 149 times
-
Create an appointment or meeting
- 01:44
- Viewed 163 times
-
Create different types of events
- 01:46
- Viewed 172 times
-
Edit and customize views
- 01:55
- Viewed 168 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 181 times
-
Search options
- 01:23
- Viewed 140 times
-
Sort and filter emails
- 02:51
- Viewed 163 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 242 times
-
The Bcc Field in Detail
- 01:53
- Viewed 161 times
-
Save and Print a Message
- 01:48
- Viewed 175 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 221 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 162 times
-
Process an incoming message
- 01:53
- Viewed 150 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 204 times
-
Organize into Folders
- 01:57
- Viewed 167 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 178 times
-
Create and add a signature to messages
- 01:26
- Viewed 160 times
-
Manage new message notifications
- 01:40
- Viewed 152 times
-
Change the default font of your emails
- 01:05
- Viewed 150 times
-
Manage Views
- 02:36
- Viewed 135 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 201 times
-
Explore the Interface
- 03:22
- Viewed 152 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 154 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.