How to Create a Personal Budget Using Excel 2007

1. Open Excel 2007 and select the 'Office' button. Select 'New.' Excel displays the templates available. Click on the word 'Budgets' in the left task pane. Review the available templates and download one of the personal budgets by clicking the 'Download' button.
2. Update your personal budget by adding your income. Locate the income section of the template and add your income. Locate the expense section of the template and add your expenses. If necessary, right click on the row and select 'Insert Row' to add additional rows to the template.
3. Save your changes to the budget by clicking the 'Save' icon in the Quick Access Toolbar.

Read more ►

How to Have Different Footers on a Word Document

Insert Different Footers in a Word 2003 Document
1. Place your cursor on the page before the one in which you want to create a different footer.
2. Go to the Insert menu and select Break. In the Insert Break dialog box that appears, select Next Page under Section Breaks.
3. Go to the View menu and select Header and Footer. Place the cursor inside the footer section of the first page in which you want to make a different footer.
4. Click the Link to Previous button on the Header and Footer toolbar. This will disconnect the footer from the previous section.
5. Enter the information you desire into the footer and save your document.
Insert Different Footers in a Word 2007 or 2010 Document
6. Place your cursor on the page before the one in which you want to create a different footer.
7. Go to the Page Layout tab and select Breaks from the Page Setup group. Select Next Page under Section Breaks in the Breaks drop-down menu.
8. Click on the page in which you want to start the different footer. Go to the Insert tab and click Footer. Click Edit Footer near the bottom of the Footer drop-down menu.
9. Click the Link to Previous button in the Navigation group on the Design tab of the Header and Footer Tools tab. This will disconnect the footer from the previous section.
10. Enter the information you desire into the footer and save your document.

Read more ►

How to Open a Specific Spreadsheet Each Time Excel Starts

1. Right-click the Windows desktop. Mouse over 'New' and select 'Shortcut.' The 'Create Shortcut' window will open.
2. Click the 'Browse' icon.
3. Locate and select the 'Excel.exe' file. This is the executable file that opens the Excel program. If you installed the program in the default location, the path to the file for the different versions is as follows:Excel 2003 - C:\Program Files\Microsoft Office\Office11\XlstartExcel 2007 - C:\Program Files\Microsoft Office\Office12\XlstartExcel 2010 - C:\Program Files\Microsoft Office\Office14\XlstartIf you can't find the 'Excel.exe' file in the default location, use the search feature on the Windows Start menu to search for it. Click 'OK.'
4. Add the command line to the end of the file path, outside the closed parentheses. The file command to open a specific spreadsheet is as follows:'c:\My Folder\book1.xlsx'The path inside the parentheses is the location of the spreadsheet file you want to open when Excel starts.
5. Click 'Next.' Type a name for the new shortcut. This should be something that you can associate with the spreadsheet that will open. Click 'Finish.' The new shortcut will appear on the desktop represented by the Excel icon.
6. Click the new shortcut to open Excel directly to the desired spreadsheet.

Read more ►

How to Activate Macros in Excel

1. Open Microsoft Excel.
2. Find and click the 'Office' button. It's not labeled, but it's the large round button with the Microsoft logo in the upper left corner of your Excel window.
3. Click on the 'Excel Options' button at the bottom of the resulting menu.
4. Click on the 'Trust Center' option in the list at left, and then click on the 'Trust Center Settings' button.
5. Click on 'Macro Settings' in the list at left, and then click the radio button next to 'Disable all macros with notification.' Using this setting, Excel will notify you when a macro opens and ask you to choose whether or not to run it.
6. Click the 'OK' button to return to your document and exit Excel completely. When you re-open, your settings will be changed.

Read more ►

How to Open XLS Files in a Microsoft Spreadsheet

