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