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….
