Download Start Excel File: http:\/\/ift.tt\/2FEK4jJ
\nDownload pdf Notes: http:\/\/ift.tt\/2Hn20MW
\nEntire Class Web Site: http:\/\/ift.tt\/2BjafuY<\/p>\n
In this video learn how to
\nExcel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College \/ Mike Girvin at excelisfun Channel at YouTube Channel.
\nTopics in Video:
\n1. (00:01) Introduction
\n2. (00:48) Enter Dates in Excel
\n3. (03:19) Date Number Formatting
\n4. (05:44) Date Math, Date Formulas and Date Functions like EDATE and EOMONTH
\n5. (15:18) Invoices, Different Elements
\n6. (17:11) Shipping Terms, including FOB Shipping and FOB Destination
\n7. (19:40) When Tax is Paid, including selling final item at a whole sale cost
\n8. (20:58) Cash Discounts: Incentive to Pay Invoice Early
\n9. (22:44) Ordinary, Cash Discounts Example 1. First Example and Close look at what Terms Mean.
\n10. (33:04) Ordinary, Cash Discounts Example 2
\n11. (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.
\n12. (48:50) AS OF, Cash Discounts
\n13. (49:40) ROG, Cash Discounts
\n14. (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.
\n15. (01:02:42) Summary<\/p>\n
Next Video: 39 Excel & Business Math<\/p>\n