Главная
Study mode:
on
1
) Introduction
2
) Business Terms: Retail & Wholesale Businesses. List Price and Wholesale Cost. Trade Discount $ Amount.
3
) Examples of Wholesale Cost Catalogs and the four different formulas needed to calculate Whole Sale Costs under four different assumptions.
4
) Single Trade Discount % Video Example. See three different Methods to calculate Wholesale Cost.
5
) Calculate Series Discounts. See three different Methods to calculate Wholesale Cost.
6
) Series Trade Discount % with Two Successive Discounts
7
) Series Trade Discount % where 2nd Discount Depends on Quantity Purchased. Learn how to use VLOOKUP Function.
8
) Series Trade Discount % where 2nd & 3rd Discount Depends on Quantity Purchased.
9
) Learn how to use IF & VLOOKUP Functions to make calculations automatic for a Series Discount.
10
) Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #VLOOKUP Function
0:00 / 0:00
1 of 10

) Introduction