Thursday, April 28, 2011

How to Change a Chart Axis in MS Word


1. Open the Word document that contains the chart you want to modify.
2. Click the chart axis you want to change. The axis will be outlined in black; right click over the axis to view options for editing the chart.
3. Select 'Format Axis' from the menu that pops up. The 'Format Axis' dialog window will open.
4. Select 'Axis Options' from the list of formatting options.
5. Select the axis scale minimum or maximum by checking 'Fixed' next to 'Minimum' or 'Maximum.' Type the minimum or maximum number you want to use for the scale.
6. Change the spacing in the tick marks on the axis by checking 'Fixed' next to 'Major unit. Enter the spacing you want for the axis tick marks. For example, if you want the tick marks to be spaced closer, enter a smaller number, such as '1.' If you want the tick marks to be spaced further apart, enter a large number, such as '5.' This is useful depending on the range of numbers on your axis.
7. Select how you want units on the axis displayed by clicking in the box next to 'Display Units' and selecting a measurement, such as hundreds or millions.
8. Click 'Close' after you finish making changes to your chart axis. The changes you selected will show up on your chart.
Read more ►

How to Find Links in Microsoft Excel


Links in Hyperlink
1. Open the Excel workbook containing the links you want to find.
2. Place your cursor in an empty cell and create a dummy hyperlink (so you can use its format to find other hyperlinks). To create the hyperlink, select the 'Insert' tab and click 'Hyperlink' in the 'Links' group. Select 'Existing File or Web Page' under 'Link to' in the 'Insert Hyperlink' dialog box. Type a website address (ex., 'http://some-address-123.com') into the 'Address' text field and click 'OK.'
3. Select the 'Home' tab and go to the 'Editing' group. Click 'Find Select' and 'Find.' The 'Find and Replace' dialog box appears. Click the 'Options' button to expand the dialog box.
4. Leave the 'Find what' text field blank. Click the arrow beside the 'Format' button and select 'Choose Format From Cell.' The dialog box minimizes and you are directed to your spreadsheet.
5. Click on the cell containing the dummy hyperlink you created in Step 2. The 'Find and Replace' dialog box reopens.
6. Select 'Workbook' from 'Within.' Select 'Values' under 'Look in.' Choose 'Find All.' All matching entries are displayed at the bottom of the dialog box.
7. Delete the dummy hyperlink from your spreadsheet.
Links in Cells
8. Repeat Step 3 of the previous section.
9. Type an open bracket '[' in the 'Find what' text field, representing the format of links in the formula bar.
10. Click 'Workbook' from 'Within' and 'Formulas' from 'Look In.' Press the 'Find All' button to display the matching links.
Links in Objects, Chart Titles or Data Series
11. Go to the text box, chart title, object or data series containing the link you want to find. To find it quickly, select the 'Home' tab and go to the 'Editing' group. Click 'Find' and 'Go To Special.'
12. Check 'Objects' in the 'Go To Special' dialog box and press 'OK.'
13. Press the 'Tab' key and check the formula bar for references to links.
Links in Names
14. Click the 'Formulas' tab in the ribbon and go to the 'Defined Names' group.
15. Click the 'Name Manager' button to display the 'Name Manager' dialog box.
16. Check the 'Refers To' tab for the link you want to find. Its cell address is displayed in the dialog box.
Read more ►

Wednesday, April 27, 2011

How to Make the Top Line Stay Visible in Excel


1. Open your spreadsheet in Microsoft Excel.
2. Click the 'View' tab in the ribbon.
3. Click 'Freeze Panes' in the 'Windows' group and click 'Freeze Top Row' to make the top line stay visible.
Read more ►

How to Convert Excel 2003 to the 2007 Format


1. Open the file to be converted using Excel 2007. Click 'File' in the menu bar and select 'Open.' Navigate to the file you wish to open and convert. This will open the file in Compatibility Mode.
2. Click the 'Microsoft Office Button' located in the menu bar then click 'Convert' in the pop up window. When asked if you are sure you wish to convert this workbook to the new file format, click 'OK' to confirm. If you do not want this warning message to appear again, select the option for 'Do not ask me again about converting workbooks.'
3. Click 'Yes' in the window that appears asking if you want to work on the file in the Excel 2007 file format. This will close the file, convert it to the new file format and reopen it for you to work on. After you have finished working with the file, click 'Save' in the File menu bar to save the file in the new format.
Read more ►

Tuesday, April 26, 2011

How to View Excel Spreadsheets Without Microsoft Office


1. Download and install the free Excel Viewer on your computer. You can find a link to the download in the resources section of this article.
2. Open the Excel Viewer. Click 'File' from the Excel Viewer window toolbar and then select 'Open.'
3. Select the Excel file you want to view and then click 'Open.' The Excel Viewer will automatically display the Excel spreadsheet you have selected.
Read more ►

How to Cross Out on Excel


1. Launch Microsoft Excel 2010 to begin working in a new workbook, or double-click an existing Excel spreadsheet to edit.
2. Click on the cell containing the text that you want to cross out. If you want to select multiple cells, hold down the 'Ctrl' key on your keyboard, and then click each desired cell with your mouse.
3. Click the 'Home' tab at the top of the window.
4. Click the 'Format Cells: Fonts' button at the bottom right-corner of the 'Font' section of the ribbon. The button is a small square with an arrow in it.
5. Check the box to the left of 'Strikethrough' in the 'Effects' section of the window, and then click 'OK.'
Read more ►

How to Make a Flowchart in Excel


1.
Make the 'Drawing' toolbar available in Excel 2003 by going to the 'View' menu and pointing to 'Toolbars.' Click on 'Drawing'; the 'Drawing' toolbar will appear at the bottom of the window. In Excel 2007, go to the 'Insert' tab of the ribbon and find the 'Illustrations' section.
2.
Click on 'AutoShapes' in Excel 2003 and point to 'Flowchart.' Click on the first shape you want to use and click onto the worksheet to place it in the appropriate area. In Excel 2007, click the 'Shapes' button and choose the shape you want to use first from the 'Flowchart' gallery. Click onto the worksheet and place the shape there. For the best results, begin your flowchart near the top of the worksheet, but leave a few rows in case you decide to add text above it.
3.
Add more shapes to your flowchart in the same manner. You need to have one shape for each step in the process. The position of the shape will depend on when the step takes place, as well as how you determine whether to take the step. For instance, if Step One is a yes or no question, you might put 'Yes' in a shape that is down and to the right of the first shape and 'No' down and to the left. Right-click each shape and click on 'Add Text' to add the information needed.
4.
Add connectors between the shapes. In Excel 2003, click the 'AutoShapes' button and click on 'Connectors.' Choose a connector and click on the first shape. Drag into place, linking the two shapes. In Excel 2007, choose a connector from the 'Shapes' drop-down menu. Connect all of the appropriate shapes.
5.
Format the shapes for more interest and effect. Right-click a shape and choose 'Format Shape' (or 'Format AutoShape'). On the 'Font' tab, you can choose a different font, change the font size or color or add effects. On the 'Alignment' tab, you can center your text. On the 'Colors and Lines' tab, you can fill the shape with a color or other fill effect. When you are finished making changes, clck 'OK.'
6.
Save your worksheet. You can use the keyboard shotcut 'Ctrl S.' Print it out if desired.
Read more ►

