Completed
) 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 ) Introduction
- 2 ) Enter Dates in Excel
- 3 ) Date Number Formatting
- 4 ) Date Math, Date Formulas and Date Functions like EDATE and EOMONTH
- 5 ) Invoices, Different Elements
- 6 ) Shipping Terms, including FOB Shipping and FOB Destination
- 7 ) When Tax is Paid, including selling final item at a whole sale cost
- 8 ) Cash Discounts: Incentive to Pay Invoice Early
- 9 ) Ordinary, Cash Discounts Example 1. First Example and Close look at what Terms Mean.
- 10 ) Ordinary, Cash Discounts Example 2
- 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 ) AS OF, Cash Discounts
- 13 ) ROG, Cash Discounts
- 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 ) Summary