Microsoft Excel Resources

How to Count Unique Values in Excel with the UNIQUE Function

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.

Excel Goal Seek Explained (Step by Step Guide)

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!

How to Use the Excel AVERAGEIF Function

How to Use the Excel AVERAGEIF Function

Learn all about the Excel AVERAGEIF function in this comprehensive beginner's guide.

How to Use Conditional Formatting in Excel

How to Use Conditional Formatting in Excel

Learn how to use conditional formatting in Excel to easily visualize your data.

A Beginner's Guide to What If Analysis in Excel

A Beginner's Guide to What If Analysis in Excel

To help you do a what if analysis in Excel, there are three tools. Learn how to use them all in this guide - Goal Seek, Scenario Manager, and data ...

How to Calculate Weighted Average in Excel

How to Calculate Weighted Average in Excel

Explore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function.

Excel Challenge 5: Formula Super Challenge

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).

How to Calculate Averages in Excel (7 Simple Ways)

How to Calculate Averages in Excel (7 Simple Ways)

Learn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions. Includes a video walkthrough and exercise file.

How to Create Pivot Table Calculated Fields

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.

The SUMIFS Excel Function

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.

How to Use the IF Function in Excel

How to Use the IF Function in Excel

Learn how to use the IF function in Excel and see how it can be combined with the OR and AND functions.

The SUMIF Excel Function

The SUMIF Excel Function

Discover what the SUMIF Excel function is and how to use it.

The COUNTIF Function in Excel

The COUNTIF Function in Excel

Improve your data management skills by learning how to use the COUNTIF function in Excel.

The Excel AND Function

The Excel AND Function

Learn how to use the Excel AND function and combine it with other functions for more flexibility.

How to Create a Running Total in Excel (Cumulative Sum)

How to Create a Running Total in Excel (Cumulative Sum)

Learn how to create a running total in Excel with this step-by-step tutorial.

The Excel OR Function

The Excel OR Function

What is the Excel OR function? How do you use it? Find out in this tutorial.

Join 473,262 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

Excel Challenge 4: Analyze Data With Power Query

Excel Challenge 4: Analyze Data With Power Query

Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).

The New Excel LET Function

The New Excel LET Function

Learn about the new Excel LET function. This new function can help make complex formulas easier to read and use.

The Excel Ribbon

The Excel Ribbon

Improve your Excel navigational skills with these tips on how to use and customize the Excel ribbon.

How to Sort in Excel

How to Sort in Excel

Learn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting.