How-To
How to Calculate Z-Score in Excel
As you know, there are many mathematical calculations you can perform with Microsoft Excel. In this tutorial, we’ll walk you...
Microsoft Excel
How-To
How to Create Labels in Word from an Excel Spreadsheet
If you’re looking to create and print labels of any kind, look no further than Microsoft Word and Excel. You...
How-To
How to Remove Duplicate Rows in Excel
Duplicate values in your Excel worksheet can mess up your data. Unless duplicates are intentional, they can cause inaccuracies and...
How-To
4 Ways to Use a Check Mark in Excel
There are many reasons you may want to use a check mark in Excel. In some cases, you may just...
How-To
How to Create Multiple Linked Drop Down Lists in Excel
Drop-down lists in Excel are powerful tools. They let you provide users with a drop-down arrow that, when selected, provides...
How-To
Random Number Generator in Excel: How and When to Use It
There are a surprising number of ways you can make use of a random number generator in Excel. But before...
How-To
How to Use Absolute References in Excel
Most people are familiar with using relative references in Excel. This is because cell references in Excel spreadsheets default to...
How-To
How to Remove Password From Excel Protected Sheets
When you work with sensitive data, you might run across protected Excel sheets. You might also want to give other...
How-To
How to Sort by Date in Excel
Sorting data by date seems like it should be a simple task, and, indeed, Microsoft Excel offers a number of...
How-To
How to Make a Pie Chart in Excel
Pie charts are a common type of data visualization. Pie charts can make it easier for others to understand the...
How-To
Add a Linear Regression Trendline to an Excel Scatter Plot
You’re either reading this because you searched for how to add a linear regression trendline to an Excel scatter plot...
How-To
4 Ways to Convert Excel to Google Sheets
If you’ve been working with data in Excel and you’ve realized you want to use Google Sheets functions or scripting,...
How-To
How to Securely Password Protect an Excel File
Microsoft Excel remains the most popular spreadsheet application in the world. Excel spreadsheet data is often sensitive, containing personal or...
How-To
3 Ways To Split a Cell In Excel
If you’re working with data in Excel that you’ve imported from other sources, sometimes you have to work with data...
How-To
5 Ways To Convert Text to Numbers In Excel
One of the most common annoyances that people cite with Excel is dealing with how numbers and text are formatted...
How-To
A Quick Guide To All Excel File Extensions & What They Mean
Excel, as well as all of the core Microsoft Office applications, have gone through decades of version upgrades. Along with...
How-To
How To Use Flash Fill In Excel
Trying to fill out cells in Excel that incorporate text or data from multiple other cells in a sheet can...
How-To
How To Search In Excel
There are multiple ways to search in Excel. The first options are if you have a massive spreadsheet of data...
How-To
How To Move Columns In Excel
Organizing your Excel spreadsheets isn’t always easy, especially when those spreadsheets are large. But if you know how to move...
How-To
How to Alphabetize In Excel
When you want to alphabetize in Excel, whether it’s to sort a column or a row, the process is usually...
How-To
How To Use The PMT Function In Excel
If you’ve ever considered taking out a mortgage or any other loan, knowing how to use the PMT function in...
How-To
How To Calculate Standard Deviation In Excel
In statistics, standard deviation is a measure of how dispersed a set of data is relative to its mean. In...
How-To
Differences Between Microsoft Excel Online And Excel For Desktop
If you have an Office 365 subscription, then you have access to all of the features that the cloud-based versions...
How-To
How to Use VLOOKUP in Excel
Have you ever had a large spreadsheet with data in Excel and need an easy way to filter and extract...
How-To
How To Insert CSV or TSV Into An Excel Worksheet
Text based data files are one of the most common methods of storing data in the world today. This is...
