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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
If you copy and paste some tables from a website into an Excel spreadsheet, they might include hyperlinks in them. To remove the hyperlinks, you could delete them and then re-enter the text. However, there’s a couple of shor...
