ExcelIsFun Courses

Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools

67 ratings

Turn real-world datasets into refreshable Excel and Power BI reports and dashboards for business decision-making.

• YouTube
• 6 hours
• Self-Paced
• Free Video

Excel Business Analytics - Forecasting, Linear Programming, Simulation and More

3 ratings

Master Excel business analytics through forecasting, linear programming, Monte Carlo simulation, Power Query data transformation, and statistical modeling techniques.

• YouTube
• 19 hours 18 minutes
• Self-Paced
• Free Video

Excel & Business Math - MEDIAN Function for FICA Social Security & Medicare Payroll Deductions

3 ratings

Use Excel’s MEDIAN function to calculate FICA Social Security and Medicare payroll deductions across tax-rate thresholds.

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

How to Build Excel Dashboard - PivotTable, Chart, Conditional Formatting

3 ratings

Build a refreshable Excel dashboard from text files using Power Query, Power Pivot, DAX measures, PivotTables, charts, slicers, and conditional formatting.

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

Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

3 ratings

Build a complete Excel payroll table with time calculations, overtime, gross pay, tax deductions, and net pay using formulas such as SUMIFS and VLOOKUP.

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

Power BI Desktop - Data Modeling & Interactive Visualizations

2 ratings

Build a Power BI data model from Excel files, then use DAX to create interactive gross-profit and units visualizations.

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

Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup

2 ratings

Learn Excel’s grid, formatting, formulas, relative and absolute cell references, page setup, and worksheet management by building a gradebook.

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

Excel Finance - Cash Flow Analysis, Stocks, Bonds and Model Building

2 ratings

Master Excel-based financial analysis including cash flow valuation, stock and bond pricing, capital budgeting, and risk assessment through comprehensive hands-on model building.

• YouTube
• 20 hours 58 minutes
• Self-Paced
• Free Video

Calculate DAX Function and Filter Context - ALLSELECTED and KEEPFILTERS

1 rating

Explore how DAX CALCULATE changes filter context, with ALL, ALLSELECTED, KEEPFILTERS, context transition, and table filters in Power BI and Excel PowerPivot.

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

Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions

1 rating

Build a refreshable Excel dashboard by combining Power Query ETL, Power Pivot data models, relationships, and DAX measures.

• YouTube
• 2 hours 4 minutes
• Self-Paced
• Free Video

Excel and Business Math - Future Value, Present Value and Periodic Payments for Annuities

1 rating

Use Excel’s FV, PV, and PMT functions to value irregular and periodic cash flows, savings plans, retirement withdrawals, and mortgages.

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

Excel Basics - Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data

1 rating

Learn Excel’s Sort, Filter, and Flash Fill features to organize, extract, and clean structured data.

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

The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

1 rating

An introduction to Excel using formulas, dynamic tables, PivotTables, charts, keyboard shortcuts, and Flash Fill to organize and analyze data.

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

M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions

1 rating

Learn M code for Power Query in Excel and Power BI, from let expressions and values to lookups and reusable custom functions.

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

Excel & Business Math - Bank Reconciliation Made Easy

1 rating

Learn to reconcile bank statements with a checkbook register in Excel, using reconciliation forms and worksheet tools to verify matching balances.

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