Learn Excel Online

Standard Deviation Formula in Excel

Excel eliminates the manual work by offering not one, but six functions to calculate standard deviation. Learn about the standard deviation formula in Excel.

How to Use the Excel SUMPRODUCT Function

The Excel SUMPRODUCT function is your secret weapon for functions you may not have access to if you're using an older Excel version. Learn more in this guide.

Excel Challenge 7: Create an Expandable Dropdown List

Help this book store owner solve this Excel data management challenge using the XLOOKUP function.

How to Make a Pie Chart in Excel

Pie charts are a popular way to show how much individual amounts contribute to a total amount. Learn how to make a pie chart in Excel.

How to Make a Scatter Plot in Excel

A scatter plot is a type of chart that shows whether there is a relationship between two variables. Let’s explore how to make a scatter plot in Excel!

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.

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

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.

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.

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.

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.

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?