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

Download Start Excel File: http://ift.tt/2FEK4jJ
Download pdf Notes: http://ift.tt/2Hn20MW
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:48) Enter Dates in Excel
3. (03:19) Date Number Formatting
4. (05:44) Date Math, Date Formulas and Date Functions like EDATE and EOMONTH
5. (15:18) Invoices, Different Elements
6. (17:11) Shipping Terms, including FOB Shipping and FOB Destination
7. (19:40) When Tax is Paid, including selling final item at a whole sale cost
8. (20:58) Cash Discounts: Incentive to Pay Invoice Early
9. (22:44) Ordinary, Cash Discounts Example 1. First Example and Close look at what Terms Mean.
10. (33:04) Ordinary, Cash Discounts Example 2
11. (38:53) 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. (48:50) AS OF, Cash Discounts
13. (49:40) ROG, Cash Discounts
14. (51:10) 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. (01:02:42) Summary

Next Video: 39 Excel & Business Math

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.