1. Use the compound interest financial calculator on Moneychimp (moneyChimp.com). Fill out the boxes on screen with information about your current loan including the principle, the interest rate, the annual addition and the years to grow. Input the number of times your interest is compounded. Click 'Calculate' to view the total amount of your loan or investment with compound interest added in.2. Use the financial calculator on 1728.com. Fill out the boxes at the bottom of the financial calculator page with information about your current loan, savings account or investment (whichever applicable)....
Browse » Home » All posts
Monday, August 15, 2011
How to Create CSV Files in Excel 2007
1. Open your spreadsheet. Click on the 'Office' button in the upper left-hand corner.2. Select the 'Save As' option from the pull-down menu. Click on the 'Other Formats' button.3. Choose the 'CSV (Comma delimited)' option.4. Type a name for the CSV file.5. Check the location of the file, making sure you remember where the file will be saved.6. Click on 'Save.' You can now close the Excel file.7. Open the CSV file to make sure there weren't any problems with the expo...
Sunday, August 14, 2011
How to Make a Graph in Excel Edit the Legend
Create a Chart1. Open the Excel worksheet that contains the data for the chart.2. Click and drag to select the data for the chart.3. Click the “Insert” tab on the command ribbon.4. Click the arrow for the preferred chart type in the “Charts” group. Examples of chart types include 'Column,' 'Line' and 'Pie.' A gallery of chart thumbnails appears.5. Click to select the chart type. A chart displays over the Excel worksheet. The “Chart Tools” ribbon shows three tabs: “Design,” “Layout” and “Format.”6. Format and style your chart with the commands on the “Design,” “Layout” and “Format”...
How to Automatically Shade Every Other Row in Excel 2007
1. Open the spreadsheet you want to shade the rows of in Excel.2. Hold the 'Ctrl' key on your keyboard and press 'A,' releasing both keys.3. Click 'Home' on the top menu in Excel 2007.4. Click 'Format as Table' under 'Styles' and click 'OK.' This shades the rows for you automatical...
How to Make Excel Reports
1. Open the Excel program to display a new worksheet.2. Click the “File” tab on the command ribbon to display a list of commands.3. Click “New,” then a gallery of “Office.com Templates” appears.4. Click the “Reports” link, then a list of folder icons appears.5. Click the preferred folder such as “Financial Records,” “Logs” or “Human Resource Records.” A gallery of thumbnail images appears.6. Click the preferred report image to display a larger image in the preview pane to the right.7. Click “Download” in the right pane. The template copies to the new worksheet.8. Click in a cell...
How to Set Margins in Excel
1. Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.2. Choose the 'File' menu and click 'Page Setup' to open the 'Page Setup' dialog box. The 'Page Setup' dialog box can be used to set up your page just how you would like it to appear.3. Click on the 'Margins' tab at the top of the 'Page Setup' dialog box to show the margins for the spreadsheet that you currently have option.4. Set the 'Left,' 'Top,' 'Right,' 'Bottom,' 'Header' and 'Footer' margins by clicking within the text box underneath each option to highlight the current margin setting.5....
Saturday, August 13, 2011
How to Create a Currency Converter With Microsoft Excel
1. Select the currency you want to convert to.2. Find the current conversion rate. Sites such as Yahoo's currency converter will list the latest currency conversion rate for the various international currencies. Several sites offer this service, so perform an Internet search for the site you feel most comfortable with.3. Open Microsoft Excel. Label the first three columns in the Excel spreadsheet as 'Current Currency,' 'Currency Conversion Factor' and 'Converted Currency.' You don't have to label the columns as indicated here, but for instructional purposes, it makes it easier to identify...
How to Import More Than 65,536 Rows in Excel 2003
1. Click 'Tools,' select 'Macro' and choose 'Macros.'2. Type a name for your macro in the 'Name' field, such as 'LargeFileImport,' and click 'Create.' The Visual Basic Editor will open automatically.3. Double-click '(Name) Module' in the 'Properties' window and type 'LargeFileModule.'4. Click the ' ' icon next to 'Microsoft Office Excel Objects.'5. Double-click 'LargeFileModule' to open the 'Code' window.6. Copy and paste the following into the 'Code' window:Sub LargeFileImport()'Dimension VariablesDim ResultStr As StringDim FileName As StringDim FileNum As IntegerDim Counter As Double'Ask...
How to Restore All Hidden Columns in Excel
1. Open the spreadsheet in Excel.2. Click on the arrow in the top left corner of the Excel spreadsheet. This highlights all data in the workbook.3. Click 'Format' in the 'Cells' menu along the top of the page. A drop-down menu appears.4. Click 'Hide Unhide' under the 'Visibility' heading, then click 'Unhide Columns.' Changes are applied instantly and all columns are visib...
Thursday, August 11, 2011
How to Create a Simple Checkbook Register With Microsoft Excel
1. Open Microsoft Excel. Type in 'Check Register' in cell A1. Center this across the columns you will be using, from A through G. Select cell A1, hold down the shift key and select cell G1. After you highlight it, go to 'Format' and 'Merge Cells.' Then select 'Center' which is under 'Format' and 'Cells.'2. Skip a row and make the headings starting in cell A4. Type in 'Item Number,' move to the next column and type in 'Date,' move to the next column and type in 'Description of Transaction,' continue moving and typing the headings as follows: 'Payment,' 'Done,' and 'Deposit.' Go to cell G3 and...
How to Number the Rows in Excel 2007
Fill Column1. Select the first cell in spreadsheet.2. Type the starting value in that cell.3. Type another value in the next cell to start sequence.4. Select cells with values that you've typed inside.5. Drag 'fill handle' to include number of cells that you want in your sequence.ROW Function6. Type '=ROW(A1)' into the first cell of the range you want to sequence. This will give you the number 1 in that cell.7. Type specific number after '=ROW(A1)' to start numbering at a certain point. For example, typing '=ROW(A1),'2010-000' will create a starting number of 2010-001.8. Drag...
How to Use MS Excel 2007 to Calculate Sum
1. Enter values into a row or column of cells.2. Navigate to the cell you want the sum to appear. You may pick any cell, even one nowhere near the cells you want to sum.3. Click the 'AutoSum' button in the Editing Box at the far right of the Home tab. Excel will enter the Sum Function in the active cell, including a range of cells to add.4. Make certain the cell range is correct (notice the dashed box for a visual representation of the cell range). Press the Enter key to confirm the Sum function.5. Drag through another range of cells if the range Excel entered is not the range you need...
How to Copy Formulas in Excel
1. Determine what formula is to be copied and to what location it is to be copied. Carefully consider the cells that are to be referenced in the formula and that they are indeed the cells that contain the information to be acted upon by this formula.2. Highlight a cell that has the formula in it and click the right mouse button. Select the 'Copy' option.3. Move to the new destination cell for this formula, right click the mouse button and select 'Paste.'4. Check the first cell to make sure the correct calculation has been performed. If not, check the formula that appears in the cell that...
How to Write Simple Macros in Excel
1. Go to the worksheet you want to insert a macro on.2. Click 'Record New Macro' after clicking 'Macro' on the Tools menu.3. Name the macro with keyboard shortcut or assign it to a toolbar. You can also add a description of the macro for reference later. These are all optional commands that you can do in the dialogue box, the next step in the wizard. If you don't want to do any of these things, you can skip the step all together and click 'OK' to start recording the macro. New macros are saved in the global template named Normal.dot by default and you can always assign a name or toolbar...
How to Determine Y Axis Values in an Excel 2003 Line Graph
1. Highlight the entire range, including the x-axis and y-axis values.2. Click 'Insert' from the menu bar. Click 'Chart.' This launches the Chart Wizard. Alternatively, click the icon of a bar graph from the toolbar.3. Select 'Line' under 'chart type.' Pick a sub-type from the right pane. Click 'next.' The wizard will generate a preview of your chart, guessing which values you want on the y-axis. The window will change to 'Step 2 of 4.' If the wizard correctly determined your values, click 'finish' to insert the chart.4. Click the 'series' tab. One box will contain the cell numbers of...
Subscribe to:
Posts (Atom)