How to Calculate PMT in Excel

1. Open Excel 2010, and click the 'fx' button on the formula bar. Type 'PMT' to locate the PMT function. Press 'Enter' on the keyboard. Click the 'PMT' function.
2. Add the variables to the PMT function. Enter the current interest rate for the loan in the 'Rate' section. Enter the number of payments in the 'Nper' section.
3. Enter the present value of the loan in the 'PV' section. Click 'Ok' to see the loan payment appear in the Excel worksheet.

Read more ►

How to Set a Default Format for Excel Charts

1. Open Microsoft Excel by opening the 'Start' menu, clicking 'All Programs,' opening the 'Microsoft Office' folder and then clicking on the Microsoft Excel icon.
2. Click the tab labeled 'Insert' at the top of the Microsoft Excel window.
3. Click the 'Create Chart' button on the bottom-right of the 'Charts' section on the Insert tab, below 'Other Charts.'
4. Select the chart type that you would like to use from the preset templates.
5. Click 'Set As Default Chart' to set the selected chart as the default format of all created charts. Click 'OK' to save your changes and to exit the window.

Read more ►

How to Use Excel for Project Timelines

1. Open the Excel worksheet.
2. Click the 'Insert' tab on the command ribbon.
3. Click the 'SmartArt' button in the 'Illustrations' group. A dialog box with a list of commands and timeline diagrams appears.
4. Click 'Process' in the list.
5. Click the preferred timeline diagram.
6. Click 'OK.' A 'SmartArt Tools' ribbon appears. The timeline template appears on the worksheet.
7. Type the text in the '[Text]' area. A text pane appears to the side. If the text pane does not display, click the left-arrow control on the side of the timeline to open. The text box can display dates, events or other project news for your timeline.
8. Click the 'Design' or 'Format' tabs on the ribbon for more options, such as changing the layout or color. For example, the timeline can appear at an angle when you click the 'Bird's Eye Scene' button in the 'SmartArt Styles' group in the 'Design' tab.
9. Move or re-size the template by pulling on the frame handles.

Read more ►

How to Record a Macro in Excel 2003

1. Open Excel. Either open the program itself or open an existing file.
2. Set your security level. Go to 'Tools > Options.' Go to the Security tab and click on 'Macro Security.' Go to the Security Level tab and change the level to medium or low.
3. Go to 'Tools > Macro.' Choose 'Record New Macro' from the options.
4. Type a name into the macro name box.
5. Type the location of the macro into the box labeled 'Store Macros In.' Click 'OK.'
6. You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.
7. When you are finished, click 'Stop Recording' on the toolbar. You may make as many macros as you need.

Read more ►

How to Turn a Picture into a background or watermark

1. Open the MS Word program.
2. Click the 'Page Layout' tab on the command ribbon.
3. Click the 'Custom Watermark' option. A 'Printed Watermark' dialog box opens.
4. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.
5. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.
6. Click the 'Select Picture' button. The picture library file opens.
7. Select the picture file.
8. Click 'Insert.'
9. Select the scale value. For example, 50 percent.
10. Select the check box for 'Washout' if you prefer a very faint watermark effect.
11. Click 'OK.' The picture file becomes a watermark on the Word document.

Read more ►

How To Freeze All Top Cells In Excel 2003

1. Open your Excel spreadsheet. You can open a spreadsheet by double-clicking the XLS file on your computer, or you can open in the 'Open' dialog box when you click the 'Open' icon at the top of your window.
2. Click the row letter on the left of the spreadsheet to highlight the row you want to freeze. To highlight more than one row, hold the 'Ctrl' key and click each row letter with your mouse.
3. Click the 'Window' menu item. Click 'Freeze Panes' to freeze the rows. Scroll down the spreadsheet. Notice the rows you froze are always displayed at the top of your workspace.

Read more ►

How to Compare Multiple Groups of Cells in Excel

