How to Work With Pivot Tables in PPT Excel 2003

1. Launch Excel 2003 and open a blank spreadsheet. Enter the source data that you want to use for the pivot table. The list should be organized in to columns or rows with original headers that correspond with the data that follows. For example, headers for a list of families who live on specific streets would be stored in the spreadsheet using the street names as column headers and the family surnames in the corresponding cells in the appropriate columns.
2. Click the “Data” menu and select the “PivotTable and PivotChart Wizard” option, which will open a separate window. Click the “Microsoft Excel” and “Pivot Table” options and click the “Next” button.
3. Select the data that you entered by clicking the header in the first column and dragging to the last cell in the last column while holding down the mouse button. Click the “Next” button.
4. Click the “New worksheet” option to display the pivot table results in a new worksheet within the Excel workbook. Click the “Existing worksheet” option to display the results in the worksheet that contains the source data. Click the “Finish” button.
5. Select the data that you want to appear in the PPT file. Click the “Copy” button. Launch PowerPoint 2003 and open a blank slide show or a presentation to which you want to add the pivot table information. Click the “Paste” button in PowerPoint to paste the data into the slide.

Read more ►

How to Program Excel Interfaces

1. Start Microsoft Excel, then open any worksheet or workbook.
2. Click on the 'Developer' tab. If you don't have this tab, click on the 'Microsoft Office' tab, then click on 'Excel Options.' Click on 'Popular' in the categories pane, and then select 'Show Developer tab in the Ribbon.' Click on 'OK' to close the dialog box. The 'Developer' tab will now be added to the toolbar.
3. Click on the 'Visual Basic' button. This will open the Visual Basic Editor (VBE).
4. Click on the 'Insert' tab and then click on 'New Module.' This opens a blank window where you can write your VBA code.
5. Write a short piece of VBA code to perform a task. For example, VBA code to bold characters is:Sub boldletter()' boldletter MacroSelection.Font.bold = TrueEnd SubThe macro should start with Sub (for subroutine) or Function, and end with End Sub or End Function. The first line of the code also contains the name of the subroutine followed by an open and closed parentheses, which is in this case is 'boldletter.' An apostrophe at the beginning of a line means that it is a comment.
6. Press the 'F5' key to run the macro.
7. Save the code by saving the workbook. Exit the VBE by pressing the 'alt' and 'F11' keys together. Click on the 'Microsoft Office' button and then click on 'Save.'

Read more ►

How to Use Microsoft Excel to Make a Bar Graph

Make a Bar Graph in Excel 2003
1. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
2. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells, or press and hold the 'Ctrl' key and click on each cell you want to select.
3. Click the 'Chart Wizard' button on the standard toolbar. Select 'Bar' under 'Chart Type.' Select a bar graph subtype in the 'Chart Subtype' box. Click 'Next.'
4. Select any other settings desired. Click 'Finish' to complete the wizard and add the bar graph to your Excel worksheet.
Make a Bar Graph in Excel 2007
5. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
6. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells or press and hold the 'Ctrl' key and click on each cell you want to select.
7. Go to the 'Insert' tab. Click 'Bar' in the 'Charts' group. Select a bar graph subtype to add the chart to the current worksheet.
8. Click on the chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different layout or move the chart to another sheet.
9. Go to the 'Format' tab under 'Chart Tools' to make formatting changes, such as shape styles and colors. Save the worksheet before closing it.

Read more ►

How to Learn Macros in Excel 2007

1. Click on the 'Developer' tab to bring up the ribbon.
2. Click the 'Record Macro' button in the Code frame of the Developer ribbon.
3. Type your desired macro name into the 'Macro Name' text box, then type the shortcut key you want to use to access your macro in the 'Shortcut Key' text box. Click 'OK.' For example, you might name your macro 'AddEmphasis' and set the shortcut key to 'E.'
4. Format your spreadsheet in whatever way you want. Whatever you do now will be repeated when you run the macro in the future. For example, you might italicize the text in a cell and change the background to yellow.
5. Click the 'Stop Recording' button in the Code section of the Developer ribbon.
6. Press 'Ctrl' and the shortcut key you chose in Step 3 at the same time. For the example, if you press 'Ctrl' and 'E' at the same time, the active cell will become italic and the background will turn yellow. You now have a working macro.

Read more ►

How to Exit From a Sub in VBA

1. Open the VBA editor. Double-click on one of the Microsoft Office programs that you want work with. Click on the 'Developer' tab and then click on 'Visual Basic.' If you don't see the 'Developer' tab, click on the 'File' tab and then 'Options.' Click on the 'Customize Ribbon' tab in the 'Options' dialog box. Click on 'Main tabs,' and then click on the 'Developer' check box. Click 'OK' to close the 'Options' dialog box.
2. Navigate to the sub procedure that you want to work with in the Visual Basic Editor. Double-click on the page in the right pane to open it. To work on a new procedure, click on 'Insert' and then 'Sub Procedure.'
3. Add the 'Exit Sub' command in the sub procedure where you want to exit a certain block of code. This will be between the Sub and End Sub commands. Usually, the Exit Sub command is added right after the code handler. Here is an example of a code block with an Exit Sub command:'Sub message ()MsgBox 'Hello World!'On Error GoTo Error_Handler:Worksheets('Welcome Message').ActivateExit SubError_Handler:If Err.Number = 9 ThenWorksheets.Add.Name = 'Welcome Message'ResumeEnd IfEnd Sub'The sub procedure shows a message box that says 'Hello World.' If for some reason the program can't display the message, it is directed to the 'Error_Handler' block. To stop the code from continuing to cycle through the same bits of code, the 'Exit Sub' command is given.

Read more ►

How to Create a Venn Diagram in Excel or Word

