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.
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
Related Courses
-
Excel Basics - Date & Time Number Formatting, Formulas, Functions & Calculations
-
Date & Time Formulas & Functions in Excel Worksheet and Power Query
-
Excel for Accountants - Formulas, Functions & Formatting to Build Account Templates
-
Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost
-
Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions
-
Excel & Business Math - IF Function, IS Functions & Building a Check Register and Other IF Tricks
