We select and review products independently. When you purchase through our links we may earn a commission. Learn more.

#### Complete Guidesby How-To Geek

X
X

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.

## How to Use Text to Columns Like an Excel Pro

Excel’s Text to Columns feature splits text in a cell into multiple columns. This simple task can save a user the heartache of manually separating the text in a cell into several columns.

## How to Use Excel’s Split Screen Function

Splitting screens, whether vertically or horizontally, is a great way to streamline your workflow when using Excel. Using this feature lets you simultaneously view separate sections of a spreadsheet, enabling you to compare d…

## How to Calculate Percentage Change with Pivot Tables in Excel

Pivot Tables are an amazing built-in reporting tool in Excel. While typically used to summarize data with totals, you can also use them to calculate the percentage of change between values. Even better: It is simple to do….

## How to Do a Linear Calibration Curve in Excel

Excel has built-in features that you can use to display your calibration data and calculate a line-of-best-fit. This can be helpful when you are writing a chemistry lab report or programming a correction factor into a piece o…

## How to Use VLOOKUP on a Range of Values

VLOOKUP is one of Excel’s most well-known functions. You’ll typically use it to look up exact matches, such as the ID of products or customers, but in this article, we’ll explore how to use VLOOKUP with a range of values….

## How to Calculate a Z-Score Using Microsoft Excel

A Z-Score is a statistical value that tells you how many standard deviations a particular value happens to be from the mean of the entire data set. You can use AVERAGE and STDEV.S or STDEV.P formulas to calculate the mean and…

## How to Find the Percentage of Difference Between Values in Excel

You can use Excel to calculate the percentage of change between two values quickly. In our simple example, we show you what you need to know to be able to calculate things like how much the price of gas changed overnight or t…

## How to Use Logical Functions in Excel: IF, AND, OR, XOR, NOT

Logical functions are some of the most popular and useful in Excel. They can test values in other cells and perform actions dependent upon the result of the test. This helps us to automate tasks in our spreadsheets….

## How to Build a PowerPoint Organizational Chart With Excel Data

Building an organizational chart in Excel makes sense because it’s easy to pull data from sources like other Excel documents or Outlook. When it comes time to show off that chart, you’ll probably want to use PowerPoint, thou…

## How to Sort Values in Microsoft Excel

Excel has “Sort A to Z” and “Sort Z to A” features that let you sort values alphabetically or numerically, and a “Custom Sort” feature that lets you sort using multiple criteria.  Here’s how to use them….

## How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel

You’ve worked hard on your spreadsheet. You don’t want anyone to mess it up. Fortunately, Microsoft Excel provides some pretty good tools for preventing people from editing various parts of a workbook….

## How to Create a Radar Chart in Excel

A radar chart compares the values of three or more variables relative to a central point. It’s useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey dat…

## How to Set the Rounding Precision in Excel

Setting the rounding precision forces Excel to always round numeric values to a specified number of digits following the decimal, saving you from having to use the ROUND function on each formula. Here’s how it works….

## How to Calculate a Weighted Average in Excel

A weighted average is one that takes into account the importance, or weight, of each value. This article will show you how to use Excel’s SUMPRODUCT and SUM functions individually and how to combine the two to calculate a wei…

## How to Change How Excel Displays Negative Numbers

Microsoft Excel displays negative numbers with a leading minus sign by default. It is good practice to make negative numbers easy to identify, and if you’re not content with this default, Excel provides a few different option…

## How (and Why) to Use the Outliers Function in Excel

An outlier is a value that is significantly higher or lower than most of the values in your data. When using Excel to analyze data, outliers can skew the results. For example, the mean average of a data set might truly refle…

## How to Add the Developer Tab to the Microsoft Office Ribbon

The Developer tab is not displayed on the Ribbon in Office apps by default, but it’s easy to add and gives you access to advanced features like macros, ActiveX controls, and form controls to Word, Excel, PowerPoint, and Vis…

## How to Use the FREQUENCY Function in Excel

Excel’s FREQUENCY function lets you count how many times values fall within specific ranges. For example, if you had the ages of a group of people in your spreadsheet, you could figure out how many people fall into different …

## How-To Geek is Looking for Microsoft Excel Writers

Think you have the perfect combination of geek knowledge and writing skills? We’re looking for experienced Microsoft Excel writers to join our team.

## What is an XLSX File (and How Do I Open One)?

A file with the .xlsx file extension is a Microsoft Excel Open XML Spreadsheet (XLSX) file created by Microsoft Excel. You can also open this format in other spreadsheet apps, such as Apple Numbers, Google Docs, and OpenOffi…

## What Your Function Keys Do In Microsoft Excel

The function keys on keyboards don’t get the love they used to, but depending on the app you’re running, they can still be quite handy. Microsoft Excel has some interesting features tucked away behind your function keys. …

## All the Best Microsoft Excel Keyboard Shortcuts

Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.

## How to Link or Embed an Excel Worksheet in a PowerPoint Presentation

Sometimes, you want to include the data on an Excel spreadsheet in a Microsoft PowerPoint presentation. There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Exce…

## How to Link or Embed an Excel Worksheet in a Word Document

Sometimes, you want to include the data on an Excel spreadsheet in your Microsoft Word document. There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Excel sheet…

## How to Round Off Decimal Values in Excel

If you don’t want to show decimal values in Excel, you can simplify your numerical data using the ROUND functions. Excel offers three functions: ROUND, ROUNDUP, and ROUNDDOWN. Let’s take a look at how they work….
How-To Geek is where you turn when you want experts to explain technology. Since we launched in 2006, our articles have been read billions of times. Want to know more?