1. Open a document in Microsoft Word or Excel.
2. Click the 'Insert' tab. In the 'Illustrations' group, click 'SmartArt.' Click the 'Relationship' tab. Scroll down and select the icon for 'Basic Venn.' Click 'OK' to insert the Venn diagram.
3. Click 'Text' in the Text pane on the left. Type the text you want to place inside the first circle, which should be the name of the thing you are comparing. Click the next item down to enter text for the next circle. You also can click a circle in the graphic and type the text there.
4. Add or remove circles from the Venn diagram if you have more or less than 3 circles you want to compare. To add a circle, select the circle nearest to where you want to add one. Click the 'Design' tab. In the 'Create Graphic' group, click 'Add Shape.' Click either 'Add Shape After' or 'Add Shape Before,' and a circle will be added to overlap the selected circle. If you need to delete a circle, select it and then press 'Delete.'
5. Edit the circles in your diagram by manually moving them around. Click a circle you want to move, then drag it to the proper location. This will change the location and size of the overlapping areas of the circles.
6. Format the diagram by clicking the graphic, then clicking the 'Design' tab. To change the color combination, click 'Change Colors' in the 'SmartArt Styles' group and select a theme. Apply a SmartArt Style to change the look of it. Scroll through the styles in the 'SmartArt Styles' group and click the one you want. To change the look of a particular circle, right-click the border of the circle. Select 'Format Shape.' Here you can edit the line color, line style and fill color.
7. Click the 'File' tab or 'Microsoft Office Button,' then 'Save as' to save your Venn diagram.

Read more ►

How to Fit an Excel Sheet on One Page

1. Open the Excel spreadsheet that you want to print. Click on 'File' in the Excel toolbar, or use the keyboard shortcut 'Alt' and 'F.'
2. From the 'File' menu, select 'Page Setup.'
3. In the 'Page Setup' dialog box, click the 'Page' tab.
4. Under 'Scaling,' click the radio button to the left of 'Fit To.'
5. Enter your desired number of pages in the 'Pages Wide' and 'Pages Tall' drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter '1' into 'Pages Wide' and delete the number in the 'Pages Tall' menu.
6. Click OK. Your Excel spreadsheet will now fit the way you want it to.

Read more ►

How to Modify a Worksheet in Excel 2007

1. Determine what you need to modify. You have just received correspondence from some of your friends that have changed their address. You now need to update their information in your workbook.
2. Open your worksheet and find the information that needs to be modified.
3. Click on 'Edit' and 'Find and Replace'. When the box appears type in the first or last name of the person you need to locate in the 'Find' box and click ok.
4. Let Excel find and take you to the information.
5. Select the columns that need to be updated. Fill in the new street, city, state and zip code with the new information.
6. Decide if you need to add more information. If your friends have included their phone number in the new information that they sent you, but you haven't put in a column for phone numbers, you can add this column now.
7. Add the new column. Go to the title row and type in a heading such as phone. You can then go back to the row you were in and add the phone number that you have just received.
8. Continue to add new information, by adding new columns or rows to the information that is already there. This is all it takes to modify your worksheet.

Read more ►

How to Print on One Page in Excel 2003

1. Click 'Start' from the bottom-left of the screen. Click 'All Programs' and then click 'Microsoft Excel 2003.'
2. Click 'File' and then 'Open.' Click the Excel file of choice and click 'Open.'
3. Click and drag the mouse over the group of cells of the worksheet you wish to print. If you do not choose the group of cells when you print, Excel will print both cells with data as well as cells that are blank.
4. Click 'File,' then click 'Print Area' and then 'Set Print Area.'
5. Click 'File' and then click 'Page Setup.'
6. Click the option 'Fit to' in the 'Page' tab. Enter the value of '1' page wide by '1' tall.
7. Click the 'Margins' tab. Check the box next to 'Horizontally' under 'Center on page' and click 'OK.' This ensures the worksheet prints in the center of the page for the standard portrait paper layout.
8. Click 'File' and then 'Print.' The Print window launches. Click 'OK' to print your worksheet.

Read more ►

How to Add Data to a Pivot Table

1. Double-click the Excel file that contains your PivotTable to open it with Excel 2010.
2. Navigate to the source data for the PivotTable. This may be in a separate area of the worksheet, or on a separate worksheet. If your data is on a separate worksheet, you can chance worksheets by clicking on the correct worksheet tab at the bottom of the window.
3. Add your desired row or column of data. You can also modify the existing data, if you need to.
4. Navigate to your PivotTable and select any cell in the table. Click the 'Options' tab at the top of the screen, and then click the 'Change Data Source' button. Excel 2010 will automatically move to your source data and open a 'Move PivotTable' window.
5. Click on the top-left cell in your source data, and hold the mouse button as you drag the mouse to the bottom-right cell. Then release the mouse button and click 'OK' on the 'Move PivotTable' window. The PivotTable will now update to include the added data.

Read more ►

How to Use the Color of an Active Cell in Excel

1. Highlight the range of data you want to sort.
2. Select the Home tab at the top of the page, then click on 'Sort Filter' in the Editing group and then click 'Custom Sort...' to open the Sort dialog box.
3. Check the box labeled 'My data has headers' if you highlighted data header rows when selecting your data.
4. Choose the column by which you want to sort your data under 'Sort by' and then select Cell Color under 'Sort On.'
5. Choose the color by which you want to sort under 'Order.' All colors present in your data range, including 'No Cell Color,' will be available as options. Choose whether you want that data placed on top or on the bottom.
6. Add additional sorting levels by clicking 'Add level' and or 'Copy level,' if desired.
7. Click 'OK' to view your sorted data.

Read more ►

How to Link Word 2007 Excel 2007 Documents

1. Open the Microsoft Word 2007 file on your computer that you want to link an Excel 2007 file into. Click on the area in your document where you want the link to appear.
2. Click on the 'Insert' tab and then click on the arrow next to the 'Object' field.
3. Click on the 'Text from File...' option from the drop-down menu and then the Insert File dialog box will appear.
4. Select the Excel 2007 file on your computer that you want to link into your document.
5. Click on the 'Insert as Link' option and then the Excel 2007 will appear as a clickable link within your document.

