ExcelIsFun Courses

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

3 reviews

Master Excel data analysis and BI with ExcelIsFun's 6-hour program. Learn to use Power Tools, create visualizations, build data models, and share reports for effective decision-making.

• YouTube
• 6 hours
• On-Demand
• Free Online Course

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

3 reviews

Learn to calculate FICA deductions and net pay using Excel's MEDIAN function with ExcelIsFun. Ideal for mastering payroll tax hurdles in under an hour.

• YouTube
• 39 minutes
• On-Demand
• Free Online Course

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

1 review

Master M Code basics to advanced levels with ExcelIsFun's 1-2 hour program. Learn Power Query in Excel & Power BI, create custom functions, and understand data types.

• YouTube
• 1 hour 42 minutes
• On-Demand
• Free Online Course

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

1 review

Master Excel with ExcelIsFun's 1-2 hour program. Learn to create formulas, PivotTables, charts, and more to enhance efficiency and productivity.

• YouTube
• 1 hour 2 minutes
• On-Demand
• Free Online Course

Power BI Desktop - Data Modeling & Interactive Visualizations

1 review

ExcelIsFun offers a concise introduction to data modeling and visualization in Power BI Desktop, covering Power Query, DAX formulas, and data model visualizations in under an hour.

• YouTube
• 38 minutes
• On-Demand
• Free Online Course

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

1 review

Learn to create a comprehensive payroll table using Excel with ExcelIsFun. Master functions like SUMIFS, MROUND, MOD, VLOOKUP in under an hour.

• YouTube
• 29 minutes
• On-Demand
• Free Online Course

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

1 review

Learn to calculate present and future values, and periodic payments for annuities using Excel in less than an hour with ExcelIsFun.

• YouTube
• 51 minutes
• On-Demand
• Free Online Course

Visualizing Data and Building Dashboards in Excel & Power BI

Learn to visualize data and build dashboards in Excel & Power BI with ExcelIsFun. Master tables, charts, PivotTables, Power Query, and more in just 1-2 hours.

• YouTube
• 1 hour 42 minutes
• On-Demand
• Free Online Course

Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know

Master Excel's LAMBDA function with ExcelIsFun's 1-2 hour program. Learn from Excel MVP Mike Girvin about Defined Names, LET function, and creating Single Cell Formula Reports.

• YouTube
• 1 hour 45 minutes
• On-Demand
• Free Online Course

Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

ExcelIsFun offers a 1-2 hour program on Excel array formulas and functions, taught by Excel MVP Mike Girvin, covering topics from fundamentals to advanced applications.

• YouTube
• 1 hour 10 minutes
• On-Demand
• Free Online Course

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

Master Excel lookup formulas with ExcelIsFun's 1-2 hour program. Learn from Excel MVP Mike Girvin on topics like XLOOKUP, XMATCH, FILTER, and more.

• YouTube
• 1 hour 19 minutes
• On-Demand
• Free Online Course

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Master Excel logical tests with ExcelIsFun's 1-2 hour online material, covering formulas, conditional formatting, PivotTables, Power Query, and more, taught by Excel MVP Mike Girvin.

• YouTube
• 1 hour 48 minutes
• On-Demand
• Free Online Course

Power Query Group By - Complete Lesson with 10 Examples

Learn to use the Group By feature in Power Query with ExcelIsFun. This under 1-hour material covers basics to advanced lessons with 10 practical examples for data analysis.

• YouTube
• 34 minutes
• On-Demand
• Free Online Course

How to Build Data Model and DAX Formulas in Power Pivot

Learn to build data models and DAX formulas in Power Pivot with ExcelIsFun. Master Power Query, create relationships between tables, and design dashboards in 1-2 hours.

• YouTube
• 1 hour 5 minutes
• On-Demand
• Free Online Course

Transform Data Sets Using Advanced Filter - Excel 2016

Learn to transform data sets using advanced Excel filters with ExcelIsFun. Master AND/OR logical tests, complex criteria, and formula criteria in under an hour.

• YouTube
• 34 minutes
• On-Demand
• Free Online Course