### How to use DMAX and DMIN functions in Excel spreadsheets [Tip]

Excel isn’t the best application for setting up databases. However, you can still set up smaller flat-file (single table) databases with the software. It includes a variety of database functions among which are DMAX and DMIN...

### How to use FV function in Excel spreadsheets [Tip]

FV (Future Value) is a financial function you can add to Excel spreadsheets. This is a function that returns the future value of an investment based on regular periodic payments and a fixed rate of interest. An investment such as ...

### How to use AVERAGEIF function in Excel spreadsheets [Tip]

AVERAGEIF is an Excel 2010/13 function that returns average values based on specified criteria. For example, if you have a data table you can add an AVERAGEIF function to a cell to find average values from one column that match cr...

### How to use MODE and MEDIAN functions in Excel spreadsheets [Tip]

MODE and MEDIAN are two functions you can add to Excel spreadsheets to find averages from a range of values.Mode is the most frequently occurring value from a data range. Median is the middle number in a given set of values. For e...

### How to use MOD and QUOTIENT functions in Excel spreadsheets [Tip]

MOD and QUOTIENT are two Excel 2010/13 functions you can add to spreadsheets to find the remainder and integer portion of a division between values. These are functions that require just two values. Enter a number and divisor to f...

### How to use RANK.AVG and RANK.EQ functions in Excel spreadsheets [Tip]

RANK.AVG and RANK.EQ are new Excel 2010 functions. They aren’t included in other versions except Excel 2013. These functions show you the statistical rank of a value within a list. So the rank tells you their order in a list of va...

### How to use EXACT functions in Excel spreadsheets [Tip]

EXACT is a function you can add to Excel 2010/13 spreadsheets. This function compares two values (text or numerical) in two cells and tells you if they match or not. If they match it returns TRUE, and if they don’t it returns FALS...

### How to use random numbers in Excel spreadsheets [Tip]

If you need to add random numbers to an Excel spreadsheet you can always enter them manually. However, it might take a while to enter lots of random numbers. Instead, add random numbers with Excel’s RAND and RANDBETWEEN func...

### How to use CEILING functions in Excel spreadsheets [Tip]

CEILING is an Excel 2010/13 function that you can add to spreadsheets to find ceiling values. The function shows you the ceiling value of a number based on a specific multiple. For example, the ceiling value of five based on a mul...

### How to use CHOOSE function in Excel spreadsheets [Tip]

CHOOSE is another function you can add to Excel 2010/13 spreadsheets. It can be a handy function for returning values from a list. It takes an index number that searches for corresponding values in a string or list. For example, e...

### How to use ISODD and ISEVEN functions Excel spreadsheets [Tip]

Excel 2010/13 has a range of functions you can add to spreadsheets. Some can provide you with details about cell details. For instance, you can add the ISODD function to a spreadsheet cell to find out if a referenced cell includes...

### How to use SUBTOTAL function in Excel spreadsheets [Tip]

SUBTOTAL is 11 Excel functions wrapped into one. It supports a total of 11 functions. So SUBTOTAL provides you with a list of alternative functions that you can add to the spreadsheet by entering the function number. First, enter ...

### How to sum SUMSQ function in Excel spreadsheets [Tip]

The square of a number is the number multiplied by itself. For example, two x two equals four, which is the square for that number. In Excel 2010/13 spreadsheets you can add squares of specified values together with the SUMSQ func...

### How to find factorials in Excel [Tip]

The factorial of a number is the product of all numbers less than n. For example, the factorial of four would be four x three x two x one, which amounts to 24. You can find the factorial of number in Excel 2010/13 with the FACT fu...