Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

ExcelIsFun via YouTube Direct link

) Introduction

1 of 15

1 of 15

) Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) Enter Dates in Excel
  3. 3 ) Date Number Formatting
  4. 4 ) Date Math, Date Formulas and Date Functions like EDATE and EOMONTH
  5. 5 ) Invoices, Different Elements
  6. 6 ) Shipping Terms, including FOB Shipping and FOB Destination
  7. 7 ) When Tax is Paid, including selling final item at a whole sale cost
  8. 8 ) Cash Discounts: Incentive to Pay Invoice Early
  9. 9 ) Ordinary, Cash Discounts Example 1. First Example and Close look at what Terms Mean.
  10. 10 ) Ordinary, Cash Discounts Example 2
  11. 11 ) Ordinary, Cash Discounts Example 3. This example shows what to do if you have two discount opportunities, including how to use Two IF Functions in a single formula, known as Nesting If Functions.
  12. 12 ) AS OF, Cash Discounts
  13. 13 ) ROG, Cash Discounts
  14. 14 ) EOM, Cash Discounts. Including the EOMONTH Function and how to use a Logical Value (TRUE / FALSE) value in a formula as a 0 or 1.
  15. 15 ) 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.