Advance Excel Lesson 7 - Auto-fill, Custom Lists, and Flash Fill
- 2 years ago
In this lesson, I cover the following topics:
Autofill: This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
Custom Lists: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
Flash Fill: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern
Autofill: This allows you to quickly fill data in contiguous cells. For example, you can have ‘Jan’ and ‘Feb’ in two adjacent cells and then you can use Autofill to get the other month names
Custom Lists: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
Flash Fill: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern