Download Start Excel File: http:\/\/ift.tt\/2pciCj0
\nDownload pdf Notes: http:\/\/ift.tt\/2Iohn9b
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
In this video learn how to create an Invoice that you can use over and over using Data Validation Drop-down, VLOOKUP, ISTEXT, ISNUMBER & IF Functions. Also see how to create a formula to extract Invoice Number from Sheet name using the CELL, REPLACE, SEARCH and LEFT Functions.
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction to creating an invoice in Excel
\n2. (01:30) Format Invoice
\n3. (02:32) Insert Company Logo and Boomerang Picture
\n4. (06:01) Calculate Wholesale Cost using a Single Trade Discount
\n5. (08:30) Data Validation – List to insert Drop-down list of Products
\n6. (11:29) Exact Match VLOOKUP to get price
\n7. (13:06) IF and ISTEXT to turn formula off when no product entered
\n8. (17:01) IF & ISNUMBER for Line Item Total
\n9. (18:41) SUM Function and other formulas for totals
\n10. (20:18) Page Setup
\n11. (21:44) Copy a Sheet using Mouse & Ctrl Key
\n12. (24:57) CELL, SEARCH, REPLACE and LEFT Functions to get Invoice Number
\n13. (29:25) Summary<\/p>\n
Next Video: 40 Excel & Business Math<\/p>\n