10 min
The Ultimate Guide to Pivot Tables in Excel
Learn how to master pivot tables in Excel to summarize, discover trends, and make sense of large data sets. This guide covers how to create pivot t...
2 min
Excel Challenge 25: Convert Dates Stored as Text
What are your options when dates in Excel are stored as text? Take this Excel challenge for a spin, then check out our solution!
5 min
How to Use the Excel ISERROR Function
Figure out whether an input will result in an error in advance with the Excel ISERROR Function.
13 min
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.
2 min
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!
9 min
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 a VBA message box with this easy ...
7 min
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.
11 min
How to Freeze Panes in Excel
Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting.
14 min
How To Do a Mail Merge in Excel
A step-by-step guide to mail merge in Microsoft Word using an Excel source list.
2 min
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?
10 min
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 ...
12 min
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.
2 min
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!
20 min
The Ultimate Guide to Data Analysis in Excel
Excel is all about data! Learn these simple but essential data analysis tools in Excel.
2 min
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!
11 min
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.
9 min
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.
11 min
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!
8 min
How to Subtract in Excel
Ever wondered how to subtract in Excel? Knowing this operation can simplify some of the most complex data.
2 min
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!