Using Excel
1. Click the 'Start' button or orb in the lower left corner of your screen, and point your cursor to 'All Programs.' Scroll down, click the 'Microsoft Office' folder, and click 'Microsoft Office Excel.' A blank Excel spreadsheet will open.
2. Click the circular Microsoft Office orb on the top left of the spreadsheet. Click the second option, 'Open.' Click the location of your Microsoft Excel spreadsheet on the left side. People usually store documents on their desktop or in the 'My Documents' folder.
3. Click the drop-down box on the lower right corner of the dialog box, and click 'All Excel files.' This will ensure that you can open the Excel file even if it was created with a different version of Microsoft Excel than the version that you have on your computer. Double-click the folder that the Excel file is located in within the main window. Click the 'Open' button in the bottom right corner.
Without Excel
4. Visit Microsoft's Excel Viewer web page (see Resources).
5. Scroll down the page until you see a blue box with a 'Download' button at the top. Click the button. A dialog box will pop up. Click 'Save File.' The download may take anywhere from a few seconds to a minute, depending on your connection speed.
6. Double-click on the file in your downloads box (ExcelViewer.exe) when it has finished downloading. Click on the 'Yes' button if the computer prompts you for permission to install the file. The installation wizard will launch.
7. Click the check box at the bottom of the wizard to agree to the agreement terms, and click the 'Next' button in the bottom right corner. Click the 'Install' button in the bottom right corner. The program may take several minutes to install. Click 'OK' when the installation has finished. You can now double-click on any Microsoft Excel file to view it.

Read more ►

How to Not Show MS Excel 2007 Page Breaks

1. Open the Excel 2007 program by double-clicking on the Excel document icon.
2. Click on the circular Microsoft Office Button at the top-left corner of the Excel 2007 window.
3. Choose 'Excel Options' from the very bottom of the drop-down box that appears. A new window will open up.
4. Click on 'Advanced' on the left side of the window.
5. Scroll down until you find the 'Display Options for this Worksheet,' which is about half-way down the page.
6. Click on the check mark next to 'Show page breaks' to remove it. Page break lines will no longer show up on your worksheet.

Read more ►

How to Create a Control Chart in Excel

1. Download a control chart template for Microsoft Excel. A good free template is available from www.vertex42.com/ExcelTemplates/control-chart.html.
2. Double-click the downloaded Excel template. The file will open in a Microsoft Excel window.
3. Choose the desired control chart format for your project. The two common control chart designs are listed as separate tabs at the bottom of the Excel window. The 'XbarR' worksheet tab creates a control chart for mean and range calculations. The 'XbarS' spreadsheet works with a control chart for mean and standard deviation.
4. Click on the control chart tab most appropriate for your project.
5. Type in the sample size, 'n', and the 'k' value control limit into the top of the worksheet in the labeled areas.
6. Paste or type the X-bar and standard deviation or range values for your data set into the worksheet's table located below the control chart display. Do not alter the grayed-out columns or the 'Sample' column.
7. View the control chart for your data and parameters. The chart in the main worksheet window automatically updates based on your criteria.

Read more ►

How to Link an Excel 2007 Chart to a PowerPoint 2007

Prepare Your Chart in Excel 2007
1. Open the spreadsheet containing your chart in Excel 2007.
2. Click the chart to select it and then press the 'Ctrl' and 'C' keys simultaneously to copy the chart to the clipboard.
3. Select a blank sheet using the tabs near the bottom of the Excel 2007 window.
4. Press the 'Ctrl' and 'V' keys simultaneously to paste the copied chart into the selected sheet.
5. Save the spreadsheet to confirm the changes.
Link Excel 2007 Chart in PowerPoint 2007
6. Open your presentation in PowerPoint 2007 and then navigate to the slide where you want the chart inserted. If you want to insert the chart within a text box, select the box by clicking it.
7. Select the 'Insert' tab and then click the 'Object' button.
8. Select the 'Create from file' option on the left side of the window.
9. Click the 'Browse' button, locate your Excel 2007 spreadsheet in the resulting window and select it by double clicking its icon.
10. Check the 'Link' box and then click 'OK.'

Read more ►

How to Filter Data in Microsoft Excel 2007

1.
Select the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
2.
Locate the Editing Group on the far right side of the Home Tab. Click on the 'Sort and Filter' button to reveal a drop-down menu of options. Click on 'Filter'.
3.
Click on the drop-down arrow that Excel added next to the field you would like the data filtered by. Select the choice you would like to see filtered.
4.
Click on another drop-down menu if you would like to filter the remaining data by an additional criteria.
5.
Click on the filter icon next to the field header used to filter the data to remove the filter and return the list to its original state.

Read more ►

How to Remove Certain Colors in Excel 2007

1. Open the Microsoft Excel 2007 document.
2. Highlight the cells that you want to remove color from.
3. Scroll to the top of the screen and click the 'home' tab.
4. Scroll to the right where there are six boxes stacked on top of one another. Click on the box that says 'normal.' This will remove all color and restore the cells back to normal.
5. Scroll to the paint-bucket icon.
6. Click on it to reveal a drop-down menu.
7. Scroll down to where its labeled 'no fill' and click on it. This removes background color.
8. Scroll to the icon that is a letter 'A' with a color pallet beneath it.
9. Click on this to reveal a drop-down menu.
10. Scroll to where it labeled 'automatic' and click on it to make it black.

Read more ►

How to Create a Pivot Table in Excel

Create a Basic Pivot Table From an Excel List
1. Ensure your data source contains all data elements you want to include in your report. All data ranges need to have labeled rows, columns and associated data values.
2. Select the 'PivotTable and Pivot Report' option from the Data menu. This option launches a wizard to aid you in creating a report.
3. Choose the 'Microsoft Office Excel List or database' data source option from the wizard. This option specifies that your data resides in an internal spreadsheet.
4. Specify PivotTable as your desired report. This triggers the data range prompt to appear.
5. Highlight the range that contains the data you would like to include. Start from the top left corner of your data set and end with the bottom right cell.
6. Decide whether you want the report to display in the worksheet with the raw data or in a separate worksheet. Although it is cleaner to have the report in a new worksheet, there is no functional difference between the two options.
7. Drag and drop the data objects from the pivot table field list onto the worksheet. The report areas include space for row, column, data and page field values. You can move the objects around until the report layout is satisfactory.
Make a Pivot Table From Multiple Ranges
8. Follow Steps 1 and 2 in Section 1.
9. Choose 'Multiple Consolidation Ranges' as your data source. This will allow Excel to pull from more than one list.
10. Specify how many page fields you want, from zero up to four. You can either create them manually or allow Excel to create them.
11. Add all ranges that contain report data. You can add, delete and browse for additional .xls files that include relevant information.
12. Complete Steps 6 and 7 in Section 1.
Generate a Pivot Table From External Files
13. Follow Steps 1 and 2 within Section 1.
14. Choose 'External Data Source.' Excel lists five options as possible data sources: dBase, Excel, HT8PRD, MS Access Database and Visio Database Samples.
15. Specify the appropriate data source(s). Browse through your directory to select the correct file.
16. Complete Steps 6 and 7 in Section 1.

Read more ►

How to Create Bins in Excel 2007

Creating Bins in Excel 2007
1. Click the Microsoft Office link in your start box and click on Microsoft Excel 2007. Microsoft Excel 2007 is the green icon, located among the choices of Microsoft programs.
2. Click 'Data Analysis,' located in the analysis group on the data tab. In the dialog box after clicking data analysis, click 'Histogram' and then click OK.
3. Type your desired input range in the 'Input Range' box.
4. Type your desired range to create a new bin in the 'Bin Range' box.
5. Click 'New Workbook' which is located under 'Output Options.' Check the 'Chart Output' check box then click OK. Your new bin within the workbook is created.

Read more ►

How to Use the Selection Pane in Excel

1. Start Microsoft Excel 2007, and open an existing workbook from your files that contains multiple images that you would like to view with the selection pane.
2. Click to select any one of your images so you can gain access to the Format ribbon. You can tell an image is selected, because it will be surrounded by white sizing handles and the 'Format' tab will appear at the top of the Excel screen.
3. Select the 'Format' tab to display the Format ribbon. This ribbon displays all the settings you can use to format images in Excel.
4. Choose the 'Selection Pane' button in the 'Arrange' section of the Format ribbon. The 'Selection and Visibility' pane will appear on the right side of the Excel screen. This pane displays a list of all the images that appear in the Excel worksheet.
5. Click the button with a picture of the eye to the right of the names of the pictures to hide any of the pictures. Clicking the button again to display the eye will make that image visible.
6. Choose the 'Show All' button at the bottom of the 'Selection and Visibility' pane to show all of the pictures in the workbook. Choose the 'Hide All' button to hide of the pictures.
7. Select the name of a picture and use the up and down arrow buttons at the bottom of the selection pane to change the order of the images on the worksheet.

Read more ►

How to Write Macros in Excel 2010

1. Open Excel on your computer. Click the 'View' tab on the ribbon and then click the 'Macros' icon.
2. Enter a descriptive name for the new macro. Do use spaces in the macro name. Create a sample macro to use during the process of learning to write a macro in VBA. Therefore, enter the macro name 'Change_Worksheet_Names' in the macro name field and then click 'Create.' The Microsoft Visual Basic for Application window opens and displays a 'Module (Code)' window with the blank 'Sub Change_Worksheet_Names()' code document.
3. Continue creating the sample macro, which changes all of the generic 'Sheet1,' 'Sheet2' worksheets in a workbook to a value from a header or title cell in each worksheet. For example, if you enter the title for each sheet in cell 'A1' of each worksheet, this macro changes the name displayed at the bottom of each worksheet to the value in the referenced cell -- in this case 'A1.' To create the macro using VBA, enter the following code between the 'Sub Change_Worksheet_Names()' and 'End Sub' tags:Dim myWorksheet As WorksheetFor Each myWorksheet In Worksheets'The next line of code verifies that cell A1 in each worksheet is not empty. This text is a code 'remark.' The single quote mark at the beginning of the line informs Excel not to include this text in the macro code. Remarks are a good way to leave notes in VBA code that explain commands or syntax used.If myWorksheet.Range('A1').Value
'' Then'This command renames the worksheet to the text value in cell 'A1' of the first worksheet.myWorksheet.Name = myWorksheet.Range('A1').ValueEnd If'The 'Next' command instructs Excel to repeat the above code commands until it has finished renaming all the worksheets in the active workbook.Next
4. Click the 'Save' icon beneath the menu bar in the VBA editor window. Enter a name for the Excel template that contains the macro code. Select 'Excel Macro-Enabled Workbook' as the file type and then click 'Save.' Close the VBA editor window.
5. Test the macro for the sample VBA code. Enter a header or sheet title name in cell A1 of each worksheet. For instance, enter 'Daily,' Weekly' and 'Monthly' in cell A1 of three worksheets. The tabs for each worksheet at the bottom of the Excel window should read 'Sheet1,' 'Sheet2' and 'Sheet3,' respectively.
6. Click 'Macro' on the 'View' tab. Highlight the 'Change_Worksheet_Names' macro and then click 'Run.' The worksheet tab names at the bottom of the window change to 'Daily,' 'Weekly' and 'Monthly.'

Read more ►

How to Insert Error Bars in Excel 2007

1. Open the Microsoft Excel 2007 application that contains the chart that you want to add error bars to.
2. Click on the area of the chart where you want to add the error bars. Click on the “Format” tab and then click on the arrow next to the “Chart Elements” box.
3. Click on the chart element from the list that you want to add the error bars to. Click on the “Layout” tab and then click on the “Error Bars” option from the “Analysis” group.
4. Select the “Error Bars with Standard Error”, “Error Bars with Percentage” or “Error Bars with Standard Deviation” option.
5. Click on the “More Error Bar Options” button and then click on the “Vertical Error Bars” or “Horizontal Error Bars” option.
6. Click on the “OK” button and the type of error bars you selected will appear on your chart.

Read more ►