Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Dive into an extensive video tutorial on Excel and business mathematics, focusing on date calculations, invoice management, and cash discounts. Learn to enter and format dates in Excel, perform date math using formulas and functions like EDATE and EOMONTH, and understand various invoice elements including shipping terms and tax considerations. Master the concept of cash discounts as incentives for early invoice payment, exploring ordinary, AS OF, ROG, and EOM discount types. Practice with multiple examples, including nested IF functions for complex discount scenarios. Gain practical skills in using Excel for business finance applications, with downloadable start files and comprehensive notes available to supplement your learning experience.

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

Reviews

Start your review of Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

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.