Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Enter Dates in Excel.
) Date Number Formatting.
) Date Math, Date Formulas and Date Functions like EDATE and EOMONTH.
) Invoices, Different Elements.
) Shipping Terms, including FOB Shipping and FOB Destination.
) When Tax is Paid, including selling final item at a whole sale cost.
) Cash Discounts: Incentive to Pay Invoice Early.
) Ordinary, Cash Discounts Example 1. First Example and Close look at what Terms Mean..
) Ordinary, Cash Discounts Example 2.
) 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..
) AS OF, Cash Discounts.
) ROG, Cash Discounts.
) 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..
) Summary.
Taught by
ExcelIsFun