Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples) скачать в хорошем качестве

Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples)

Download workbook: http://people.highline.edu/mgirvin/Al... This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. 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)