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 amount of annual interest will be displayed. In this example, after entering the formula, Excel would display 35.56695, meaning you would earn $35.57 in interest for the year.

Read more ►

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 box, and 'TRUE' indicates a checked box.
3. Type '=IF(A1=TRUE,'checked','unchecked')' in the cell where you want to enter your formula.Replace 'A1' with the cell linked to the check box. This cell now responds as you wish to your check box.
4. Replace 'checked' (including quotation marks) with the formula you want to use if the check box is ticked. Replace 'unchecked' with the formula you want to use if the check box is not ticked. You now have a formula that will respond to the check box.

Read more ►

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 easily be added to the drop-down box menu.
3. Go back to the worksheet where you want the drop-down box. Click in the cell where it should be inserted.
4. Click on the 'Data' tab on the top toolbar. Click on the drop-down arrow next to 'Data Validation' in the 'Data Tools' section. Select 'Data Validation' and a box will open up.
5. Select the 'Settings' tab in the 'Data Validation' box. This is where you will enter the information to set up the drop-down box and menu.
6. Choose 'List' from the menu under the 'Allow' section. Additional fields will be displayed in the box. Make sure that the 'Ignore' blank and 'In-cell' drop-down boxes are checked.
7. Enter a source for the drop-down box. In the 'Source' box, enter the equal symbol (=) and the name of the list that you created. The name should be entered just as you entered it when you named the list. For example: enter =Animals.
8. Click 'OK.' You will see an arrow out to the side of the cell where you added the drop-down box. Click on the arrow to access items from the list. To add a specific item to the cell, click on it and the cell will be populated with that item.

Read more ►

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 print.

Read more ►

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 that appears every time you open Excel, asking if you want to update your links.

Read more ►

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.
Click 'Remove Arrows' to delete the arrows the auditing function added to your worksheet.

Read more ►

How to Check for Duplicate Text in Excel

Excel 2007
1. Go to Microsoft Excel 2007 and open the worksheet you want to check.
2. Insert a column header for the column you’re checking. Then select the column and click on the “Data” tab.
3. Click on “Remove Duplicates” in the “Data Tools” group.
4. Place check marks by “My data has headers” and the columns you want to verify. Then click on “OK” to remove the duplicates.
Excel 2003
5. Open your document in Excel 2003. Make sure the column has a column header, then select the column you want to verify.
6. Select “Data,” “Filter” and “Advanced Filter” from the toolbar.
7. Accept the selected range or use your own. To change the list range, click on the “List Range” button and select your range on the spreadsheet.
8. Select “Copy to another location” under “Action” and place a check mark by “Unique records only.” Click on the “Copy to” button and choose the location where the updated data is placed. Then click on 'OK' to apply the update.
9. Double-check that the updated list looks correct, then select the old column and delete it.

Read more ►

How to Convert Xlsb to Xls

1. Double-click the XLSB file on your computer. This opens the file and loads Microsoft Excel on your desktop.
2. Click the 'File' menu button and then click 'Save As'. This opens your 'Save' dialog window. Select 'XLS' from the 'File type' drop-down box.
3. Click 'Save'. The file is saved to your hard drive and converted to the XLS file format.

Read more ►

How to Install Microsoft Excel Features in Excel 2003

1. Click the 'Start' or Windows button in the lower left corner of the screen, then select the 'Control Panel' option.
2. Choose the 'Programs and Features' or 'Add/Remove Programs' option, depending on which version of Windows is installed on your system.
3. Scroll to Microsoft Office 2003, then select the 'Change' option.
4. Choose the option to 'Add or Remove Features', then click the 'Next' button.
5. Check the box next to Microsoft Excel, as well as the box next to 'Choose advanced customization of applications'. Click the 'Next' button.
6. Click the ' ' sign next to Microsoft Office Excel, then click the feature that you would like to install. Select the 'Run from my computer' option. Repeat for any additional features you would like to install, then click the 'Update' button.

Read more ►

How to Disable the Automatic Updates for MS Office

