Excel - Flash Fill Tutorial
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
- 2951 views
-
Excel - AutoFill
- 2:55
- Viewed 3414 times
-
Excel - AutoFill and Flash Fill
- 1:36
- Viewed 3059 times
-
Excel - Copying formulas
- 3:00
- Viewed 3238 times
-
Excel - How things are organized
- 1:58
- Viewed 3265 times
-
Excel - Copy a chart
- 2:59
- Viewed 3191 times
-
Excel - Customize charts
- 4:28
- Viewed 3478 times
-
Excel - Create a chart
- 0:52
- Viewed 2938 times
-
Excel - Cell references
- 1:34
- Viewed 3146 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4566 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4217 times
-
3D Maps
- 1:41
- Viewed 4116 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3867 times
-
Ink Equation
- 0:41
- Viewed 3846 times
-
Manage conditional formatting
- 4:30
- Viewed 3844 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3775 times
-
Start using Excel
- 4:22
- Viewed 3758 times
-
Create a combo chart
- 1:47
- Viewed 3738 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3732 times
-
The SUMIF function
- 5:27
- Viewed 3708 times
-
More complex formulas
- 4:17
- Viewed 3701 times
-
Manage drop-down lists
- 6:12
- Viewed 3672 times
-
A closer look at the ribbon
- 3:55
- Viewed 3657 times
-
New Chart types
- 1:52
- Viewed 3656 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3636 times
-
Functions and formulas
- 3:24
- Viewed 3630 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3627 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3604 times
-
Using functions
- 5:12
- Viewed 3602 times
-
The SUM function
- 4:37
- Viewed 3580 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3565 times
-
Advanced formulas and references
- 4:06
- Viewed 3538 times
-
AVERAGEIF function
- 3:04
- Viewed 3534 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3522 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3496 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3496 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3487 times
-
Customize charts
- 4:28
- Viewed 3478 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3477 times
-
More print options
- 5:59
- Viewed 3473 times
-
Freeze panes in detail
- 3:30
- Viewed 3470 times
-
IF with AND and OR
- 3:35
- Viewed 3464 times
-
Add numbers
- 2:54
- Viewed 3452 times
-
A first look at Excel 2016
- 3:22
- Viewed 3451 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3444 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3440 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3432 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3429 times
-
AutoFilter details
- 3:27
- Viewed 3427 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3426 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3425 times
-
AutoFill
- 2:55
- Viewed 3414 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3397 times
-
Drop-down list settings
- 4:14
- Viewed 3394 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3391 times
-
Advanced filter details
- 4:13
- Viewed 3386 times
-
Work with macros
- 4:40
- Viewed 3373 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3373 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3372 times
-
Header and footer details
- 3:41
- Viewed 3372 times
-
Input and error messages
- 2:52
- Viewed 3367 times
-
Subtract time
- 3:58
- Viewed 3363 times
-
Insert columns and rows
- 4:16
- Viewed 3361 times
-
Insert headers and footers
- 2:02
- Viewed 3355 times
-
Sort details
- 4:46
- Viewed 3344 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3341 times
-
Assign a button to a macro
- 2:49
- Viewed 3309 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3308 times
-
Conditionally format dates
- 2:38
- Viewed 3306 times
-
Save your macro
- 2:59
- Viewed 3305 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3301 times
-
Operator order
- 2:04
- Viewed 3282 times
-
Basic math
- 2:28
- Viewed 3277 times
-
How things are organized
- 1:58
- Viewed 3265 times
-
Copying formulas
- 3:00
- Viewed 3238 times
-
Introduction to Excel
- 0:59
- Viewed 3235 times
-
Advanced IF functions
- 3:22
- Viewed 3205 times
-
Improved version history
- 0:51
- Viewed 3204 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3198 times
-
Copy a chart
- 2:59
- Viewed 3191 times
-
TEXTJOIN
- 0:47
- Viewed 3169 times
-
Use conditional formatting
- 2:02
- Viewed 3161 times
-
IFS
- 1:05
- Viewed 3148 times
-
How to create a table
- 2:11
- Viewed 3147 times
-
Cell references
- 1:34
- Viewed 3146 times
-
Conditionally format text
- 2:12
- Viewed 3144 times
-
One click Forecasting
- 1:01
- Viewed 3134 times
-
Save, publish, and share
- 2:22
- Viewed 3107 times
-
Add formulas and references
- 2:52
- Viewed 3101 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3099 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3091 times
-
Get going fast
- 1:38
- Viewed 3085 times
-
Use slicers to filter data
- 1:25
- Viewed 3074 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3059 times
-
Nested IF functions
- 3:30
- Viewed 3043 times
-
Freeze or lock panes
- 1:06
- Viewed 3022 times
-
Weighted average
- 2:06
- Viewed 3011 times
-
Drop-down lists
- 0:55
- Viewed 2985 times
-
Average a group of numbers
- 2:01
- Viewed 2959 times
-
CONCAT
- 0:51
- Viewed 2948 times
-
Create a chart
- 0:52
- Viewed 2938 times
-
Edit a macro
- 3:29
- Viewed 2932 times
-
SWITCH
- 1:03
- Viewed 2924 times
-
Map Chart in Excel
- 0:31
- Viewed 2908 times
-
Sort and filter data
- 1:38
- Viewed 2894 times
-
Share documents
- 1:13
- Viewed 2832 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2783 times
-
Microsoft Search
- 0:34
- Viewed 2767 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2709 times
-
Page numbers in depth
- 3:06
- Viewed 2665 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2579 times
-
Accessibility in Excel
- 1:12
- Viewed 2510 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2473 times
-
Funnel Chart
- 0:33
- Viewed 2451 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2277 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2134 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2100 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2099 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2046 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2021 times
-
Text before & after Function
- 4:57
- Viewed 1913 times
-
Change chart type
- 1:29
- Viewed 1684 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1655 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 978 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 911 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 837 times
-
Format Data with Copilot
- 1:52
- Viewed 767 times
-
Generate formulas from a concept
- 01:02
- Viewed 6 times
-
Add a third-party application
- 02:40
- Viewed 13 times
-
Send a survey or questionnaire by email
- 02:06
- Viewed 9 times
-
Collaborate directly during an event with Microsoft Loop and Outlook
- 02:01
- Viewed 9 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 7 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 6 times
-
Create your reservation page for appointment booking (Bookings)
- 03:17
- Viewed 8 times
-
Share a document securely with Outlook
- 02:21
- Viewed 11 times
-
Block a sender
- 01:54
- Viewed 11 times
-
Identify a fraudulent email
- 02:06
- Viewed 7 times
-
Prevent transfer for a meeting
- 01:19
- Viewed 9 times
-
Prevent the forwarding of an email
- 01:01
- Viewed 8 times
-
Protect an email by encrypting
- 01:10
- Viewed 3 times
-
Provide an overview of best security practices in Outlook
- 01:08
- Viewed 9 times
-
Recover deleted items
- 01:09
- Viewed 5 times
-
Recall or replace an e-mail message
- 01:45
- Viewed 8 times
-
Respond to invitations as a delegate
- 02:55
- Viewed 9 times
-
Use a Shared Mailbox
- 01:18
- Viewed 6 times
-
Create and Manage Appointments in Delegated Calendars
- 02:04
- Viewed 9 times
-
Send Emails on Behalf of Someone Else
- 01:13
- Viewed 11 times
-
Mailbox Delegation Setup
- 01:59
- Viewed 8 times
-
Calendar Delegation Setup
- 01:21
- Viewed 11 times
-
Grant delegate access in Microsoft 365 administration
- 01:23
- Viewed 8 times
-
Making changes to a text
- 00:37
- Viewed 8 times
-
Consult the adoption of Copilot through Viva Insights
- 00:52
- Viewed 6 times
-
Search from emails with Copilot
- 00:53
- Viewed 9 times
-
Using Copilot in OneNote with Right-Click
- 01:21
- Viewed 5 times
-
Organizing OneNote with Copilot
- 00:46
- Viewed 5 times
-
Tracking changes in a Loop page with Copilot
- 01:15
- Viewed 5 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 6 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 7 times
-
Send invitations or reminders with Copilot
- 00:53
- Viewed 6 times
-
Generate formulas from a concept
- 01:02
- Viewed 6 times
-
Analyzing a OneDrive file with Copilot
- 01:25
- Viewed 9 times
-
Analyzing multiple OneDrive documents with Copilot
- 01:01
- Viewed 12 times
-
Use the Meeting Dashboard
- 02:48
- Viewed 7 times
-
Respond to a Meeting Poll
- 01:30
- Viewed 13 times
-
Create a Meeting Poll
- 02:48
- Viewed 5 times
-
Display Three Time Zones
- 01:52
- Viewed 2 times
-
View Other Calendars
- 00:50
- Viewed 4 times
-
Open a Shared Calendar
- 01:29
- Viewed 6 times
-
Share Your Calendar
- 01:54
- Viewed 8 times
-
Use the Scheduling Assistant
- 01:42
- Viewed 4 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 5 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 5 times
-
Translate Emails in Outlook
- 01:32
- Viewed 9 times
-
Make Your Outlook Signature Accessible
- 01:12
- Viewed 2 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 9 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 8 times
-
Improve Email Accessibility
- 02:02
- Viewed 5 times
-
Send Automatic Out-of-Office Replies
- 02:22
- Viewed 9 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 3 times
-
Respect Your Colleagues' Off Hours (Viva Insights)
- 01:27
- Viewed 3 times
-
Delay Email Delivery
- 01:10
- Viewed 7 times
-
Use Conversation View
- 01:47
- Viewed 3 times
-
Clean Up Your Inbox
- 01:18
- Viewed 12 times
-
Organize Your Messages with Rules
- 02:01
- Viewed 5 times
-
Use Categories
- 02:51
- Viewed 5 times
-
Easily Sort Your Mails
- 01:38
- Viewed 4 times
-
Automate Routine Actions
- 02:19
- Viewed 5 times
-
Create an Email Template
- 01:40
- Viewed 8 times
-
Create a task from a message
- 02:00
- Viewed 51 times
-
Share a task list
- 03:10
- Viewed 62 times
-
Create a task or reminder
- 01:50
- Viewed 57 times
-
Task Module Overview
- 01:56
- Viewed 57 times
-
Manage Teams online meeting options
- 01:56
- Viewed 53 times
-
Edit or delete an appointment, meeting or event
- 01:50
- Viewed 73 times
-
Create a reminder for yourself
- 01:59
- Viewed 49 times
-
Respond to a meeting
- 01:00
- Viewed 54 times
-
Create an appointment or meeting
- 01:44
- Viewed 63 times
-
Create different types of events
- 01:46
- Viewed 56 times
-
Edit and customize views
- 01:55
- Viewed 54 times
-
Presentation and introduction to the calendar
- 01:35
- Viewed 62 times
-
Search options
- 01:23
- Viewed 55 times
-
Sort and filter emails
- 02:51
- Viewed 59 times
-
Request a Read Receipt or Delivery Confirmation
- 02:01
- Viewed 57 times
-
The Bcc Field in Detail
- 01:53
- Viewed 58 times
-
Save and Print a Message
- 01:48
- Viewed 60 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 72 times
-
Attach files efficiently in Outlook
- 02:20
- Viewed 62 times
-
Process an incoming message
- 01:53
- Viewed 50 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 62 times
-
Organize into Folders
- 01:57
- Viewed 63 times
-
Set Your Work Hours in Outlook
- 02:02
- Viewed 55 times
-
Create and add a signature to messages
- 01:26
- Viewed 55 times
-
Manage new message notifications
- 01:40
- Viewed 56 times
-
Change the default font of your emails
- 01:05
- Viewed 62 times
-
Manage Views
- 02:36
- Viewed 49 times
-
Add and manage multiple accounts on Outlook
- 01:24
- Viewed 75 times
-
Explore the Interface
- 03:22
- Viewed 55 times
-
Introduce the new version of Outlook
- 02:01
- Viewed 56 times
-
Survey Consumer Satisfaction Panel with ChatGPT
- 01:55
- Viewed 156 times
-
Enhance Your Product on Social Media with ChatGPT
- 02:13
- Viewed 152 times
-
Write a Product Description with ChatGPT
- 02:30
- Viewed 145 times
-
Structure Your Product Launch Project
- 01:51
- Viewed 164 times
-
Initiate a Market Research Study with ChatGPT
- 02:08
- Viewed 133 times
-
Manage Storage Space
- 02:08
- Viewed 173 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 159 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 167 times
-
Make a File Request
- 01:24
- Viewed 178 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 177 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 186 times
-
Modify Sharing Rules
- 00:53
- Viewed 178 times
-
Check Granted Shares
- 00:48
- Viewed 166 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 178 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 152 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 182 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 175 times
-
Search for Documents
- 01:31
- Viewed 146 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 178 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 174 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 163 times
-
Edit, Delete a Share
- 02:16
- Viewed 172 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 178 times
-
Power and Manage OneDrive
- 01:36
- Viewed 170 times
-
What is OneDrive ?
- 01:14
- Viewed 255 times
-
Personality and tone for a realistic rendering
- 01:18
- Viewed 235 times
-
Format and example for optimal results
- 01:50
- Viewed 255 times
-
The importance of context in your requests
- 01:44
- Viewed 258 times
-
Precise task in conversational AI
- 01:55
- Viewed 275 times
-
Basics of prompting with conversational AI
- 02:29
- Viewed 257 times
-
What is a prompt ?
- 01:14
- Viewed 258 times
-
Survey Consumer Satisfaction Panel
- 02:38
- Viewed 344 times
-
Promote Your Product on Social Networks with Copilot
- 02:41
- Viewed 294 times
-
Write a Product Description with Copilot
- 02:36
- Viewed 327 times
-
Structure Your Product Launch Project
- 02:15
- Viewed 326 times
-
Initiate a Market Study with Copilot
- 03:15
- Viewed 325 times
-
Create a Business Presentation Report with ChatGPT
- 02:00
- Viewed 397 times
-
Boost Your Proposal with ChatGPT
- 02:19
- Viewed 373 times
-
Generating an Executive Summary with ChatGPT
- 01:47
- Viewed 432 times
-
Writing a Business Proposal with ChatGPT
- 02:22
- Viewed 368 times
-
Analyzing a Specification Document with ChatGPT
- 02:15
- Viewed 374 times
-
Create a Business Presentation Report with Copilot
- 03:02
- Viewed 424 times
-
Boost Your Proposal with Copilot Coaching for Outlook
- 02:18
- Viewed 405 times
-
Generating an Executive Summary with Copilot
- 01:46
- Viewed 460 times
-
Writing a Business Proposal with Copilot
- 03:40
- Viewed 377 times
-
Analyzing a Specification Document with Copilot
- 02:59
- Viewed 416 times
-
Creating a Welcome Presentation with ChatGPT
- 1:51
- Viewed 528 times
-
Creating a Welcome Presentation with Copilot
- 2:30
- Viewed 510 times
-
Debriefing a Job Interview with ChatGPT
- 1:54
- Viewed 527 times
-
Debriefing a Job Interview with Copilot
- 4:28
- Viewed 746 times
-
Analyze a resume with ChatGPT
- 1:52
- Viewed 519 times
-
Analyze a resume with Copilot
- 2:07
- Viewed 654 times
-
Responding to a Job Application Email with ChatGPT
- 1:38
- Viewed 625 times
-
Draft a Personalized Thank you Email
- 2:09
- Viewed 488 times
-
Draft a job offer with ChatGPT
- 1:49
- Viewed 545 times
-
Draft a job offer with Copilot
- 2:00
- Viewed 486 times
-
Add interactivity to your videos
- 1:20
- Viewed 534 times
DiLeaP AI: THIS MIGHT BE HELPFUL
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
- 1748 Views