Resources in Microsoft Excel
2 min
Excel Challenge 14: Using Multiple Sources for a Dropdown List
Test your Excel skills with this multi-source, sequential lookup challenge!
17 min
The Ultimate Guide to Excel Charts
Learn how to create and use a variety of Excel charts. Charts help to summarize information in a way that makes numbers easier to understand and in...
15 min
Working With Excel Dynamic Arrays
Excel dynamic arrays have changed the way we use all functions and formulas in Excel for the better. Learn about it in this article.
2 min
Excel Challenge 13: Use Partial Match to Find Multiple Criteria
Can you filter in Excel using multiple criteria and wildcards? Test your skills by stepping up to this challenge!
10 min
Waterfall Charts in Excel - A Beginner's Guide
A waterfall chart is one of the most visually descriptive charts supported in Excel. Learn how to create your own.
2 min
Excel Challenge 12: Methods for Splitting Cell Values
In this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most effic...
2 min
Excel Challenge 11: Super-Challenge! Create an Interactive Worksheet
Can you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge!
16 min
How to Use the Excel SEARCH Function
The Excel SEARCH function is meant to help you look for something within a specific text string. Learn about it here.
13 min
How to Use the COUNTIFS Excel Function
COUNTIFS determines the number of occurrences by comparing each range with its respective criterion. It then counts how many rows match all the sta...
11 min
How to Use the Excel RIGHT Function
When you want to extract data from the end of a string, the Excel RIGHT function might be just the thing you need.
12 min
How to Use the Excel LEFT Function
When you want to extract some values from one location in Excel without copying all the cell’s contents, the Excel LEFT function might be the thing...
12 min
How to Lock Cells in Excel
You can protect data in Excel at different levels. Learn how to lock cells in Excel.
2 min
Excel Challenge 10: Automating Repetitive Tasks With Macros
In this challenge, you get to build your first simple macro in Excel by automating a repetitive report! Can you solve this challenge?
11 min
How to Alphabetize in Excel
Sharpen your sorting skills now with these tips on how to alphabetize in Excel.
15 min
Excel Custom Number Format - A Beginner’s Guide
A number format controls how cells with numeric data appear in Excel. Learn about how Excel custom number formats work in this beginner's guide.
2 min
Excel Challenge 9: Making Use of Advanced Sorting Techniques in Excel
Think sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so.
8 min
How to Use the FREQUENCY Excel Function
The FREQUENCY Excel function simplifies the task of grouping values, especially in large datasets. Learn more!
11 min
How to Use Excel Solver
Excel solver can be applied to workforce management, maximizing profitability, and financial planning. Learn how to use the tool!
11 min
How to Make a Graph in Excel
You can make a graph in Excel for simple, advanced, and complex data. Here's how to make a graph in Excel.
10 min
The Excel TEXT Function
The Excel TEXT function allows you to convert numbers to Excel text format using Excel’s format codes. Learn all about it.