How to Use Excel to Find Percentiles: A Step-by-Step Guide
Calculating percentiles in Excel is a breeze. Simply use the PERCENTILE or PERCENTILE.EXC function, input your data range and the percentile you’re looking for, and …
Formulas
How-to guides and tutorials about topics related to formulas that you use in the spreadsheets on your computer or phone.
How to Make a Profit Margin Formula in Excel: A Step-by-Step Guide
Making a profit margin formula in Excel requires setting up a spreadsheet with your cost and revenue data, then creating a formula that divides net …
How to Deduct a Percentage in Excel: A Step-by-Step Guide
Deducting a percentage in Excel is a breeze once you get the hang of it. Simply click on the cell you want to calculate the …
How to Calculate Gross and Net Margins in Excel: A Step-by-Step Guide
Calculating gross and net margins in Excel is a straightforward process that involves a few simple formulas. Once you input your revenue and cost data, …
How to Use the Less Than or Equal to Function in Excel: A Step-by-Step Guide
To use the less than or equal to function in Excel, you simply need to type the formula <= followed by the value you are …
Excel Formula to Find Differences in Numbers: A Step-by-Step Guide
Excel is a powerful tool that can do a lot more than just addition and subtraction. Have you ever needed to find differences between numbers …
How to Remove First Character in Excel 2013 Cell
Microsoft Excel includes a lot of tools that can help you quickly manage your data. Some of these are things that you might be using …
How to Apply a Formula to an Entire Column in Google Sheets
Learning how to apply a formula to an entire column in Google Sheets is a simple task that can save you time and headaches. Just …
How to Use the Character Count Excel 2013 Tool
If you’ve ever tried to count the number of digits or letters in a cell, then you have probably discovered that it’s kind of difficult. …
How to Calculate Percentage in Excel
Microsoft Excel has a lot of different ways that you can compare data. Many of these options exist as formulas, and it’s likely that you …
How to Subtract in Google Sheets
Spreadsheet applications like Microsoft Excel and Google Sheets are more than just a way to organize and display data. They are also powerful applications capable …
How to Turn Off Formulas in Excel 2010
Microsoft Excel formulas are amazing for their ability to quickly perform complex calculations and provide you with an answer. While it can seem like these …
How to Subtract in Excel 2013 with a Formula (An Easy 4 Step Guide)
There is a pretty steep learning curve when you start to see all of the different things that you can do in Microsoft Excel. It’s …
How to Enable Iterative Calculation in Google Sheets
Many people that use Google Sheets won’t encounter problems with the settings that it has in the default configuration. But if your spreadsheet contains a …
How to Combine Three Columns Into One in Excel
It’s often a good idea to separate as much information as possible in Microsoft Excel. Depending on what you are going to be using that …
How to Display a “0” Instead of #N/A When Using VLOOKUP in Excel 2013
The VLOOKUP formula in Microsoft Excel is one of the most efficient ways to find data in spreadsheets. Along with the concatenate formula, I have …
How to Calculate Median in Excel 2013
Learning how to calculate a median in Excel 2013 is similar to learning how to perform most other mathematical functions within the program, such as …
How to Unhide Formula Bar in Excel 2010
Knowing exactly what you are working on is critical in Microsoft Excel, especially when you are adjusting a formula. One way to make this a …
How to Remove Last Digit in Excel 2013
The Microsoft Office spreadsheet application, Microsoft Excel, offers a lot of ways that you can manipulate the values within the cells of your spreadsheets. For …
How to Find a Row Sum in Excel 2010
If you haven’t used the formulas that Microsoft Excel provides, then you may not realize just how powerful the application can be. While its formatting …
How to Print Formulas in Excel 2010
Configuring the data in the cells of your Microsoft Excel spreadsheet is often just one part of creating and distributing data. While a spreadsheet may …
How to Convert MM to Inches in Excel 2013
Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert …
How to Find an Average in Excel 2013
Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to …
How to Change Recalculation Settings in Google Sheets
When you make a change in one of your Google Sheets spreadsheets, certain functions will recalculate so that you always have the most current information. …
How to Calculate Age from a Birthdate in Excel 2013
Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values …
How to Show Formulas in Google Sheets
The beauty of formulas in spreadsheets is their ability to perform calculations for you. Often this occurs with the help of a mathematical operator in …
How to Concatenate Text in Excel 2013
Retyping data is always a hassle in spreadsheets. It’s also prone to errors, so you might be looking for a better way to combine data …
How to Add Leading Zeroes to Numbers in Excel 2013
If you are working with numbers that might include zeroes at the start of those numbers, then you might be running into a problem. Excel …
How to Calculate the Number of Workdays Between Two Dates in Excel 2013
One way that you can use Excel 2013 is to keep track of ongoing projects, or important dates that occur either in your personal life …
How to Multiply in Excel 2013
If you are trying to figure out how to multiply in Excel 2013, then you might be struggling to find the formula or option to …
Why Isn’t My Sum Updating in Excel 2013 Anymore?
A sum that is not updating automatically in Excel 2013 can be frustrating and, depending upon the importance of the information that it affects, potentially …
Excel 2013 Formulas Not Working
It can be frustrating, even problematic, when your Excel formulas are not working. We use formulas in our Excel spreadsheets to automatically calculate values for …
How to Enable Formula AutoComplete in Excel 2013
Are you familiar with a lot of the formulas in Excel, but you don’t remember the exact parameters that you need to use? Microsoft Excel …
How to Count the Number of Blank Cells in a Range in Excel 2013
When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, …
How to Determine the Day of the Week from a Numerical Date in Excel 2013
Excel 2013 has a lot of helpful tools and tricks that you can use to find information about data contained in a worksheet. One of …
How to Remove Leading Spaces in Excel 2013
You might discover that you need to know how to remove leading spaces in Excel when you have data that is difficult to work with …
How to Select the Cells Containing Formulas in Excel 2010
When you discover an error in Microsoft Excel, and that error is part of a formula, then the level of difficulty in resolving the problem …
How to Use R1C1 Reference Style in Excel 2010
If you have ever run into issues with cell references in Excel formulas, then you may be looking for another way to use them. Or …
How to Turn on Automatic Calculation in Excel 2010
Are you working with a spreadsheet in Microsoft Excel 2010 where you change a cell that is included in a formula, but the result of …
How to Display a Formula Result in a Text Box in Excel 2010
Text boxes can be a useful tool in Microsoft Excel. One particular example is when your spreadsheet has a lot of data in it, but …
Why Is Excel 2010 Showing the Formulas Instead of the Answers?
You may discover that you need Excel to show results instead of formulas when you enter a formula that remains visible. An Excel spreadsheet can …
How to Hide the Formula Bar in Excel 2013
You can hide the Microsoft Excel 2013 formula bar by clicking the View tab at the top of the window, then unchecking the Formula Bar …
How to Find the Highest Value in Excel 2013
Excel 2013 offers a large number of useful formulas that will help you to find or calculate important information from your spreadsheet data. Whether you …
How to Find the Number of Days Between Two Dates in Excel 2013
Excel worksheets can contain all types of different data, including formulas (like one that lets you subtract in Excel), text, numbers, pictures, and dates. Dates …
How to Show the Formula Bar in Excel 2013
The layout and appearance of your Excel 2013 installation can be customized in a number of different ways. There is an area of the default …
How to Show Formulas in Excel 2013
Learning how to show formulas in Excel 2013 is a helpful way for you to determine why you might not be calculating the desired result …
How to Create a Formula in Excel 2013
There is a lot of utility that can come from organizing data in an Excel worksheet. Information is sortable and easy to edit, and you …
Quickly Add Latin Text in Word 2013
You might find that you need to add a Latin paragraph to a document in Word 2013 when you need to view the structure of …
How to Find a Median in Excel 2010
Excel 2010 is a great tool when you have a lot of data that you want to compare. You can easily perform mathematical operations on …
How to Add Up a Column in Excel 2011
If you’ve ever used a calculator while you were putting data into a spreadsheet, you may be wondering if there is a faster method of …