Monday November 9, 2009
On occasion there is a need to transfer a row of
data into a column. This might be done when re-vamping a
spreadsheet or when creating a summary table of information.
Whatever the reason, Excel has a
function, the TRANSPOSE function, that simplifies the task. This function will copy a
row of data and place it in a column or copy data from a
column into a row.
To find out the details of using this function read the article on the
Excel 2007 TRANSPOSE Function.
Related Articles
Friday November 6, 2009
After discussing Excel's VLOOKUP
function, I thought I should follow that up with the HLOOKUP function.
Both LOOKUP functions can be used to help you find specific
data located in a
database or list of data. The difference between the two functions lies in how your data is organized in your
spreadsheets.
If the data is organized in
columns, you would use VLOOKUP, if the data is kept in
rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the
Excel 2007 HLOOKUP Function.
Related Articles
Wednesday November 4, 2009
If you store large amount in spreadsheets, Excel's VLOOKUP is a handy
function to know. It allows you to easily locate specific
data in a
database or list.
For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.
For details on how to setup and use the VLOOKUP function in your spreadsheets, read the article
Excel 2007 VLOOKUP Step by Step Tutorial.
Related Articles
Monday November 2, 2009
One Excel
function that can be used to calculate the number of days between two dates is the
EDATE function.
It is mainly used to calculate the maturity date for an investment that falls on the same day of the month as the issue date or due date for a project.
The function can also be used to find the start date rather than the due date by using negative numbers when writing the function.
To find out the details of using this function, read the article on
Excel 2007 EDATE Function.
Related Articles