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 workshe...
Browse » Home » All posts
Sunday, June 24, 2012
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 wind...
Saturday, June 23, 2012
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...
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...
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....
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 workspa...
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...
Friday, June 22, 2012
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 workshe...
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...
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 Pan...
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...
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 settin...
How to Do a Pie Chart in Microsoft 2003 Programs
Excel 20031. 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...
Thursday, June 21, 2012
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 ...
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 appe...
Subscribe to:
Posts (Atom)