1. Click the Windows 'Start' button and type 'Windows Update' in the search bar. Click on 'Windows Update' (it should be the first item listed).
2. Click 'Change Settings' located on the left hand column.
3. Click on the option list under 'Important Updates.' It will currently be set to 'Install Updates Automatically' but you can change this. There are a few options such as not downloading updates at all, or having the computer only download them automatically (but not install them without you choosing to do so). Pick the option that you feel most comfortable with; as long as you don't select the automatic install option you will be fine.
4. Click 'OK' to save the option.

Read more ►

How to Automatically Number Rows for an Excel Spreadsheet

1. Open the Microsoft Excel application on your computer. Click on the first cell where you want to establish a numbered pattern.
2. Type the beginning of the pattern in the first cell, like a “1.” Click on the next cell to continue the sequence by typing a following number in the sequence, like “2.”
3. Highlight the cells that you put numbers in and click on the fill handle in the lower right corner of the highlighted selection. Drag the handle down to complete as many rows as you want and the rows will be automatically numbered.
4. Click on the “Tools” option from the top tool bar menu if you don’t see the fill handle appear. Click the “Options” button and then click on the “Edit” tab.
5. Check the box next to the “Allow cell drag and drop” field. Every time you start to perform a function in a new row, or if you add a row, then a sequential number will automatically be updated.

Read more ►

How to Type a Negative Number in MS Excel

1. Launch Microsoft Excel 2010.
2. Click on a blank cell.
3. Press the 'Minus' sign ('-') on the keyboard and immediately press the desired numbers on the keyboard. Press 'Enter,' 'Tab' or an arrow key to save the number, and move to an adjacent cell.
4. Right click on the cell with the negative number displayed. Click 'Format Cells' on the context menu.
5. Click the 'Number' tab and click the desired format name in the left column to display options for that particular number format. Click the desired options for the number on the right. The options will vary by the type of number format being used.

Read more ►

How to Calculate Covariance in Excel 2007

1. Run Microsoft Excel 2007 and open the workbook that contains your data arrays.
2. Determine the cell addresses for your two arrays. For example, if your arrays are contained in the first 10 columns of rows A and B, then the cell addresses for those arrays are A1:A10 and B1:B10.
3. Click a blank cell that you would like to use to display the covariance between your data arrays.
4. Type the following in the cell:=COVAR(A1:A10,B1:B10)Substitute the cell addresses for your two data arrays in place of the sample addresses in the example.
5. Press 'Enter.' The cell displays the covariance between the two data arrays.

Read more ►

How to Calculate Pecentage Using Excel

1. Browse to the Excel file containing the data for which you wish to calculate a percentage, and then double-click that file to open it in Excel 2010.
2. Locate the cells containing the data that represents your 100 percent value and the cell to which you are comparing it.
3. Note the cell names for those two particular cells. For example, if one piece of data is in the upper-leftmost cell, then the cell name would be 'A1.'
4. Click inside the cell in which you want to display the percentage.
5. Type '=AA/BB,' where 'BB' is the name of the cell containing your 100 percent value, and 'AA' is the name of the cell containing the amount to which you are comparing it.
6. Press 'Enter' to perform the calculation.
7. Right-click the cell into which you just typed your formula, and then click 'Format Cells.'
8. Click the 'Number' tab at the top of the window.
9. Click 'Percentage' in the column at the left side of the window, and then click 'OK.'

Read more ►

How to Upgrade to Excel 2007

1. Insert the Microsoft Office 2007 setup disc into the computer. The installer should automatically launch. If it does not, open the 'Computer' folder, open the Microsoft Office disc and double-click the 'setup.exe' file.
2. Enter your Product Key when prompted. Accept the license agreement.
3. Click 'Custom.' Select 'Remove all previous versions' or 'Remove only the following applications: > Microsoft Office Excel.' The former will remove all applications in the currently installed Microsoft Office suite.
4. Select 'Installation Options.' Select 'Microsoft Office Excel > Run from Computer.' If you wish to upgrade other Office applications during this installation, select those as well.
5. Click 'Install Now.' Click 'Close' when the upgrade completes.

Read more ►