Featured Videos from our Excel, Power BI, Python in Excel, and Excel Modeling Courses

Excel Modeling Course Videos

Sample videos from the course Excel Modeller

View Course

Data Tables Advanced

Use unlimited variables and create unlimited results! Magic!

Watch Video

Arixcel Add-in Demo

Awesome Excel add-in that saves time and reduces risk!

Watch Video

Goal Seek

Excel calculates the input to deliver a defined output! Super useful in commercial analysis and modelling!

Watch Video

INDEX in Modelling

Create dynamic calculations using financial modelling's most important and versatile function!

Watch Video

Power BI, Power Query & Power Pivot Videos

Sample videos from the courses Power BI: Monthly Financial Reporting and Power Query & Pivot: Automating Reporting

View Course

Power BI: Month, QTD & YTD Financials

Create & toggle Month, QTD & YTD views in your financial reporting.

Watch Video

Creating Measure Tables in Power BI

Store your measures in measure tables to keep things organised!

Watch Video

Creating Measure Tables in Power Pivot

Store your measures in measure tables to keep things organised!

Watch Video

Python in Excel Demo Videos

Sample videos from the course Python in Excel

View Course

Python in Excel: Creating a DataFrame from External Data using Power Query

Use Power Query to connect to external data, and then Excel's new Python integration to create DataFrames from it, for onward calculation and analysis.

Watch Video

Python in Excel: Merging DataFrames to Map Data

Use Microsoft's latest innovation, Python in Excel, to merge DataFrames of data - robustly mapping them - for onward calculation and analysis.

Watch Video

Python in Excel: Using GroupBy to Aggregate Data by Category

Use the GroupBy function in Microsoft's latest innovation, Python in Excel, to aggregate the data of a DataFrame by category.

Watch Video

Advanced Excel Function Videos

Sample videos from the course Excel Analyst

View Course

Excel INDEX & MATCH: Creating Two-Way Lookups

Combine INDEX and MATCH functions in Excel to lookup data from multiple rows and multiple columns.

Watch Video

Excel XLOOKUP: Complete Guide to the Function

Complete guide to using XLOOKUP, Excel's most versatile lookup function.

Watch Video

Excel SUMPRODUCT: Calculate and Summarise Data

Demo of Excel's powerful SUMPRODUCT function calculating commissions, weighted averages, and summaries!

Watch Video

Excel SUMIFS: Summarise Data Using Multiple Criteria

Learn this key Excel function for better analysis, modelling, and summaries.

Watch Video

Excel SUM: Using the Function & "Punch Through" Technique

Masters the SUM function and save time with punch throughs!

Watch Video