Sunday, June 26, 2011

How to Organize in Excel 2007


1. Open your Excel 2007 program. Right click the bottom of the program where is says 'Sheet 1.'
2. Click 'Rename' to give the worksheet a specific name. You can also rename the other available sheets or add more sheets by clicking the icon next to 'Sheet 3.' Multiple sheets allows you to organize different sets of data within the same spreadsheet, such as expenses and payments.
3. Type in the headers for your columns or rows to start adding data. For example, you might have separate columns for various types of expenses. You can add each expense to different rows along with the cost to organize the information more effectively.
4. Move your data into a table for even more organization power. Highlight the data you want in the table. Click 'Format as Table' from Styles. Choose a table layout. Your data will then be moved into a table, which makes sorting much easier.
5. Sum up totals for expenses, payments and other information with numbers or money easily. Highlight all the columns or rows you want to add up. Highlight one extra cell. From 'Formulas,' click 'AutoSum' and the numbers you highlighted will add up on the last cell.

Blogger news