Read more ►

How to Calculate Range in Excel

1. Open a new worksheet in Microsoft Excel. For the purposes of this article, type a series of numbers into column A, beginning with '1' in cell A1 and ending with '10' in cell A10.
2. Click on cell B1, which should be blank, and type '=MAX(A1:A10)' to find the highest number in the data sample you entered. In this case, it will be 10.
3. Click on cell B2, which is also blank, and type '=MIN(A1:A10)' to find the lowest number in the data sample. In this example, it will be 1.
4. Click on the blank cell B3 and type '=B1-B2' to calculate the range by subtracting the minimum value of your data from the maximum value. In the above example, the range is 9.

Read more ►

How to Hide Formulas in an Excel Spreadsheet

1. Locate the cells with the formulas you want to hide.
2. Select those cells by clicking and dragging with your mouse.
3. Right-click on your selection, and select 'Format cells' from the resulting menu. In the window that appears, select the tab titled 'Protection' and check the check box labeled 'Hidden.' Click 'OK' to finish.
4. Finally, select the 'Review' tab in Excel's main window, and select the 'Protect Sheet' option. This final step will ultimately hide your formulas. If you want to view them again, disable the protection on the sheet. You can also password-protect the sheet if need be.

Read more ►

How to Sort in Microsoft Excel 2007

1. Open your data file in the Excel 2007 program. Place your mouse over the first letter that represents your first column (usually column A). A down-pointing arrow will appear. Left-click your mouse and hold, then drag the mouse across to select all of your columns. Let go of the mouse and look through the file to assure that all of your columns are highlighted (selected).
2. Click the 'Data' tab on the Excel 2007 main menu. Go to the 'Sort Filter' section. Click 'Sort'---a dialog box will appear.
3. Choose the column letter by which you want to sort your list under the 'Sort by' box. For instance, if you have a mailing list containing last name (as column A), first name (as column B), address (as column C) and phone number (as column D), you'll probably want to sort your list by last name (column A), so that you can refer to customers by name quickly. If you plan to call all customers within a certain area code, you'd sort the list by phone number (column D).
4. Select your 'Sort On' attribute. The choices are values, cell color, font color and cell icon. The values choice will be most commonly selected---this looks at the data inside of each cell. The other three options are format-based. For instance, if you have color-coded various cells in your list and want to display them all next to each other on the sheet, you would sort on 'cell color.' The same is the case for cell fonts and icons you have inserted into the cell using 'Conditional Formatting' (see Resources for more information on cell icons).
5. Pick the 'Order' that you want the information to sort by. For values, it is either A to Z or Z to A. For the other sort options (cell color, font, icon), you choose which color or icon you want to appear first or last and the rest will settle in between. Click 'OK' to sort the data.

Read more ►

How to Make All Excel Rows the Same Height

1. Open Microsoft Excel.
2. Hold the 'Ctrl' key and press 'A' to select all cells.
3. Right-click any row number and select 'Row Height...' from the pop-up menu.
4. Enter a point size for the cell in the 'Row Height' window and click 'OK' to set all rows to that size. Alternatively, you can click and drag the line between row numbers to change them visually. When you release your mouse button, all rows will appear at the selected height.

Read more ►

How to Calculate the Percent Change in Excel

1. Open Microsoft Excel.
2. Click the cell where you want the calculation to be performed.
3. Type '=(B-A)/A' and press 'Enter' to calculate the decimal change from 'A' to 'B.' Replace 'A' with the original number, and 'B' with the new number. As an example, to calculate the decimal change on a sale which reduced the original price of $120 to the sale price of $80, you would enter '=(80-120)/120' and press 'Enter.' This produces 0.3333. You can also use cell references, such as '=(A2-A1)/A1' where 'A1' references the first row of the 'A' column.
4. Right-click the cell, and select 'Format Cells...'
5. Click 'Percentage' under the 'Category' list of the 'Number' tab. Select the number of 'Decimal places' and click 'OK' to change the decimal change into percent change. The default number of decimal places is two. In the example, 0.3333 is converted into '33.33%.'

Read more ►

How to Create Check Boxes

Set Up Word or Excel
1. Click 'Start' > 'All Programs' > 'Microsoft Office' and then either 'Microsoft Word 2010' or 'Microsoft Excel 2010.'
2. Select 'Options' from the 'File' tab in Microsoft Office or Microsoft Excel's ribbon. Select 'Customize Ribbon.'
3. Select the 'Developer' check box under 'Main Tabs.' Click 'OK.'
Check Boxes in Word
4. Select 'Design Mode' from the 'Developer' tab of the ribbon.
5. Click the place on the document where you want to insert the check box.
6. Click the 'Check Box Content Control' icon in the 'Controls' group of the Developer tab.
7. Select 'Properties' in the 'Controls' group of the Developer tab. Enter an optional title or tag. Change any other optional settings pertaining to formatting and click 'OK.' Enter labels and instructions.
8. Add more check boxes if you desire groups. Select the group of check boxes by pressing the Ctrl key and clicking on each you want. Select 'Group' from the 'Controls' group of the Developer tab.
9. Select 'Save' from the 'File' tab.
Check Boxes in Excel
10. Select 'Insert' from the 'Developer' tab of the ribbon bar. Select the check-box icon in the 'Form Controls' group.
11. Select the cell of the Excel worksheet where you want the upper left corner of the check-box control located.
12. Select 'Properties' from the 'Controls' group of the Developer tab.
13. Select one of three initial states for 'Value' for the check box: unchecked (default), checked or mixed (applies for groups of check boxes where one or more values may be checked initially).
14. Enter the cell reference that contains the initial value of the check box under 'Cell link,' e.g., $C$1. You may click the icon and then click the cell in the spreadsheet if you prefer. Click 'OK.'
15. Click to the right of the check box to edit the label text. Select 'Save' from the 'File' tab.
Protect the Word Form for Distribution
16. Select 'Restrict Editing' on the Developer tab in Word.
17. Check the box for 'Allow only this type of editing in the document' in section two of the 'Restrict Formatting and Editing' pane located on the right of your screen. Select 'Filling in forms' from the drop-down list in section two 'Editing restrictions.'
18. Click 'Yes, Start Enforcing Protection' in section three 'Start enforcement.' You may enter a password or leave the password fields blank. Click 'OK.'

