ExcelIsFun Courses

Data Modeling - VLOOKUP, Power Query or Power Pivot?

Learn data modeling techniques using VLOOKUP, Power Query, and Power Pivot for efficient data analysis in Excel. Explore methods for handling multiple tables and creating effective PivotTable reports.

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

The Magic of Power Query to Import, Transform & Load Data

Learn to import, clean, and transform data using Power Query in Excel. Master techniques for efficient data handling, report creation, and automated updates.

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

Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards

Learn to create effective data visualizations in Excel using tables, charts, conditional formatting, and dashboards. Master techniques for clear, impactful data presentation and analysis.

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

PivotTables & Slicers - Create Dashboards & Summary Reports

Master PivotTables, Slicers, and dashboards in Excel. Create cross-tab reports, frequency distributions, and custom calculations for effective data analysis and visualization.

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

Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

Learn to use Excel formulas for data analysis, comparing traditional methods with dynamic arrays. Master SUMIFS, COUNTIFS, and AVERAGEIFS for creating effective summary reports.

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

Data, Proper Data Sets, Excel Tables, Logical Tests, More

Learn essential Excel skills for data analysis: proper data sets, tables, sorting, filtering, and logical tests. Master the basics of handling and extracting insights from raw data efficiently.

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

DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI

Comprehensive guide to DAX iterators and table functions in Excel Power Pivot and Power BI, covering advanced concepts like context transition, cardinality, and performance optimization.

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

Power BI Desktop Comprehensive Introduction - Power Query, DAX, Dashboards, Publishing

Comprehensive Power BI Desktop tutorial covering data import, DAX formulas, dashboard creation, and report publishing. Master essential skills for effective data analysis and visualization.

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

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

Comprehensive guide to Excel Power Pivot, DAX formulas, and functions. Learn data modeling, building relationships, and creating advanced calculations for powerful business intelligence dashboards.

• YouTube
• 2 hours 4 minutes
• On-Demand
• Free Video

Comprehensive Excel Dynamic Array Formula Lesson - The Power of Array Formulas

Explore Excel's new dynamic array formulas and functions, enhancing data analysis with spill ranges, UNIQUE, FILTER, SORT, and more. Master advanced techniques for efficient spreadsheet manipulation and reporting.

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

Mysteries of VLOOKUP Function Revealed - Amazing Examples

Comprehensive tutorial on VLOOKUP function in Excel, covering 15 examples from basic to advanced usage, including exact and approximate matches, dynamic tables, and error handling.

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

Power BI M Code for Moving Annual Total - Custom Function Power Query Custom Column

Learn to create custom functions in Power BI for calculating Moving Annual Totals using M code. Master advanced data transformation techniques and optimize performance with table buffering.

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

Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More

Comprehensive introduction to M Code in Power Query, covering values, expressions, functions, and advanced techniques for efficient data manipulation and analysis.

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

Power Query Group By Feature and Table.Group Function - Examples

Learn Power Query's Group By feature with five practical examples, including calculating totals, standard deviation, joining names, and ranking sales.

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

Power Query - 6 Types of Joins, 6 Types of Merges - 9 Examples

Explore Power Query's 6 types of joins and merges through 9 practical examples, enhancing your data analysis skills in Excel with step-by-step guidance.

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