ExcelIsFun Courses

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video

Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions

Master Excel date functions, invoice elements, and cash discounts. Learn to perform date math, use nested IF functions, and understand various discount types for efficient business calculations.

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

Excel & Business Math - Trade Discounts, Series Discounts, Net Cost Equivalents & Wholesale Cost

Learn to calculate trade discounts and wholesale costs using Excel functions like VLOOKUP and IF. Master business terms and automate calculations for single and series discounts in retail and wholesale scenarios.

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

Excel and Business Math - VLOOKUP and MAX Functions for Percentage Method Federal Income Tax Deduction

Learn to calculate federal income tax withholdings using VLOOKUP and MAX functions in Excel, with practical examples for different marital statuses and pay periods.

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

Excel & Business Math - VLOOKUP Function for Incentive Pay: Commissions & Piecework

Master VLOOKUP for incentive pay calculations, including piecework and commissions. Learn to create lookup tables and apply VLOOKUP for various business scenarios with 15 practical examples.

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