MS Excel Functions - VVI (wht else u need ...)

This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other common spreadsheet programs.

1. Spreadsheet Formulas
2. Excel 2003 Functions
3. Excel Logical Functions
4. Excel's Math Functions
5. Excel Count Functions
6. Excel Text Functions

7. Excel's Date Functions
8. Excel Statistical Functions
9. Excel's Trig Functions
10. Lookup and Reference Functions
11. Excel's Financial Functions

Spreadsheet Formulas

Formulas are one of the most useful features of spreadsheets like Excel. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections.

• Excel 2007 Formulas Step by Step Tutorial
• Excel 2003 Formulas Step by Step Tutorial
• Excel Math

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 IF Function Step by Step Tutorial
• How to Use Excel's SUM Function
• Excel 2003 AutoSUM
• Excel Autosum Function (video)
• Date Function in Excel
• Excel 2003 AVERAGE Function
• Excel 2003 MAX Function
• Excel 2003 MIN Function
• Excel VLOOKUP

• Excel HLOOKUP
• Excel 2003 COUNT Function
• Excel 2003 COUNTA Function
• Excel 2003 ROUND Function
• Excel 2003 AND Function
• Excel 2003 OR Function
• Excel 2003 PRODUCT Function
• Using Labels in Excel Formulas and Functions

Excel Logical Functions

Excel Logical Functions can be used to introduce decision making into your spreadsheet.

• Excel 2007 IF Function Tutorial
• Excel 2007 AND Function
• Excel 2007 OR Function

• Excel IF Function Step by Step Tutorial
• Excel 2003 OR Function
• Excel 2003 AND Function

Excel's Math Functions

Excel's Math Functions can be used to perform common mathematical operations such as addition (SUM function), multiplication (product function), and rounding numbers (ROUND function).

• Excel 2007 SUM Function
• Excel 2007 AutoSum
• Excel 2007 SUMIF
• Random Numbers in Excel 2007
• Excel 2007 RANDBETWEEN Function
• Excel 2007 ROUND Function
• Excel 2007 INT Function
• Excel 2007 ROUNDDOWN Function

• Excel 2007 ROUNDUP Function
• Excel 2007 QUOTIENT Function
• Excel 2007 PRODUCT Function
• Excel 2003 AutoSUM
• Excel 2003 AutoSUM AV ( Audio Visual) Tutorial
• Excel 2003 ROUND Function
• How to Use Excel's SUM Function?
• Excel 2003 PRODUCT Function

Excel Count Functions

Excel Count Functions allow you to count up the number of cells being used for a specific purpose such as the number of cells containing number values or the number of blank cells in a data range.

• Excel 2007 COUNT Function
• Excel 2007 COUNTA Function
• Excel 2007 COUNTIF Function
• Excel 2007 COUNTIFS Function

• Excel 2007 COUNTBLANK Function
• Excel 2003 COUNTA Function
• Excel 2003 COUNT Function

Excel Text Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

• Excel 2007 CONCATENATE Function
• Excel 2007 LEFT Function
• Excel 2007 RIGHT Function
• Excel 2007 MID Function
• Excel 2007 TRIM Function

Excel's Date Functions

Excel's Date Functions can be used to add such things as the current date, the current time, or the day of the week to a spreadsheet.

• Excel 2007 TODAY Function
• Excel 2007 NOW Function
• Excel 2007 NETWORKDAYS Function
• Date Function in Excel 2003

Excel Statistical Functions

Excel Statistical Functions can be used to analysis the data in a spreadsheet. For example, they can be used to tell you the number of data entries you have, the average value of your data.

• Excel 2007 AVERAGE Function
• Excel 2007 AVERAGE IF
• Excel 2007 MAX Function
• Excel 2007 MIN Function
• Excel 2007 MEDIAN Function
• Excel 2007 MODE Function

• Excel 2007 LARGE Function
• Excel 2007 SMALL Function
• Excel 2007 RANK Function
• Excel 2003 MAX Function
• Excel 2003 MIN Function
• Excel 2003 AVERAGE Function

Excel's Trig Functions

Excel's list of functions includes the common Trig functions that can be used to find the sine, cosine, and tangent of an angle.

• Excel 2007 SIN Function
• Excel 2007 COS Function
• Excel 2007 TAN Function
• Excel 2007 RADIANS Function

Lookup and Reference Functions

Excel's Lookup Functions can be used to simplify finding specific entries in a data table.

• Excel 2007 VLOOKUP Function
• Excel VLOOKUP
• Excel HLOOKUP
• Excel 2007 TRANSPOSE Function

Excel's Financial Functions

Excel's Financial Functions can be used to help you determine changes in dollar value of investments and loans.

• Calculating Loan Payments Using Excel's PMT Function
• Calculating Future Value Using Excel's PMT Function