How to Calculate the Time Difference Between Two Times in Excel 2003

1. Open Excel 2003, and select a workbook that contains columns with time information. Click 'File' on the menu bar, and select 'Open.' Browse your files, and select the workbook. Click the 'Open' button. The workbook opens.
2. Highlight the first column that contains time data. Right-click the highlighted data, and select 'Format Cells.' The Format Cells dialog box appears. Click the 'Number' tab. Select 'Time' from the 'Category' list. Select the first time format displayed. Click 'OK.'
3. Highlight the second column that will appear in the timed calculation. Press 'F4.' This repeats the previous timed number format.
4. In the third column, enter a time difference formula. The formula will subtract the first column from the second column. The formula will begin with an '=.' Click on the first cell in the first column and press the '-' key on your keyboard. Click the first cell in the second column and press 'Enter.'
5. Highlight the third column. Right-click the highlighted data, and select 'Format Cells.' The Format Cells dialog box appears. Click the 'Number' tab. Select 'Custom' from the 'Category' list. Select the time format that displays the following: '[h]:mm:ss.' Click 'OK.' Your difference column now displays the timed difference between the first and second column.

Read more ►

How to Use MegaStat in Excel 2007

1. Create a new spreadsheet in Excel 2007.
2. Open MegaStat.
3. Click the 'Add-Ins' menu option at the top-right of the screen, and you will see a new available option for 'MegaStat.' Click it to gain access to all MegaStat's functions.

Read more ►

How Do I Create a Color Drop Down Box in Excel?

Create Lookup List With Background Color
1. Go to a section of unused cells in the spreadsheet.
2. Type the choices that will appear in the drop-down list. Type one choice per cell and compose a list of choices with each selection under the previous one.
3. Highlight all cells in the list and then right-click on the highlighted block of cells.
4. Click 'Format Cells' from the context menu.
5. Click the 'Fill' tab and then click on the desired color for the background of the lookup list (the selected cells).
6. Click 'OK.' The background color of the cells is set.
Add the Lookup Cells As a Drop-down Box
7. Select the cell where the drop-down options will be placed.
8. Click 'Data' from the top navigation bar. Click 'Validation.'
9. Click the 'List' option from the 'Allow' drop-down list.
10. Click the 'Source' icon from the top navigation bar and drag the cursor over the lookup list. Alternatively, type the range of cells defining the lookup list, such as '(=$A$1:$A$4).'
11. Tick the box next to the 'In-Cell Dropdown' option and then click 'OK.' The lookup list now appears as a drop-down box in the selected cell.

Read more ►

How to Create Conditional Formats in Excel 2007

1. Open an existing Microsoft Excel document in which to create these conditional formats. Double click on the 'My computer' option on the main operating system desktop. Choose the location of the Excel file and double click on the file icon to open the document.
2. Ascertain which cells or worksheet the conditional formatting will apply to. Prior to opening the conditional formatting manager, choose particular cells, the entire worksheet or workbook to apply the conditional format.
3. Choose the 'Conditional Formatting' button from the home menu ribbon. Then select the 'Manage Rules' option from the conditional formatting menu.
4. Click on the 'New Rule' button from the conditional formatting rules manager dialogue box.
5. Select the type of rule to create. There are six types of rules that a user can create, in this case the 'Format All Cells Based on Their Values' type will be utilized.
6. Determine the scheme and value basis for the condition format rule. For instance, a user can make the color of each cell vary based on the number in the cell. The highest number gets a certain color while the lowest gets another color. All the numbers in between will be assigned a variation on color scheme based on the value relative to the highest and lowest number in the spreadsheet.
7. Apply the format style to the conditional format. There are four options to choose from. In this case, a '2-Color Scale' was used.
8. Save the rule and the spreadsheet once the conditional formatting rule is complete.

Read more ►

How to Make Mailing Labels in Excel 2007

