Resources
12 min
How to Create a Histogram in Excel
Histograms are useful for reporting on statistical data, especially when large datasets are involved. Here’s how to create a histogram in Excel.
7 min
How to Strikethrough in Excel
The strikethrough effect is an effective way to visually highlight that a task has been completed. Learn how to strikethrough in Excel.
9 min
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...
10 min
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 ...
2 min
Excel Challenge 7: Create an Expandable Dropdown List
Help this book store owner solve this Excel data management challenge using the XLOOKUP function.
11 min
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.
9 min
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!
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.
8 min
How to Use Microsoft Teams Video Conference
By far, the most popular feature of the Teams platform is the Microsoft Teams video conference. Learn all about it in this ultimate how-to guide.
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
LinkedIn Profile Tips - 24 Ways to Get Hired on LinkedIn
Use your LinkedIn profile to its full potential to market your personal brand and land your next dream role. Here are some LinkedIn profile tips to...
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.