Resources
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?
7 min
10 Ways to Manage a Hybrid Team
This article gives practical guidance on how to manage a hybrid team effectively to boost productivity and morale.
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.
7 min
The Value of Soft Skills Training
Find out why your organization needs to prioritize soft skills training and how it's going to benefit your staff.
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.
3 min
Excel Challenge 8: Create a Performance Incentive Worksheet
Use the VLOOKUP and IF functions to solve this new Excel challenge that takes you into a contact center. Take the challenge to learn real-world Exc...
17 min
12 Basic Excel Formulas You Need to Know
Don’t know much about how to use Excel formulas? Learn about these 12 basic Excel formulas to get started.
8 min
How to Remove Duplicates in Excel
Let’s clean up your worksheet by learning how to find, and then, how to remove duplicates in Excel.
11 min
How to Use the Excel INDIRECT Function
With a single argument, you can add sophistication to your worksheet by allowing it to behave dynamically. That’s the Excel INDIRECT function.
12 min
How to Create a Histogram in Excel
Histograms are useful for reporting on statistical data, especially when large datasets are involved. Here’s how to create a histogram in Excel.
7 min
How to Strikethrough in Excel
The strikethrough effect is an effective way to visually highlight that a task has been completed. Learn how to strikethrough in Excel.
9 min
Standard Deviation Formula in Excel
Excel eliminates the manual work by offering not one, but six functions to calculate standard deviation. Learn about the standard deviation formula...
10 min
How to Use the Excel SUMPRODUCT Function
The Excel SUMPRODUCT function is your secret weapon for functions you may not have access to if you're using an older Excel version. Learn more in ...
2 min
Excel Challenge 7: Create an Expandable Dropdown List
Help this book store owner solve this Excel data management challenge using the XLOOKUP function.
11 min
How to Make a Pie Chart in Excel
Pie charts are a popular way to show how much individual amounts contribute to a total amount. Learn how to make a pie chart in Excel.