Completed
) Exact Match VLOOKUP to get price
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to creating an invoice in Excel
- 2 ) Format Invoice
- 3 ) Insert Company Logo and Boomerang Picture
- 4 ) Calculate Wholesale Cost using a Single Trade Discount
- 5 ) Data Validation - List to insert Drop-down list of Products
- 6 ) Exact Match VLOOKUP to get price
- 7 ) IF and ISTEXT to turn formula off when no product entered
- 8 ) IF & ISNUMBER for Line Item Total
- 9 ) SUM Function and other formulas for totals
- 10 ) Page Setup
- 11 ) Copy a Sheet using Mouse & Ctrl Key
- 12 ) CELL, SEARCH, REPLACE and LEFT Functions to get Invoice Number
- 13 ) Summary