1. Open the Excel 2010 spreadsheet that holds the cell groups you want to compare.
2. Decide which group of cells will be the main group, which all other groups will be compared against.
3. Click the top left cell in the second group of cells. Hold the 'Shift' key and click the bottom right cell from that group. This will highlight the entire group of cells.
4. Click the 'Home' tab at the top of the screen, then click the 'Conditional Formatting' button and choose 'New Rule' from the drop-down menu.
5. Click 'Use a formula to determine which cells to format' at the top of the New Formatting Rule window. Enter the following into the 'Format values...' box:=not(a1=d1)Change 'a1' to the top left cell in your master group of cells and change 'd1' to the top left cell in the current selection. Click the 'Format' button in the lower right corner of the window, choose the 'Fill' tab and select a color that you want to use to highlight the differences in the groups. Click 'OK' when you are done. The differences in the second group will now appear highlighted.
6. Repeat this process for every group of cells that you want to compare against the original group.

Read more ►

How to Turn Anchor Text Into URL in Excel

1. Open Excel 2010. Click on one of the sheet tabs that appear at the bottom of the worksheet. Click into one of the cells and select the 'Insert' tab. Click 'Hyperlink.'
2. Select 'Existing File or Web Page' in the 'Link To' section.
3. Add the anchor text in the 'Text To Display' box. For example, if you are linking to cnn.com, enter 'CNN.' Type the web address in the 'Address' box. Click 'Ok' to save the changes. The hyperlink, or anchor text, appears in the Excel worksheet.

Read more ►

How to Remove Auto

1. Open Excel 2007, then open the document for which you want to remove the automatic publishing feature.
2. Click the round 'Microsoft Office' menu in the upper-left corner of Excel and select 'Save As.' Click the 'Save As Type' drop-down list and select 'Web Page' if the option isn't already selected. Click the 'Publish' button near the bottom of the dialog box to open the 'Publish As Web Page' dialog box.
3. Clear the box beside 'AutoRepublish Every Time This Document Is Saved' under 'Publish As' to disable automatic publishing for the open document. To disable the feature for other documents you previously published, click the 'Choose' drop-down list and select 'Previously Published Items.' Click the document's name under the menu and click the 'Remove' button.
4. Click the 'Close' button at the bottom of the dialog box, then press 'Ctrl' and 'S' to save your current document.

Read more ►

How to Turn off Filter Keys in Excel 2003

1. Click 'Start.' Click 'Control Panel.' Type 'access' into the Search box and press 'Enter.'
2. Click 'Change How Your Keyboard Works' from the results. Click 'Set up Filter Keys' from the Make It Easier to Type section.
3. Uncheck the 'Turn on Filter Keys' and 'Turn on Filter Keys When Right Shift Is Pressed for 8 Seconds' boxes.
4. Click 'Apply' to turn off Filter Keys for all applications, including Excel 2003. Click 'OK' to exit from Control Panel.

Read more ►

How to Make a Bar Graph Using Microsoft Excel 2003

1.
Label the data you want to graph in Microsoft Excel 2003. In Row 1, type the labels for each piece of data you plan to graph. For example, type “Month” in cell A1 and “Units” in cell B1.
2.
Enter the data that you want to graph. Microsoft Excel 2003 needs you to provide the data that will be included in the bar graph. Under the labels you have set up in each row, type the information you want to graph. For example, type the months of the year under the heading in Column A (“Jan” in A2), and the units under the heading in Column B to correspond with the months in Column A.
3. Open the chart wizard window. From the menu bar, select Insert>Chart.
4.
Select the type of bar graph you want to make. Under Chart Type, select 'Bar'. Then, click to select the particular type of bar graph you want to make under Chart sub-type. Click “Next.”
5.
Select the range for the data to be included in the bar graph. Microsoft Excel 2003 defaults to capture the data in the spreadsheet. If Microsoft Excel 2003 does not default to capture the data, then click and drag your mouse over the data to be included in the bar graph. Click “Next.”
6.
Define bar graph options. Microsoft Excel 2003 provides several tabs to define bar graph options, such as to define where to put the legend, what information should be tracked on which axis and what the title of the bar graph should be. Make your selections and then click “Next.”
7.
Define where to save the bar graph. The default is to save the bar graph in the current spreadsheet. Click the radio button for your choice and then click 'Finish'. The bar graph appears where you told Microsoft Excel 2003 to make it.
8. Change the text on the bar graph if needed. If you want to change the title or other text on the bar graph, click on the text you want to change and then type in your changes.

