ExcelIsFun Courses

Microsoft 365 Excel - Date and Time Formulas, Functions and Formatting - Part 4

Master essential Excel date and time functions, including serial numbers, formatting, calculations for payroll, project timelines, and workday management with practical examples and formulas.

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

Excel Lookup Functions: XLOOKUP, FILTER, XMATCH, LOOKUP, and SWITCH - Part 6

Master Excel's powerful lookup functions including XLOOKUP, FILTER, XMATCH, and SWITCH through hands-on examples and practical applications for data analysis and management tasks.

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

Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation - EMT 1922

Master Excel's SCAN function to create dynamic spilled array formulas for automatic bank reconciliation, running totals, and advanced accounting tasks with relative cell references.

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

Excel Formula to UnPivot: Convert Cross-Tab Table to Proper Table Using LAMBDA - EMT 1887

Master the process of unpivoting cross-tabulated tables in Excel using advanced formulas. Create reusable functions with LAMBDA and LET to efficiently transform data without Power Query.

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

Excel Formulas for Accounting Bank Reconciliation with IF, ISNUMBER and SUM Functions - EMT 1921

Master bank reconciliation in Excel using IF, ISNUMBER & SUM functions to automatically calculate book and bank balances with efficient formulas and avoid common errors.

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

FILTER Function and Logical Test Made Easy with BYROW and AND Functions - Excel Magic Trick 1912

Master Excel's FILTER function with AND logical tests using three methods: helper columns, multiplication operators, and BYROW & AND functions for dynamic data extraction.

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

COUNTIFS, GROUPBY and LET Functions - Create Amazing Single Cell Dynamic Spilled Array Report - EMT 1901

Master advanced Excel array formulas using COUNTIFS, GROUPBY & LET to build dynamic single-cell reports that count and list customers by coupon groups with 22 functions.

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

Fixing N/A Errors in XLOOKUP and VLOOKUP - Hidden Characters Problem

Master troubleshooting techniques for #N/A errors in Excel lookups by identifying and fixing hidden characters using functions like CODE, CHAR, REGEXREPLACE, and advanced formulas.

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

Excel Logical Functions and IF Statements - Advanced Tutorial

Master Excel's logical functions through 14 practical examples, from basic IF statements to advanced combinations with XLOOKUP, AND, OR, and NOT operators for powerful data analysis and automation.

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

Power Query Custom Function with Parameter to Get and Transform Multiple CSV Files Data - EMT 1919

Master Power Query custom functions with parameters to efficiently import and transform multiple CSV files into a unified dataset using M Code techniques.

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

Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas - MS 365 Excel Basics #13

Master creating a Power BI dashboard using SQL data with 7 million rows, DAX formulas, and Power Query to build interactive gross profit visualizations including maps and comparative measures.

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

Excel Basics - Power Pivot, Data Model, Relationships, DAX Measures, and Filter Context - Lesson 11

Master Power Pivot in Excel by learning data modeling, relationships, DAX measures, and filter context. Create effective reports with practical examples and avoid common pitfalls in data model implementation.

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

PIVOTBY & GROUPBY Functions: 10 Mind-Blowing Examples - MS 365 Excel Basics #9

Master PIVOTBY & GROUPBY functions in Excel with 10 practical examples, from creating dynamic reports to connecting with charts, all with instant updates that outperform traditional PivotTables.

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

MS 365 Excel Basics: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips - Part 8

Master Excel data analysis tools including PivotTables, Slicers, Charts, and Conditional Formatting to transform raw data into meaningful information and create dynamic, visual reports.

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

Power Query Nested Functions in Custom Column - Convert Multiple CSV Files into One Table - EMT 1918

Master nested Power Query functions to transform multiple CSV files with cross-tabulated data into a single, properly structured table using advanced M Code techniques.

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