ExcelIsFun Courses

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

Create reusable Excel invoices with product drop-downs, VLOOKUP price retrieval, conditional formulas, totals, and automatically incrementing invoice numbers.

• YouTube
• 31 minutes
• Self-Paced
• Free Video

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

Use Excel date math and nested IF formulas to calculate invoice totals, shipping and tax, and cash discounts under ordinary, AS OF, ROG, and EOM terms.

• YouTube
• 1 hour 5 minutes
• Self-Paced
• Free Video

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

Calculate wholesale costs from single and series trade discounts, including quantity-dependent discounts automated with Excel’s IF and VLOOKUP functions.

• YouTube
• 37 minutes
• Self-Paced
• Free Video

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

Use Excel’s VLOOKUP function and lookup tables to automate piecework and commission-pay calculations across payroll examples.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video

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

Use Excel’s IF and IS functions to build a checkbook register with balance formulas, validation, and conditional formatting.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

Excel & Business Math - Important Formulas for Increase Decrease Problems

Learn to solve percentage increase and decrease problems in Excel using table and diagram methods, formulas, and examples from finance, sales, property, and pricing.

• YouTube
• 1 hour
• Self-Paced
• Free Video

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

Learn three equivalent percent formulas for solving Part, Rate, and Base in eight practical business calculations.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

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

Learn to convert percents and fractional percents and display them accurately in Excel with built-in and custom number formats.

• YouTube
• 38 minutes
• Self-Paced
• Free Video

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

Learn to add and subtract unlike fractions by hand with the “LCD Times One Method,” then verify the work using Excel’s LCM function.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

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

Reduce fractions by hand and in Excel, then use units to understand and calculate ratios and rates.

• YouTube
• 36 minutes
• Self-Paced
• Free Video

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

Learn how Excel represents division, fractions, decimals, and percentages while avoiding percentage-formatting pitfalls in tax and savings calculations.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

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

Learn five steps for translating word problems into efficient Excel formulas, checking calculations, and writing answers through theater, retail, conservation, and trucking examples.

• YouTube
• 53 minutes
• Self-Paced
• Free Video

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

Learn practical Excel formula techniques for arithmetic, including checking calculations and rounding money amounts correctly.

• YouTube
• 56 minutes
• Self-Paced
• Free Video

Excel & Business Math - All About Excel Formulas for Business Math Class

Learn to build, evaluate, copy, and troubleshoot Excel formulas through business math examples, operators, functions, and a practical formula checklist.

• YouTube
• 47 minutes
• Self-Paced
• Free Video

Excel and Business Math - Number Formatting and When You Must Use Round Function

Learn why Excel number formatting can disguise underlying values and when the ROUND function is essential for accurate money calculations.

• YouTube
• 33 minutes
• Self-Paced
• Free Video