Monday, April 25, 2011

How to Paste Special in Microsoft Excel 2003


1. Select the cells, rows, or columns that you want to manipulate and go to the Edit menu and select 'Copy' (or press Ctrl-C) to copy the data.
2. Click the cursor on the cell or cells where you want the manipulated data to be placed.
3. Go back to the Edit menu and select 'Paste Special.' This will open up a window where you will choose how to manipulate the selected data.
4. The first section, labeled 'Paste,' is where you tell Microsoft Excel what parts of the data you want to paste. 'All' will paste all of the copied data, 'Formulas' will paste just the formulas connected to the copied data, 'Values' will paste just the outcome of the copied data and not the formulas and 'Formats' will paste just the style of the copied data.
5. The second section, labeled 'Operation,' allows you to manipulate the copied data. You can select one of the four basic arithmetic operations--Add, Subtract, Multiply, or Divide. Click the cursor on the cell or cells that you want to combine with the copied data, and Microsoft Excel will perform the operation between the two sets of values.
6. When you have chosen the 'Paste' and 'Operation' options you want, click 'OK' and Microsoft Excel will paste the data appropriately.
Read more ►

How to Find a Confidence Interval for the True Mean Using Excel 2007


1. Enter the alpha value in cell A1. The alpha value represents '1,' minus the probability the true mean lies within the confidence interval. For example, if you want a 95 percent probability that the true mean lies within the confidence interval, your alpha value equals 0.05.
2. Enter the standard deviation of the data in cell A2. The wider the distribution of data, the greater the standard deviation.
3. Enter the sample size in cell A3. The larger the sample size, the smaller the confidence interval will be.
4. Enter '=CONFIDENCE(A1,A2,A3)' into cell A4. Excel will display the confidence interval. For example, if you have an alpha value of 0.05, a standard deviation of 3 and a sample size of 160, the confidence interval would be 0.464846274.
Read more ►

How to Balance a Checkbook With Excel 2003


Manual Method
1. Open a blank Excel 2003 spreadsheet.
2. Type the following headings in the first row: 'Check #,' 'Date,' 'Description,' 'Debit,' 'Credit' and 'Balance.' These mimic your checkbook register. Format the headings however you like. Recommended formatting is to bold, center and underline headings.
3. Type 'Initial Balance' or 'Initial Deposit' in the first empty cell under 'Description.' Type your current or starting balance in the first empty cell under 'Balance.'
4. Type the following formula in the next empty cell under 'Balance': '=F2-D3 E3. This assumes Debit is in column D, Credit is in column E and Balance is in column F. If the column letters differ, adjust the formula accordingly.
5. Enter data into each row of the checkbook spreadsheet.
6. Find the current balance after each entry by clicking the balance cell above your entry. This will not apply to your first entry. Drag the cell, or copy and paste the cell, to the cell directly below it. For instance, if your previous balance is in cell F3, highlight F3 and copy the formula into F4.
Template Method
7. Open a blank Excel 2003 spreadsheet.
8. Go to 'Help' and select 'Microsoft Excel Help.'
9. Type 'check register' in the search box and press 'Search.'
10. Click 'Check Register.' This will be your first result. Press 'Download' to download and use the template.
11. Follow the instructions in the box that appears to begin using the template.
Read more ►

Sunday, April 24, 2011

How to Edit Cells With Multiple Users in Excel 2007


1. Format the document prior to sharing it across a network. Once an Excel 2007 file is shared, many common formatting procedures are no longer available until the sharing is deactivated. These include conditional formatting, charts, pictures, links, outlines and PivotTables. It is best to prepare the file for mass data entry with the features everyone will need during editing.
2. Click on the 'Share Workbook' button. This will open up the features dialog for network sharing of the Excel 2007 document with multiple users. The button is found on the Review tab of the Excel 2007 toolbar, in the Changes group.
3. Save or copy the file to a shared network folder that all users can access.
4. Inform all users of the location of the shared Excel 2007 document. Each user will see changes by other users every time they press the 'Save' button. The overlapping changes in the document will occur seamlessly with the exception of multiple edits to the same data cell. In this case, saving the file will launch a conflict resolution window to choose between your changes and those input by another user.
Read more ►

How to Change the Order of the Legend in an Excel Graph


1. Locate the chart data in the Excel spreadsheet. To locate the applicable data, click on the graph: the data will be surrounded on the worksheet by a blue box.
2. Copy the data, then paste it to a clear area on your workbook. Alternatively, paste it into a new worksheet.
3. Change the data into the order you want it to appear on the graph then copy and paste the columns.
4. Copy and paste the new data order back into the original spot on the workbook.
Read more ►

How to Remove Leading Zeroes in Excel


1. Open the spreadsheet that you want to edit in the Microsoft Excel program.
2. Highlight the cells that contain decimal information for which you'd like to remove the leading zero.
3. Right-click the highlighted cells and choose 'Format Cells.' This will open a cell-formatting options window.
4. Click the 'Number' tab and select 'Custom' from the category list.
5. Click the text box underneath the 'Type' heading and press the 'Backspace' key multiple times to clear the contents of the field.
6. Type a decimal point and then type the number of zeroes that correspond to the number of decimal places that you want to display in the cells. For instance, to display three decimal places with no leading zero, you would input: .000.
7. Click the 'OK' button to save your changes. The decimal information in the formatted cells will now be displayed without a leading zero.
Read more ►

How to Create an Alphanumeric Custom List in Excel 2007


