Resources in Microsoft Excel
9 min
How to Use the IFERROR Excel Function
The IFERROR Excel function is a logical function that tells Excel what to do if the formula that was entered returns an error response. Learn how t...
8 min
How to Multiply in Excel
There are two main ways to do multiplication in Excel. Learn how to multiply in Excel here.
8 min
How to Insert Excel Checkboxes
Did you know you can use Excel to insert checkboxes for to-do lists, dynamic charts, and dashboards? Learn about Excel checkboxes in this beginner'...
8 min
How to Make a Bar Graph in Excel
Bar graphs are an effective way to visually compare frequency, amounts, or units. Learn how to make a bar graph in Excel.
8 min
PMT Function Excel
Learn how to use the Excel PMT function in this comprehensive beginner's guide.
10 min
How to Concatenate in Excel
There are four ways to concatenate in Excel (the CONCATENATE Excel function, CONCAT, TEXTJOIN, and the & operator). Learn about them in this beginn...
7 min
How to Insert a Check Mark in Excel
There are 5 easy ways to insert a check mark and here we explore them all with examples. Choose your favorite.
4 min
How to Use the Excel COUNTA Function
The Excel COUNTA function counts all cells with data. Learn all about it in this beginner's guide.
8 min
How to Use the COUNT Function in Excel
Excel is all about large quantities of data. Learn how to use the COUNT function in Excel to count your data in various ways.
9 min
What is INDEX MATCH in Excel?
Combining INDEX and MATCH in Excel is a great way to overcome the limitations of VLOOKUP. It's also a clever way of performing a two-way lookup.
7 min
How to Count Unique Values in Excel with the UNIQUE Function
To help you count unique values in Excel, try the UNIQUE function. Learn all about it in this beginner's guide.
9 min
Excel Goal Seek Explained (Step by Step Guide)
The Excel Goal Seek feature is a useful what if analysis tool. Learn all about it in this beginner's guide!
8 min
How to Use the Excel AVERAGEIF Function
Learn all about the Excel AVERAGEIF function in this comprehensive beginner's guide.
8 min
How to Use Conditional Formatting in Excel
Learn how to use conditional formatting in Excel to easily visualize your data.
13 min
A Beginner's Guide to What If Analysis in Excel
To help you do a what if analysis, Excel provides three tools. Learn how to use them all in this guide.
7 min
How to Calculate Weighted Average in Excel
Explore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function.
2 min
Excel Challenge 5: Formula Super Challenge
It's time for some more fun with Excel! Try solving this Excel formula challenge from Excel MVP Alan Murray (aka. Computergaga).
12 min
How to Calculate Averages in Excel (7 Simple Ways)
Learn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions.
6 min
How to Create Pivot Table Calculated Fields
Want to level up your pivot table skills? Learn how to add and modify a pivot table calculated field with this how-to guide.
7 min
The SUMIFS Excel Function
Learn how to use the SUMIFS Excel function to add values that meet multiple specific criteria with this step-by-step tutorial.