Read more ►

How to Change the Default Email in Excel 2003 Groupwise

1. Close the Microsoft Excel program if it is currently open or running.
2. Open the Start menu and click on 'Control Panel.'
3. Double-click on the 'Internet Options' icon.
4. Go to the 'Programs' tab at the top of the 'Internet Options' pop-up window.
5. Open the drop-down menu labeled 'Email' and choose 'Novell GroupWise' from the list of applications.
6. Hit the 'OK' or 'Apply' button to save the settings and change your default email client.
7. Relaunch Microsoft Excel and click on an email hyperlink to test the new settings.

Read more ►

How to Do a Pie Chart in Microsoft 2003 Programs

Excel 2003
1. Open a Microsoft Excel spreadsheet that contains the data that you want to add to a pie chart.
2. Click 'Insert' from the Excel 2003 menu bar and then select 'Chart.' The Chart Wizard will appear.
3. Select the 'Pie' chart type from the left side of Excel 2003's Chart Wizard.
4. Select the standard 'Pie' sub-type from the right side of the window. Click 'Next.'
5. Select either 'Rows' or 'Columns' for the data range. Microsoft Excel 2003 requires you to organize the data that you want to add to a pie chart in rows or columns.
6. Enter the data range manually into the 'Data range' field or click the button to the right of the field and select the data range with your mouse. Click 'Next.'
7. Click the 'Titles' tab and enter a title for your pie chart.
8. Click the 'Legend' tab and place a check-mark next to 'Show legend' if you want a legend to appear next to the pie chart. Select the placement for the legend, if you choose to show a legend.
9. Click the 'Data Labels' tab and select the labels that you wish to add to your pie chart. You can add category names, values, percent values or series labels to the pie chart.
10. Click 'Finish' and your chart will appear in your document.
Word
11. Open a blank Microsoft Word document.
12. Click 'Insert' in the Microsoft Word 2003 menu bar and scroll down to 'Picture.' Scroll right and click 'Chart.' A generic bar chart will appear in your document along with a 'datasheet,' which is a separate window with cells that contains pre-filled data. Values on the datasheet correspond to the values on the chart in the document.
13. Right-click an empty area inside the bar chart that appeared in your blank Microsoft Word 2003 document in Step 2. Click 'Chart Type.' The Chart Type menu box will appear.
14. Select 'Pie' as the 'Chart type' in the left side of the window. Select the standard 'Pie' sub-type from the right side of the window. Click 'OK.'
15. Click 'View' and select 'Datasheet.' If the datasheet is already visible in your document, skip this step.
16. Input the labels for each of the pie slices in the top row of the datasheet window. Input the values of each of the pie slices into the row below the labels. The pie chart on the Microsoft Word 2003 document will update as you change the data in the datasheet. Close the datasheet once you are happy with the changes.

Read more ►

How to Protect Excel Cells From Modification

1. Start Microsoft Excel and open the file you want to change.
2. Drag mouse and highlight the cells you want to protect.
3. Open the Format menu and select Cells.
4. Select the Protection tab.
5. Click the Locked option.
6. Select OK to accept the changes.
7. Open the Tools menu and select Protection, then select Protect Sheet.
8. Click OK.

Read more ►

How to Insert Comments in Microsoft Excel 2003

1. Select the cell to which you wish to add comments. Do this by left-clicking on the cell.
2. Access the comments submenu by scrolling to the “Insert” tab on the command bar and selecting “Comment.”
3. Enter the comment. A comment call-out box will appear above the cell. Enter the desired text in that box.
4. Implement the comment by left-clicking on any adjacent cell. The 'commented' box will appear with a red arrow over the left side. When you hover the cursor over it, the comment call-out box will again appear.

Read more ►