Microsoft Excel

Resources in Microsoft Excel

Your Guide to VLOOKUP Table Array

Your Guide to VLOOKUP Table Array

Learn the most useful tips and best practices for using VLOOKUP Table Array, from Microsoft Excel expert Claudia Buckley.

Excel Challenge 24: Extract Unique Values From a Dataset

Excel Challenge 24: Extract Unique Values From a Dataset

Can you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns!

Easy VBA Message Box Tutorial

Easy VBA Message Box Tutorial

Improve the interactivity of your worksheet by adding a message box to your macro's VBA code. Learn how to create your first message box with this ...

How to Divide in Excel

How to Divide in Excel

As simple as division may seem, learning how to divide in Excel is key to mastering some of the most complex functions and formulas.

How to Freeze Panes in Excel

How to Freeze Panes in Excel

Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting.

How To Do a Mail Merge in Excel

How To Do a Mail Merge in Excel

A step-by-step guide to mail merge in Microsoft Word using an Excel source list.

Excel Challenge 23: How to Break Ties When Ranking

Excel Challenge 23: How to Break Ties When Ranking

Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?

Pivot Table Filter in Excel

Pivot Table Filter in Excel

So you've entered all your data in Excel and you want to zero in on a special segment. Pivot Table filters help to display select portions of data ...

VLOOKUP With Multiple Criteria or Multiple Results in Excel

VLOOKUP With Multiple Criteria or Multiple Results in Excel

Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.

Excel Challenge 22: Create a Dynamic Excel Chart Range

Excel Challenge 22: Create a Dynamic Excel Chart Range

Can you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution!

The Ultimate Guide to Data Analysis in Excel

The Ultimate Guide to Data Analysis in Excel

Excel is all about data! Learn these simple but essential data analysis tools in Excel.

Excel Challenge 21: Unpivoting Data Within a Table

Excel Challenge 21: Unpivoting Data Within a Table

Can you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge!

How to Make a Table in Excel

How to Make a Table in Excel

Want to know how to make a table in Excel? It's a lot more than just data and labels. Learn about Excel's dynamic and ever adapting tables.

How to Use the Data Analysis Toolpak in Excel

How to Use the Data Analysis Toolpak in Excel

The Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat.

How to Sort a Pivot Table

How to Sort a Pivot Table

Wondering how to sort a pivot table? Learn how to sort in basic and custom orders in no time!

How to Subtract in Excel

How to Subtract in Excel

Ever wondered how to subtract in Excel? Knowing this operation can simplify some of the most complex data.

Excel Challenge 20: Calculate Years Between Two Dates

Excel Challenge 20: Calculate Years Between Two Dates

Choose the best Excel date function to calculate the number of years between two dates with this Excel challenge!

How to Use the Excel SUBSTITUTE Function

How to Use the Excel SUBSTITUTE Function

Check out all the ways you can replace instances of text with the Excel SUBSTITUTE function.

How to Use Excel Pivot Table Slicers

How to Use Excel Pivot Table Slicers

Meet pivot table slicers in Excel – the cooler, more efficient cousin to filters. Learn how to display your desired variables in an instant.

Excel Challenge 19: Using Advanced Logic to Return Different Results

Excel Challenge 19: Using Advanced Logic to Return Different Results

What Excel functions do you use when multiple combinations could lead to different outcomes? Share it with us by working on our latest Excel challe...