Download Start Excel File: http://ift.tt/2pciCj0
Download pdf Notes: http://ift.tt/2Iohn9b
Entire Class Web Site: http://ift.tt/2BjafuY
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.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction to creating an invoice in Excel
2. (01:30) Format Invoice
3. (02:32) Insert Company Logo and Boomerang Picture
4. (06:01) Calculate Wholesale Cost using a Single Trade Discount
5. (08:30) Data Validation – List to insert Drop-down list of Products
6. (11:29) Exact Match VLOOKUP to get price
7. (13:06) IF and ISTEXT to turn formula off when no product entered
8. (17:01) IF & ISNUMBER for Line Item Total
9. (18:41) SUM Function and other formulas for totals
10. (20:18) Page Setup
11. (21:44) Copy a Sheet using Mouse & Ctrl Key
12. (24:57) CELL, SEARCH, REPLACE and LEFT Functions to get Invoice Number
13. (29:25) Summary
Next Video: 40 Excel & Business Math