YoVDO

Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses VLOOKUP Function Courses

Course Description

Overview

Dive into a comprehensive 37-minute video tutorial on trade discounts, series discounts, net cost equivalents, and wholesale cost calculations in Excel. Learn essential business terms, explore various methods for calculating wholesale costs, and master the use of VLOOKUP and IF functions to automate calculations. Gain practical skills in handling single and series trade discounts, including scenarios where discounts depend on purchase quantities. Download accompanying Excel files and PDF notes to enhance your learning experience in this Excel and Business Math class taught by Michael Girvin at Highline College.

Syllabus

) Introduction.
) Business Terms: Retail & Wholesale Businesses. List Price and Wholesale Cost. Trade Discount $ Amount..
) Examples of Wholesale Cost Catalogs and the four different formulas needed to calculate Whole Sale Costs under four different assumptions..
) Single Trade Discount % Video Example. See three different Methods to calculate Wholesale Cost..
) Calculate Series Discounts. See three different Methods to calculate Wholesale Cost..
) Series Trade Discount % with Two Successive Discounts.
) Series Trade Discount % where 2nd Discount Depends on Quantity Purchased. Learn how to use VLOOKUP Function..
) Series Trade Discount % where 2nd & 3rd Discount Depends on Quantity Purchased..
) Learn how to use IF & VLOOKUP Functions to make calculations automatic for a Series Discount..
) Summary.


Taught by

ExcelIsFun

Related Courses

A Beginner’s Guide to Data Handling and Management in Excel
Packt via FutureLearn
Introduction to Financial Accounting: The Accounting Cycle
University of California, Irvine via Coursera
ADP Entry-Level Compensation and Benefits Analyst
Coursera
Microsoft Excel: Advanced Data Analysis and Visualisation
Cloudswyft via FutureLearn
Advanced Data Visualisation and Analysis in Excel
Packt via FutureLearn