Excel
Pages - Menu
(Move to ...)
Home
▼
Monday, February 28, 2011
How to Use Excel's Concatenate Function
›
1. Learn the syntax for Concatenate. It is Concatenate (text_1,text_2,...text_n) where text_1,text_2,...text_n are 1 to 30 text items that...
How to Preview an Excel Worksheet
›
1. Start Microsoft Excel and open a spreadsheet that you are ready to print. 2. Choose the 'File' menu. Select 'Print Previe...
How to Modify Pivot Table Data
›
Change Data 1. Locate the source data that your pivot table is based on. This is normally at the top left corner of the worksheet, or on a...
Sunday, February 27, 2011
How to Identify Duplicate Items in Excel
›
1. Click on the column name that you want to check for duplicates. You can also select a range across several columns by selecting the top...
How to Customize Columns and Rows in Excel
›
Customize the Columns 1. Click and drag your mouse over the columns you want to customize. Alternately, click the letter directly above th...
How to Convert Quattro Pro for Windows to Excel 2007
›
1. Download the Quattro Pro file converter from Microsoft. The link is in the Resources section below. 2. Double-click on the file you d...
How to Open to a Specific Directory in Excel 2007
›
1. Click the 'Office' button in the upper left of Excel. 2. Select 'Excel Options.' 3. Click 'Save' on the lef...
Saturday, February 26, 2011
How to Insert Page Numbers in Excel 2007
›
Adding Page Numbers 1. Open the worksheet to which you would like to add sequential numbering, and select the 'Insert' tab from th...
How to Link Cell Sheets in Excel 2007
›
1. Type '=' in the cell that you want the link to occur in. 2. Click the worksheet, located at the bottom of the page, that cont...
How to Calculate Compound Annual Interest in Excel 2003
›
1. Label cell A1 'Original Principal,' cell A2 'Compounding Periods Per Year,' A3 'Annual Interest Rate (as a percenta...
How to Use Checkboxes to Control Formulas in Excel
›
1. Open your Microsoft Excel spreadsheet. Locate the check box that you want to use, if you already have one in place. Alternatively, clic...
How to Set Up a Drop
›
1. Make a list of the items that you want to be listed in the drop-down menu. It is best to do this in a separate worksheet from where you...
How to Create Labels Using Microsoft Word
›
1. Open a new document in Microsoft Word. 2. Click on “Tools.” 3. Place the cursor on “Letters and Mailings” and click. 4. Drag the ...
Friday, February 25, 2011
How to Update the Links in Excel 2007
›
1. Open the Microsoft Excel 2007 spreadsheet file on your computer that you want to update links for. 2. Click on the 'Data' tab...
How to Use Formula Auditing in Microsoft Excel 2007
›
1. Click in the cell to which you would like to trace the connections. For example, if you would like to know which cells are part of a pa...
‹
›
Home
View web version