Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm
This video teaches:
1) Flash Fill = Program by example
i. You give Excel one or more examples to the right of your data, and it tries to figure out what you want.
ii. If Excel can see your "Pattern", it will perform the action
iii. Actions include:
1. Combine, Extract, Insert, Reverse
iv. Flash Fill works on" Text, Numbers, Dates, Times
v. Keyboard to run Flash Fill: Ctrl + E
vi. Flash Fill is in the Data Tools group in the Data Ribbon Tab

Highline Community College Busn 216 Computer Applications Class Office 2013 (Fun With Computers) taught by Michael Girvin. Excel Basics. Learn Excel, How To Excel.