Create the List
1. Open Excel and click on the Office button, which is located in the top left-hand corner of the window.
2. Click the 'Excel Options' item from the menu that drops down.
3. Click on the category labeled 'Popular.' Locate the section called 'Top options for working with Excel.' Click the 'Edit Custom Lists' item in this section.
4. Click the 'New List' option located in the 'Custom Lists' box.
5. Type the first item of the custom list. Choose any combination of alphanumeric text characters. Enter the item into the 'List entries' box. Press the Enter key on the keyboard.
6. Type the rest of the list items, pressing Enter after each list item.
7. Press the 'Add' button when the list is complete. The new list displays in the 'Custom lists' box.
8. Press the 'OK' button, and then press it again to close out the open windows. The custom list is now created in Microsoft Excel 2007.
Use the Custom List
9. Type the first custom list item into a cell in the Excel 2007 window.
10. Type the second list item in an adjacent cell to the first item. This may be entered in a cell on any of the four sides of the first list item.
11. Select the two cells by clicking on one and dragging with the mouse to the other. The two cells will appear with a dark, translucent overlay.
12. Hover the mouse over the lower right corner of either cell. The mouse cursor will change to a small black ' ' sign.
13. Drag the mouse in the desired direction for the completed list. Drag for as many cells as you desire. Release the mouse, and the custom list is filled into all the cells.
Read more ►

Saturday, April 23, 2011

How to Insert the Time Date in an Excel Spreadsheet


1. Navigate to the cell to which you want to add the date and time. Click on the cell to highlight.
2. Move your mouse up to the 'Fx' bar above the spreadsheet. This is the bar where you enter formulas for specific cells.
3. Type '=Now()' without the quotation marks. This enters the current date and time into the Excel spreadsheet in the selected cell.
Read more ►

Friday, April 22, 2011

How to Merge 2 Excel Workbooks in Excel 2007


Share the Workbook
1. Launch Microsoft Excel on your computer. Click 'File' and then 'Open' on the ribbon bar. Navigate to the file to share, highlight it and click the 'Open' button.
2. Click 'Tools' and then 'Share Workbook.' Click the 'Editing' tab and then enable the 'Allow Changes by more than one user at the same time' option.
3. Click the 'Advanced' tab and then click 'Track changes.' Click the 'Keep change history for:' option. In the 'Days' text box, enter a number of days for the estimated time needed for others in the group to edit the file and review changes. Click the 'OK' button.
4. Click 'File' then 'Save' on the ribbon bar to save the workbook.
Merge the Shared Workbooks
5. Launch Excel and open the original version of the shared workbook -- not the ones that users edited.
6. Click 'Tools' and then 'Merge Workbooks' on the ribbon bar. In the pop-up box, click and select one of the distributed copies of the workbook. Click the 'OK' button.
7. Merge other distributed workbooks as needed using the 'Merge Workbook' function.
Read more ►

How to Save Margins in Excel


1. Open Excel and click the 'Page Layout' tab and then click 'Margins.'
2. Click 'Custom Margins' in the menu that appears. Click the 'Margins' tab in the 'Page Setup' window that appears.
3. Click the number in the 'Top' box and type the margin size you wish to use in the 'Top' box. Repeat this step for the 'Left,' 'Right,' and 'Bottom' boxes.
4. Click the 'OK' button to save the settings for the worksheet.
Read more ►

How to Use a Microsoft Excel 2003 Dashboard


1. Produce an annual report or magazine quality visuals reports using Excel. Use templates downloaded from the Microsoft website. Create a chart by arranging the data (that you want to plot in your chart) in columns and rows. Select the cells you want to include and from the Insert menu, click the Chart option. Select the type of chart you want to represent your data. For example, select a pie chart, and decide where you want to place the chart.
2. Replace charts that do not reflect the data you want used. Because Excel is so flexible, you can lay out the flow of business processes and drill down into the lower level data necessary to make effective decisions about your business. Customizing an Excel dashboard for your particular needs makes it more useful.
3. Use ratios, calculations and other data shown on a visual dashboard to make effective decisions for your business. Dashboards provide a visual representation of your company's business performance and allow you to identify and mitigate any negative results or inefficiencies. Dashboards save executives time by aggregating data into a single visual report that allows them to make informed decisions.
4. Use Excel formulas to test for errors by comparing data, identifying missing values and listing values that exceed defined parameters.
5. Access underlying data to drill down into specific issues and make effective choices about actions to take to rectify any problems you uncover.
Read more ►

How to Use Excel Cell Data to Reference a Sheet Name


