Excel 2007 TRANSPOSE Function
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
Excel 2007 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
Excel 2007 VLOOKUP Step by Step Tutorial
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
Excel 2007 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
Excel TODAY Function
You could just type the date into a cell, or, if you desire more flexibility, you can use the TODAY function, which is one of Excel's date functions.
To find out how to use the function, read the article on using the Excel 2007 TODAY Function.
Related Articles
Excel 2007 DATE Function
These are known, not surprisingly, as Excel's date and time functions, and they can be found under that heading on the formulas tab of the ribbon in Excel 2007.
One in this group is the DATE function. Unlike the more commonly used NOW and TODAY functions, which can be used to add the current time and/or date to a spreadsheet, the DATE function is often used when dealing with dates or times in formulas or other functions.
As well, it can be used to convert regular dates and times to the computer's serial date.
To find out the details of using this function, read the article on Excel 2007 DATE Function.
Related Articles
Excel 2007 NOW Function
These are known, not surprisingly, as Excel's date and time functions, and they can be found under that heading on the formulas tab of the ribbon in Excel 2007.
One of the more commonly used in this group is the NOW function, which adds the current time and date to a cell in your spreadsheet.
You can then format this entry to show just the current date, or just the current time, or leave it as is if you want both displayed.
To find out the details of using this function, read the article on using the Excel 2007 NOW Function.
Related Articles
Calculate the Number of Days Between Dates in Excel
If you need to know the number of days between a start and end date there is a function in Excel that can help you out.
The DATEDIF function will not only find the number of days, it can also be used to find the number of months or years as well.
One thing however, DATEDIF is undocumented - which means you won't find it listed with other functions in Excel. It does work though and it can simplify the task of finding the days, months, or years between dates.
To find out the details of using this function, read the article on Calculate the Number of Days Between Dates in Excel.
Related Articles
Sort Data by Cell Color in Excel 2007
Excel's sort feature is probably used most often to sort spreadsheet data by such things as names, titles, or numbers. Another very useful ability that the Sort feature has is to sort by cell color.
If you have used conditional formatting to change the cell color of specific data then sorting by cell color allows you to group such data together. Doing so often makes it easier to find specific information or to spot trends in a large table of data.
To find out more, read the article on how to Sort Data by Cell Color in Excel 2007.
Related Articles
Sort Data by Font Color in Excel 2007
Excel's sort feature is probably used most often to sort spreadsheet data by such things as names, titles, or numbers. Another very useful ability that the Sort feature has is to sort by font color.
If you have used conditional formatting or you have formatted negative numbers to show up in a different color, then sorting by font color allows you to group such data together. Doing so often makes it easier to find specific information or to spot trends in a large table of data.
To find out more, read the article on how to Sort Data by Font Color in Excel 2007.
Related Articles


