Posts Tagged 'Excel functions', page 3

Excel CELL function with formula examples

The fastest way to get some specific information about a cell in Excel is to use the CELL function. Among other things, it can tell you whether a cell is protected or not, retrieve the cell address and value, show a full path to the workbook that contains the cell, and a lot more. Continue reading

Excel ADDRESS function with formula examples

To create a cell reference in Excel, you can type the column and row coordinates manually. Alternatively, you can get a cell address from the row and column numbers supplied to the ADDRESS function. Continue reading

How to do Spearman correlation in Excel

When doing correlation analysis in Excel, in most cases you will deal with the Pearson correlation. But when the underlying assumptions of the Pearson correlation (continuous variables, linearity, and normality) are not met, you can do the Spearman rank correlation instead of Pearson's. Continue reading

Correlation in Excel: coefficient, matrix and graph

One of the simplest statistical calculations that you can do in Excel is correlation. Though simple, it is very useful in understanding the relations between two or more variables. Microsoft Excel provides all the necessary tools to run correlation analysis, you just need to know how to use them. Continue reading

Excel IF OR function with formula examples

IF is one of the most popular Excel functions and very useful on its own. Combined with the logical functions such as AND, OR, and NOT, the IF function has even more value because it allows you to test multiple conditions in desired combinations. Continue reading

How to subtract in Excel: formula for numbers, percentages, dates and times

Subtraction is one of the four basic arithmetic operations, and every primary school pupil knows that to subtract one number from another you use the minus sign. This good old method also works for subtracting numbers and cells in Excel. Continue reading

Excel TRANSPOSE function to rotate data from columns to rows

Some Excel users prefer organizing data vertically in columns while others choose horizontal arrangement in rows. In situations when you need to quickly change the orientation of a given range, TRANSPOSE is the function to use. Continue reading

How to use LINEST function in Excel - formula examples

In this tutorial, intended for beginners, we will touch only lightly on theory and calculations behind the Excel LINEST function. Our main focus will be on providing you with a formula that simply works and which you can easily customize for your data. Continue reading

Excel VALUE function to convert text to numbers

Normally, Microsoft Excel recognizes numbers stored as text and converts them to the numerical format automatically. However, if the data is in a format that Excel cannot recognize, numeric values can be left as text making calculations impossible. Continue reading

How to get absolute value in Excel: ABS function with formula examples

One of the fundamental things we know about numbers is that they can be positive and negative. But sometimes you may need to use only positive numbers, and that's where the absolute value comes in handy. Continue reading

IFERROR with VLOOKUP in Excel - elegant way to trap #N/A errors

Excel VLOOKUP and IFERROR - these two functions may be pretty hard to understand separately, let alone when they are combined. In this article, you will find a few easy-to-follow examples that address common uses and clearly illustrate the formula logic. Continue reading

Excel substring: how to extract text from cell

Although there is no such thing as Substring function in Excel, there exist three Text functions to extract text of a given length from a cell. Additionally, there are FIND and SEARCH functions to get a substring before or after a specific character. Continue reading

How to divide in Excel and handle #DIV/0! error

As with other basic math operations, Microsoft Excel provides several ways to divide numbers and cells. Which one to use depends on your personal preferences and a particular task you need to solve. Continue reading

Excel IFERROR function with formula examples

"Give me a formula, and I shall make it return an error," an Excel user would say. In this tutorial, we won't be looking at how to return errors in Excel, we'd rather learn how to prevent them in order to keep your worksheets clean and your formulas transparent. Continue reading

Excel TODAY function to insert today's date and more

You want to put today's date in some cell? Or you wish to highlight the current date in your Excel calendar? Or you'd like to find the date closest to today? All this can be done by using the Excel TODAY function and this tutorial will teach you how. Continue reading

Excel MOD function to get remainder and more

The Excel MOD function is designed to get the division remainder, but it can do much more than its original purpose. In this tutorial, you will find a few non-trivial uses of MOD in Excel that may prove useful in your worksheets. Continue reading

Excel RANK functions with formula examples

When you need to determine the relative position of a number in a list of numbers, the easiest way is to sort the numbers in ascending or descending order. If for some reason sorting is not possible, the Excel RANK function is the perfect tool to do the job. Continue reading

Basic Excel formulas & functions with examples

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel. Continue reading

How to square root in Excel: SQRT function and other ways

Squaring a number and finding a square root are very common operations if mathematics. But how do you do square root in Excel? Either by using the SQRT function or by raising a number to the power of 1/2. Continue reading

How to calculate standard deviation in Excel

In statistics, the arithmetic mean and standard deviation are two closely related concepts. But while the former is understood by most, the latter is comprehended by few. The aim of this tutorial is shed some light on what the standard deviation is and how to calculate it in Excel. Continue reading

Pages: 1 2 3 4 5 6 7 8 9