Highline Excel 2013 Class Video 30


Custom Number Formatting & Text Functions, (33 Examples)

DESCRIPTION

Topics in this video:
1. 23 Examples of Custom Number Formatting.
2. Custom Number Formatting For Unit Price for Invoice.
3. Three TEXT function examples for creating labels.
4. Extract First Name formula using LEFT and SEARCH.
5. LEN function.
6. Extract Last Name formula using REPLACE and SEARCH functions.
7. Extract Last Name formula using SUBSTITUTE function.
8. Create e-mail address from employee names using LOWER, LEFT, SEARCH, REPLACE functions.
9. Flash Fill to create e-mail address from employee names.
10. TEXT function to create time from Text Time Items and the backslash character to insert a character into a Custom Number formatting.
11. Flash Fill to create time from Text Time Items.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 168 times – 21 MB




Be the first to comment

Leave a Reply