Read more ►

How to Change Row Colors in Pivot Table

1. Open Microsoft Excel 2003, then open the workbook containing the pivot table you want to change the row colors.
2. Click the tab in the Excel workbook for the sheet that contains the pivot table. If workbook tabs are hidden, click the 'Tools' link in the menu bar, then click the 'Options' link in the drop-down menu to open the 'Options' dialog box. Click the 'View' tab in the dialog box, check the box next to 'Sheet tabs,' then click the 'OK' button.
3. Select one of the rows in the pivot table you want to change the color. Click the first cell in the row, then drag the pointer to the final cell. Do not select the row by clicking on the row number as this will result in the row color you apply extending beyond the limits of the pivot table.
4. Right click over the row you have selected and click the 'Format Cells' link in the context menu.
5. Click the 'Patterns' tab, then click the color you want from the set of colors displayed in the 'Cell Shading' section.
6. Click the 'OK' button to close the 'Format Cells' window and apply the color you chose to the row you selected. Repeat the process to apply color to other rows in the pivot table.

Read more ►

How to Remove Excel From Shared Mode

1. Click the Windows Start icon and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel.' The spreadsheet software opens.
2. Press the 'Ctrl' and the 'O' keys to open the 'Open' dialog window. Double-click the file you want to edit.
3. Click the 'Review' ribbon tab, then click 'Protect and Share Workbook.' This button opens a sharing configuration window.
4. Remove the check mark next to the 'Allow changes by more than one user at the same time.' Click 'OK' to save the changes.

Read more ►

How Do I Change Margins on One Page of a Document in Microsoft Word?

1. Highlight all of the text on the page where you want to change the margins.
2. Open the 'Page Setup' dialogue box.
3. Enter your desired margin sizes in each corresponding margin field.
4. Click the drop-down arrow next to 'Apply to' and choose 'Selected text.'
5. Click 'OK' to finish adding margins.

Read more ►

How to Create a Chart in Excel 2007

1. Create data that can be charted. Open Excel 2007, and either open an existing worksheet or use the default. Enter or create some data that supports the creation of a chart, for example the amount of sales by product over a period of time. This data should be in the form of a table, with the element values to be charted populating the left hand column and the data series, or information about the elements, in the cells across from each element. More than one series, for example the quarters in a year, can be included for each element. Title the data series across the top of the table and do not leave any blank spaces in the table.
2. Select the data to be charted. Left-click and drag a box around the data to select it. Make sure to include both the data and the labels.
3. Choose the chart type. Select 'Insert' on the Excel 2007 ribbon and then choose from the chart types listed in the 'Charts' section. For a chart type that's not visible, select the 'Other Charts' icon. The chart will be placed on the worksheet near the table of data. By default, the series will be listed across the bottom, or 'x-axis,' and the elements will be listed to the side. The element values will be listed on the left, or 'y-axis' of the chart.
4. Position the chart. Left-click on any white space on the chart, and move it to the desired location.
5. Format the chart. Right-click on the chart and a variety of options will appear in a dialog. Change the font displayed within the chart, change the chart type and select different chart data by selecting the relevant item from the list. To change the chart's appearance, select 'Format Chart Area,' and then select from the options to change the chart's 'Fill,' 'Border Color,' 'Border Styles,' 'Shadow' and '3-D Format.'

Read more ►

How to Calculate IRR

1. Set up a new spreadsheet with each row showing the cash inflows and outflows by year. For example, Row 1 would have the cost of the new equipment at time zero (the date of purchase). Row 2 would have the expected manufacturing cost savings in year 1. Row 3 would have the savings in year 2, etc.
2. Choose 'Insert/Function' from the main menu. Select 'All Functions' and choose 'IRR' from the list.
3. A box will appear that asks you to define the values, and for a guess. Highlight your cash inflows and outflows in your spreadsheet to be the relevant values. For a guess, choose the default of .10. There will almost never be a need to make another, different guess, unless you are dealing with multiple IRRs.
4. The formula calculates your internal rate of return (IRR) in percentage format and inserts the answer into your chosen cell. If you do not wish the formula to round the percentage, choose 'Increase Decimal' on your toolbar to add decimal places.
5. Compare the calculated internal rate of return (IRR) to your benchmark rate for investments. For example, if your other alternative is to invest that initial capital outlay in another investment, you would compare the IRR to the rate you would earn on another investment. If the rate of return is higher than your benchmark rate, you would choose to invest in the project. If you are calculating IRRs on multiple potential projects, you would choose the project with the highest IRR.

Read more ►

How to Convert Mac Office 2003 Excel to Windows Excel 2003

1. Connect the flash drive to your Mac computer. In a moment you are going to see a desktop icon appear for the device.
2. Open Microsoft Office 2003 and load the file you want to convert over to Windows.
3. Click 'File,' 'Save' and select the flash drive as your save location.
4. Eject the flash drive by dragging it down to the trash can in the lower right corner of your desktop dock. Once the icon is gone you can safely remove the device from your Mac.
5. Connect the flash drive to your Windows computer. Launch Microsoft Office Excel 2003.
6. Click 'File,' followed by 'Open.' Select the flash drive and choose the Excel file you saved from the Mac. Click 'Open' and the file is opened into the program.

Read more ►

How to Learn Excel for Free on the Computer

