7 min
How to Use the Excel SUBSTITUTE Function
Check out all the ways you can replace instances of text with the Excel SUBSTITUTE function.
11 min
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.
2 min
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...
42 min
20 Excel Date Functions - Explained!
There are more than 20 date formulas in Excel to help simplify common operations involving dates. Here is a list of some top Excel date functions.
2 min
Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match
How do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out!
7 min
How to Use the TRIM Function in Excel
Learn how to clean up data easily using the TRIM function in Excel.
4 min
How to Use VSTACK and HSTACK in Excel
Exciting new Excel functions are here! Learn how VSTACK and HSTACK in Excel make list combinations effortless.
2 min
Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts
Can you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge by using PivotTables and ...
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: 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!