QuickTips Index - page 2

**Excel 2007 ROUND Function**

The ROUND function, one of Excel's math functions, is used to reduce a number to a specific number of decimal places.

**Excel 2007 FLOOR Function**

The FLOOR function, one of Excel's math functions, is used to round a number downwards to a specified multiple. This article includes a step by step example of using the FLOOR function in Excel.

**Excel 2007 CEILING Function**

The CEILING function, one of Excel's math functions, is used to round a number upwards to a specified multiple. This article includes a step by step example of using the CEILING function in Excel.

**Excel 2007 MROUND Function**

The MROUND function, one of Excel's math functions, can be used to round a number upwards or downwards to a specified multiple. This article includes a step by step example of using the MROUND function in Excel.

**Excel 2007 RANDBETWEEN Function**

Generate random numbers in Excel using the RANDBETWEEN function. This tutorial has a step by step example of how to generate random numbers in Excel using the RANDBETWEEN function.

**Random Numbers in Excel 2007**

Generate random numbers in Excel using the RAND function. This tutorial has a step by step example.

**Calculate the Number of Days Between Dates in Excel**

The Excel DAYS360 Function can be used in accounting systems to calculate the number of days between two dates based on a 360-day year(twelve 30-day months). This article includes a step by step example of using the DAYS360 function in Excel.

**Excel 2003 ROUND Function**

Rounding numbers and rounding decimals is easy to accomplish in Excel.
The ROUND function is one of the math functions available in Microsoft Excel 97 to Excel 2007. This article includes an example to walk you through using the ROUND function.

**Excel 2003 COUNT Function**

Excel's COUNT function is a very useful function. What it does is count up the number of cells containing numbers in a selected range.

**Excel 2007 TODAY Function**

The TODAY function, one of Excel's date functions, is used to add today's date to a spreadsheet.

**Find the Square Root of Numbers in Excel 2007**

This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.

**Excel 2007 VALUE Function**

The VALUE function, one of Excel's text functions, is used to convert text to values. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.

**Excel 2007 AutoMIN**

This article shows you how to use the AutoMIN function, a shortcut to using Excel's MIN function to find the smallest number in a list. Included is a step by step example of using the AutoMIN function.

**Excel 2007 MIN Function**

The MIN function, one of Excel's statistical functions, is used to find the smallest or minimum value in a given list of numbers. This article includes an example to walk you through using Excel's MIN function.

**Excel 2007 AutoMAX**

This article shows you how to use the AutoMAX function, a shortcut to using Excel's MAX function to find the largest number in a list. Included is a step by step example of using the AutoMAX function.

**Excel 2007 AutoCOUNT**

This article shows you how to use the AutoCount feature to count numbers in Excel. Included is a step by step example of using the AutoCount function.

**Excel 2007 MAX Function**

The MAX function, one of Excel's statistical functions, is used to find the largest or maximum number in a given list of values. This article includes an example to walk you through using Excel's MAX function.

**Excel 2007 AutoSUM**

The AutoSum feature, a shortcut to using Excel's SUM function, provides a quick way to add up columns or rows of figures in a spreadsheet.

**Excel 2007 AutoAVERAGE**

This article shows you how to use the AutoAverage feature, a shortcut to using Excel's AVERAGE function. Included is a step by step example of using the AutoAverage feature.

**Excel 2007 COUNTBLANK**

The COUNTBLANK function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet certain criteria.

**Excel 2007 COUNTA Function**

Excel 2007's COUNTA function allows you to count up the number of cells containing numbers, dates, or text labels in a selected range.

**Excel 2007 COUNT Function**

Excel 2007's COUNT function allows you to count up the number of cells containing numbers in a selected range.

**Excel 2007 SIGN Function**

The SIGN function, one of Excel's math functions, will tell you whether the number in a cell is negative or positive in value or whether it is equal to zero. This article includes a step by step example of using the SIGN function in Excel.

**Excel 2007 INFO Function**

Excel's INFO function gives out information on a number of items related to the current spreadsheet such as the current file's location, the number of worksheets open in the current workbook, and even the version of Excel that is being used. This article includes an example of how to use the INFO function in an Excel spreadsheet.

**Excel 2007 CELL Function**

Excel's CELL function gives you information about a cell such as formatting, data type,location, and whether the cell has been protected or locked. This article shows you how to use this function in an Excel spreadsheets.