Excel - Flash Fill Video
In this video, you will learn about Flash Fill, a feature in Microsoft 365 that automatically fills in and formats data.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.
- 2:59
- 1819 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3308 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3060 times
-
3D Maps
- 1:41
- Viewed 2679 times
-
Manage conditional formatting
- 4:30
- Viewed 2656 times
-
Create a combo chart
- 1:47
- Viewed 2541 times
-
The SUMIF function
- 5:27
- Viewed 2536 times
-
Functions and formulas
- 3:24
- Viewed 2443 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2426 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2416 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2402 times
-
The SUM function
- 4:37
- Viewed 2391 times
-
More complex formulas
- 4:17
- Viewed 2379 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2376 times
-
Using functions
- 5:12
- Viewed 2375 times
-
Manage drop-down lists
- 6:12
- Viewed 2363 times
-
Advanced formulas and references
- 4:06
- Viewed 2354 times
-
More print options
- 5:59
- Viewed 2352 times
-
Introduction to Excel
- 0:59
- Viewed 2347 times
-
New Chart types
- 1:52
- Viewed 2331 times
-
Customize charts
- 4:28
- Viewed 2329 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2275 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2273 times
-
Start using Excel
- 4:22
- Viewed 2267 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2262 times
-
Freeze panes in detail
- 3:30
- Viewed 2257 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2248 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2247 times
-
AutoFilter details
- 3:27
- Viewed 2242 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2239 times
-
AutoFill
- 2:55
- Viewed 2233 times
-
Drop-down list settings
- 4:14
- Viewed 2232 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2224 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2220 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2219 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2207 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2207 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2196 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2190 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2183 times
-
Header and footer details
- 3:41
- Viewed 2170 times
-
Add numbers
- 2:54
- Viewed 2167 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2163 times
-
Sort details
- 4:46
- Viewed 2154 times
-
Operator order
- 2:04
- Viewed 2153 times
-
A first look at Excel 2016
- 3:22
- Viewed 2152 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 2152 times
-
IF with AND and OR
- 3:35
- Viewed 2149 times
-
Assign a button to a macro
- 2:49
- Viewed 2137 times
-
A closer look at the ribbon
- 3:55
- Viewed 2136 times
-
Work with macros
- 4:40
- Viewed 2127 times
-
Insert headers and footers
- 2:02
- Viewed 2118 times
-
Advanced filter details
- 4:13
- Viewed 2117 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 2117 times
-
Print worksheets and workbooks
- 1:07
- Viewed 2115 times
-
Insert columns and rows
- 4:16
- Viewed 2114 times
-
Basic math
- 2:28
- Viewed 2113 times
-
One click Forecasting
- 1:01
- Viewed 2111 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 2110 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 2107 times
-
Use conditional formatting
- 2:02
- Viewed 2106 times
-
Ink Equation
- 0:41
- Viewed 2090 times
-
AVERAGEIF function
- 3:04
- Viewed 2085 times
-
Save your macro
- 2:59
- Viewed 2079 times
-
Improved version history
- 0:51
- Viewed 2057 times
-
Input and error messages
- 2:52
- Viewed 2057 times
-
Copy a chart
- 2:59
- Viewed 2051 times
-
Subtract time
- 3:58
- Viewed 2051 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2029 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2028 times
-
Cell references
- 1:34
- Viewed 2027 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2017 times
-
IFS
- 1:05
- Viewed 1998 times
-
Conditionally format dates
- 2:38
- Viewed 1994 times
-
TEXTJOIN
- 0:47
- Viewed 1993 times
-
Add formulas and references
- 2:52
- Viewed 1984 times
-
Get going fast
- 1:38
- Viewed 1981 times
-
Conditionally format text
- 2:12
- Viewed 1980 times
-
Copying formulas
- 3:00
- Viewed 1978 times
-
Freeze or lock panes
- 1:06
- Viewed 1950 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1950 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1948 times
-
Save, publish, and share
- 2:22
- Viewed 1943 times
-
Weighted average
- 2:06
- Viewed 1925 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1917 times
-
Average a group of numbers
- 2:01
- Viewed 1901 times
-
Use slicers to filter data
- 1:25
- Viewed 1899 times
-
How to create a table
- 2:11
- Viewed 1894 times
-
Share documents
- 1:13
- Viewed 1886 times
-
How things are organized
- 1:58
- Viewed 1881 times
-
Advanced IF functions
- 3:22
- Viewed 1879 times
-
Drop-down lists
- 0:55
- Viewed 1876 times
-
Create a chart
- 0:52
- Viewed 1866 times
-
CONCAT
- 0:51
- Viewed 1846 times
-
Edit a macro
- 3:29
- Viewed 1838 times
-
Sort and filter data
- 1:38
- Viewed 1802 times
-
SWITCH
- 1:03
- Viewed 1791 times
-
Nested IF functions
- 3:30
- Viewed 1789 times
-
Page numbers in depth
- 3:06
- Viewed 1766 times
-
Microsoft Search
- 0:34
- Viewed 1765 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1716 times
-
Map Chart in Excel
- 0:31
- Viewed 1710 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1706 times
-
Funnel Chart
- 0:33
- Viewed 1545 times
-
Accessibility in Excel
- 1:12
- Viewed 1516 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1459 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1203 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1178 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1145 times
-
Change chart type
- 1:29
- Viewed 1143 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1113 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1104 times
-
Text before & after Function
- 4:57
- Viewed 1096 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1046 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 821 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 109 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 114 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 112 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 122 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 121 times
-
Managing permissions of a document library
- 2:01
- Viewed 107 times
-
Create a permission group
- 2:11
- Viewed 153 times
-
SharePoint permission levels
- 2:16
- Viewed 113 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 118 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 152 times
-
Create a SharePoint Lists
- 2:18
- Viewed 160 times
-
Create a document library
- 1:56
- Viewed 156 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 165 times
-
Customise my site Homepage
- 3:03
- Viewed 118 times
-
Configure the global Theme and logo
- 2:26
- Viewed 163 times
-
Delete a SharePoint site
- 1:12
- Viewed 111 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 115 times
-
Create a SharePoint site
- 1:57
- Viewed 162 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 106 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 119 times
-
Prevent comments on modern pages
- 1:15
- Viewed 154 times
-
Disable subsite creation
- 0:53
- Viewed 111 times
-
Set the proper time zone
- 0:44
- Viewed 114 times
-
Define site storage limits
- 1:42
- Viewed 107 times
-
Disable site creation
- 0:52
- Viewed 114 times
-
Access the admin center
- 0:52
- Viewed 158 times
-
Work together on the same document
- 1:48
- Viewed 121 times
-
Create a folder or a file in a library
- 1:46
- Viewed 162 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 128 times
-
Use the filter pane in a library
- 2:00
- Viewed 114 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 112 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 110 times
-
Use version history
- 1:57
- Viewed 111 times
-
Open and work on a document
- 2:42
- Viewed 116 times
-
Rename and find a document
- 2:00
- Viewed 105 times
-
Create a SharePoint site
- 2:58
- Viewed 168 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 166 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 120 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 114 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 113 times
-
Participate in a Town Hall
- 0:53
- Viewed 108 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 112 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 118 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 111 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 117 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 115 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 113 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 123 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 125 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 118 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 112 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 166 times
-
Send an Email to a Team
- 0:38
- Viewed 172 times
-
Analyze Team Dynamics
- 1:19
- Viewed 114 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 156 times
-
Create Approval Templates
- 2:06
- Viewed 164 times
-
Manage Document Approval
- 0:56
- Viewed 114 times
-
Make a New Approval Request
- 1:26
- Viewed 161 times
-
Use Templates for Document Creation
- 1:03
- Viewed 117 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 116 times
-
Filter Your Document Display
- 1:10
- Viewed 109 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 120 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 115 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 114 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 121 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 116 times
-
Add and Explore Workflows
- 1:35
- Viewed 115 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 111 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 108 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 114 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 115 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 165 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 131 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 108 times
-
Manage Conversation Options
- 1:35
- Viewed 118 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 112 times
-
Schedule Message Delivery
- 0:58
- Viewed 152 times
-
Finding Help?
- 0:56
- Viewed 420 times
-
Chancing Your Status
- 0:40
- Viewed 457 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 404 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 465 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 398 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 631 times
-
File Management
- 1:04
- Viewed 419 times
-
Managing Teams and Channels
- 2:15
- Viewed 414 times
-
Posting in a Channel
- 2:15
- Viewed 442 times
-
Creating a Channel
- 2:05
- Viewed 388 times
-
Creating or Joining a Team
- 1:11
- Viewed 619 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 408 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 601 times
-
Starting a Conversation
- 0:53
- Viewed 437 times
-
Searching for Items or People
- 0:30
- Viewed 387 times
-
Interface Overview
- 1:10
- Viewed 464 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 465 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 437 times
-
Change application settings
- 2:53
- Viewed 447 times
-
Manage accessibility settings
- 1:33
- Viewed 651 times
-
Manage privacy settings
- 1:00
- Viewed 459 times
-
Set up and customize your teams
- 2:02
- Viewed 401 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 449 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 414 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 451 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 482 times
-
Generate a presence report
- 1:23
- Viewed 405 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 413 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 423 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 635 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 478 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 427 times
-
Following your activities and your team's activities
- 1:26
- Viewed 407 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 415 times
-
Manage team files
- 1:28
- Viewed 436 times
-
Invite external guests
- 1:19
- Viewed 456 times
-
Create private and shared channels
- 1:52
- Viewed 636 times
-
Manage your teams
- 2:38
- Viewed 467 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 630 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 416 times
-
Store files in conversations
- 1:38
- Viewed 392 times
-
Isolate a conversation window
- 0:50
- Viewed 427 times
-
Use and co-edit files
- 2:06
- Viewed 441 times
-
View events
- 2:21
- Viewed 582 times
-
Take notes in meetings
- 0:35
- Viewed 521 times
-
Manage a meeting
- 2:08
- Viewed 529 times
-
Start an instant meeting
- 1:33
- Viewed 593 times
-
Join a meeting as a participant
- 2:13
- Viewed 842 times
-
Automatically record a meeting
- 1:12
- Viewed 594 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 566 times
-
Share content in meetings
- 2:44
- Viewed 515 times
-
Use a background image during a video call
- 1:19
- Viewed 474 times
-
Schedule private or team meetings
- 2:17
- Viewed 633 times
-
Synchronize only one channel
- 0:56
- Viewed 662 times
-
Pin a channel to your favorites
- 1:04
- Viewed 595 times
-
Add channels and tabs
- 1:40
- Viewed 623 times
-
Interact in a conversation
- 2:03
- Viewed 449 times
-
Edit and enhance messages
- 1:57
- Viewed 829 times
-
Create a team using a template
- 1:03
- Viewed 785 times
-
Create a team and add members
- 1:37
- Viewed 713 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 751 times
-
Interact in conversations
- 1:30
- Viewed 627 times
-
Private and small group chats
- 2:03
- Viewed 537 times
-
Overview of conversations
- 1:02
- Viewed 598 times
-
Define your status message
- 2:13
- Viewed 909 times
-
Customize notifications
- 2:05
- Viewed 649 times
-
Edit photo in Teams
- 0:42
- Viewed 503 times
-
Find content and people
- 0:59
- Viewed 604 times
-
Presentation of the desktop application
- 2:16
- Viewed 489 times
-
Introduction to Teams
- 1:25
- Viewed 480 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
- 874 Views