Resources in Microsoft Excel
9 min
Variance Formula Excel
Variance is a number that gives a general idea of the dispersion of a dataset. Learn about the variance formula in Excel.
12 min
How to Merge Cells and Split Cells in Excel
Excel has several features which give us the ability to merge and split cells in multiple ways. Here’s how to merge cells in Excel and split cells ...
11 min
How to Make a Line Graph in Excel
Line graphs are some of the most common types of charts used to display continuous data. Here’s how to make a line graph in Excel.
12 min
How to Use the SUM Function in Excel
One of the best functions for beginners to learn is the SUM function in Excel. Start learning with this comprehensive tutorial.
10 min
How to Filter in Excel
Have you ever wanted to temporarily display only certain data from a larger dataset without deleting the rest? Learn how to filter in Excel.
10 min
LEN Function Excel - A Beginner's Guide
The LEN Excel function returns the number of characters in a text string. Learn all about it in this beginner's guide.
3 min
Excel Challenge 6: Using Basic Logical Functions
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?
10 min
How to Calculate Percentage in Excel
If you do lots of work with numbers in Excel, then you’ll be working with percentages fairly often. Learn how to calculate percentages in Excel.
12 min
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...
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
Learn about Excel checkboxes in this beginner's guide. Did you know you can use Excel to insert checkboxes for to-do lists, dynamic charts, and das...
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
If you're trying to figure out how to insert a check mark in Excel, here are 5 easy ways with examples. Choose a favorite for your next task-orient...
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?
Learn about INDEX MATCH in Excel. Combining INDEX and MATCH is a great way to overcome the limitations of VLOOKUP and a clever way to perform a two...
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.