Microsoft Excel Resources

Excel Challenge #2

Excel Challenge #2

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

Excel VBA Code Library - Useful Macros for Beginners

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

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

12 Best Practices in Dashboard Design

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

Join 256,572 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

How to Use Wildcard Characters in Excel

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 in Excel - What's the Difference?

Find out who wins in this XLOOKUP vs VLOOKUP standoff.

Excel Challenge #1

Excel Challenge #1

Think you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga). Download the ...

HLOOKUP vs VLOOKUP: A Beginner's Guide

HLOOKUP vs VLOOKUP: A Beginner's Guide

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

200+ Best Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fan...

XLOOKUP in Excel: A Beginner's Guide

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

12 Most Useful Excel Functions for Data Analysis

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

Google Sheets Vs. Excel: Everything You Need to Know

Google Sheets Vs. Excel: Everything You Need to Know

In the battle of best spreadsheet software, who will win? Let's dig into Google Sheets vs. Excel.

A Beginner's Guide to VLOOKUP vs Pivot Tables

A Beginner's Guide to VLOOKUP vs Pivot Tables

In this article we will examine VLOOKUP, Pivot Tables and Power Pivot, and when you should use each of them for best results.

A Beginner's Guide to Power Query, Power Pivot and Power BI

A Beginner's Guide to Power Query, Power Pivot and Power BI

We demystify the differences between Power Query, Power Pivot, and Power BI and show you how they all work together.

How to Master Excel in 11 Steps

How to Master Excel in 11 Steps

It's no secret that Excel is an essential skill. If you are ready to level up your Excel skills, then check out our guide to becoming an Excel pro!

How to Make a Column Chart in Excel: A Guide to Doing it Right

How to Make a Column Chart in Excel: A Guide to Doing it Right

Ready to wow your colleagues with some impressive graphs and charts? Then learn the in's and out's of Excel column charts with this handy guide!

How (and When) to Use ANOVA in Excel: The Ultimate Guide

How (and When) to Use ANOVA in Excel: The Ultimate Guide

Looking to improve your processes by running an analysis of variance? Learn how to run one and two-way ANOVA in Excel with this step-by-step guide!

9 Best Excel Skills for Accountants in 2020

9 Best Excel Skills for Accountants in 2020

Like most people, you're probably using Excel for accounting. If you want to maximize your efficiency then check out these top Excel skills for acc...

11 Best Excel Presentation Tips in 2020

11 Best Excel Presentation Tips in 2020

Learn how to make professional, or even beautiful spreadsheets with these eleven Excel presentation tips!

The Best Free Gantt Chart Template for Excel

The Best Free Gantt Chart Template for Excel

Make your life a lot easier with this free Excel Gantt chart template! Download it now!