1. Click 'Start,' click 'All Programs,' click 'Microsoft Office' and then click 'Microsoft Office Excel 2007' to display its Book1 - Microsoft Excel window.
2. Click the blue question mark — Microsoft Office Excel Help — button to display the Excel Help window. Scroll to 'Training' and then click on it to display a list of Training Topics. Click on 'Excel 2007 training courses' to display its window, which is subtitled: A roadmap to Excel 2007 training. Click on the title of any course listed here to display its website, read its title page, click 'Start this course' to display page 2, and then click 'Back' and 'Next' to navigate through its web pages. Most of these courses include practice exercises and self-evaluation tests. When you have finished a course, simply close your browser to redisplay the Excel 2007 training courses window in help.
3. Scroll to '1. GET FAMILIAR WITH EXCEL,' click 'UP TO SPEED WITH EXCEL 2007' to display its web page and then work through the course as described in step 2. Click 'Get to know Excel 2007: Create your first workbook' and then work through its course. Click 'Get to know Excel 2007: Enter formulas' and then work through its course. Click 'Learn how to figure out dates using formulas in Excel 2007' and then work through its course. Completing these four courses should help learn how to use the basic features of Excel 2007.
4. As needed, you can continue with the other courses in: 2. CREATE CHARTS IN EXCEL, 3. CREATE PIVOTTABLE REPORTS, 4. SHARE DATA WITH OTHER PEOPLE, and 5. LEARN GENERAL OFFICE SKILLS.

Read more ►

How to Spell Check Multiple Worksheets in Excel

1. Open Excel by double-clicking on the program's icon. Open the document with multiple worksheets that you want to spell check.
2. Click on the first bottom tab while holding down the 'Shift' key. Continue holding down the 'Shift' key and click on the remaining tabs to highlight all worksheets that need checking for spelling or grammatical errors.
3. Select the 'Tools' menu option and then choose 'Spelling.' A popup box appears asking, 'Do you want to continue checking at the beginning of the sheet?' Click 'Yes.'
4. Review each word that the computer doesn't recognize. The spell check takes you through each worksheet. The popup box gives you options for each spelling mistake: 'Ignore,' 'Change,' 'Add,' 'AutoCorrect,' 'Ignore All' or 'Change All.'
5. Choose the option that fits your needs for each word. Clicking on that option takes you to the next error.
6. Go through each potential error that pops up. A popup box then appears stating, 'The spelling check is complete for the selected sheets.' Click on 'OK.'
7. Hit 'Save' to save any changes you made to your worksheets. Then, click on one of the tabs highlighted so further changes you make don't affect multiple worksheets.

Read more ►

How to Calculate Compound Interest for Excel 2003

1. Title cell A1 'Principal,' cell A2 'Compounding Periods,' cell A3 'Yearly Rate,' cell A4 'Time Period,' cell A5 'Periodic Rate' and cell A6 'Total Interest.'
2. Enter the value for the amount of money you started with in cell B1, the number of times interest compounds each year in cell B2, the yearly interest rate in cell B3 and the number of years you will leave the money in the account in cell B4.
3. Enter the formula '=B3/(B2*100)' in cell B5 to calculate the periodic interest rate. You have to divide by 100 to convert from a percentage to a decimal.
4. Enter the formula '=B1*(1 B5)^(B2*B4)-B1' in cell B6 to find the total interest. Once you have entered the formula, the total interest for your specified time period will be displayed.

Read more ►

How to Merge or Split Cells Data in Microsoft Excel

1. Open Excel 2010. Type some random numbers in cells A1, B1 and C1. Highlight cells A1, B1 and C1.
2. Click the 'Home' tab and select 'Merge and Center.' The cells will merge as one large cell displaying information from cell A1.
3. Split the merged cells by selecting the newly merged cell. Click 'Merge and Center' icon. The cells will split displaying three separate cells again.

Read more ►

How to Create a Dropdown List in Excel 2007

1. Type a list of entries for the drop-down list in a single column. For example, if you want a drop-down list for the days of the week, type 'Monday' in cell A1, 'Tuesday' in cell A2, 'Wednesday' in cell A3, 'Thursday' in cell A4, 'Friday' in cell A5, 'Saturday' in cell A6, and 'Sunday' in cell A7.
2. Click on the cell where the drop-down list will go.
3. Click on the 'Data' tab, then click on 'Data Validation,' then click on 'Data Validation' again.
4. Click on the 'Settings' tab in the dialog box.
5. Click on 'List' from the 'Allow' box.
6. Enter the cell references into the 'Source' text box. In the above example, you would type '=A1:A7.' The 'in-cell dropdown' check box should already be checked. If it isn't, make sure to check it.
7. Click on the 'OK' button. Excel will insert a list into the chosen location.

Read more ►

How to Create a Spreadsheet Template in Excel

