Basic Excel Formulas ShowBasic Excel Formulas
Below are some basic formulas for Microsoft excel:
Basic formula :
ADDITION cell A1 to A10 = sum (A1: A10)
AVERAGE cell A1 to A10 = average (A1: A10)
MAXIMUM cell A1 to A10 = max (A1: A10)
MINIMUM...
EXCEL: The INTERSECTION function ShowEXCEL: The INTERSECTION function
You have a table consisting of rows and columns.
Want to know the value of the cell at the intersection of a particular row / column in your table
Example:
Your table:
- starts C3 to F3 ......
Difference between dates with the DATEDIF function ShowDifference between dates with the DATEDIF function
The Syntax
Example
Making use of:
Notes
The DATEDIF function is not documented in Excel, here are some informations about it
The Syntax
=DATEDIF(start date;end date;type of...
Excel – Arrow keys stopped functioning ShowExcel – Arrow keys stopped functioning
Issue
Solution
Note
Issue
I am using Excel 2000. I am trying to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I was always able to move up,...
Download XLS (Excel) to DBF Converter ShowDescription
The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Spreadsheets - Mathematical Functions ShowStandard Functions
Function
Description
ABS()
This function returns the absolute value of a number. It therefore
returns the number, if it is positive, or the opposite (positive) if it
is negative
ODD(value)
Rounds a number up to the...
Spreadsheets - Arithmetic Functions ShowThe Concept of a Function
Spreadsheets generally have a large number of
integrated functions for processing data. There are hundreds,
categorised as follows:
Arithmetic functions that offer basic tools to process numerical data
Statistical...
E-Procurement - Management of the purchasing function Showe-Procurement
The term "e-Procurement" (for Electronic Procurement, sometimes written eprocurement) refers to the use of new technologies to automate and optimize the purchasing function of the company.
The term refers to a B2B exchange, i.e. a...
As per http://office.microsoft.com/en-us/excel/HP051992911033.aspx Sheets in a workbook Limited by available memory (default is 3 sheets) for excel 2003
Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.
