StepByStep Index

Excel 2003 HLOOKUP
Excel’s HLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a HLOOKUP function in Excel, including an example.

Excel 2003 VLOOKUP
Excel’s VLOOKUP function is used to find specific information that has been stored in a table of data stored in a spreadsheet. This article covers how to create a VLOOKUP function in Excel, including an example.

Excel 2007 VLOOKUP Step by Step Tutorial
Excel’s VLOOKUP function can be used to find specific data that is stored in a spreadsheet table. This step by step tutorial walk you through using Excel's VLOOKUP function.

Using Labels in Excel Formulas and Functions
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".

Excel IF Function Step by Step Tutorial
The Excel IF function is one of the most useful functions available. The IF function allows for decision making in a spreadsheet. Specific criteria are setup that result in one of two actions occurring, depending on whether or not the criteria are met.

SUM and AutoSUM Step by Step Tutorial
The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut to using the SUM function is the Auto SUM button. This step by step tutorial walks through how to use Excel's SUM function and the Auto SUM feature to perform spreadsheet calculations.