1. Create a workbook file with all the basic settings you use: sheets, default text (such as column and row labels and page headers and footers), formulas, macros and anything else you want in new workbooks based on the template. You probably don't want to enter a lot of data into the template, but you might.
2. Open the File menu and select Save As.
3. In the 'Save as type' box, click Template (*.xlt).
4. In the 'Save in' box, select the folder where you want to store the template. To create a normal template, select the Templates folder, which should have automatically opened when you chose the Template type in the previous step.
5. To make this template the default (so that it's automatically selected), save the folder in the XLStart folder. The XLStart folder should be located in the following place: C:\Windows\Application Data\Microsoft\Excel\XLStart.
6. In the 'File name' box, type a name for the template (like 'Budget template'). Use the name 'book' if you want this template to be the default.
7. Click Save.

Read more ►

How to Add Comments to an Excel Worksheet

1. Open the Excel spreadsheet you wish to change.
2. Select the cell into which you'll write your comment.
3. Choose Comment under the Insert menu.
4. Type your comment into the resulting box.
5. Finish typing and click outside the box to save your comment.

Read more ►

How to Make a Gantt Chart in Excel

1. Open a new Excel worksheet. For the purposes of this article, enter 'Task' in cell A1, 'Start Date' in cell B1 and 'Length' in cell C1. Type in a few lines of chart data under the appropriate headings. The first column names the tasks, the second column provides a start date, and the third column lists the number of days each task is expected to take.
2. Select the data table by clicking the first cell and dragging across all the cells you typed data into. Go to the Insert tab and select 'Bar' from the Chart panel. Click on 'Stacked Bar' under the 2D heading as the chart subtype.
3. Click on 'Select Data' in the Design tab under Chart Tools; the Select Data Source window will open. Remove any entries listed under Legend Entries (Series) by selecting them and clicking 'Remove.'
4. Click on 'Add' to bring up the Edit Series dialog box. Type 'Start Dates' in the Series name field. Delete any values in the Series values field. Click inside the field, then drag your mouse from the first data cell to the last data cell in the Start Dates column; you will see the data range appear in the field. Click on 'OK' to return to the Select Data Source window.
5. Repeat Step 4 to add a new data series. Name it 'Length' and select the data in the Length column. Return to the Select Data Source window.
6. Click on 'Edit' under Horizontal (Category) Axis Labels and drag your mouse from the first data cell to the last data cell in the Tasks column (not including the heading). Click on 'OK' to return to the Select Data Source window, and 'OK' again to return to the worksheet.
7. Double-click on the colored area in the left side of any of the bars. The Format Data Point box will open. Click on 'Fill' and change it to 'No Fill.' Click on 'Border Color' and change it to 'No Line.' Click 'Close' to apply the changes. The first color in the bars will be gone.
8. Double-click the category axis, which is the area where the task names are listed. The Format Axis dialog box will open. Under Axis Options, click the 'Categories in Reverse Order' check box. The chart order will be flip-flopped.
9. Double-click the value axis, which is the white area where the start dates are shown. The 'Format Axis' dialog will open. Under Alignment, change the Custom Angle to 45 degrees. Click 'OK' to apply these changes.
10. Click on the chart legend and press the 'Delete' key to remove it.

Read more ►

How to Create a Template in Excel 2007

1. Open Microsoft Excel 2007 on the computer.
2. Click the 'Microsoft Office' button from the main program menu, and then click 'Open.' Browse to and double-click the existing Excel workbook or worksheet that you want to use as a template. If you don't have an existing spreadsheet, click 'New' to create a new Excel document to use as a template.
3. Enter the information and add the elements that you want to include in the Excel template. This should include all the data, graphics, text, macros and formulas that the template requires to work properly.
4. Click the 'Microsoft Office' button on the main menu, and then click 'Save As.'
5. Type a name for the template in the 'File Name' box.
6. Click 'Excel Template' in the 'Save As Type' box. If the workbook contains macros that you need to include in the template, click 'Excel Macro-Enabled Template' in the 'Save As Type' box. Click 'Save.'

Read more ►

How to Expand a Row in Excel 2003

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel' to open the software.
2. Click 'File,' then click 'Open.' Double-click the Excel file with the rows you want to edit. The file loads in the Excel editor.
3. Hover the mouse over the line below the row you want to expand. Notice the cursor displays an arrow. Click the row's grid line and expand the height.
4. Click the 'Save' button to save the changes. Repeat these steps for each row you want to edit.

Read more ►

How to Print in Excel 2007

Print Whole Worksheet
1. Open your document in Microsoft Excel. Click on a cell within the table to activate it.
2. Click the Microsoft Office button at the top of the worksheet. The Microsoft Office button will appear as a light blue circle with the Office logo inside. Click 'Print' or use the keyboard shortcut 'Ctrl' and 'P,' followed by 'OK.'
3. Click 'Table' under the 'Print What' option that will appear. Clicking 'Table' will print the entire chart.
Print Part of a Worksheet
4. Click on a cell and drag your mouse cursor to the rest of the table you wish to print. The table will highlight in a shaded color to indicate the highlighted cells.
5. Navigate your cursor to the 'Page Setup' group located inside the new 'Page Layout' tab at the top of the worksheet. Click 'Print Area.'
6. Click 'Set Print Area' to set the highlighted cells for printing. Print the worksheet by pressing 'Ctrl' and 'P,' followed by 'OK.'

Read more ►

How to Use Security Features in Excel

1. Enable security alerts from suspicious website links. Click the Microsoft Office button and choose 'Excel Options.' Choose 'Trust Center,' then click 'Trust Center Settings' and select 'Privacy Options.' Make sure you have 'Check Office documents that are from or link to suspicious Web sites' checked.
2. Select 'Enable Content' on the message bar if your workbook has external content. Choose to unblock the external content when the security dialog box appears.
3. Access the Trust Center to view your security and privacy settings for Active-X controls, add-ins and macros. Click on the Microsoft Office button and go to 'Excel Options.' From there, go to 'Trust Center' and then 'Trust Center Settings.'
4. Password-protect your workbook. You can choose to require a password before anyone can open or modify your workbook. Select 'Tools' from the 'Save As' dialog box. Click 'General Options' and input your passwords in the designated area.
5. Set the VBA / Macro Security to determine how VBA code and XML macros are executed. Go to 'Tools,' then 'Macros.' Set the security setting to at least medium.
6. Protect your worksheet from unauthorized editing by using Worksheet Protection. This allows other people to view most of the worksheet, but only edit certain cells. Click 'Tools,' go to 'Protection' and select 'Worksheet Protection.'

Read more ►

How to Include Grand Totals in Excel Pivot Charts

1. Open the PivotChart.
2. Click the 'Field List Button' image on the PivotChart toolbar if the Field List Button is not showing.
3. Click the field and go to 'Totals.'
4. Click 'Row Area' to add the grand total to the row area and 'Column Area' to add it to the column.

Read more ►

How to Insert a Template in Excel 2007

1. Hold the 'Windows' key down and press 'E' to open Windows Explorer.
2. Navigate to where you saved the template you want to insert into Excel.
3. Open another Windows Explorer window, type 'C:\Users\USERNAME\AppData\Roaming\Microsoft\Templates' in the top address field and press 'Enter.' When typing the address, change 'USERNAME' to your Windows username, which is listed beneath your picture on the 'Start' menu.Do not try to navigate into this folder by clicking folders. If you maintain Windows 7's default settings, you will not find the 'AppData' folder because it is a hidden system folder. However, by directly typing the location in the address bar, you bypass the hidden nature of the folders, which saves you the trouble of changing your Windows configuration.
4. Hold the 'Alt' key and press 'Tab' to return to the previous Windows Explorer window.
5. Click and begin dragging the Excel template file, which should have the XLTS extension.
6. Hold the 'Alt' key and press 'Tab' again to return to the template folder. Do not release your left mouse button yet.
7. Continue dragging the template file and drop it into the right pane by releasing the left mouse button. This inserts the template into Excel and makes it available for use.

Read more ►

How to Upgrade Microsoft Excel

1. Insert the install CD or DVD into the disk drive.
2. Enter your product key when prompted. This will occur after the install screen has popped up. If the install screen does not come up automatically, then navigate to your CD/DVD drive through 'My Computer' and double click on the Microsoft Office disk icon. The product key can be found on a sticker on the CD case inside your Microsoft Office box.
3. Accept the Microsoft License agreement.
4. Select 'Install Now' or 'Customize.' 'Install Now' will upgrade all previous versions of the Microsoft Office program that correspond to your recently purchased Office software. 'Customize' will allow you to specify which applications and features are upgraded.
5. Activate your product after the installation is completed. Activating over the internet is the quickest method if you have an internet connection. If you decline activation at this time, you will be prompted to activate each time you open an Office program.

Read more ►

How to Make a Basic Bookkeeping Spreadsheet in Excel

1. Examine your personal or business finances to determine the best way to use Excel. Different options are keeping track of accounts receivable and payable, including payroll, rent or utilities and any raw materials used in the production process.
2. Open Excel on your computer and create a new spreadsheet by clicking on the blank page icon at the top left of your screen.
3. Orient yourself with Excel's format. The page is made up of a grid which creates boxes. Information can be typed into each box.
4. Title the headings for your spreadsheet's rows and columns. For example, you may choose to use the first column to list all the dates in a given month, the second column to list any accounts receivable transactions and the third column to list any accounts payable transactions.
5. Fill in the information into the appropriate boxes. For example, if you or your company paid out $15,000 in payroll checks on the first of the month, you would write '15,000' in the corresponding box.
6. Add the total dollar amounts from each column -- in our example, you'd have a total for accounts receivable and a total for accounts payable. You can also calculate average expenditures and profits by selecting the 'Subtotals' option from the drop-down box under the 'Data' tab.
7. Sort information from high to low or low to high by clicking on the 'Sort' option from the drop-down box under the 'Data' tab; this gives you the option of seeing which entries had the highest or lowest values.

Read more ►

How to Paste Into PowerPoint and Remove Gridlines

1. Select the text, image or object that you want to include in your PowerPoint presentation. For example, highlight a range of cells in an Excel spreadsheet. Press 'Ctrl C' on your computer's keyboard.
2. Press 'Ctrl M' in PowerPoint to create a new slide and then press 'Ctrl V' to paste the object. If you copied a spreadsheet, for instance, it will paste in as a spreadsheet object. Note, that you can link or embed things such as spreadsheets, charts and Word documents.
3. Click on the 'View' tab in PowerPoint and click in the check box next to 'Gridlines' to remove the gridlines from the design view. If you want to remove the gridlines from a spreadsheet that you've pasted in, click inside the spreadsheet in PowerPoint. Press 'Ctrl A' to select all of the content in the spreadsheet. Click on the 'Table Tools: Design' tab and in the 'Table Styles' section click on the 'Borders' button and choose 'No Borders.'

Read more ►

How to Assign a Macro to a Cell in Excel

1. Right-click the sheet tab you want the change to happen in. The sheet tabs are at the very bottom of the worksheet.
2. Click 'View Code.'
3. Cut and post the following code into the worksheet:Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Target.Address = '$A$1' ThenRange('A10') = 'Your text here'End IfEnd Sub
4. Change the code to suit your needs. The above code writes 'Your text here' into cell 'A10' when cell 'A1' is clicked. Change the 'A1' in 'Target.Address = '$A$1'' to the cell you want to click, then change Range('A10') = 'Your text here' to indicate the cell you want the event to happen in and the text you want to appear.

Read more ►

How to Create Frequency Relative Frequency on Excel Using a Pivot Table

1. Gather all of your data and compile it into a list on Microsoft Excel. Select and highlight the entire list of data points. Right click it and choose the option 'Sort from smallest to largest.' Now that the data points are in numerical order, the task of creating a frequency distribution table will be much easier.
2. Determine the interval size and the number of classes that will be used for your distribution table. For example you may have something like 5 classes of intervals: 1-5, 5-10, 10-15, 15-20, and 20-25. These classes will be used to organize the data points.
3. Start setting up the table on Microsoft Excel. In column A, set up the different classes and label the column as 'Class.' Column B will be for the 'Frequency.' Count up the number of data points that fall in each class interval, and state the frequency in column B. Select the empty cell below the list of frequencies in Column B and use the sum function to add up the values. This result will give you the total number of data points. In column C, set up the 'Relative Frequency.' Relative Frequency is calculated simply by dividing the individual frequencies by the total number of data values. Select an empty cell at the end of the 'Relative Frequency' column and perform the 'sum' function. The sum for the 'Relative Frequency' column should be 1.00.
4. Select the 'Insert' tab on Microsoft Excel, and select the PivotTable button. Use the selection icon and select the entire table. Place a check next to 'New Worksheet,' so that the table appears on a separate sheet. Click 'OK.' A column in the right side of the screen will appear. Place a check next to the following fields that you'd like to add to your report: 'Class,' 'Frequency,' and 'Relative Frequency.'
5. Use the 'Options' and 'Design' tabs to edit and format the PivotTable.

Read more ►

How to Open Excel Templates

1. Open Excel. Click 'File' if you are using Excel 2010 or click the 'Office' button if you are using Excel 2007. The Office menu will open.
2. Click 'New' on the Office menu. A window called 'New Workbook' will open. You can search for and open Excel templates here.
3. Look to the 'Templates' section on the 'New Workbook' menu. You can view recently used or installed templates here.
4. Click one of the Excel template categories to view an Excel template. Categories you can choose from are 'Blank and Recent' and 'Installed Templates.'
5. Select the template you want to open and click 'Create' or 'OK' depending on whether you are opening a recent template or an installed template. The template will open in a new workbook.

Read more ►

How to Compare Workbooks

Comparing Numeric Values
1. Open a new workbook, and name it CompareWorkbooks.xls.
2. Look at the values that you want to compare in both workbooks. For example, you may wish to compare cells B2 to F7.
3. In cell B2 (or the upper left cell) of the CompareWorkbooks workbook, insert the formula '=[Workbook1.xls]Sheet1!A1-[Workbook2.xls]Sheet1!A1.' If the Workbooks or sheets are named differently, change the formula as appropriate.
4. Copy the formula from that cell into all of the applicable cells in the CompareWorkbooks workbook. A '0' in a cell means that the cells in the two compared workbooks are identical. A value in the cell represents the difference between the values in the corresponding cells in the compared workbooks.
Comparing Almost Identical Workbooks
5. To compare workbooks that are virtually identical, open a new workbook, and name it CompareWorkbooks.xls.
6. Look at the values that you want to compare in both workbooks. For example, you may wish to compare cells B2 to F7.
7. In cell B2 (or the upper left cell) of the CompareWorkbooks workbook, insert the formula '=IF([Workbook1.xls]Sheet1!A1
[Workbook2.xls]Sheet1!A1,'DIFF VALUE',''). If the Workbooks or sheets are named differently, change the formula as appropriate.
8. Copy the formula from that cell into all of the applicable cells in the CompareWorkbooks workbook. If the words 'DIFF VALUE' appear in a cell, it means that the corresponding cells in the two compared workbooks are different.

Read more ►

How to Graph a Trend Analysis in Microsoft Excel

1. Enter the data in Microsoft Excel on which the trend analysis will be performed.
2. Create a chart from the data entered. The chart must be an unstacked, two-dimensional chart that is formatted as bars, columns or lines.
3. Click anywhere in the chart. This will display the Chart Tools and add the Design, Layout and Format tabs at the top of the worksheet.
4. Click Trendline under the Layout tab in the Analysis grouping. This will create a drop-down showing the types of trend analysis that can be performed on your data chart.
5. Select one of the predefined trend-line options. The options are linear, exponential, linear forecast and two-period moving average. This will automatically graph the trend analysis in the chart.

Read more ►

How to Calculate Total Number of Rows in MS Excel

1. Log on to your computer and open Microsoft Excel by clicking on the 'Start' button, choosing 'All Programs' from the menu and selecting 'Microsoft Office.' Choose 'Excel' from the list of programs, then click the 'File' menu and choose 'Open' from the menu.
2. Hold the 'Ctrl' key down and tap the 'End' key on your keyboard. This will automatically move the cursor to the last row in the spreadsheet that contains an entry. If you simply want to know how many rows are in your spreadsheet you can use that row number. If you need to know how many rows actually contain data, move on to the next step.
3. Position your cursor underneath the last row that currently contains data and type '=COUNT(' hit the up arrow on your keyboard, then the period key. Hit the up arrow again and continue pressing the up arrow until you reach the top of the spreadsheet. When you have reached the top of the spreadsheet type ')' to close the calculation. You will see the number of rows that contain data.
4. Type the formula directly if you are working with a large spreadsheet. If you are working with a spreadsheet that contains a large number of rows, it will be easier to enter the formula directly. To enter the formula directly type '=COUNT(firstrow:lastrow)' For instance, if the first row in your spreadsheet is A1 and the last is Z1, the formula would be '=(COUNT(A1:Z1).