1. Create a workbook in Excel. It will start with three worksheets, shown by tabs along the bottom of the screen. By default, these are named 'Sheet1,' 'Sheet2' and 'Sheet3.' Sheet1 will be active.
2. Enter ''Sheet2' in cell A2. Enter ''Sheet3' in cell A3. Note that both of these prepend the word 'Sheet' with a single quote ('), to indicate that it's a text value.
3. Click on the tab for Sheet2 and enter 'Orange' in cell A1.
4. Click on the tab for Sheet3 and enter 'Screwdriver' in cell A1.
5. Click on the tab for Sheet1, and in cell B2, enter the following formula: '=INDIRECT('''A2''!A1')' (without the quotation marks before the equals sign or after the final parentheses). Once you hit 'Enter,' the formula will evaluate, and the cell will show the word 'Orange.' The INDIRECT() function is substituting the contents of cell A2 into the normal cross-sheet cell reference format. This gives the same result as if you'd entered ' =Sheet2!A1' into cell C2.
6. Copy cell B2 and paste it into cell B3. Cell B3 will now show the word 'Screwdriver.' This is because the relative reference in the formula you entered is now pulling the name of the worksheet from cell A3 rather than A2.
Read more ►

How to Convert Excel 2007 Files to dBase


1. Find out what formats the database you're importing into can accept. Nearly all of them can take comma-separated values (CSV), and many can accept legacy Excel formats, such as XLS.
2. Click the 'Office' button (the round button at the upper left with the Microsoft Office logo on it). On the menu that pops up, select 'Save As.'
3. Select the appropriate file type (either CSV or XLS) from the drop-down menu at the bottom of the dialog box that opens up. Click on the 'Save' button.
4. Import the file in dBase or FoxPro to make sure that everything worked appropriately and the data is in the right place.
Read more ►

Thursday, April 21, 2011

How to Make a Word Search With Microsoft Excel


1. Make a list of the words that you want to appear in your word search. The number of words should correlate to the size of the word search: larger grids can contain more words than smaller grids. Relate the words to a common theme such as animals, colors or family members.
2. Open Microsoft Excel. Select the rows and columns that you want to appear in your word search by clicking in box A1, holding down the mouse button, and dragging the cursor to highlight other boxes. For example, select boxes A1 through Y25 to make a square 25-by-25 word search.
3. Click the 'Home' tab and select 'format' under the 'cells' section. Click 'column width' in the menu and type '2' in the box that appears. Click 'OK.' While the cells are still selected, click the 'center text' symbol under the 'alignment' section.
4. Type the words from your list into the Excel spreadsheet. Type one letter per cell and make words read in the vertical, horizontal and diagonal directions.
5. Type random letters in the remaining cells. Type fragments of words that already appear in the search to make it harder to find the real words. The word search is completed as soon as you fill all the cells.
6. Format your word search. You can select all the cells (as you did in step 2) and put a border around the word search by right clicking and selecting the 'borders' button from the menu that appears. Change the style of the letters by selecting the cells and selecting a new font, size or color in dropdown menus under the 'font' section. Type the search words from your list in step 1 below the grid of letters or on a separate page.
7. Print your word search or email it to friends or family. Print multiple copies if you are playing a game as a group or if you are a teacher who has prepared this word search for students.
Read more ►

How to Set a Password on Excel 2007


1. Open the Excel spreadsheet to which you want to add a password. Click the Microsoft Office Button, select 'Save' and select a location to save the spreadsheet.
2. Click the Microsoft Office Button, select 'Prepare' and choose 'Encrypt Document' from the list. An 'Encrypt Document' dialog box appears.
3. Enter a password into the text box and click 'OK.' Confirm the password on the next menu by entering it again into the text box and click 'OK.' If you entered the password correctly, the dialog box will disappear. Save the spreadsheet again.
Read more ►

Wednesday, April 20, 2011

How to Recover a Protected Password in Excel 2007


Excel 2007 Password (Software)
1. Download Excel 2007 Password from the Last Bit website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and quot;Excel 2007 Passwordquot; to open it.
2. Click quot;Startquot; then click the folder icon to locate the Excel document you want to recover. Click quot;Open.quot;
3. Wait for Excel 2007 Password to crack the password. If it is successful it will prompt you for payment to release your password to you; if it is not successful it costs nothing.
Excel Key (Shareware)
4. Download Excel Key from the Passware website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and click the application to open it.
5. Click quot;Recoverquot; to locate your Excel 2007 document for which you want to recover the password. Click quot;Openquot; to load it.
6. Wait for Excel Key to search the file. If it manages to crack the password it will display it in the quot;Passwords foundquot; tab of the program. If you have a trial version, it will display the first two letters or numbers of your passwords, but you have to buy the full version to read the rest.
7. Check the passwords displayed on quot;Passwords found.quot; It displays the quot;File-open passwordquot; the quot;File-modifyquot; and any quot;Workbookquot; and quot;Worksheetquot; passwords it might find. Close Excel Key when you are finished.
Excel Password Recovery Master (Shareware)
8. Download Excel Password Recovery Master from the Rixler Software website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and click the application to open it.
9. Click the folder icon next to quot;Excel document name.quot; Locate your Excel 2007 document, select it and click quot;Open.quot;
10. Wait for Excel Password Recovery Master to recover your passwords.
11. Make a note of the quot;Open,quot; quot;Write,quot; quot;Workbookquot; and quot;Shared Workbookquot; passwords it can recover. Click quot;Open document in Microsoft Excelquot; if you want to otherwise close Excel Password Recovery Master.
Read more ►

How to Remove Excess Area in an Excel 2007 Graph


1. Move your cursor over the white space behind the graph until you see a cursor with four arrows in a cross.
2. Click the mouse to select the 'Resize' function.
3. Click on one of the circles located on the corners or sides of the graph and drag until the graph fills the chart area as desired. This will remove any excess white space in the chart.
Read more ►

How to Make a Guest List on an Excel Template


1.
Open Excel. It doesn't matter if you are in a blank workbook or an existing spreadsheet. If you are using Excel 2003 or earlier, click 'File' and then 'New.' If you are in Excel 2007, click the Office button and then click 'New.'
2.
Type 'Guest List' into the 'Search Online' box in the 'Templates' section if you are using Excel 2003. In 2007, click 'Microsoft Office Online' under templates, and then type 'Guest List' into the 'Search Microsoft Office Online for a Template' box. Click 'Go.'
3.
Click on a template in the 'Search Results' box to preview it. When you have found the basic template you like, click the 'Download' button. The guest list template will open as a new Excel worksheet.
4.
Make changes to the way your guest list looks. If you want to use a different graphic than the one on the template, click the picture to select it. Go to the 'Insert' menu of Excel 2003 and point to 'Picture,' and then click on 'Clip Art.' Go to the 'Insert' tab in Excel 2007 and click on 'Clip Art' in the 'Illustrations' group. Find a clip art that suits your event and insert it. You can format fonts and alter colors by selecting a cell or range, right clicking and choosing 'Format Cells.' Change text by clicking on the words you want to change, selecting them with your mouse and typing the text you want.
5.
Save your guest list in your My Documents or another folder. Give it a name that pertains to your event, such as 'Party Guest List.' As you decide who you will invite, type the names and addresses in the appropriate location.
6.
Sort your list after you have entered all of your guest information. This will help you make sure you didn't forget anyone, and also ensure that there are no duplicates on your list. Start by clicking the square between A and 1 in the top left corner of the guest list. This will select your entire sheet. In Excel 2003, go to the 'Data' menu and click 'Sort.' In Excel 2007, go to the 'Data' tab and click 'Sort.' Make sure 'Header Row' is selected and click 'OK.'
Read more ►

Tuesday, April 19, 2011

How to Add a Bullet in Excel


1. Start Microsoft Excel and open a spreadsheet.
2. Point to the cell that you want to add the bullet to with the mouse and double-click the left button to edit the cell.
3. Hold down the 'ALT' key and press the '7' key on the number pad. When you release these keys, a bullet will appear in the cell. When using a laptop keyboard, an additional key may be necessary if it does not have a number pad. The key sequence for a bullet on a laptop is 'ALT' 'Fn' '7.'
4. Hit 'ALT' then 'Enter' to go to the next line in a cell. Once your cursor moves to the next line, enter the bullet keystrokes to get a bullet on the next line. Repeat this sequence to add as many bullets as needed to a cell.
Read more ►

How to Install Microsoft Excel Features


Microsoft Vista
1. Click on the 'Start' button, then click 'Control Panel.'
2. Click on 'Programs,' then click on 'Installed Programs.'
3. Click on 'Excel,' then click 'Change.'
4. Click 'Add or Remove Features' and 'Next.'
5. Click on the Microsoft Excel features you want, then click on 'Upgrade' or 'Install Now.'
Windows XP
6. Click on 'Start,' then click on 'Control Panel.'
7. Click on 'Add or Remove Programs,' then click 'Change or Remove Programs.'
8. Click on 'Excel,' then click on 'Change.'
9. Click 'Add or Remove Features,' then click 'Next.'
10. Click on the Microsoft Excel features you want and click on 'Upgrade' or 'Install Now.'
Read more ►

How to Use the Excel OnTime Method


Specific Time
1. Click on the 'Developer' tab. If you do not see it, then click on the 'Microsoft Office' button. Click the 'Excel Options' button. Click on the 'Popular' tab. Check the 'Show Developer tab in the ribbon' check box. Click the 'OK' button.
2. Click the 'View Code' icon in the Controls section.
3. Type the following code:Private Sub Workbook_Open()Application.OnTime TimeValue ('13:00:00'), 'YourProcedure'End SubThis tells excel to run the procedure, or macro, named YourProcedure to run at 1 p.m.
Lapsed Time
4. Click on the 'Developer' tab.
5. Click the 'View Code' icon in the Controls section.
6. Type the following code:Private Sub Workbook_Open()Application.OnTime Now TimeValue ('00:05:00'), 'YourProcedure'End SubThis tells excel to run the procedure, or macro, named YourProcedure to run five minutes from now.
Read more ►

Monday, April 18, 2011

How to Insert Footnotes in Excel 2003


1. Right-click on the cell that will link to the footnote. Select 'Hyperlink.'
2. Click 'Place in This Document' when the 'Insert Hyperlink' menu opens.
3. Enter the name of the cell that will include the footnote in the 'Type the cell reference' box. For example, if you were going to include the footnote in A27, you would type 'A27' here.
4. Click 'OK.'
5. Click on the cell (e.g., A27) that will include the footnote, and type the footnote information. The cell that you clicked on in Step 1 will now link to this cell when you click it.
Read more ►

How to Insert a Row in Excel 2007


1. Click on any cell in the row below the location where you would like to insert a new row. For example, if you'd like to add a row above row 11, click on a cell in row 11.
2. Locate the 'Cells' group on the Microsoft Excel 'Home' tab. It is located at the upper-right-hand corner of the screen.
3. Click on the 'Insert' drop-down button located in the Cells group (the first button displayed).
4. Select the 'Insert Sheet Rows' option.
Read more ►

How to Use Column Headings in Excel


How to Freeze Column Headings
1. Start Microsoft Excel. Open the worksheet in which you want to freeze the column headings.
2. Click inside of the first cell in the row just beneath the one containing the column headings.
3. Go to the 'Window' menu in Excel 2003 and select 'Freeze Panes.' Go to the 'View' tab in Excel 2007 or 2010 and click 'Freeze Panes' in the 'Window' group. Select 'Freeze Panes' from the drop-down list. Excel freezes the rows above and the columns to the left of the cell you select, so if your heading is in 'Row 1' and you click inside cell 'A2,' only the first row will freeze. When you scroll down the page, the row with the headings will be 'frozen' so that you can still view the headings as you move down the worksheet.
4. Unfreeze the row if desired. Go to the 'Window' menu in Excel 2003 and click 'Unfreeze Panes.' In Excel 2007 or 2010, go to the 'View' tab, click 'Freeze Panes' and select 'Unfreeze Panes.'
How to Print Column Headings on All Pages
5. Start Microsoft Excel. Open the worksheet in which you want to print the column headings.
6. Go to the 'File' menu in Excel 2003, click 'Page Setup' and go to the 'Sheet' tab. In Excel 2007 or 2010, go to the 'Page Layout' tab, click the 'Page Setup' dialog launcher in the bottom right corner of the 'Page Setup' section and go to the 'Sheet' tab.
7. Select the 'Row and Column Headings' check box in the 'Print' section of the dialog box in Excel 2003, 2007 and 2010 to ensure that the column headings print.
8. Click the button at the right end of the 'Rows to Repeat at Top' box in all versions of Excel. This reference button gives you access to the worksheet. Simply click the row number to select the row containing the column headings. Click the reference button once more. This enters the reference for the row number that you want to print into the 'Rows to Repeat at Top' box.
9. Click 'OK.' When you print the worksheet, the heading row will print at the top of every page.
Read more ►

How to Calculate a Z


1. Open Excel 2007 and a blank spreadsheet.
2. Enter all of your data in one column. Each separate piece of data should be in its own cell.
3. Click on an empty cell within the spreadsheet and then calculate the mean of your data by entering an average function in the formula bar and hitting 'Enter.' The mean will be displayed in the empty cell. If your data was listed in cells B3 to B52, your function would look like this: 'Average (B3:B52).'
4. Click on another empty cell within your spreadsheet and then calculate the standard deviation of your data by entering a standard deviation function in the formula bar and hitting 'Enter.' If your data was listed in cells B3 to B52, your function would look like this: 'STDEV (B3:B52).'
5. Click on an empty cell in the spreadsheet and then click on the 'fx' button, located beside the formula bar. Enter the cell number that you would like to calculate a z-score for in the 'X' box. Enter the mean you calculated in Step 3 in the 'Mean' box. Enter the standard deviation you calculated in Step 4 in the 'Standard_dev' box.
6. Click 'OK.' The z-score for the number you entered in the 'X' box will be displayed in the empty cell you selected in Step 5.
Read more ►

Sunday, April 17, 2011

How to Set a Date Range in Excel


Set Start and End Dates
1. Click any cell in an Excel spreadsheet, then click the 'Home' tab. Click the 'Short date' item from the dropdown list in the 'Numbers' panel. This tells Excel to display the number you entered in the cell as a date.
2. Type any date in the cell you just formatted, in this format 'm/d/yyyy.' For example, type '1/1/2001.'
3. Use the instructions from step 1 to format the cell two columns to the right of the first cell you formatted. Type the ending date of your range in this cell.
4. Click in the cell that's in between the two cells containing your dates, then click the '=' sign to tell Excel that you're entering a formula instead of a number or text. Click the cell with the ending date, the press '-' to indicate a subtraction calculation.
5. Click the start date, then press 'Enter.' Excel will enter the number of days between the start and the end dates.
Set Start Date and Duration
6. Click a cell in a spreadsheet, then click the 'Home' tab's 'Short date' item in the 'Numbers' panel.
7. Type the starting date of your range. For example, type '1/1/2001.'
8. Click the cell immediately to the right of your start date, then type the number of days you want for your date range. For example, if your range spans three days, type '3' in the cell.
9. Use the instructions from steps 1 to format the next cell to the right as a short date. Press '=' to indicate a formula, then click the start date's cell, followed by pressing ' .'
10. Click the cell to the left, then press 'Enter.' Excel will calculate the ending date of your range, by adding the start date to the number in the cell to the left, which is the number of days in your range.
Read more ►

How to Return to Normal View in Excel 2007


1. Right-click anywhere on the Excel 2007 screen. A menu will pop up.
2. Use the cursor to highlight the 'Close Full Screen' option.
3. Click on the 'Close Full Screen' option. Excel 2007 will immediately return to normal view.
Read more ►

How to Disable Scientific Notation in Excel 2003


1. Highlight the column into which your list will go.
2. Right-click anywhere in the highlighted column.
3. Choose 'Format Cells...: from the drop-down menu.
4. In the 'Number' tab, choose 'Text' from the 'Category' list. Import your data.
Read more ►

How to Create a Pivot Table From Multiple Sheets


1. Open the Excel workbook that has the worksheets you want to use to create a Pivot Table. Click a blank cell that you aren't using in the Pivot Table report.
2. Start the Pivot Table and Pivot Chart Wizard by pressing the following keys 'ALT' 'D' 'P.' The Pivot Table and Pivot Chart Wizard box will open.
3. Check the box next to 'Multiple consolidation ranges' under the question that asks 'What is the data that you want to analyze?'
4. Check the box next to 'Pivot Table' when asked what type of report you want to create; click 'Next.'
5. Check the box next to 'I will create the page fields' and click 'Next.'
6. Select the ranges of data you want to use to create the Pivot Table. For example, click 'Sheet 1' and use your mouse to highlight the data you want to use from that sheet. After you select a range of data, click 'Add.' Select the next sheet you want to use data from and highlight the data and click 'Add.' Repeat this for each sheet that has data you want to use.
7. Check the box next to the number of page fields you want when you are asked how many page fields you want on the Pivot Table.
8. Enter an item label for each page field you chose to add and click 'Next.'
9. Decide whether you want to add the Pivot Table to a new or existing worksheet and click 'Finish.' The Pivot Table will open and you can begin manipulating the data.
Read more ►

How to Hide the Standard Toolbars in Office


1. Click 'Start' > 'All Programs' > 'Microsoft Office,' and then click on the MS Office program you want to use.
2. Right-click on the blue question mark icon in the upper right-hand corner of the program window. The icon is on the same line as the 'Home' and 'Insert' tabs.
3. Choose 'Minimize the Ribbon.' The ribbon disappears.
4. Show the ribbon again by right-clicking the question mark icon and choosing 'Minimize the Ribbon.' (See the check mark next to 'Minimize the Ribbon' when minimize is active.)
Read more ►

Saturday, April 16, 2011

How to Recover an Excel File from Autosave


1. Open Microsoft Excel to enable the recovery features available in the Office 2010 suite.
2. Recover a file you haven't yet saved. Select 'File,' and then 'Recent.' Choose 'Recover Unsaved Workbooks.' From the saved drafts folder that displays, choose your file and click 'Open.' Select the 'Save' icon and name your file to save it properly.
3. Recover a previous version of a file to which you forgot to save changes. Open the file upon which you were working. From the File tab, select 'Info.' From the versions listed, select the one labeled '(when I closed without saving).' Click 'Restore' to overwrite any previously-saved versions to this last autosaved version of your workbook.
Read more ►

How to Move Excel Macros to Another PC


Copying the Workbook
1. Determine where your macros are saved. You can save the macros you create in the workbook you are currently using or in your personal workbook. If you want to use your macros across different workbooks, you are most likely saving them to the personal.xls workbook.
2. Copy the workbook where the macros are saved to your chosen storage medium.
3. Copy the workbook to the new computer and start using your macros.
Using the VBA Editor
4. Copy the actual macros themselves from the Visual Basic editor.
5. Go to Tools–Macro–Visual Basic Editor.
6. Go to the Modules folder in the Project window in the left-hand corner of the screen.
7. Open Module 1 and copy the code for the macros you wish to copy. Paste this into the notepad and copy to your chosen storage medium.
8. Repeat Step 2 on another computer and go to Tools–Macros.
9. Name your macro and paste the code from the notepad into the macro window. Press Create and close out of the Visual Basic Editor.
Read more ►

Friday, April 15, 2011

How Can I Get Rid of Page Breaks in Excel?


1. Select the worksheet that you would like to print. Select 'Page Break Preview,' in the View tab.
2. Click the page break that you would like to delete. Click breaks within the page setup menu. 'Click 'Remove page break.'
3. Click 'Select All' at the top left-hand corner of the worksheet. Scroll to the Insert menu Select 'Reset All Page Breaks.'
4. Remove page breaks in the Excel for Mac version by rolling the mouse over the page break -- which is a dotted line. Click on it then go to the Insert Drop-down menu.
5. Scroll down to and select 'Remove Page Break.' This removes the page break from the worksheet.
Read more ►

How to Change Text Case in Microsoft Excel


How to Change Text Case in Excel 2007
1. Open the Excel spreadsheet.
2. Click on the cell that is next to the first data cell in the row of cells to be changed.
3. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6 type in: =Proper(A6) to change the text in the A column to proper case.
4. Click 'Home' and then 'Fill>Down,' or click and drag down the row of adjacent cells to fill them with the text-case formula. The row should now contain the new text version of the original row of cells.
5. Click on the top cell of the newly filled row and drag down to highlight the entire row.
6. Click 'Home>Copy.'
7. Click on the first cell of the row containing the original data.
8. Click 'Paste>Paste Special>Values>OK.' The data with the new text case will appear in the original data row.
9. Delete the row adjacent to the data. Click 'Save' to save the changes you made to the spreadsheet.
How to Change Text Case in Older Versions of Excel
10. Open the Excel spreadsheet.
11. Click on the cell that is next to the first data cell in the row of cells to be changed.
12. Click 'Insert>Columns.'
13. Click on the first cell in the newly inserted column that is next to the first original data cell.
14. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6, type in: =Proper(A6) to change the text in the A column to proper case.
15. Click on that cell again and drag down the row of adjacent cells to highlight the row.
16. Click 'Edit>Fill>Down.' Click 'Copy.'
17. Click on the first cell in the row containing the original data.
18. Click 'Edit>Paste Special>Values>OK.' The data with the new text case will appear in the original data row.
19. Delete the row adjacent to the data. Click 'Save' to save the changes you made to the spreadsheet.
Read more ►

How to Include a Signature When Sending Excel Email As an Attachment Button


Create the Signature Line
1. Open the Excel worksheet.
2. Click on the worksheet where you wish to insert a signature line.
3. Click the 'Insert' tab on the command ribbon.
4. Click the down-arrow on the 'Signature Line' button in the 'Text' group. A drop-down list appears.
5. Click 'Microsoft Office Signature Line.' A 'Signature Setup' dialog box opens.
6. Type the information to appear under the signature line: suggested signer, suggested signer's title, suggested signer's email address and instructions.
7. Select the check box for 'Allow the signer to add comments in the Sign dialog.'
8. Select the check box for 'Show sign date in signature line.'
9. Click 'OK,' then the signature line appears on the worksheet.
Sign the Excel Signature Line
10. Open the Excel worksheet.
11. Right-click the signature line. A list of commands appears, including 'Sign.'
12. Click 'Sign.'
13. Type your name in the text box. You can opt to select an image file to open in the signature line.
14. Save this worksheet.
Email the Excel Attachment
15. Open the email program.
16. Click to open a new email message screen.
17. Attach the Excel file.
18. Type a message that refers to the attachment.
19. Send the email message with the attached Excel file.
Read more ►

How to Reduce the Size of an Excel Spreadsheet


1. Make a backup copy of the file you want to reduce.
2. Open the Excel document and hit 'Ctrl' ' End' in each tab of the spreadsheet. You're looking for the last cell with data in it, in effect the lowest, right-most cell in the worksheet. For many sheets, this cell will be well outside of what you might have thought the spreadsheet contained.
3. Select unused columns by clicking on a column header, then holding down the 'Ctrl' 'Shift' 'Right Arrow' keys. This will select all columns to the right of the one you selected, including the one you selected. Press the 'Delete' key.
4. Select unused rows by clicking on a row header, then holding down the 'Ctrl' 'Shift' 'Down Arrow' keys. This will select all rows beneath of the one you selected, including the one you selected. Press the 'Delete' key.
Read more ►

How to Ungroup Worksheets in Excel


1. Start Microsoft Excel 2007 and open a workbook from your files that contains worksheets that are grouped together.
2. Locate the worksheet tabs at the bottom left of the opened workbook. The sheet tabs that are white are the ones that are grouped together.
3. Hold down the CTRL key on your keyboard and click on the sheet tab of the worksheet that you want to ungroup from the rest of the worksheet group. Once you do this, the worksheet will be turn back to its set color and become separated from the existing group.
4. Release the CTRL key on your keyboard after you have ungrouped the worksheet.
5. Continue to hold down the CTRL key and click to select sheet tabs of the worksheets you no longer want to be included in the group.
Read more ►

How to Unprotect a Microsoft Excel Document


Microsoft Excel 2010
1. Click the 'File' tab and click 'Open.' Navigate to the file you want to unprotect, select the file and click 'Open.'
2. Select the “Review” tab on the ribbon at the top of the screen, and click “Unprotect Sheet” from the Review menu.
3. Enter the file’s password if prompted to do so.
Microsoft Excel 2003
4. Click “File” on the toolbar and then select “Open.” Navigate to folder that contains the protected spreadsheet. Select the file and click “Open.”
5. Select the “Tools” drop-down menu, select “Protection” and choose “Unprotect Worksheet.'
6. Enter the file’s password if prompted to do so.
Read more ►

Thursday, April 14, 2011

How Do I View Two Excel Spreadsheets on Two Screens?


1. Open the first document you wish to view through Excel. This will open your document on one screen.
2. Click on the Start Menu at the bottom left of your computer screen, then open Microsoft Excel again. This will open Excel in a separate window.
3. Click 'File' then 'Open' from the toolbar at the top of the Excel window, then find and open the second file you wish to view. You now have two files open, in two separate Excel windows. This makes it easy to click back and forth between files, plus copy and delete information as needed.
Read more ►

How to Make a Flowchart in Microsoft Office


1. Open Microsoft Word from the 'Microsoft Office' folder under 'All Programs' in the Start menu. Select a new document in Microsoft Word.
2. Click on 'Shapes' under the Insert tab to see a list of available shapes. The flowchart category has several shapes useful for creating flowcharts.
3. Select a shape you like, and then click on the document to add the shape in that position. You can move the shape by clicking on it and then dragging across the document while holding down the mouse button. Edit your shape using the options available in the menu at the top, and add a text box if you want to label the shape.
4. Repeat step 3 to create a full flowchart suited to your needs. You can use the shapes available under 'Lines' in the Shapes menu to create lines to connect your flowchart. Experiment to find a flowchart that fits your style.
Read more ►

How to Make an Inventory Spreadsheet


1. Open your software. If you need automatic updates with SharePoint, use Excel 2010. If you are creating a simple list for insurance purposes, use a word processing program with tables or a spreadsheet program.
2. Determine the data labels to include in your inventory spreadsheet. If you are doing a home inventory, for example, include 'Value' as a column heading, in addition to labels such as 'Item' and 'Serial Number.' For a retail inventory, create headings such as 'Wholesale Cost' and 'Retail Price.'
3. Enter your column headings across the first row of your table. Set the first column as the index -- or unique identifier -- of the information for that row. For example, a SKU for business inventory, or an item's name for home use.
4. Enter the data in the rows and columns. Every item in a row provides further information related to its index. In a retail inventory, for example, enter the retail price, wholesale cost and item description for the same SKU. For a home inventory, enter information that further defines the item, such as size, value and cost.
5. Maintain your inventory manually by adding items as they are bought or otherwise acquired, and deleting items as they sold or otherwise removed.
6. Automatically update your inventory using SharePoint. SharePoint lists automatically update Excel spreadsheets provided you have read permission for the SharePoint list. In SharePoint, select the 'Export to Spreadsheet' option from the List tab, in the Connect Export group. Select 'File Download,' 'Open,' and then 'Enable' to synchronize the data with your computer. In Excel, select 'Refresh' in the External Table Data group on the Design tab to see the updated information.
Read more ►

Tuesday, April 12, 2011

How to Resize a Chart in Excel


1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart or create a chart from existing Excel data.
2. Click on the chart you want to resize so it is selected. A light blue outline will surround the chart when it is selected.
3. Point to one of the corners or edges of the selected chart where you see three small dots. Your mouse will turn into a double-headed arrow when you hover over the areas that you can resize.
4. Click with your mouse on the edge of the chart where you see the three areas and drag the mouse either outward (to make the chart larger) or inward (to make the chart smaller.)
5. Release the mouse button when you are happy with the resizing you have just completed. The chart will now be resized as you specified.
6. Continue to click and drag the sides and corners of the Excel chart until you get it exactly the size you want.
Read more ►

How to Delete a Drop Down Box in Excel


Remove the Drop-Down Only
1. Select the cells that have drop-down boxes.
2. Click the 'Data' tab and choose 'Data Validation.'
3. Remove the check in the box labeled 'In-cell dropdown.' Click 'OK.'
Remove Data Validation
4. Select the cells that have drop-down boxes.
5. Click the 'Data' tab and choose 'Data Validation.'
6. Select 'Any value' under 'Allow.' Click 'OK.'
Read more ►

How to Create a Floating Bar Chart in Microsoft Excel 2003


1. Set up your spreadsheet data with at least two rows of data. One of the rows of data will be what you actually want to show in the graph, and the other data set needs to have values that are less than the data set you want to show.
2. Highlight the data set. Click on the 'Insert' menu at the top of the screen, and then click on 'Chart' to bring up the chart options.
3. Click on the 'Bar' option from the list of chart type options on the left-hand side to bring up all of the bar chart options. Click on the 'Stacked Bar Chart' option, click 'Next' twice, and then click 'Finish' to build chart in the spreadsheeet.
4. Click on the lower series of data in the chart to select it. Right-click, and click on the 'Format Series' command to bring up the Series options window.
5. Click on the 'Patterns' tab. Select 'None' under Border and Area, and Click 'OK.' The upper series should be the only part showing on your graph, and it should be 'floating' above the axis.
Read more ►

How to Solve Linear Programming in Excel


1. Set up the linear program in the form:Maximize c(transpose)xSubject to: Ax ≤ b, x ≥ 0where c, x, A, and b are matrices. The objective function can also be minimized or equal to some number z. The constraints are in linear form. X does not have to have a non negative constraint. These differences in the linear program depend on the specific problem. However, it is imperative that the linear program be set up correctly. Be sure to make all calculations for the cTx, Ax, and b matrices in Excel before you solve the linear program. You can begin by either setting all values of x to 1 or leaving them unknown. It can be helpful to name the cells by clicking 'Insert' in the toolbar, 'Name,' and 'Define.' The names of the cells can by typed into Solver directly.
2. Open Solver and input the necessary cells. In order to input a cell, click on the Excel icon to the right of the text box, and then click on the desired cell. The 'Set Target Cell:' is the objective function. 'By changing Cells:' are the variables in your linear program, which is the x matrix. Click on 'Add' to add a constraint. The cell reference is the Ax matrix. Choose the type of constraint (greater than or equal to, less than or equal to, or equal to) from the pull down menu. The constraint is the b matrix. If x is non-negative, add this constraint for each x value.
3. Choose a correct linear model from the 'Select a Solving Method:' pull down menu. Standard form linear programs generally use a LP Simplex solving method. If x has a non-negative constraint, check the box 'Make Unconstrained Variables Non-Negative.'
4. Solve the linear program by clicking on 'Solve.' Allow Solver to think for a moment. If Solver finds a solution a dialogue box with the title 'Solver Results' will pop-up. You are given the choice of keeping the solver solutions or restoring all cells to their original value.
Read more ►

How to Sort by Cell Color


1. Click the first cell in the range of cells you want to sort. Drag down and across to highlight each of the cells that needed to be sorted by their color.
2. Navigate to the tab labeled 'Data.' Click the 'Sort' button at the left side of the 'Sort and Filter' grouping.
3. Click the 'Column' drop-down box underneath the 'Sort By' heading. Select the column in the range you want to sort.
4. Select the 'Sort On' drop-down menu and choose 'Cell Color.' Click the 'Order' drop-down menu and select the color you want to sort by, such as 'Green' or 'No Cell Color.'
5. Click the final drop-down menu and choose either 'On Top' or 'On Bottom' to specify where the sorted cells should be arranged. Click 'OK' to sort the range of cells by their color.
Read more ►

Monday, April 11, 2011

How to Create a Loan Amortization Table in Excel


1. Download the free Amortization Schedule for Excel 1.6 spreadsheet program available by Vertex42 and CNET. The program is designed for the layman and makes it easy to create a loan amortization table that quickly visualizes the relationships between a loan's principal, its time period and interest rate. Once created, the table may be changed by adjusting any of these variables on-the-fly. The flexibility of this template makes it easy to see how the loan is affected by the occasional extra payment. It also demonstrates the consequences of a missed payment. The table supports all the popular payment schedules, from weekly to annual payments. It optionally allows payment information to be rounded.
2. Download a Microsoft template for loan amortization. The company that makes Excel also makes its own amortization tables available to users. These are provided for free from the Microsoft Office website. The template takes advantage of Microsoft's own financial formulas built in to the Excel program. The variables for a fixed interest rate, payment schedule and loan principal are input and the template creates an interactive amortization table to show all the relationships. In addition to the table itself, the Microsoft template also creates a loan summary section where the overall parameters and outcomes of the loan are spelled out. This includes the total amount of interest paid after the loan cycle completes.
3. Buy a more robust loan amortization package from a company such as the Spreadsheet Store, which provides a set of six Excel loan analysis spreadsheets for a fee of $25 as of March 2010. While all loans have similar parameters, the Loan Calculator for Excel package creates an amortization schedule for many different scenarios for added flexibility to nearly any loan situation. Some loans follow a 'balloon' style which requires a large lump sum at the end of the payment term. Other loans break the loan cycle up into a graduated repayment plan where the initial round of payments cover the interest only. Still other loans do not use a fixed interest rate and thus the payment sizes can change periodically. This package of spreadsheets covers all these loan situations and more so the user is ready to visualize any credit opportunity with greater clarity. In addition to the loan amortization tables, these spreadsheets also create graphs that depict the loan parameters in a particularly visual layout.
Read more ►

How to Create Tabs in an Excel Spreadsheet


1. Open Microsoft Excel. There will be multiple tabs at the bottom with the name 'Sheet' and a number for each tab. Each of these tabs is a separate worksheet. Click on the tab to open that worksheet.
2. Right-click on the tab and select 'Rename' to change the name on the tab.
3. Add tabs to the file by right-clicking on a tab and selecting 'Insert.'
4. Copy an existing worksheet as a new tab by right-clicking on a tab and selecting 'Move or Copy.' Choose where to place the new tab and select the copy check box to leave the original tab in its location.
5. Rearrange tabs by dragging them to a new location among the tabs.
6. Delete unused worksheet tabs by right-click on the tab for the worksheet that you do not want and selecting 'Delete.'
Read more ►

How to Paste Special in Microsoft Word


1. Start Microsoft Word and open an existing file or start a new document.
2. Copy the text you want to paste from another Word file or other application.
3. Place your cursor in your open Word document where you want to paste the copied text.
4. Right-click and choose 'Paste' from the shortcut menu. You can also use the keyboard shortcut of CTRL V to paste the text into the new location. After you paste, a clipboard will appear at the end of the pasted text.
5. Hover your mouse over the clipboard until an arrow appears to the right of the clipboard.
6. Click on the clipboard arrow to show a drop-down menu. These are your paste special options.
7. Choose 'Keep Source Formatting' to keep the formatting that was in the original document. 'Match Destination Formatting' matches the formatting of the pasted text to the surrounding formatting within the document to which you are pasting. 'Keep Text Only' pastes the text you have copied while ignoring any type of formatting.
Read more ►

Blogger news