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
- 1682 views
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 3142 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 2903 times
-
3D Maps
- 1:41
- Viewed 2500 times
-
Manage conditional formatting
- 4:30
- Viewed 2490 times
-
Create a combo chart
- 1:47
- Viewed 2361 times
-
The SUMIF function
- 5:27
- Viewed 2338 times
-
Functions and formulas
- 3:24
- Viewed 2290 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 2261 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 2253 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 2243 times
-
The SUM function
- 4:37
- Viewed 2227 times
-
More complex formulas
- 4:17
- Viewed 2215 times
-
Advanced formulas and references
- 4:06
- Viewed 2211 times
-
Introduction to Excel
- 0:59
- Viewed 2203 times
-
More print options
- 5:59
- Viewed 2198 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 2197 times
-
Using functions
- 5:12
- Viewed 2189 times
-
Customize charts
- 4:28
- Viewed 2188 times
-
Manage drop-down lists
- 6:12
- Viewed 2179 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 2109 times
-
New Chart types
- 1:52
- Viewed 2103 times
-
Freeze panes in detail
- 3:30
- Viewed 2096 times
-
Create a PivotTable report manually
- 4:59
- Viewed 2094 times
-
AutoFill
- 2:55
- Viewed 2092 times
-
Start using Excel
- 4:22
- Viewed 2091 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 2082 times
-
AutoFilter details
- 3:27
- Viewed 2079 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 2079 times
-
Drop-down list settings
- 4:14
- Viewed 2076 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 2054 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 2045 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 2042 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 2041 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 2039 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 2039 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2036 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 2028 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 2027 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 2020 times
-
Look up values on a different worksheet
- 2:39
- Viewed 2012 times
-
Header and footer details
- 3:41
- Viewed 2011 times
-
Sort details
- 4:46
- Viewed 1994 times
-
Operator order
- 2:04
- Viewed 1993 times
-
Assign a button to a macro
- 2:49
- Viewed 1984 times
-
A closer look at the ribbon
- 3:55
- Viewed 1981 times
-
IF with AND and OR
- 3:35
- Viewed 1980 times
-
Work with macros
- 4:40
- Viewed 1973 times
-
Advanced filter details
- 4:13
- Viewed 1960 times
-
A first look at Excel 2016
- 3:22
- Viewed 1959 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 1959 times
-
Add numbers
- 2:54
- Viewed 1956 times
-
Insert columns and rows
- 4:16
- Viewed 1955 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 1953 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 1953 times
-
Basic math
- 2:28
- Viewed 1950 times
-
Print worksheets and workbooks
- 1:07
- Viewed 1949 times
-
One click Forecasting
- 1:01
- Viewed 1944 times
-
Use conditional formatting
- 2:02
- Viewed 1942 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 1937 times
-
Insert headers and footers
- 2:02
- Viewed 1933 times
-
Ink Equation
- 0:41
- Viewed 1910 times
-
Improved version history
- 0:51
- Viewed 1897 times
-
Copy a chart
- 2:59
- Viewed 1888 times
-
Subtract time
- 3:58
- Viewed 1886 times
-
Input and error messages
- 2:52
- Viewed 1886 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 1879 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 1876 times
-
Save your macro
- 2:59
- Viewed 1875 times
-
AVERAGEIF function
- 3:04
- Viewed 1867 times
-
Save and print an Excel workbook
- 1:53
- Viewed 1863 times
-
Cell references
- 1:34
- Viewed 1858 times
-
IFS
- 1:05
- Viewed 1853 times
-
Add formulas and references
- 2:52
- Viewed 1850 times
-
Get going fast
- 1:38
- Viewed 1826 times
-
Copying formulas
- 3:00
- Viewed 1822 times
-
Freeze or lock panes
- 1:06
- Viewed 1811 times
-
Conditionally format text
- 2:12
- Viewed 1811 times
-
TEXTJOIN
- 0:47
- Viewed 1810 times
-
Conditionally format dates
- 2:38
- Viewed 1806 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 1794 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 1792 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 1787 times
-
Weighted average
- 2:06
- Viewed 1767 times
-
Save, publish, and share
- 2:22
- Viewed 1767 times
-
Share documents
- 1:13
- Viewed 1748 times
-
Average a group of numbers
- 2:01
- Viewed 1748 times
-
How to create a table
- 2:11
- Viewed 1736 times
-
Use slicers to filter data
- 1:25
- Viewed 1732 times
-
Drop-down lists
- 0:55
- Viewed 1717 times
-
How things are organized
- 1:58
- Viewed 1714 times
-
Advanced IF functions
- 3:22
- Viewed 1709 times
-
Create a chart
- 0:52
- Viewed 1708 times
-
CONCAT
- 0:51
- Viewed 1694 times
-
Edit a macro
- 3:29
- Viewed 1692 times
-
Sort and filter data
- 1:38
- Viewed 1654 times
-
SWITCH
- 1:03
- Viewed 1645 times
-
Nested IF functions
- 3:30
- Viewed 1641 times
-
Microsoft Search
- 0:34
- Viewed 1626 times
-
Page numbers in depth
- 3:06
- Viewed 1604 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 1579 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 1571 times
-
Map Chart in Excel
- 0:31
- Viewed 1566 times
-
Funnel Chart
- 0:33
- Viewed 1420 times
-
Accessibility in Excel
- 1:12
- Viewed 1359 times
-
Check Accessibility in Excel
- 1:51
- Viewed 1318 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1054 times
-
Change chart type
- 1:29
- Viewed 1044 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 1024 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1002 times
-
Text before & after Function
- 4:57
- Viewed 975 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 963 times
-
Create dynamic drop down lists
- 3:26
- Viewed 956 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 876 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 709 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 84 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 78 times
-
Format Data with Copilot
- 1:52
- Viewed 76 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 75 times
-
Creating a Form with Copilot
- 1:57
- Viewed 74 times
-
What can Copilot do for you ?
- 2:37
- Viewed 81 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 78 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 84 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 75 times
-
Format Data with Copilot
- 1:52
- Viewed 76 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 76 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 81 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 103 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 105 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 81 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 80 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 72 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 72 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 79 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 123 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 73 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 77 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 74 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 83 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 76 times
-
Draft an Email with Copilot
- 2:35
- Viewed 88 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 79 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 68 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 83 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 79 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 72 times
-
How to Access Copilot
- 1:32
- Viewed 108 times
-
Manage priority people
- 0:24
- Viewed 113 times
-
Finding Help?
- 0:56
- Viewed 310 times
-
Chancing Your Status
- 0:40
- Viewed 334 times
-
Enabling Mobile Notifications
- 1:28
- Viewed 299 times
-
Enabling Subtitles During a Meeting
- 1:28
- Viewed 328 times
-
Sharing Content in a Meeting
- 0:41
- Viewed 288 times
-
Creating and Joining a Meeting
- 1:22
- Viewed 470 times
-
File Management
- 1:04
- Viewed 307 times
-
Managing Teams and Channels
- 2:15
- Viewed 304 times
-
Posting in a Channel
- 2:15
- Viewed 335 times
-
Creating a Channel
- 2:05
- Viewed 283 times
-
Creating or Joining a Team
- 1:11
- Viewed 457 times
-
Disabling Conversation Notifications
- 0:27
- Viewed 301 times
-
Responding or Reacting to a Message
- 1:01
- Viewed 453 times
-
Starting a Conversation
- 0:53
- Viewed 315 times
-
Searching for Items or People
- 0:30
- Viewed 283 times
-
Interface Overview
- 1:10
- Viewed 339 times
-
Finding and Installing Teams for Mobile
- 0:57
- Viewed 326 times
-
Importing and Processing Images with Copilot Edge
- 1:12
- Viewed 319 times
-
Optimizing the Edge Experience with Copilot
- 0:42
- Viewed 308 times
-
Summarizing a Video with Copilot Edge
- 0:53
- Viewed 419 times
-
Summarizing a PDF with Copilot Edge
- 0:53
- Viewed 1081 times
-
Generating an Image with Copilot Edge
- 0:58
- Viewed 361 times
-
Composing a Text with Copilot Edge
- 1:37
- Viewed 339 times
-
Using Conversational AI Copilot Edge
- 1:13
- Viewed 334 times
-
Personal Account vs. Professional Account
- 0:56
- Viewed 495 times
-
Managing Privacy in Copilot Edge
- 0:43
- Viewed 393 times
-
Accessing Copilot in Microsoft Edge
- 0:35
- Viewed 510 times
-
Enabling Copilot Edge in the Enterprise Environment
- 0:55
- Viewed 396 times
-
Respect your right to disconnect with Insights
- 2:26
- Viewed 328 times
-
Change application settings
- 2:53
- Viewed 326 times
-
Manage accessibility settings
- 1:33
- Viewed 493 times
-
Manage privacy settings
- 1:00
- Viewed 336 times
-
Set up and customize your teams
- 2:02
- Viewed 295 times
-
How to add Klaxoon to a current Teams meeting?
- 0:36
- Viewed 329 times
-
How to start a Teams meeting from Klaxoon?
- 1:15
- Viewed 313 times
-
How to integrate Klaxoon directly into a Teams meeting?
- 1:22
- Viewed 329 times
-
Use Microsoft Whiteboard in meetings
- 1:40
- Viewed 371 times
-
Generate a presence report
- 1:23
- Viewed 302 times
-
Generate automatic translations and transcriptions in a meeting
- 1:58
- Viewed 303 times
-
Retrieve items saved in a breakout room
- 0:40
- Viewed 314 times
-
Create, manage and set up a breakout room
- 2:15
- Viewed 480 times
-
Set up breakout rooms before the meeting
- 1:35
- Viewed 347 times
-
Get feedback from your coworkers with Forms questionnaires
- 2:08
- Viewed 325 times
-
Following your activities and your team's activities
- 1:26
- Viewed 305 times
-
Understand the differences between Connectors, Applications and Tabs
- 1:40
- Viewed 310 times
-
Manage team files
- 1:28
- Viewed 325 times
-
Invite external guests
- 1:19
- Viewed 338 times
-
Create private and shared channels
- 1:52
- Viewed 465 times
-
Manage your teams
- 2:38
- Viewed 358 times
-
Reply to and react to a Teams conversation in an e-mail
- 0:42
- Viewed 473 times
-
Collaborate within a conversation with Microsoft Loop
- 1:34
- Viewed 307 times
-
Store files in conversations
- 1:38
- Viewed 291 times
-
Isolate a conversation window
- 0:50
- Viewed 321 times
-
Use and co-edit files
- 2:06
- Viewed 336 times
-
Exploring Innovation: Applications of Generative AI in Modern Commerce
- 3:25
- Viewed 384 times
-
Optimizing Customer Journeys with AI: A Deep Dive
- 4:39
- Viewed 604 times
-
Deciphering AI-Assisted Marketing: Navigating Personalization, Ethics, and User Engagement in the Digital Age
- 5:34
- Viewed 610 times
-
Generative AI in Marketing : Revolutionize Your Advertising Campaigns
- 4:09
- Viewed 449 times
-
AI in Education : Technology and Innovation in Teacher Training
- 3:31
- Viewed 563 times
-
Shaping the Educational Future : AI, Diversity, Inclusion & Innovative Case Studies
- 3:48
- Viewed 323 times
-
AI and Automated Assessment
- 4:55
- Viewed 417 times
-
AI in Professional and Continuing Education
- 2:26
- Viewed 458 times
-
AI & Education : Technological Innovation Redefining Learning
- 2:23
- Viewed 617 times
-
AI & Education : Interactive Learning and Adaptive Assessment
- 2:55
- Viewed 407 times
-
Educational Revolution : Shaping the Future of Learning with Artificial Intelligence
- 6:39
- Viewed 415 times
-
Deep Dive into NVIDIA Omniverse in 3D Modeling
- 2:25
- Viewed 349 times
-
Advanced Data Analysis with Chat GPT-4 : Unleashing the Power of Data Analysis
- 2:17
- Viewed 330 times
-
Discovering Plugins in Chat GPT-4 : Maximizing Generative AI's Capabilities
- 2:12
- Viewed 404 times
-
Writing with Intelligence : Exploring GPT-4's Capabilities in Generative Writing
- 2:21
- Viewed 422 times
-
Composing with AI : Exploring AIVA and Generative Music
- 2:04
- Viewed 595 times
-
Other Wonders of AI : The Revolution in Image Creation
- 1:19
- Viewed 449 times
-
DALL·E : Turning Words into Artworks
- 1:18
- Viewed 423 times
-
Midjourney : The Symbiosis of Imagination and AI
- 1:32
- Viewed 387 times
-
The Essence of Generative AI in Artistic Creation
- 1:27
- Viewed 453 times
-
Unveiling Prompts : The Evolution and Future of Human-Machine Interaction
- 2:39
- Viewed 400 times
-
Navigating the Neural Forest : Secrets of AI Prompts
- 2:05
- Viewed 377 times
-
Generative AI Prompts : Harnessing the Power of Models
- 3:01
- Viewed 469 times
-
Generative AI in the Digital Space : From Ideation to Presentation
- 2:09
- Viewed 391 times
-
From Data to Discoveries : The Art of Innovation with Generative AI
- 4:38
- Viewed 463 times
-
Keys to Success, Pitfalls to Avoid, and Best Practices
- 2:29
- Viewed 424 times
-
The Impact of AI in the World of Science
- 1:44
- Viewed 468 times
-
Generative AI : Revolution, Efficiency, and Applications in the Modern World
- 1:52
- Viewed 469 times
-
Creative Symbiosis : When Generative AI Shapes Our Future
- 3:46
- Viewed 497 times
-
Generative AI : Between Extreme Personalization and Digital Ethics
- 2:17
- Viewed 498 times
-
Image and Video Manipulation : The Impact of Deepfakes
- 1:51
- Viewed 425 times
-
The Impact of Generative AI on Truth and Trust
- 3:16
- Viewed 452 times
-
Societal Implications of Generative AI
- 5:58
- Viewed 539 times
-
Adaptation Strategies for Organizations and Individuals
- 3:49
- Viewed 465 times
-
History of Generative AI
- 5:27
- Viewed 480 times
-
What is Generative AI ?
- 2:40
- Viewed 537 times
-
Harnessing Advanced Options in Your Loop
- 2:14
- Viewed 297 times
-
Leveraging OneDrive Logic in Your Loop
- 1:01
- Viewed 479 times
-
Transforming Your Section into a Component and Collaborating
- 2:34
- Viewed 213 times
-
Exchange and Communicate Using Discussions in Loop
- 1:14
- Viewed 382 times
-
Search and tag people with “@”
- 2:15
- Viewed 279 times
-
Enhance your pages using the "/" Command
- 3:24
- Viewed 309 times
-
Creating your new workspace
- 1:24
- Viewed 452 times
-
How to Work with the Microsoft Loop Interface?
- 2:36
- Viewed 311 times
-
What is Microsoft Loop ?
- 2:09
- Viewed 361 times
-
View events
- 2:21
- Viewed 458 times
-
Take notes in meetings
- 0:35
- Viewed 411 times
-
Manage a meeting
- 2:08
- Viewed 405 times
-
Start an instant meeting
- 1:33
- Viewed 467 times
-
Join a meeting as a participant
- 2:13
- Viewed 669 times
-
Automatically record a meeting
- 1:12
- Viewed 467 times
-
Presentation of different tools in a meeting
- 1:47
- Viewed 443 times
-
Share content in meetings
- 2:44
- Viewed 388 times
-
Use a background image during a video call
- 1:19
- Viewed 371 times
-
Schedule private or team meetings
- 2:17
- Viewed 497 times
-
Synchronize only one channel
- 0:56
- Viewed 519 times
-
Pin a channel to your favorites
- 1:04
- Viewed 477 times
-
Add channels and tabs
- 1:40
- Viewed 489 times
-
Interact in a conversation
- 2:03
- Viewed 347 times
-
Edit and enhance messages
- 1:57
- Viewed 659 times
-
Create a team using a template
- 1:03
- Viewed 610 times
-
Create a team and add members
- 1:37
- Viewed 555 times
-
Plan a meeting based on a conversation
- 1:28
- Viewed 611 times
-
Interact in conversations
- 1:30
- Viewed 474 times
-
Private and small group chats
- 2:03
- Viewed 415 times
-
Overview of conversations
- 1:02
- Viewed 479 times
-
Define your status message
- 2:13
- Viewed 712 times
-
Customize notifications
- 2:05
- Viewed 514 times
-
Edit photo in Teams
- 0:42
- Viewed 381 times
-
Find content and people
- 0:59
- Viewed 473 times
-
Presentation of the desktop application
- 2:16
- Viewed 384 times
-
Introduction to Teams
- 1:25
- Viewed 374 times
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
- 706 Views