Microsoft Excel Resources

Waterfall Charts in Excel - A Beginner's Guide

Waterfall Charts in Excel - A Beginner's Guide

A waterfall chart is one of the most visually descriptive charts supported in Excel. Learn how to create your own.

Excel Challenge #12

Excel Challenge #12

In this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most effic...

How to Use the Excel Find Function

How to Use the Excel Find Function

The Excel FIND function helps you look for something within a specific text string. Learn how in this tutorial.

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 #11

Excel Challenge #11

Can you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge!

How to Use the Excel SEARCH Function

How to Use the Excel SEARCH Function

The Excel SEARCH function is meant to help you look for something within a specific text string. Learn about it here.

How to Use the COUNTIFS Excel Function

How to Use the COUNTIFS Excel Function

The COUNTIFS Excel function is especially useful when you want to count the number of cells that meet several criteria. Learn more here!

How to Use the Excel RIGHT Function

How to Use the Excel RIGHT Function

When you want to extract data from the end of a string, the Excel RIGHT function might be just the thing you need.

Join 326,861 serial learners

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

How to Use the Excel LEFT Function

How to Use the Excel LEFT Function

When you want to extract some values from one location in Excel without copying all the cell’s contents, the Excel LEFT function might be the thing...

How to Lock Cells in Excel

How to Lock Cells in Excel

You can protect data in Excel at different levels. Learn how to lock cells in Excel.

Excel Challenge # 10

Excel Challenge # 10

In this challenge, we are exploring charts. How good are you with charts in Excel? Can you solve this challenge?

How to Alphabetize in Excel

How to Alphabetize in Excel

Sharpen your sorting skills now with these tips on how to alphabetize in Excel.

Excel Custom Number Format - A Beginner’s Guide

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.

Excel Challenge # 9

Excel Challenge # 9

Think sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so.

How to Use the FREQUENCY Excel Function

How to Use the FREQUENCY Excel Function

The FREQUENCY Excel function simplifies the task of grouping values, especially in large datasets. Learn more!

How to Use Excel Solver

How to Use Excel Solver

Excel solver can be applied to workforce management, maximizing profitability, and financial planning. Learn how to use the tool!

How to Make a Graph in Excel

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.

The Excel TEXT Function

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.

Excel Challenge # 8

Excel Challenge # 8

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

12 Basic Excel Formulas You Need to Know

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