Learn Excel Online

Mixed References in Excel - a Beginner's Guide

Learn all about the mixed reference Excel feature in this beginner's guide.

Relative References in Excel - A Beginner's Guide

Learn all about the relative reference Excel feature in this beginner's guide.

Excel Challenge 2: Clean and Transform Data with Power Query

Ready for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now!

Excel VBA Code Library - Useful Macros for Beginners

Automate your Excel tasks with ready-made code from our VBA code library.

Absolute References in Excel - A Beginner's Guide

Learn all about the absolute reference Excel feature in this beginner's guide.

12 Best Practices in Dashboard Design

Learn what a dashboard is, the different types, and the best practices in dashboard design.

How to Use Wildcard Characters in Excel

Learn how to use wildcard characters in Excel to save time when working with formulas.

XLOOKUP vs VLOOKUP in Excel - What's the Difference?

XLOOKUP vs VLOOKUP! What is the difference between VLOOKUP and XLOOKUP? And which one is better? You be the judge. Includes a video and practice file.

Excel Challenge 1: Use Raw Data to Create Dynamic Reports

Think you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray!

HLOOKUP vs VLOOKUP: A Beginner's Guide

It's the battle of the lookups - this time it's HLOOKUP vs VLOOKUP. Which will win?

XLOOKUP in Excel: A Beginner's Guide

XLOOKUP in Excel is a powerful function that will help you save time and effort. Learn about it here.

12 Most Useful Excel Functions for Data Analysis

Learn 12 of the most useful Excel functions for data analysis, with free practice worksheet included!