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

YouTube

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

ExcelIsFun via YouTube

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
This course teaches how to calculate Trade Discounts (Single and Series) to determine Wholesale Cost, understand Business Terms, and utilize VLOOKUP and IF Functions for automated calculations in Excel. The teaching method includes video examples and explanations. The course is intended for individuals interested in improving their Excel skills for business math applications.

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

Reviews

Start your review of Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

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.