Resources in Microsoft Excel
13 min
How to use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel
Learn to use TEXTBEFORE, TEXTAFTER, and TEXTSPLIT for easier text handling in Excel.
29 min
Excel Basics - Step by Step Tutorial for Beginners
From figuring out the interface to using advanced filters, learn all there is to know when it comes to Excel basics.
2 min
Excel Challenge 16: Techniques for Manipulating Text
Practice splitting and re-formatting text using time-saving techniques in Excel!
6 min
How to Compare Two Columns in Excel
Learn how to compare two columns in Excel in a few simple steps.
4 min
How to Move Rows and Columns in Excel
Rearranging data in Excel isn't as complicated as it sounds. Learn how to move columns in Excel (and rows too!) in a few simple steps.
3 min
Excel Challenge 15: Track Expenses with Data Visualization
For this Excel challenge, let's use conditional formatting to make this monthly expense sheet more visually appealing!
9 min
Cell Styles in Excel: The Complete Guide
These useful hacks will make your Microsoft Excel sheet look impressive and organized. Discover how to use Cell Styles in Excel.
14 min
Using AutoFill in Excel
The Autofill Excel function recognizes patterns and simplifies the task of data entry for large datasets. Learn more!
2 min
Excel Challenge 14: Perform a Lookup From Multiple Sources
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: Design an Interactive Selection Form
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
The Excel RIGHT function might be just the thing you need, when you want to extract data from the end of a string. A video and free exercise file a...
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.