We will fill in data quickly and easily from one column into another using Excel’s Flash Fill tool. It’s all about Excel seeing the right pattern in the data. Timestamps 00:00 Intro 00:30 Go to the video description to access links 00:52 Flash Fill feature was released in 2013 01:18 Flash Fill looks for patterns 02:03 Data is dirty 03:21 Drag down fill handles and then select Flash Fill 04:22 Use shortcut keys to Flash Fill - Ctrl + E 04:51 What to do when Excel does not get the pattern perfectly 06:00 Use top menu to Flash Fill - Data > Flash Fill 08:15 Advantages of using the shortcut keys or top menu to Flash Fill 09:07 Format telephone numbers using Flash Fill 09:56 Create an email list using Flash Fill 10:40 Create a passcode list using Flash Fill 11:34 How to add non significant zeroes in Excel using custom formatting You can download a copy of the spreadsheet used in this challenge using this link: docs.google.com/spreadsheets/d/1SU5BfYMeLiW2Ur6Bz23Pu29a8CjRT-Zx/edit?usp=sharing&ouid=113397942570982704051&rtpof=true&sd=true How to use AutoFill in Excel: ruclips.net/video/zGRoHQ9TyK4/видео.html Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLcdqmgfWC-h7JVaVViVxRiiMOMh_2Z1Kw Excel challenge: ruclips.net/p/PLcdqmgfWC-h6LfgQMq1CsyT_Hr7WLHaSD WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/ WeCanEduTech Podcast: wecanedutech.podbean.com/ WeCanEduTech FB: facebook.com/WeCanEduTech How Flash Fill was created www.microsoft.com/en-us/research/blog/flash-fill-gives-excel-smart-charge/ Connect with Jason Matthew on LinkedIN: www.linkedin.com/in/jason-matthew/
We will fill in data quickly and easily from one column into another using Excel’s Flash Fill tool. It’s all about Excel seeing the right pattern in the data.
Timestamps
00:00 Intro
00:30 Go to the video description to access links
00:52 Flash Fill feature was released in 2013
01:18 Flash Fill looks for patterns
02:03 Data is dirty
03:21 Drag down fill handles and then select Flash Fill
04:22 Use shortcut keys to Flash Fill - Ctrl + E
04:51 What to do when Excel does not get the pattern perfectly
06:00 Use top menu to Flash Fill - Data > Flash Fill
08:15 Advantages of using the shortcut keys or top menu to Flash Fill
09:07 Format telephone numbers using Flash Fill
09:56 Create an email list using Flash Fill
10:40 Create a passcode list using Flash Fill
11:34 How to add non significant zeroes in Excel using custom formatting
You can download a copy of the spreadsheet used in this challenge using this link: docs.google.com/spreadsheets/d/1SU5BfYMeLiW2Ur6Bz23Pu29a8CjRT-Zx/edit?usp=sharing&ouid=113397942570982704051&rtpof=true&sd=true
How to use AutoFill in Excel: ruclips.net/video/zGRoHQ9TyK4/видео.html
Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLcdqmgfWC-h7JVaVViVxRiiMOMh_2Z1Kw
Excel challenge: ruclips.net/p/PLcdqmgfWC-h6LfgQMq1CsyT_Hr7WLHaSD
WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/
WeCanEduTech Podcast: wecanedutech.podbean.com/
WeCanEduTech FB: facebook.com/WeCanEduTech
How Flash Fill was created www.microsoft.com/en-us/research/blog/flash-fill-gives-excel-smart-charge/
Connect with Jason Matthew on LinkedIN: www.linkedin.com/in/jason-matthew/