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 will be joined together. These values may be numbers, text strings or references to single cells.2. Use the ampersand () as the calculation operator. This method also may be used to join text items instead of the Concatenate function. For example, =A1A2 will return the same result as =Concatenate (A1,A2).3. Look at an example for Concatenate. Set A2=salmon, A3=species, A4=25 and enter =Concatenate('Stream population for ',A2,' ',A3,' is ',A4,'/mile')...
Browse » Home » All posts
Monday, February 28, 2011
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 Preview' to enter 'Print Preview' view.3. Navigate through your Excel spreadsheet pages by using the 'Next' and 'Preview' buttons at the top of the 'Print Preview' view.4. Zoom on your Excel spreadsheet by clicking the 'Zoom' button while in the 'Print Preview' view. Click on 'Zoom' once to magnify the spreadsheet page you are on. Click it again to return to full-page view.5. Print the spreadsheet by clicking the 'Print' button to exit 'Print Preview' and bring up the...
How to Modify Pivot Table Data
Change Data1. 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 separate worksheet that you can access from the tabs at the bottom left corner of the Excel window.2. Make the required modifications to your data.3. Navigate back to the Excel pivot table and click on any cell within the table.4. Click the 'Options' tab at the top of the screen, then press the 'Refresh' button in the middle of the toolbar. Your pivot table will now reflect the changes you made in the source data.Add New Data5. Locate and navigate...
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-left cell in the range and then holding 'Shift' while selecting the bottom-right cell.2. Select the 'Home' tab at the top of the Excel window. Click on the 'Conditional Formatting' button in the 'Styles' area of the ribbon.3. Move your mouse over 'Highlight Cell Rules' in the drop-down menu and then choose 'Duplicate Values.'4. Choose the type of color to apply to duplicate cells by using the drop-down box on the right. It defaults to a light red color...
How to Customize Columns and Rows in Excel
Customize the Columns1. Click and drag your mouse over the columns you want to customize. Alternately, click the letter directly above the column to automatically select all the cells in this area.2. Select the 'Column' option under the 'Format' drop-down menu, then click the 'Width' option to enter a distinct value for this measurement.3. Use the 'Formatting Palette' (Mac), the 'Formatting Toolbar' (Windows) or the 'Font' group on the 'Home' tab (Excel 2007) to personalize the column. Click the 'Fill Color' option to apply a background color, or click the 'Pattern' or 'Pattern Color' box...
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 download (qp7conv.exe). Follow the download instructions on the screen.3. Open Excel 2007. Click on the Office Button (the round icon at the upper left with the Microsoft Office logo on it) and select 'Open.' On the drop-down menu for 'file type,' select Quattro Pro. This will allow you to open any Quattro Pro file (with extensions *.wb3 or *.wb2) into Excel 20...
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 left hand menu.4. Change 'Default file location' to the specific directory you want to use. Click 'OK.' Now if you open or save a file, your new directory is the one that will op...
Saturday, February 26, 2011
How to Insert Page Numbers in Excel 2007
Adding Page Numbers1. Open the worksheet to which you would like to add sequential numbering, and select the 'Insert' tab from the text group.2. Choose 'Header and Footer' and then select 'Click to add header,' or 'Click to add footer,' depending on where you would like the numbers to be located. This will display the 'Header and Footer Tools' option.3. In order to select the location of the page number, you will choose the left, center or right section of the header or footer you have decided on.4. Click 'Page Number' from the 'Header and Footer Elements group.'5. Once you see 'Page'...
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 contains the cell you want to link.3. Select the cell you want to link and press 'Enter.' Excel then takes you back to the page where you created the link. By selecting the cell, the Excel automatically formats the 'sheetname!celladdress' for y...
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 percentage)' and cell A4 'Annual Interest.'2. Enter the amount of money you put into the account in cell B1, the number of times per year into B2 and the annual interest rate expressed as a percentage in cell B3. For example, if you started with $1,000 and your bank pays 3.5 percent interest, compounded on a monthly basis, you would enter '1000' in cell A1, '12' in cell A2 and '3.5' in cell A3.3. Enter the formula '=B1*(1 B3/1200)^B2-B1' in cell A4. When you enter this formula, the...
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, click 'Developer,' 'Insert,' then click the check box to insert one. Right click the check box and click 'Format Control.' Click the cell button next to 'Cell link,' and designate a cell, then press 'Enter.' Choose a cell in a row or column that doesn't contain any other data as you can hide this row or column if you wish. Click 'OK.'2. Click the check box, and you will see the words 'TRUE' or 'FALSE' appear in the designated cell. 'FALSE' indicates an unchecked...
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 want to set up the drop-down menu box, so that it doesn't clutter up the spreadsheet. To access different worksheets, click on the tabs at the bottom of the page. Beginning in cell A1 of the new worksheet, enter each item for the list in a separate cell.2. Name the list by first highlighting the list of items. Then click in the 'Name Box' just above column A. Enter in a name for the list--Animals, for example. Once the list is created and named, it can...
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 cursor to “Envelopes and Labels…” and click.5. Open the “Labels” tab.6. Type the information that you wish to appear on the label.7. Check your printer to ensure that it is loaded with blank labels.8. Click pri...
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 and then click on the 'Edit Links' option from the 'Connections' group.3. Click on the 'Update Values' option and the links will automatically be updated. Click on the 'Close' button.4. Click on the 'Data' tab and then click on the 'Edit Links' option again. Click on the 'Startup Prompt' option.5. Click on the box next to the 'Ask to update automatic links' field so that it's selected. Close out of the dialog box, and now you will receive an automatic message...
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 particular formula, click in the cell containing the formula.2. Click on the 'Formula' tab in the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.3. Select the auditing option you want to appear on your worksheet. Trace Precedents will show cells included within a formula. Trace Dependents will show which formula a cell is included in. The arrows that Excel adds to your work sheet will print on your document.4. ...
Subscribe to:
Posts (Atom)