This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other common spreadsheet programs.
- Spreadsheet Formulas
- Excel 2003 Functions
- Excel Logical Functions
- Excel's Math Functions
- Excel Count Functions
- Excel Text Functions
- Excel's Date Functions
- Excel Statistical Functions
- Excel's Trig Functions
- Lookup and Reference Functions
- 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 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'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 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.
Lookup and Reference Functions
Excel's Lookup Functions can be used to simplify finding specific entries in a data table.
Excel's Financial Functions
Excel's Financial Functions can be used to help you determine changes in dollar value of investments and loans.
CAclubindia
