Excel 2003 Functions
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.
Excel 2003 COUNTIF Multiple Criteria
How to count up the number of cells in selected ranges that meet multiple criteria in Excel. This tutorial includes a step by step example of how to count up the number of cells in selected ranges that meet multiple criteria in Excel.
Excel VLOOKUP Tutorial
Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table. This tutorial includes a step by step example.
Excel HLOOKUP Step by Step Tutorial
This tutorial covers how to use HLOOKUP to find specific data that is stored in an Excel database. This tutorial includes a step by step example of how to use the HLOOKUP function in Excel.
Count in Excel
Excel has a number of Count Functions that will total the number of cells in a selected range. The reason that there is more than one COUNT function is that each does a slightly different job.
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.
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.
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.
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.
Excel MAX Function
The Max function, one of Excel’s statistical functions, is used to find the largest or maximum value in a given list of numbers. This article includes an example to walk you through using this function.
Excel 2003 MIN Function
The MIN function is used to find the smallest or minimum value in a given list of numbers.
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 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.
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 Nested OR and IF Function Tutorial
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.