1. Open the Excel 2007 worksheet containing the list you want to use to make mailing labels. If you do not yet have a list, open a blank worksheet. Enter a name for each column in the first row of the worksheet. Choose names that will be easy to understand in the merge, such as 'First Name,' 'Last Name' and 'Street Address.' Save and close the worksheet.
2. Start Word 2007. Go to the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels' from the drop-down list. The 'Label Options' dialog box opens.
3. Select the label settings for the label pages you are using. Pick the label brand name from the 'Label Vendor' drop-down list. Select the product number that is listed on the label package in the 'Product Number' list. Click 'Detail' to view the details for a label, such as the size and the number of labels per page. If the label you are using is not listed, click 'New Label' and enter the specifications for your label. Click 'OK' when you have made your selections.
4. Click 'Select Recipients' in the 'Start Mail Merge' section of the 'Mailings' tab. Click 'Use Existing List.' Navigate to the Excel 2007 worksheet containing the list you want to use to make mailing labels. In the 'Select Table' dialog box, click the sheet of the workbook that has the list you want to use. Click 'OK.'
5. Click 'Address Block' in the 'Write Insert Fields' group of the 'Mailings' tab. Click the 'Match Fields' button. Match the address block fields to the field names you used in your Excel worksheet. Click 'OK' to close the 'Match Fields' dialog box. Click 'OK' to close the 'Insert Address Block' dialog box.
6. Click 'Update Labels' in the 'Write Insert Fields' group of the 'Mailings' tab. Click 'Finish and Merge' in the 'Finish' group of the 'Mailings' tab. Select 'Edit Individual Documents' to create a new document with the merged mailing labels and print them later or click 'Print Documents' to print the labels immediately.

Read more ►

How to Put Excel Data Into a Pie Chart

1. Open a new worksheet in Microsoft Excel. Add headings in the first column down the left side of the page. For instance, if you are making a pie chart of my favorite things, you would write, 'Football,' in cell A1, 'Chocolate,' in cell A2, and 'Television,' in cell A3. Then, put the numbers in the 'B' column. So, using the above example, this would mean you'd put 50% in cell B1 next to 'Football,' a 30% in cell B2, next to 'Chocolate,' and a 20% in cell B3 next to 'Television.'
2. Highlight all of the cells in both columns, from A1 to B3. In Microsoft Excel 2007, simply click the 'Pie' button in the toolbar at the top of your screen. In earlier versions of Excel, and on the Mac 2008 version, click on the 'Insert' menu at the top of the screen and select the 'Chart...' option. A smaller window will pop-up called the 'Chart Wizard.'
3. Hit the 'Pie' button in Microsft Excel 2007, and a drop down menu will appear. Choose the type and style of pie chart you want, and that chart will then be inserted into your spreadsheet. This is the final step to make a pie chart in Excel 2007. If you are using earlier versions of Excel or Excel 2008 for Mac, proceed to the next steps.
4. Click on 'Pie' in the 'Chart Type' menu. To the right of the menu, you will see six different sub-types for how you want your chart to look. Click on the type of pie chart you want and then click and hold the button that says, 'Press and Hold to View Sample.' This will give you a preview of how your chart will look using the data you have entered. When you are happy with your chart, click 'Next' at the bottom of the window.
5. Clarify that the data range is correct in the pie chart. In the space titled, 'Data Range,' click on the gray button with red, blue, and black dots to the right of the blank space. This will shrink the Chart Wizard window. Use your mouse to highlight the area of data you want, including the headings and corresponding numbers. Click 'Next.'
6. Title your chart in the space on the left that says, 'Chart title.' When you are finished, click 'Next.' Finally, choose where you want your chart to be displayed. You can have it displayed directly in the document, or place it in a new spreadsheet. When you have made your choice, select, 'Finish,' and your pie chart will appear in the document.

Read more ►

How to Merge Excel Worksheets Into a Workbook

1. Open Microsoft Excel. Press and hold the 'Ctrl' key on your computer's keyboard and press the 'O' key to start the 'Open' window. Click on the first workbook you would like to open. Press and hold the 'Ctrl' key and click on the second workbook. Press the 'Open' button at the bottom right of the 'Open' window to open both workbooks.
2. Click the workbook on the bottom Windows toolbar that contains the sheet that you would like to merge. Right-click the sheet tab that you would like to move or copy. For example, right-click 'Sheet 1' tab at the bottom left of the Excel workspace to select the first sheet to merge. Click 'Move or Copy...' from the drop-down list.
3. Click the 'To Book' drop-down menu on the 'Move or Copy' window. Click on the workbook to which you want to move the worksheet. For example, if your other workbook is called 'Book1,' click on the 'Book1' workbook. Click the sheet name of where you want the sheet to appear in the new workbook from the 'Before sheet' menu. If you want your sheet to appear at the end of the workbook, click 'move to end' from the 'Before sheet' menu.
4. Check the 'Create a copy box' if you want to maintain the sheet in the current workbook. Otherwise, leave the box unchecked to move the sheet from one workbook to the other. Press the 'OK' button to move or copy the worksheet from one workbook to the other.

