Microsoft Excel

Resources in Microsoft Excel

Excel Challenge # 6

Excel Challenge # 6

It’s coming up to the end of the year and there’s a scramble to take vacation days. Can you help your HR department solve this challenge?

How to Calculate Percentage in Excel

How to Calculate Percentage in Excel

If you do lots of work with numbers in Excel, then you’ll need to calculate percentages quite often. Learn how to calculate percentages in Excel.

How to Create a Drop Down List in Excel

How to Create a Drop Down List in Excel

Excel drop down lists are an easy way to control the values entered in a cell. We’ll explore how to create a drop down list in Excel using three m...

How to Use the IFERROR Excel Function

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

How to Multiply in Excel

How to Multiply in Excel

There are two main ways to do multiplication in Excel. Learn how to multiply in Excel here.

How to Insert Excel Checkboxes

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

How to Make a Bar Graph in Excel

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.

PMT Function Excel

PMT Function Excel

Learn how to use the Excel PMT function in this comprehensive beginner's guide.

How to Concatenate in Excel

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

How to Insert a Check Mark in Excel

How to Insert a Check Mark in Excel

In this tutorial, we’ll show you how to insert a check mark in Excel. If you use Excel to generate and execute lists check marks will come in handy.

How to Use the Excel COUNTA Function

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.

How to Use the COUNT Function in Excel

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.

What is INDEX MATCH & Why Should You Use It?

What is INDEX MATCH & Why Should You Use It?

INDEX MATCH is a great way to overcome the limitations of VLOOKUP. In this resource we explore how and when to use it.

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.

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 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, Excel provides three tools. Learn how to use them all in this guide.

Join 279,824 serial learners

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

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.