Completed
Free Excel Business Math & Formulas Course at YouTube
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel and Business Math - Percentage Change Formulas, Invoicing, Payroll, Finance and More
Automatically move to the next video in the Classroom when playback concludes
- 1 Free Excel Business Math & Formulas Course at YouTube
- 2 Excel & Business Math 01: Introduction to Excel. Why We Use Excel for Math. First Formula.
- 3 Excel & Business Math 02: Copying Formulas with Relative & Absolute Cell References
- 4 Excel & Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models
- 5 Excel & Business Math 04: Excel Built-in Functions, Data Types and Keyboards are Fast!
- 6 Excel & Business Math 05: Number Formatting & When You MUST Use ROUND Function
- 7 Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class
- 8 Excel & Business Math 07: Style Formatting Format Painter, Mini Toolbar, Styles, Clear Format & More
- 9 Excel & Business Math 08: Arithmetic Tips for Add, Subtract, Multiply, Divide, Exponents, Rounding
- 10 Excel & Business Math 09: Five Steps to Solve Math Word Problems in Excel
- 11 Excel & Business Math 10: Division, Fractions, Decimals, Percentages: Number Formatting & Formulas
- 12 Excel & Business Math 11: Types Of Fractions & Fraction Number Formatting
- 13 Excel & Business Math 12: Reducing Fractions, Prime Factors and Understanding & Calculating Ratios
- 14 Excel & Business Math 13: Mixed Number to Improper Fraction, Improper Fraction to Mixed Number
- 15 Excel & Business Math 14: Convert Decimal To Fraction & Convert Fraction To Decimal
- 16 Excel & Business Math 15: Multiplying and Dividing Fractions By Hand & In Excel
- 17 Excel & Business Math 16: Fun With Adding & Subtracting Fractions & Least Common Denominator
- 18 Excel & Business Math 17: Solve Fractional Business Math Problems using Excel
- 19 Excel & Business Math 18 Percents & Percentage Number Formats (including Fractional Percents)
- 20 Excel & Business Math 19: Round a Percent using ROUND Function & Rate of Change Formula
- 21 Excel & Business Math 20: Percent Formulas for Part, Rate & Base (8 Example)
- 22 Excel & Business Math 21: Percent Formulas & Business Math Word Problems
- 23 Excel & Business Math 22: Rate Formula for Common Size Income Statement using Mixed Cell Reference
- 24 Excel & Business Math 23: Important Formulas for Increase Decrease Problems (8 Awesome Examples)
- 25 Excel & Business Math 24: COUNTIFS Function & Part/Base for Probabilities & Frequency Distributions
- 26 Excel & Business Math 25: Percentage Formulas to Help Calculate a Budgeted Forecast for Next Year
- 27 Excel & Business Math 26: Is Rate of Change Same for Increase by $10 and Decrease by $10?
- 28 Excel & Business Math 27: Bank Reconciliation Made Easy
- 29 Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too
- 30 Excel & Business Math 29: Time Number Formatting & Time Calculations in Excel for Payroll Table
- 31 Excel & Business Math 30: Payroll Time Sheets, IF Function, Sheet Reference for Overtime & Gross Pay
- 32 Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples)
- 33 Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND
- 34 Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples)
- 35 Excel & Business Math 34: MEDIAN Function for FICA Social Security & Medicare Payroll Deductions
- 36 Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction
- 37 Excel & Business Math 36: Comprehensive Excel Payroll Example: SUMIFS, MROUND, MOD, VLOOKUP & More
- 38 Excel & Business Math 37: Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost
- 39 Excel & Business Math 38: Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
- 40 Excel & Business Math 39: Create Excel Invoices, Data Validation Drop-down, VLOOKUP & IF Functions
- 41 Excel & Business Math 40: Partial Payment on Invoice with Cash Discount, Credit to Account Balance?
- 42 Excel & Business Math 41: Markup On Cost or Markup On Sell Price? Calculate & How They Are Different
- 43 Excel & Business Math 42: Simple Interest Calculations & Short Term Loans
- 44 Excel & Business Math 43: Compound Interest Calculating Future Value of a Lump Sum FV Excel Function
- 45 Excel & Business Math 44: What is Present Value? Calculate Present Value Of Lump Sum Amount.
- 46 Excel & Business Math 45: Future Value, Present Value and Periodic Payments for Annuities