Read more ►

How to Delete Cells in MS Office 2003

1. Open an existing worksheet in Microsoft Excel.
2. Select the cell (or cells) you want to delete from your worksheet. To select an individual cell, simply click the cell. For a range of cells, click the first cell and drag your cursor down to the last cell. If it's a large range, click the first cell in the range, and press 'Shift' while you click the last cell. Press 'CTRL' while clicking individual cells that aren't adjacent.
3. Open the 'Edit' menu.
4. Click 'Delete.' As a shortcut, right-click the selection and click 'Delete.'
5. Make a selection in the 'Delete' dialog box. Select 'Shift Cells Left, Shift Cells Up, Entire Row or Entire Column.' This will determine what to do with the remaining cells after you delete.

Read more ►

How to Divide Cells in Excel

Divide the Numbers in a Cell
1. Click on a cell to enter your data.
2. Type an equal sign (=).
3. Type your first number. For this example, we will divide 15 by 5.
4. Press the forward slash key on your keyboard (/). This is the division sign in Excel.
5. Type in your next number, 5.
6. Press the 'Enter' key on your keyboard or click on the check mark on the tool bar. This displays the result of the calculation.
Divide Numbers in a Range of Cells
7. Type the number 15 into cell A1.
8. Type the number 5 into cell A2.
9. Click cell A3 and type an equal sign (=).
10. Click on cell A1. 'A1' should appear after the equal sign in A3.
11. Press the forward slash (/) key on your keyboard.
12. Click on cell A2. 'A2' should appear after the forward slash. Your formula should look like this: = A1/A2.
13. Press the 'Enter' key on your keyboard or click on the check mark button on the tool bar to perform the calculation. The answer 3 should appear in cell A3.
Divide Numbers Using the Quotient Function
14. Use the quotient function. You can divide numbers with the quotient function: QUOTIENT (Numerator, Denominator). The only difference between using this function and using regular division is that, if there are any remainders, the answer from the quotient function will not display it.
15. Type the number 15 into cell A1. This is your numerator.
16. Type the number 2 into cell A2. This is your denominator.
17. Click on A3, where the result will be displayed.
18. Click on the 'Paste function' button (fx) on the tool bar to open the list of functions. Select 'Quotient.' The quotient dialog box should appear.
19. Click on the 'Numerator' line. Click on cell A1.
20. Click on the 'Denominator' line in the dialog box. Click on cell A2.
21. Click on 'OK' to close the Quotient dialog box. The number 7 appears as the answer in cell A3. Notice that the answer does not include any remainders.

Read more ►

How to Calculate a Percentile Using Excel

1. Enter your dataset in a continuous column in Excel. For this example, assume that the data is entered in cells A1 to A100.
2. Determine what percentile you want to calculate, and convert it to a number between zero and one. For example, the 20th percentile is 0.2, the 55th percentile is 0.55, the 100th percentile is 1, and so on. This example will use the 40th percentile (0.4).
3. Enter the following formula in the cell where you want the percentile result to show:=PERCENTILE(A1:A100,0.4).This tells Excel to calculate the 40th percentile of the data in cells A1 to A100.

Read more ►

How to Add a Shadow to a Chart in Excel

1. Start Microsoft Excel and open an existing workbook from your files that contains a chart to which you would like to add a shadow.
2. Select the chart you would like to add a shadow to by clicking on it with your mouse. The chart will be surrounded by a light blue outline when it is selected.
3. Choose the 'Format' tab at the top of the Excel screen to show the formatting options that you can apply to your selected chart. Locate the 'Shape Styles' section of the 'Format' ribbon.
4. Click the small half box and arrow button that lies on the 'Shape Styles' title bar on the lower right corner. This will open the 'Format Chart Area' dialog box.
5. Select 'Shadow' from the left side of the 'Format Chart Area' dialog box to display the shadow settings you can add to the selected chart.
6. Use the 'Preset' drop-down menu to choose a preset shadow from Excel. You can change the color of the shadow by selecting a new color from the 'Color' drop-down menu. The settings for the shadow can be changed using the 'Transparency,' 'Size,' 'Blur,' 'Angle' and 'Distance' sliders.
7. Click the 'Close' button to close the 'Format Chart Area' dialog box and return to your chart, which is now highlighted with a shadow.

