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

YouTube

Excel and Business Math - Percentage Change Formulas, Invoicing, Payroll, Finance and More

ExcelIsFun via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn essential business mathematics and Excel formulas through this comprehensive 23-hour course covering percentage calculations, invoicing systems, payroll processing, and financial functions. Master fundamental Excel skills including formula creation, cell referencing, number formatting, and built-in functions while applying them to real-world business scenarios. Explore arithmetic operations, fraction and decimal conversions, and percentage formulas for solving business word problems. Develop expertise in banking calculations, payroll time sheets with overtime calculations, and advanced functions like VLOOKUP and IF statements for commission and piecework calculations. Build practical business templates for trade discounts, invoice creation with cash discounts, markup calculations, and financial planning using Excel's FV, PV, and PMT functions. Practice creating check registers, bank reconciliations, and comprehensive payroll systems while learning time calculations, rounding techniques, and data validation methods to streamline business calculations and eliminate manual calculator work.

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

Reviews

Start your review of Excel and Business Math - Percentage Change Formulas, Invoicing, Payroll, Finance and More

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.