Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

ExcelIsFun via YouTube Direct link

) Introduction to creating an invoice in Excel

1 of 13

1 of 13

) Introduction to creating an invoice in Excel

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. 1 ) Introduction to creating an invoice in Excel
  2. 2 ) Format Invoice
  3. 3 ) Insert Company Logo and Boomerang Picture
  4. 4 ) Calculate Wholesale Cost using a Single Trade Discount
  5. 5 ) Data Validation - List to insert Drop-down list of Products
  6. 6 ) Exact Match VLOOKUP to get price
  7. 7 ) IF and ISTEXT to turn formula off when no product entered
  8. 8 ) IF & ISNUMBER for Line Item Total
  9. 9 ) SUM Function and other formulas for totals
  10. 10 ) Page Setup
  11. 11 ) Copy a Sheet using Mouse & Ctrl Key
  12. 12 ) CELL, SEARCH, REPLACE and LEFT Functions to get Invoice Number
  13. 13 ) Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.