Topic: Buying & Selling
Video/Class
Project 37:
Video to watch:
Excel & Business Math 37: Trade Discounts,
Series Discounts, Net Cost Equivalents & Wholesale Cost ( 35:22 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo37TradeDiscounts.xlsx
Handout to download: ExcelBusinessMathVideo37TradeDiscounts.pdf
Assigned Homework: HW #1 - 4 at end of Excel Workbook for this video.
Video/Class
Project 38:
Video to watch:
Excel & Business Math 38: Date Math, Invoices, Cash
Discounts on Invoices, Nested IF Functions
( 1 hour & 04:43 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo38CashDiscounts.xlsx
Handout to download: ExcelBusinessMathVideo38CashDiscounts.pdf
Assigned Homework: HW #1 - 17 at end of Excel Workbook for this video.
Video/Class
Project 39:
Video to watch:
Excel & Business Math 39: Create Excel Invoices, Data
Validation Drop-down, VLOOKUP & IF Functions
( 30:31 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo39Invoices.xlsx
Handout to download: ExcelBusinessMathVideo39Invoices.pdf
Assigned Homework: HW #1 at end of Excel Workbook for this video.
Video/Class
Project 40:
Video to watch: Excel
& Business Math 40: Partial Payment on Invoice with Cash Discount, Credit to
Account Balance?
( 11:30 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo40PartialPayments.xlsx
Handout to download:
ExcelBusinessMathVideo40PartialPayments.pdf
Assigned Homework: HW #1 - 3 at end of Excel Workbook for this video.
Video/Class
Project 41:
Video to watch:
Excel & Business Math 41: Markup On Cost or Markup On
Sell Price? Calculate & How They Are Different ( 24:36 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo41Markup.xlsx
Handout to download: ExcelBusinessMathVideo41Markup.pdf
Assigned Homework: HW #1 - 6 at end of Excel Workbook for this video.
ExcelBusinessMathVideo41Markup.xlsx (not ready for download)