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
- 2683 views
-
Office Online - PivotTable Insertions
- 0:43
- Viewed 2683 times
-
Word - Locate your documents
- 0:20
- Viewed 3271 times
-
Teams - Inviting Other People to an Ongoing Call
- 0:45
- Viewed 2474 times
-
Teams - Transferring a Call
- 1:50
- Viewed 2534 times
-
PowerPoint - On-Slide 3D Model Animation
- 0:45
- Viewed 3544 times
-
Excel - Chat with your co-editors in real-time
- 0:28
- Viewed 3876 times
-
Excel - Work simultaneously with others on a workbook
- 0:43
- Viewed 3203 times
-
Teams - Receiving Phone Calls on the Mobile Application
- 1:10
- Viewed 2402 times
-
Access your Office Online App
- 0:43
- Viewed 3290 times
-
Office 365 overview
- 2:27
- Viewed 3206 times
-
Office Online Apps
- 1:27
- Viewed 3203 times
-
Check your day planning
- 0:30
- Viewed 3026 times
-
Manage your profile privacy settings
- 1:01
- Viewed 2997 times
-
Discover Excel Online
- 2:34
- Viewed 2976 times
-
Presentation of the interface of your profile
- 1:41
- Viewed 2927 times
-
Change your profile picture
- 1:09
- Viewed 2886 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2869 times
-
Discover PowerPoint Online
- 2:35
- Viewed 2811 times
-
Discover Word Online
- 2:34
- Viewed 2741 times
-
Access to your recent documents
- 1:14
- Viewed 2705 times
-
Manage our recent documents
- 2:24
- Viewed 2652 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2625 times
-
Run a search in Office365 Portal
- 1:09
- Viewed 2589 times
-
Change the theme of your Office portal
- 0:33
- Viewed 2566 times
-
Install Office on your smartphone
- 1:02
- Viewed 2443 times
-
Manage language and time zone
- 0:52
- Viewed 2319 times
-
Overall view of your licences and subscription
- 0:46
- Viewed 2266 times
-
Install Office on 5 devices
- 1:53
- Viewed 2223 times
-
Change your password
- 0:36
- Viewed 2038 times
-
Morph transition
- 0:43
- Viewed 7771 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4554 times
-
Instant captions & subtitles in Powerpoint
- 0:43
- Viewed 3892 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3876 times
-
Automatically mark deleted emails as read
- 0:46
- Viewed 3866 times
-
Design ideas with Powerpoint
- 0:37
- Viewed 3773 times
-
TEXTJOIN
- 0:47
- Viewed 3735 times
-
IFS
- 1:05
- Viewed 3657 times
-
Let Outlook read your emails out loud
- 0:32
- Viewed 3647 times
-
Map Chart in Excel
- 0:31
- Viewed 3638 times
-
On-Slide 3D Model Animation
- 0:45
- Viewed 3544 times
-
CONCAT
- 0:51
- Viewed 3508 times
-
Discover the new simplified ribbon
- 0:29
- Viewed 3467 times
-
Insert icons
- 0:43
- Viewed 3434 times
-
SWITCH
- 1:03
- Viewed 3398 times
-
How to search a file in all channels
- 0:29
- Viewed 3370 times
-
Prevent forwarding of a meeting
- 0:29
- Viewed 3342 times
-
Quickly sort emails
- 0:27
- Viewed 3330 times
-
Display 3 time zones
- 0:37
- Viewed 3316 times
-
Make your presentation lively with the Zoom function
- 0:41
- Viewed 3290 times
-
Microsoft Search
- 0:34
- Viewed 3273 times
-
Locate your documents
- 0:20
- Viewed 3271 times
-
Prevent recipients from forwarding emails
- 0:34
- Viewed 3266 times
-
Reusing slides
- 0:37
- Viewed 3246 times
-
Identify meeting members
- 0:26
- Viewed 3241 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3234 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3203 times
-
How to set quiet hours
- 0:32
- Viewed 3196 times
-
Use dictate to type in Word
- 0:27
- Viewed 3162 times
-
Custom your personal reminders and notifications
- 0:44
- Viewed 3140 times
-
3D Models
- 0:42
- Viewed 3060 times
-
Funnel Chart
- 0:33
- Viewed 3059 times
-
Translate your Word documents into any language
- 0:33
- Viewed 3032 times
-
Icon insertion
- 0:54
- Viewed 3017 times
-
Let Word read your documents out loud
- 0:36
- Viewed 2951 times
-
Edit document with natural gestures
- 0:34
- Viewed 2931 times
-
Embed fonts in presentations
- 0:40
- Viewed 2854 times
-
New tab "Recording"
- 0:43
- Viewed 2724 times
-
Removing the background of a picture
- 0:41
- Viewed 2675 times
-
Chat with co-authors while editing
- 0:29
- Viewed 2626 times
-
Make screenshots easier
- 3:59
- Viewed 2545 times
-
Configure multiple virtual desktops
- 1:35
- Viewed 2524 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2314 times
-
Work on multiple windows
- 1:21
- Viewed 2276 times
-
Is a hacker always a cybercriminal?
- 01:31
- Viewed 11 times
-
Will I know what to do if I get hacked?
- 01:16
- Viewed 7 times
-
Do I have to be an IT expert to protect myself?
- 01:14
- Viewed 11 times
-
Do cybercriminals only target large companies?
- 01:21
- Viewed 8 times
-
Are all files safe as long as I open them with trusted software?
- 01:24
- Viewed 10 times
-
Is contactless payment safe ?
- 01:26
- Viewed 19 times
-
Are online payments riskier than in-store ones?
- 01:21
- Viewed 10 times
-
Is cloud storage less secure than my personal computer?
- 01:37
- Viewed 9 times
-
Is scanning a QR code always safe?
- 01:21
- Viewed 8 times
-
Can my mobile apps do anything without my permission?
- 01:19
- Viewed 9 times
-
Is public Wi-Fi safe if no password is required?
- 01:26
- Viewed 8 times
-
Is the sender’s email address enough to verify a message?
- 01:29
- Viewed 9 times
-
Can I safely click a link in a message?
- 01:46
- Viewed 9 times
-
Does connecting to a well-known website guarantee its safety?
- 01:27
- Viewed 10 times
-
Am I safe online if I’m careful?
- 01:22
- Viewed 10 times
-
Does private browsing make me anonymous?
- 01:27
- Viewed 10 times
-
Are updates useless if everything works fine?
- 01:28
- Viewed 7 times
-
Is a firewall the same as an antivirus?
- 01:31
- Viewed 9 times
-
Does my antivirus block all threats?
- 01:46
- Viewed 8 times
-
Is a free antivirus good enough?
- 01:38
- Viewed 11 times
-
Is signing in with Google or Facebook a bad idea ?
- 01:34
- Viewed 7 times
-
Is my password secure if it contains an @ and a number?
- 01:41
- Viewed 11 times
-
Is a strong password all I need to stay safe?
- 01:55
- Viewed 11 times
-
Unlock new possibilities with the Mistral Canvas
- 02:01
- Viewed 14 times
-
Mistral at the service of coding
- 01:37
- Viewed 13 times
-
Analyze and compare your documents with Mistral
- 01:58
- Viewed 11 times
-
Generate your images and visuals with Mistral AI
- 02:06
- Viewed 12 times
-
Use Mistral AI to summarize online information
- 01:00
- Viewed 12 times
-
Exchange and manage your conversations with Mistral AI
- 03:31
- Viewed 12 times
-
Explore Mistral AI's generative options
- 01:51
- Viewed 12 times
-
Set up your Mistral workspace
- 01:42
- Viewed 10 times
-
Discover Mistral, the French-style AI
- 01:51
- Viewed 12 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 29 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 25 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 26 times
-
Relevant views to highlight your information
- 01:52
- Viewed 33 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 24 times
-
A well-structured form for easy entry
- 01:17
- Viewed 31 times
-
The right column type for each data set
- 02:35
- Viewed 27 times
-
Custom columns to match your needs
- 02:09
- Viewed 24 times
-
Smooth updates and management for any list
- 01:06
- Viewed 27 times
-
Simple ways to add data to your list
- 01:06
- Viewed 27 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 27 times
-
A fully custom list built from scratch
- 01:34
- Viewed 28 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 33 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 36 times
-
The essentials of the Lists interface
- 02:01
- Viewed 29 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 30 times
-
Personality and tone for a believable rendering
- 01:48
- Viewed 66 times
-
Format and example for optimal results
- 02:03
- Viewed 68 times
-
The Importance of Context in Your Applications
- 02:14
- Viewed 59 times
-
Task Accuracy in Prompting
- 02:31
- Viewed 126 times
-
The Basis of Prompting in Conversational AI
- 02:41
- Viewed 55 times
-
What is a prompt in conversational AI?
- 02:02
- Viewed 69 times
-
Extract Text from an Image
- 01:07
- Viewed 83 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 140 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 155 times
-
Query an Attached Meeting
- 01:51
- Viewed 65 times
-
Plan with Copilot
- 01:15
- Viewed 98 times
-
Share Requests with Your Team
- 03:07
- Viewed 145 times
-
Translate a presentation
- 01:38
- Viewed 76 times
-
Generate a Video
- 01:49
- Viewed 81 times
-
Add Speaker Notes
- 00:56
- Viewed 83 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 149 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 137 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 157 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 199 times
-
Copilot at the service of project reports
- 02:36
- Viewed 165 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 171 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 304 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 169 times
-
Project mode
- 01:31
- Viewed 163 times
-
Create an agent for a team
- 01:53
- Viewed 279 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 277 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 131 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 282 times
-
Copilot Studio agent settings
- 01:33
- Viewed 122 times
-
Add new actions
- 01:54
- Viewed 279 times
-
Create a first action
- 01:59
- Viewed 267 times
-
Manage topics
- 01:51
- Viewed 154 times
-
Manage knowledge sources
- 01:11
- Viewed 118 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 270 times
-
Access Copilot Studio
- 01:09
- Viewed 265 times
-
Get started with Copilot Studio
- 01:25
- Viewed 131 times
-
Introduction to PowerBI
- 00:60
- Viewed 294 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 281 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 272 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 305 times
-
Introduction to Planner
- 00:56
- Viewed 283 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 422 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 290 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 428 times
-
Introduction to Sway
- 01:53
- Viewed 367 times
-
Introducing to Word
- 01:00
- Viewed 269 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 261 times
-
Create a call group
- 01:15
- Viewed 459 times
-
Use call delegation
- 01:07
- Viewed 225 times
-
Assign a delegate for your calls
- 01:08
- Viewed 426 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 230 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 229 times
-
Manage advanced call notifications
- 01:29
- Viewed 241 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 380 times
-
Block unwanted calls
- 01:24
- Viewed 275 times
-
Disable all call forwarding
- 01:09
- Viewed 255 times
-
Manage a call group in Teams
- 02:01
- Viewed 273 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 224 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 230 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 247 times
-
Manage voicemail messages
- 01:55
- Viewed 382 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 420 times
-
Customize your voicemail greeting
- 02:17
- Viewed 224 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 291 times
-
Manage simultaneous calls
- 01:52
- Viewed 257 times
-
Support third-party apps during calls
- 01:53
- Viewed 376 times
-
Add participants quickly and securely
- 01:37
- Viewed 242 times
-
Configure call privacy and security settings
- 02:51
- Viewed 240 times
-
Manage calls on hold
- 01:20
- Viewed 236 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 245 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 234 times
-
Draft a Service Memo
- 02:33
- Viewed 279 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 270 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 437 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 409 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 141 times
-
Other Coaches
- 01:45
- Viewed 293 times
-
Agents in SharePoint
- 02:44
- Viewed 233 times
-
Prompt coach
- 02:49
- Viewed 261 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 247 times
-
Configure a Copilot Agent
- 02:39
- Viewed 258 times
-
Describe a copilot agent
- 01:32
- Viewed 292 times
-
Rewrite with Copilot
- 01:21
- Viewed 245 times
-
Analyze a video
- 01:21
- Viewed 269 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 251 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 257 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 277 times
-
Create an image with Copilot
- 00:42
- Viewed 473 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 267 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 272 times
-
Chat with Copilot
- 00:50
- Viewed 282 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 453 times
-
Data Privacy in Copilot
- 00:43
- Viewed 276 times
-
Access Copilot
- 00:25
- Viewed 488 times
-
Use a Copilot Agent
- 01:24
- Viewed 312 times
-
Edit in Pages
- 01:49
- Viewed 319 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 292 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 278 times
-
Generate the email for the recipient
- 00:44
- Viewed 268 times
-
Action Function
- 04:18
- Viewed 240 times
-
Search Function
- 03:42
- Viewed 281 times
-
Date and Time Function
- 02:53
- Viewed 302 times
-
Logical Function
- 03:14
- Viewed 463 times
-
Text Function
- 03:25
- Viewed 294 times
-
Basic Function
- 02:35
- Viewed 251 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 292 times
-
Introduction to Power Fx
- 01:09
- Viewed 297 times
-
The New Calendar
- 03:14
- Viewed 501 times
-
Sections
- 02:34
- Viewed 263 times
-
Customizing Views
- 03:25
- Viewed 257 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 562 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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise