Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

AutoFill and Flash Fill in Excel

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to master AutoFill and Flash Fill features in Excel through this comprehensive 45-minute tutorial that demonstrates how to speed up data entry and formatting tasks. Discover how to apply AutoFill for formulas, create custom lists for automated data series, and explore Flash Fill techniques to extract, combine, and generate data automatically. Practice AutoFill formatting techniques to quickly apply consistent styling across cells and ranges, then advance to using AutoFill for formula replication and other practical applications. Build custom lists that can be automatically filled in sequences, saving time on repetitive data entry tasks. Explore Flash Fill capabilities including data extraction from text strings, combining information from multiple columns, and creating new data patterns based on examples you provide. Access downloadable course files to follow along with hands-on exercises that reinforce each concept, helping you work more efficiently and save significant time in your Excel workflows.

Syllabus

00:00:00 - Course Introduction
00:01:25 - AutoFill Formatting
00:07:50 - AutoFill for Formulas
00:10:50 - Other Applications of AutoFill
00:23:59 - Create Custom List
00:32:03 - Introduction to Flash Fill
00:35:31 - Flash Fill: Extract
00:38:30 - Flash Fill: Combine
00:41:05 - Flash Fill: Create

Taught by

Simon Sez IT

Reviews

Start your review of AutoFill and Flash Fill in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.