Read more ►

How to Remove Passwords in Excel 2007

1. Open the password-protected Excel 2007 file by double-clicking it from Windows or clicking 'Open' from the Office menu at the upper left of the screen.
2. Attempt to modify the document by double-clicking a cell and attempting to change a value. An error message will appear and warn you about your attempted action.
3. Click the 'Review' tab at the top of the screen.
4. Click 'Unprotect Sheet' and supply the document's password when prompted. Click 'OK' to submit the password.
5. Click the Office icon and then click 'Save.' The document will be saved in its unprotected state, and a password will no longer be needed to modify it.

Read more ►

How to Turn Excel 2007 Documents to Excel 2003

1. Open the Excel 2007 file that you want to convert into Excel 2003.
2. Click the 'File' button in the upper left hand corner.
3. Highlight 'Save As,' and then select 'Excel 97-2003 Workbook' as your save option. This will save your spreadsheet as '.xls', which is the Excel 2003 format.

Read more ►

How to Write Macros in Excel 2003

1. Click 'Tools > Macros > Record New Macro...' in the top menu.
2. Choose a name for your macro and type it into the 'Macro Name' textbox. For example, if you want to create a button that sets a certain cell to a special format, you might name the macro 'Special Format Macro.'
3. Type the shortcut key you want to use to access the macro into the 'Shortcut Key' textbox. If the example, you might choose 'S' as your shortcut key.
4. Press 'OK.'
5. Make the changes you wish to record into the macro. For example, you could make the text of the cell bold and the borders green.
6. Press the stop button on the Stop Recording Dialog. The button has a blue square on it.

Read more ►