Excel 2003 Functions
Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel 2003.
Excel PRODUCT Function
In Excel, a function is just a built-in formula. Functions have been added to spreadsheets to simplify performing specific mathematical operations in the spreadsheet. The PRODUCT function can be used when multiplying numbers or a range of values together.
In Excel, a function is just a built-in formula. Functions have been added to spreadsheets to simplify performing specific mathematical operations in the spreadsheet. The PRODUCT function can be used when multiplying numbers or a range of values together.
Excel IF Function Step by Step Tutorial
The IF function, one of Excel's logic functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using the IF function.
The IF function, one of Excel's logic functions, tests to see if a certain condition in a spreadsheet is true or false. This article includes an example to walk you through using the IF function.
SUM and AutoSUM Step by Step Tutorial
This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations.
This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations.
Excel SUM Function
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
Excel Auto SUM
The Excel Auto SUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet.
The Excel Auto SUM is a shortcut to using the SUM function. By using the icon on the standard toolbar, you can quickly enter the SUM function into your spreadsheet.
AutoSUM AV ( Audio Visual) Tutorial
Next in our series on The SUM and AutoSUM function is an Audio Visual tutorial that takes you through several examples of using AutoSum.
Next in our series on The SUM and AutoSUM function is an Audio Visual tutorial that takes you through several examples of using AutoSum.
Date Function in Excel
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week.
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week.
Excel AVERAGE Function
Excel’s AVERAGE function is one of the Statistical Functions that are included with the program. The AVERAGE function can be used to find the average, or arithmetic mean, of values in a selected range of cells.
Excel’s AVERAGE function is one of the Statistical Functions that are included with the program. The AVERAGE function can be used to find the average, or arithmetic mean, of values in a selected range of cells.
Excel MAX Function
The Max function, one of Excel’s statistical functions, is used to find the largest value in a given list of arguments. This article includes an example to walk you through using this function.
The Max function, one of Excel’s statistical functions, is used to find the largest value in a given list of arguments. This article includes an example to walk you through using this function.
Excel MIN Function
The MIN function, one of Excel’s statistical functions, is used to find the smallest value in a given list of arguments. This article includes an example to walk you through using the MIN function.
The MIN function, one of Excel’s statistical functions, is used to find the smallest value in a given list of arguments. This article includes an example to walk you through using the MIN function.
Excel HLOOKUP
Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a HLOOKUP function in Excel, including an example.
Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a HLOOKUP function in Excel, including an example.
Excel VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a VLOOKUP function in Excel, including an example.
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This article covers how to create a VLOOKUP function in Excel, including an example.
Excel's 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'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's COUNTA Function
A very useful, yet little known function in Excel is COUNTA, which will count up the number of cells containing data – either numbers or labels in a selected range.
A very useful, yet little known function in Excel is COUNTA, which will count up the number of cells containing data – either numbers or labels in a selected range.
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.
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 AND Function
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
The AND function is one of Excel’s “Logical Functions”. Like most logical functions, the AND function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
Excel OR Function
The OR function is one of Excel’s “Logical Functions”. Like most logical functions, the OR function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
The OR function is one of Excel’s “Logical Functions”. Like most logical functions, the OR function only returns a true or false result. To determine whether the output will be true or false, the function evaluates at least one expression located in another cell in the spreadsheet.
Using Labels in Excel Functions and Formulas
Using labels in functions and formulas in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January". Using labels in a formula or function is often easier then trying to pin point the exact cell references of your data.
Using labels in functions and formulas in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January". Using labels in a formula or function is often easier then trying to pin point the exact cell references of your data.