Excel Function Tutorials
One of Excel's most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data. Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel.
- Excel 2010 Functions (67)
- IF Functions (14)
- Count Functions (6)
- Date Functions (15)
- Logical Functions (4)
- Math Functions (10)
- Text Functions (10)
- Rounding Number Functions (8)
- Excel 2003 Functions (20)
- Random Number Functions (3)
- Trig Functions (5)
- Lookup Functions (11)
- Statistical Functions (14)
- Information Functions (5)
- Engineering Functions (1)
- Financial Functions (2)
Excel IF Functions
IF functions are one of the most versatile functions available in Excel and other spreadsheet programs. This Series of Articles covers how to use Excel IF functions as well as uses for the IF function in spreadsheets.
Nested Functions in Excel
How to use nested functions in Excel such as IF, AND, OR, SUM, and ROUND. These tutorials include step by step examples of how to use nested functions in Excel.
Nested Functions in Excel
Nested functions in Excel combine the operations of two or more functions in one cell. This tutorial includes a step by step example on nested functions in Excel.
Using Labels in Excel Formulas and Functions
Using labels in formulas and functions 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.
Excel SUM Function
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
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.