Excel - AutoFill Tutorial
In this video, you will learn about Autofill and Flash Fill in Excel.
The video covers how to use Autofill to automatically fill in a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.
- 2:55
- 3107 views
-
Excel - Flash Fill
- 2:59
- Viewed 2660 times
-
Excel - AutoFill and Flash Fill
- 1:36
- Viewed 2819 times
-
Excel - Copying formulas
- 3:00
- Viewed 2911 times
-
Excel - Cell references
- 1:34
- Viewed 2895 times
-
Excel - Copy a chart
- 2:59
- Viewed 2915 times
-
Excel - Create a chart
- 0:52
- Viewed 2709 times
-
Excel - Start using Excel
- 4:22
- Viewed 3218 times
-
Excel - Create a combo chart
- 1:47
- Viewed 3419 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4260 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 3962 times
-
3D Maps
- 1:41
- Viewed 3712 times
-
Manage conditional formatting
- 4:30
- Viewed 3571 times
-
Create a PivotTable report manually
- 4:59
- Viewed 3525 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 3482 times
-
The SUMIF function
- 5:27
- Viewed 3420 times
-
Create a combo chart
- 1:47
- Viewed 3419 times
-
New Chart types
- 1:52
- Viewed 3398 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 3365 times
-
Functions and formulas
- 3:24
- Viewed 3350 times
-
A closer look at the ribbon
- 3:55
- Viewed 3349 times
-
Using functions
- 5:12
- Viewed 3326 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3324 times
-
Manage drop-down lists
- 6:12
- Viewed 3317 times
-
More complex formulas
- 4:17
- Viewed 3299 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 3283 times
-
The SUM function
- 4:37
- Viewed 3273 times
-
Advanced formulas and references
- 4:06
- Viewed 3255 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3245 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 3244 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3244 times
-
More print options
- 5:59
- Viewed 3224 times
-
Start using Excel
- 4:22
- Viewed 3218 times
-
Customize charts
- 4:28
- Viewed 3211 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3196 times
-
A first look at Excel 2016
- 3:22
- Viewed 3193 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3192 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3192 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3188 times
-
Freeze panes in detail
- 3:30
- Viewed 3180 times
-
Ink Equation
- 0:41
- Viewed 3179 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3178 times
-
AVERAGEIF function
- 3:04
- Viewed 3176 times
-
IF with AND and OR
- 3:35
- Viewed 3171 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3171 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3167 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3157 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3152 times
-
Add numbers
- 2:54
- Viewed 3149 times
-
AutoFilter details
- 3:27
- Viewed 3130 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3112 times
-
Drop-down list settings
- 4:14
- Viewed 3109 times
-
Header and footer details
- 3:41
- Viewed 3092 times
-
Sort details
- 4:46
- Viewed 3071 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3068 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3068 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3063 times
-
Advanced filter details
- 4:13
- Viewed 3058 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3057 times
-
Assign a button to a macro
- 2:49
- Viewed 3053 times
-
Insert headers and footers
- 2:02
- Viewed 3043 times
-
Operator order
- 2:04
- Viewed 3041 times
-
Save your macro
- 2:59
- Viewed 3037 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 3037 times
-
Work with macros
- 4:40
- Viewed 3035 times
-
Insert columns and rows
- 4:16
- Viewed 3032 times
-
Introduction to Excel
- 0:59
- Viewed 3025 times
-
Subtract time
- 3:58
- Viewed 2993 times
-
Input and error messages
- 2:52
- Viewed 2985 times
-
Conditionally format dates
- 2:38
- Viewed 2968 times
-
Basic math
- 2:28
- Viewed 2963 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 2953 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 2941 times
-
TEXTJOIN
- 0:47
- Viewed 2924 times
-
Save and print an Excel workbook
- 1:53
- Viewed 2923 times
-
Copy a chart
- 2:59
- Viewed 2915 times
-
Copying formulas
- 3:00
- Viewed 2911 times
-
Improved version history
- 0:51
- Viewed 2902 times
-
One click Forecasting
- 1:01
- Viewed 2896 times
-
Cell references
- 1:34
- Viewed 2895 times
-
Advanced IF functions
- 3:22
- Viewed 2890 times
-
IFS
- 1:05
- Viewed 2876 times
-
Use conditional formatting
- 2:02
- Viewed 2875 times
-
How to create a table
- 2:11
- Viewed 2872 times
-
Add formulas and references
- 2:52
- Viewed 2862 times
-
Conditionally format text
- 2:12
- Viewed 2861 times
-
Get going fast
- 1:38
- Viewed 2860 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 2847 times
-
Save, publish, and share
- 2:22
- Viewed 2843 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 2832 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 2819 times
-
Use slicers to filter data
- 1:25
- Viewed 2806 times
-
Nested IF functions
- 3:30
- Viewed 2791 times
-
Freeze or lock panes
- 1:06
- Viewed 2767 times
-
How things are organized
- 1:58
- Viewed 2765 times
-
CONCAT
- 0:51
- Viewed 2724 times
-
Weighted average
- 2:06
- Viewed 2722 times
-
Average a group of numbers
- 2:01
- Viewed 2716 times
-
Drop-down lists
- 0:55
- Viewed 2716 times
-
Create a chart
- 0:52
- Viewed 2709 times
-
Edit a macro
- 3:29
- Viewed 2675 times
-
SWITCH
- 1:03
- Viewed 2667 times
-
Flash Fill
- 2:59
- Viewed 2660 times
-
Sort and filter data
- 1:38
- Viewed 2628 times
-
Map Chart in Excel
- 0:31
- Viewed 2608 times
-
Share documents
- 1:13
- Viewed 2581 times
-
Microsoft Search
- 0:34
- Viewed 2578 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 2548 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 2489 times
-
Page numbers in depth
- 3:06
- Viewed 2469 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2376 times
-
Accessibility in Excel
- 1:12
- Viewed 2309 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2252 times
-
Funnel Chart
- 0:33
- Viewed 2201 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2042 times
-
Create dynamic drop down lists
- 3:26
- Viewed 1907 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 1901 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 1898 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 1840 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 1829 times
-
Text before & after Function
- 4:57
- Viewed 1724 times
-
Change chart type
- 1:29
- Viewed 1554 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 1440 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 773 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 754 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 700 times
-
Format Data with Copilot
- 1:52
- Viewed 641 times
-
Manage Storage Space
- 02:08
- Viewed 32 times
-
Synchronize Your Teams and SharePoint Files on Your Computer
- 01:29
- Viewed 30 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 30 times
-
Make a File Request
- 01:24
- Viewed 34 times
-
Restore Your OneDrive Space
- 01:42
- Viewed 31 times
-
Find All Shares from the Same Person
- 01:08
- Viewed 30 times
-
Modify Sharing Rules
- 00:53
- Viewed 31 times
-
Check Granted Shares
- 00:48
- Viewed 35 times
-
Protect My Document with a Password and Expiration Date
- 01:02
- Viewed 29 times
-
Avoid Abusive Document Sharing
- 00:57
- Viewed 29 times
-
Best Security Practices on OneDrive
- 01:27
- Viewed 30 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 29 times
-
Search for Documents
- 01:31
- Viewed 29 times
-
Use Document History or Restore a Document to a Previous Version
- 02:11
- Viewed 31 times
-
Discover the Meaning of OneDrive Icons
- 02:16
- Viewed 29 times
-
Sync OneDrive with a Computer
- 02:38
- Viewed 30 times
-
Edit, Delete a Share
- 02:16
- Viewed 33 times
-
Share and Collaborate OneDrive
- 02:45
- Viewed 32 times
-
Power and Manage OneDrive
- 01:36
- Viewed 29 times
-
What is OneDrive ?
- 01:14
- Viewed 31 times
-
Personality and tone for a realistic rendering
- 01:18
- Viewed 125 times
-
Format and example for optimal results
- 01:50
- Viewed 134 times
-
The importance of context in your requests
- 01:44
- Viewed 149 times
-
Precise task in conversational AI
- 01:55
- Viewed 150 times
-
Basics of prompting with conversational AI
- 02:29
- Viewed 128 times
-
What is a prompt ?
- 01:14
- Viewed 130 times
-
Survey Consumer Satisfaction Panel
- 02:38
- Viewed 191 times
-
Promote Your Product on Social Networks with Copilot
- 02:41
- Viewed 177 times
-
Write a Product Description with Copilot
- 02:36
- Viewed 187 times
-
Structure Your Product Launch Project
- 02:15
- Viewed 180 times
-
Initiate a Market Study with Copilot
- 03:15
- Viewed 193 times
-
Create a Business Presentation Report with ChatGPT
- 02:00
- Viewed 272 times
-
Boost Your Proposal with ChatGPT
- 02:19
- Viewed 251 times
-
Generating an Executive Summary with ChatGPT
- 01:47
- Viewed 255 times
-
Writing a Business Proposal with ChatGPT
- 02:22
- Viewed 243 times
-
Analyzing a Specification Document with ChatGPT
- 02:15
- Viewed 257 times
-
Create a Business Presentation Report with Copilot
- 03:02
- Viewed 291 times
-
Boost Your Proposal with Copilot Coaching for Outlook
- 02:18
- Viewed 278 times
-
Generating an Executive Summary with Copilot
- 01:46
- Viewed 265 times
-
Writing a Business Proposal with Copilot
- 03:40
- Viewed 257 times
-
Analyzing a Specification Document with Copilot
- 02:59
- Viewed 268 times
-
Creating a Welcome Presentation with ChatGPT
- 1:51
- Viewed 402 times
-
Creating a Welcome Presentation with Copilot
- 2:30
- Viewed 375 times
-
Debriefing a Job Interview with ChatGPT
- 1:54
- Viewed 386 times
-
Debriefing a Job Interview with Copilot
- 4:28
- Viewed 536 times
-
Analyze a resume with ChatGPT
- 1:52
- Viewed 387 times
-
Analyze a resume with Copilot
- 2:07
- Viewed 420 times
-
Responding to a Job Application Email with ChatGPT
- 1:38
- Viewed 434 times
-
Draft a Personalized Thank you Email
- 2:09
- Viewed 357 times
-
Draft a job offer with ChatGPT
- 1:49
- Viewed 396 times
-
Draft a job offer with Copilot
- 2:00
- Viewed 361 times
-
Add interactivity to your videos
- 1:20
- Viewed 413 times
-
Customise my SharePoint site navigation
- 2:20
- Viewed 522 times
-
Managing permissions on a SharePoint List
- 1:42
- Viewed 525 times
-
Managing permissions on a SharePoint page
- 1:27
- Viewed 560 times
-
Managing permissions on a SharePoint file
- 1:12
- Viewed 522 times
-
Managing permissions in a SharePoint folder
- 1:10
- Viewed 580 times
-
Managing permissions of a document library
- 2:01
- Viewed 518 times
-
Create a permission group
- 2:11
- Viewed 659 times
-
SharePoint permission levels
- 2:16
- Viewed 520 times
-
Generate a usage report for my SharePoint site
- 1:42
- Viewed 561 times
-
Create a SharePoint news and send it via mail
- 1:59
- Viewed 667 times
-
Create a SharePoint Lists
- 2:18
- Viewed 675 times
-
Create a document library
- 1:56
- Viewed 667 times
-
Create and publish a SharePoint page
- 2:44
- Viewed 705 times
-
Customise my site Homepage
- 3:03
- Viewed 549 times
-
Configure the global Theme and logo
- 2:26
- Viewed 734 times
-
Delete a SharePoint site
- 1:12
- Viewed 567 times
-
Modify membership to the sites of my organization
- 1:38
- Viewed 516 times
-
Create a SharePoint site
- 1:57
- Viewed 693 times
-
Choose expiration and permissions options for links opened to anyone
- 1:08
- Viewed 522 times
-
Disable the OneDrive sync button
- 0:49
- Viewed 566 times
-
Prevent comments on modern pages
- 1:15
- Viewed 727 times
-
Disable subsite creation
- 0:53
- Viewed 520 times
-
Set the proper time zone
- 0:44
- Viewed 577 times
-
Define site storage limits
- 1:42
- Viewed 546 times
-
Disable site creation
- 0:52
- Viewed 578 times
-
Access the admin center
- 0:52
- Viewed 716 times
-
Work together on the same document
- 1:48
- Viewed 530 times
-
Create a folder or a file in a library
- 1:46
- Viewed 730 times
-
Synchronise a SharePoint document library
- 1:42
- Viewed 553 times
-
Use the filter pane in a library
- 2:00
- Viewed 502 times
-
Pin a document to the top of a document library
- 1:32
- Viewed 524 times
-
Share a document to someone outside of my SharePoint site
- 3:57
- Viewed 517 times
-
Use version history
- 1:57
- Viewed 523 times
-
Open and work on a document
- 2:42
- Viewed 502 times
-
Rename and find a document
- 2:00
- Viewed 493 times
-
Create a SharePoint site
- 2:58
- Viewed 741 times
-
Register as a Participant in a Teams Webinar
- 1:05
- Viewed 749 times
-
Add Interactivity to Your Teams Webinar
- 2:02
- Viewed 508 times
-
Ensure Your Webinar Options Before Launching
- 1:09
- Viewed 516 times
-
Prepare Your Webinar with Microsoft Teams
- 3:13
- Viewed 535 times
-
Participate in a Town Hall
- 0:53
- Viewed 513 times
-
End the Event and Gather Statistics
- 1:10
- Viewed 530 times
-
Communicate Behind the Scenes
- 0:56
- Viewed 548 times
-
Moderate the Chat During a Town Hall
- 1:26
- Viewed 512 times
-
Start and Manage Your Event with Multiple People
- 1:20
- Viewed 564 times
-
Start and Manage Your Event Alone
- 1:56
- Viewed 505 times
-
Test Your Event with the Green Room
- 1:52
- Viewed 512 times
-
Plan and Launch a Town Hall
- 2:15
- Viewed 517 times
-
When and Why to Use Town Hall
- 1:38
- Viewed 561 times
-
Differentiate Between Meeting Types
- 1:38
- Viewed 549 times
-
Secure Teams Upon Creation
- 2:57
- Viewed 513 times
-
Apply a Specific Policy to a User
- 1:22
- Viewed 690 times
-
Send an Email to a Team
- 0:38
- Viewed 732 times
-
Analyze Team Dynamics
- 1:19
- Viewed 548 times
-
Create and Send Signatures with Dedicated Services
- 1:46
- Viewed 686 times
-
Create Approval Templates
- 2:06
- Viewed 717 times
-
Manage Document Approval
- 0:56
- Viewed 547 times
-
Make a New Approval Request
- 1:26
- Viewed 739 times
-
Use Templates for Document Creation
- 1:03
- Viewed 548 times
-
Manage Storage Spaces on Teams
- 2:05
- Viewed 503 times
-
Filter Your Document Display
- 1:10
- Viewed 515 times
-
Secure a Shared Document with a Password
- 1:28
- Viewed 514 times
-
Restrict a Document to Certain Team Members
- 1:50
- Viewed 519 times
-
Restrict a Document to Read-Only
- 0:58
- Viewed 507 times
-
Centralize Important Events in a Single Channel Calendar
- 0:42
- Viewed 528 times
-
Set Up Monitoring in a Channel with an RSS Feed
- 0:48
- Viewed 513 times
-
Add and Explore Workflows
- 1:35
- Viewed 537 times
-
Use Connectors to Receive Notifications
- 0:48
- Viewed 544 times
-
Manage Privacy in Private Channels
- 2:34
- Viewed 519 times
-
Integrate Klaxoon in a Teams Channel
- 0:40
- Viewed 555 times
-
Enable Klaxoon as an App in Teams
- 1:44
- Viewed 567 times
-
Understand and Secure Information Sharing in Instant Messaging
- 2:38
- Viewed 723 times
-
Use Commands and Keyboard Shortcuts
- 1:29
- Viewed 568 times
-
Customize the Display of the Function Panel
- 0:45
- Viewed 494 times
-
Manage Conversation Options
- 1:35
- Viewed 510 times
-
Use Viva Insights in Conversations
- 0:53
- Viewed 556 times
-
Schedule Message Delivery
- 0:58
- Viewed 705 times
-
Creating a Form with Copilot
- 1:57
- Viewed 608 times
-
What can Copilot do for you ?
- 2:37
- Viewed 626 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 773 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 754 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 700 times
-
Format Data with Copilot
- 1:52
- Viewed 641 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 620 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 676 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 805 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 861 times
-
Use the Copilot Conversation Pane in Word
- 1:56
- Viewed 612 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 786 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 691 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 752 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 578 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 874 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 918 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 648 times
-
Generate and Organize Ideas with Copilot
- 2:06
- Viewed 606 times
-
Summarize Your Email Exchanges with Copilot
- 0:53
- Viewed 707 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 619 times
-
Draft an Email with Copilot
- 2:35
- Viewed 750 times
-
Copilot After Teams Meetings
- 1:43
- Viewed 640 times
-
Copilot During Teams Meetings
- 3:29
- Viewed 590 times
-
Copilot in Teams Conversations
- 2:47
- Viewed 664 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 600 times
-
Chat, Get Inspired, and Search with Copilot
- 3:26
- Viewed 599 times
-
How to Access Copilot
- 1:32
- Viewed 853 times
-
Manage priority people
- 0:24
- Viewed 430 times
DiLeaP AI: THIS MIGHT BE HELPFUL
RELATED COURSES This tutorial is part of the following courses
Video Training Microsoft Excel - Discovery level
Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!
- Your trainer for this course
- Cours E-learning
- 1861 Views