ExcelIsFun Courses

Full Advanced Data Analysis and BI Class - Power Query, Power Pivot, DAX, M Code, Power BI and Excel

Build refreshable, shareable dashboards and reports with Power Query, Power Pivot, DAX, Excel, and Power BI data models.

• YouTube
• 1 day 5 hours 45 minutes
• Self-Paced
• Free Video

Excel for Statistical Analysis in Business and Economics

Master statistical analysis using Excel with comprehensive coverage of descriptive statistics, probability distributions, hypothesis testing, and data visualization techniques.

• YouTube
• 23 hours 52 minutes
• Self-Paced
• Free Video

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

Master Excel formulas for business calculations including percentages, payroll, invoicing, and finance functions like FV, PV, and PMT in this comprehensive 23-hour tutorial.

• YouTube
• 23 hours 11 minutes
• Self-Paced
• Free Video

Slowly Changing Dimensions Data Modeling Techniques

Master data modeling techniques for slowly changing dimensions using Excel, Power Query, PivotTables, Power Pivot, and Power BI with DAX formulas.

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

Excel Rounding Functions - ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, and More

Learn to use Excel rounding functions for precise totals, payroll calculations, pricing, times, and lookups.

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

Excel Cell References - Relative, Absolute, Mixed, Worksheet, and 3-D References

Learn to use relative, absolute, mixed, worksheet, workbook, and 3-D cell references in Excel formulas.

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

What If Scenario Analysis in Excel

Master What If Scenario Analysis in Excel through hands-on tutorials covering scenario creation, formula input management, and toolbar customization for financial modeling.

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

Build Power Query Custom Function - Convert Multiple CSV Cross Tab Tables into Single Table

Master Power Query custom functions to transform multiple cross-tabulated CSV files into a unified table using M Code and advanced data transformation techniques.

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

Comprehensive Excel Formula Guide - MS 365 Excel Basics - Lesson 7

Master essential Excel formulas, from basic calculations to advanced functions like XLOOKUP, dynamic arrays, and logical operations. Includes hands-on practice with real-world examples and practical applications.

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

MS 365 Excel Basics: Power Query, FlashFill, XLOOKUP, PivotTables, Sort and Filter - 7 Data Analysis Examples

Master essential Excel data analysis tools including Power Query, FlashFill, XLOOKUP, PivotTables, sorting, and filtering through seven practical examples with downloadable practice files and step-by-step guidance.

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

Power Query: A Cleaner Way to Import and Append CSV Files - The Transformative Power of M Code

Master a cleaner approach to importing and appending CSV files in Power Query using M code, including extracting filenames, adding columns, and using let expressions to streamline your data transformation process.

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

Power BI Desktop - Creating Interactive Visuals and Dashboards by Importing Excel Data Models - Lesson 12

Master Power BI Desktop to create interactive dashboards by importing Excel data models, building various visualizations, formatting elements, and implementing features like drill-downs, tool tips, and visual interactions.

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

Power Query Unpivot with 2 Column Variables - Bad Data Into Good Data - Excel Magic Trick 1916

Master Power Query's unpivot technique to transform cross-tabulated data with dual column variables into clean, analyzable datasets using transpose, merge, and split operations.

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

Text Formulas & Functions in Excel Worksheet and Power Query

Learn to join, split, format, search, replace, and clean text in Excel with worksheet formulas and Power Query.

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

Date & Time Formulas & Functions in Excel Worksheet and Power Query

Learn Excel and Power Query date-time formulas for workday calculations, shift hours, fiscal attributes, and PivotTable-ready data.

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