ExcelIsFun Courses

Power Query - Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook

Master Excel's Power Query to efficiently append tables, handle recursion issues, and manipulate data using advanced functions like Excel.CurrentWorkbook and Table.ColumnNames.

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

Power Query - Import Multiple Excel Files and Combine into Proper Data Set

Learn to import and combine multiple Excel files using Power Query, create a unified dataset, and build dynamic PivotTable reports with automated updates when new files are added.

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

Power Query Introduction - Importing & Transformation Data in Excel & Power BI Desktop

Comprehensive introduction to Power Query for data importing, cleaning, and transformation in Excel and Power BI Desktop, with practical examples and hands-on exercises.

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

Data Analysis Business Intelligence Terms - Microsoft Power Tools for Data Analysis Class

Comprehensive overview of data analysis and business intelligence concepts, including data types, models, and database structures for effective data management and analysis.

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

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

Transform invoice data into a star schema using Power Query, creating a single fact table for improved reporting and analysis in Power BI Desktop.

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

Excel and Business Math - Compound Interest Calculating Future Value of a Lump Sum FV Excel Function

Master compound interest calculations using Excel's FV function. Learn to compare simple and compound interest, analyze cash flow direction, and apply formulas for various investment scenarios.

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

Excel & Business Math - Simple Interest Calculations & Short Term Loans

Learn to calculate simple interest, solve for principal, rate, and time in Excel. Master essential formulas for short-term loans and financial calculations.

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

Visualizing Data and Building Dashboards in Excel & Power BI

Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.

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

Fundamentals of DAX in Power BI & Power Pivot

Comprehensive tutorial on DAX fundamentals for Power BI and Power Pivot, covering key concepts, functions, and advanced techniques to enhance data analysis and reporting skills.

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

Power Query Group By - Complete Lesson with 10 Examples

Comprehensive tutorial on Power Query's Group By feature, covering basic to advanced applications with 10 practical examples for data analysis and calculations in Excel.

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

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

Master Excel array formulas with 50 practical examples, covering fundamental concepts, advanced functions, and real-world applications for data analysis and reporting.

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

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

Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.

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

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

Master Excel's logical functions, formulas, and advanced features. Learn to create powerful data analysis tools using PivotTables, conditional formatting, and Power Query for efficient data management.

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

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

Comprehensive guide to Excel's LAMBDA function, covering creation of reusable functions, helper functions, recursion, and advanced reporting techniques for enhanced spreadsheet efficiency.

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

Create Excel Invoices, Data Validation Drop-Down, VLOOKUP & IF Functions

Learn to create reusable Excel invoices using advanced functions like VLOOKUP, IF, and data validation. Master invoice formatting, calculations, and automated invoice numbering for efficient business operations.

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