Read more ►

How to Make a Pictograph on Excel

1. Launch Excel 2010 and open a spreadsheet containing data that can be expressed in a graph. Highlight the cells that you want Excel to include in the graph.
2. Select the 'Insert' tab at the top of the window. Click 'Column' or 'Bar' in the 'Charts' section of the toolbar to generate a graph from the selected data.
3. Double-click one of the graph's bars. This opens a Format Data Point window.
4. Select the 'Fill' heading on the left side of the Format Data Point window.
5. Click to select the 'Picture or Texture Fill' radio button.
6. Click the 'File' button under 'Insert from' and double-click the image you want to use for the selected bar.
7. Click the 'Stack' radio button to display several stacked copies of the selected image in place of the bar, or click the 'Stretch' radio button to display a single image stretched to fill the bar.
8. Click 'OK' and repeat Steps 3 through 7 for the remaining bars of the graph.

Read more ►

How to Set Printing Options in Excel

1. Start Microsoft Excel and open a spreadsheet that you would like to print.
2. Choose the 'File' button and click 'Print' to bring up the 'Print' dialog box.
3. Change the printer you are using by clicking the 'Name' list under the 'Printer' section of the 'Print' dialog box. You can view the printers you have installed and click on which printer you would like to use to print your spreadsheet.
4. Check the 'Print to file' check box in the 'Printer' section of the 'Print' dialog box to print the spreadsheet to another computer file instead of from a printer.
5. Set the print range of your spreadsheet by selecting the 'All' radio button to print all of the pages or 'Page(s)' radio button to print only a certain page or multiple pages in your spreadsheet. If you choose the 'Page(s)' option you will need to use your keyboard to specify which pages you would like to print.
6. Select what you would like to print by choosing either 'Selection,' 'Active sheet(s),' 'Entire workbook' or 'List' under the 'Print what' section of the 'Print' dialog box.
7. Set the number of copies that you want to print by using your keyboard to type in the number beside 'Number of copies' under the 'Copies' section of the dialog box. You can also choose to collate the spreadsheet by putting a checkmark in the 'Collate' check box in this same section.

Read more ►

How to Use Excel 2003 Formulas Functions for Budgets

1. Decide which formula you want to use. For example, you may want to add a column of data or multiply certain budgetary numbers by 12 to convert from a monthly to yearly budget.
2. Locate the formula you need in the 'Microsoft: Excel Commonly Used Formulas' (see Resources). For example, click on 'Add Numbers' in the Math subsection. One of the functions you can use is the 'Sum' function, which adds numbers in a single cell or multiple cells.
3. Enter the formula into the cell where you would like the answer to appear. For example, you may want to add a list of budget items in cells B2 to B10 and display the result in cell B11. All formulas begin with an equals sign ('='), so type the following text into cell B11:=SUM(B2:B10)The colon means 'to' as in 'Cells B2 to B10 inclusive.'
4. Use a function instead of a formula to perform calculations. For example, you can use the autosum function in Excel instead of specifying a formula. To use the autosum function, click on the cell where you would like the total to appear (in the above example, that was cell B10). Then click the autosum symbol on the standard toolbar. The autosum symbol is an uppercase sigma. Click on the cells you would like to sum (for example, B2 through B10). The autosum function will place your result in cell B10.

Read more ►

How to Scroll With a Mouse Wheel in Excel 2007

1. Open Microsoft Excel 2007 and launch the document you need to view.
2. Click inside the document somewhere (or on the scrollbar at the side of the page). This tells the mouse you are working inside the loaded Excel document.
3. Drag your finger from top to bottom over the scroll wheel on the mouse. This moves the page down and you can see the scrollbar on the side of the screen move with your movements.
4. Drag your finger from the bottom of the scroll wheel to the top. Doing so scrolls the page back up toward the top of the document.

Read more ►