Microsoft Excel Resources

Excel Challenge 23

Excel Challenge 23

Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?

Pivot Table Filter in Excel

Pivot Table Filter in Excel

So you've entered all your data in Excel and you want to zero in on a special segment. Pivot Table filters help to display select portions of data ...

Handling Lookups for Multiple Criteria in Excel

Handling Lookups for Multiple Criteria in Excel

Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.

Excel Challenge 22

Excel Challenge 22

Can you create a dynamic cell range reference in Excel? Take our latest Excel challenge to prove it!

The Ultimate Guide to Data Analysis in Excel

The Ultimate Guide to Data Analysis in Excel

Excel is all about data! Learn these simple but essential data analysis tools in Excel.

200+ Best Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fan...

Excel Challenge 21

Excel Challenge 21

Can you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge!

How to Make a Table in Excel

How to Make a Table in Excel

Want to know how to make a table in Excel? It's a lot more than just data and labels. Learn about Excel's dynamic and ever adapting tables.

Join 394,621 serial learners

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

How to Use the Data Analysis Toolpak in Excel

How to Use the Data Analysis Toolpak in Excel

The Excel Data Analysis Toolpak is a handy helper that analyzes complex or large data in a heartbeat.

How to Sort a Pivot Table

How to Sort a Pivot Table

Wondering how to sort a pivot table? Learn how to sort in basic and custom orders in no time!

How to Subtract in Excel

How to Subtract in Excel

Ever wondered how to subtract in Excel? Knowing this operation can simplify some of the most complex data.

Excel Challenge 20

Excel Challenge 20

Choose the best Excel date function to calculate the number of years between two dates with this Excel challenge!

How to Use the Excel SUBSTITUTE Function

How to Use the Excel SUBSTITUTE Function

Check out all the ways you can replace instances of text with the Excel SUBSTITUTE function.

How to Use the Excel Pivot Table Slicer

How to Use the Excel Pivot Table Slicer

Meet pivot table slicers in Excel – the cooler, more efficient cousin to filters. Learn how to display your desired variables in an instant.

Excel Challenge 19

Excel Challenge 19

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

20 Excel Date Functions - Explained!

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.

Excel Challenge 18

Excel Challenge 18

How do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out!

How to Use the TRIM Function in Excel

How to Use the TRIM Function in Excel

Learn how to clean up data easily using the TRIM function in Excel.

How to Use VSTACK and HSTACK in Excel

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.

Excel Challenge 17

Excel Challenge 17

Can you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge!