Download workbook: people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm
Topics in this video:
1. 23 Examples of Custom Number Formatting (00:18 min)
2. Custom Number Formatting For Unit Price for Invoice (15:33 min)
3. Three TEXT function examples for creating labels (16:26 min)
4. Extract First Name formula using LEFT and SEARCH (18:55 min)
5. LEN function (20:13 min)
6. Extract Last Name formula using REPLACE and SEARCH functions (21:38 min)
7. Extract Last Name formula using SUBSTITUTE function (23:15 min)
8. Create e-mail address from employee names using LOWER, LEFT, SEARCH, REPLACE functions (42:10 min)
9. Flash Fill to create e-mail address from employee names (26:00 min)
10. TEXT function to create time from Text Time Items and the backslash character to insert a character into a Custom Number formatting (Barry Houdini Trick) (27:52 min)
11. Flash Fill to create time from Text Time Items (29:43 min)
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.
Be sure to download the workbook to follow along with the examples. They are found on the official course website.