ExcelIsFun Courses

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.

• YouTube
• 31 minutes
• On-Demand
• Free Video

Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

Master Excel date functions, invoice elements, and cash discounts. Learn to perform date math, use nested IF functions, and understand various discount types for efficient business calculations.

• YouTube
• 1 hour 5 minutes
• On-Demand
• Free Video

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

Learn to calculate trade discounts and wholesale costs using Excel functions like VLOOKUP and IF. Master business terms and automate calculations for single and series discounts in retail and wholesale scenarios.

• YouTube
• 37 minutes
• On-Demand
• Free Video

Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.

• YouTube
• 30 minutes
• On-Demand
• Free Video

Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework

Master VLOOKUP for incentive pay calculations, including piecework and commissions. Learn to create lookup tables and apply VLOOKUP for various business scenarios with 15 practical examples.

• YouTube
• 1 hour 21 minutes
• On-Demand
• Free Video

Excel & Business Math - IF Function, IS Functions & Building a Check Register and Other IF Tricks

Learn to create a check register using Excel's IF and IS functions, with practical applications of conditional formatting, data validation, and advanced formula techniques.

• YouTube
• 32 minutes
• On-Demand
• Free Video

Excel & Business Math - Bank Reconciliation Made Easy

Learn bank reconciliation concepts, Excel techniques for side-by-side worksheets, and conditional formatting. Master check components, endorsements, and bank services while practicing reconciliation examples.

• YouTube
• 45 minutes
• On-Demand
• Free Video

Excel & Business Math - Important Formulas for Increase Decrease Problems

Learn essential formulas for solving increase and decrease problems in Excel, with practical examples from finance, real estate, and business to enhance your data analysis skills.

• YouTube
• 1 hour
• On-Demand
• Free Video

Excel & Business Math - Percent Formulas for Part, Rate & Base

Master percent formulas for Part, Rate, and Base with 8 practical examples. Learn a memorization trick and apply these universal calculations to transform your business math skills.

• YouTube
• 33 minutes
• On-Demand
• Free Video

Excel & Business Math - Percents & Percentage Number Formats Including Fractional Percents

Master percentage calculations and Excel formatting techniques, including fractional percentages. Learn to convert, recognize, and apply percentages in business contexts with practical examples.

• YouTube
• 38 minutes
• On-Demand
• Free Video

Excel & Business Math - Fun With Adding & Subtracting Fractions & Least Common Denominator

Learn to add and subtract fractions efficiently using the "LCD Times One Method" with practical examples on paper and in Excel. Enhance your math skills through engaging exercises and clear explanations.

• YouTube
• 33 minutes
• On-Demand
• Free Video

Excel & Business Math - Reducing Fractions, Prime Factors and Understanding & Calculating Ratios

Master fraction reduction, prime factors, and ratio calculations in Excel and by hand. Learn practical techniques for simplifying fractions and understanding the meaning behind ratios.

• YouTube
• 36 minutes
• On-Demand
• Free Video

Excel & Business Math - Division, Fractions, Decimals, Percentages - Number Formatting & Formulas

Master division, fractions, decimals, and percentages in Excel. Learn number formatting, formulas, and practical applications for business math, with hands-on examples and formatting tips.

• YouTube
• 32 minutes
• On-Demand
• Free Video

Excel & Business Math - Five Steps to Solve Math Word Problems in Excel

Master Excel's five-step approach to solve math word problems efficiently. Learn to translate English to math symbols, tackle retail calculations, and handle complex unit conversions.

• YouTube
• 53 minutes
• On-Demand
• Free Video

Excel & Business Math - Arithmetic Tips for Add, Subtract, Multiply, Divide, Exponents, Rounding

Learn essential Excel formula tricks for basic math operations, including addition, subtraction, multiplication, division, exponents, and rounding. Enhance your spreadsheet skills and efficiency.

• YouTube
• 56 minutes
• On-Demand
• Free Video