How to Create a List Box to Select Multiple Entries in Excel 2003

1. Enter the data you wish to format as a drop-down list within a single row or column. Make sure it is a single block of cells such as A2:A6.
2. Highlight the cells in your list. Click the 'Name' box next to the 'Formula' bar and enter a name for your list. Click 'Enter.'
3. Click 'Validation' from the 'Data' tab. Highlight the cells for which you created the list. Choose 'List' from the 'Validation' box. Type a '=' sign before the name of your list within the 'Source' box and click 'OK.'

Read more ►

How to Create a Multiple Baseline Graph in Excel 2010

1. Type the label for your first baseline into cell A1. Type the label for your first intervention into cell B1, the next baseline in C1 and the next intervention in D1. Continue for as many baselines and interventions as you want to show in your graph.
2. Enter the data for the first baseline in column A. Enter the data for the first intervention in column B starting on the first row after the last entry in column A. Accordingly, you will have blank cells in column B where there is data in column A and blank cells in column A where there is data in column B. Continue for all of the columns so that each new set of data starts in the row below the last entry in the previous column.
3. Click and drag from cell A1 to the lower-right corner of your data. Click on the 'Insert' tab and choose 'Line' from the 'Charts' section. The multiple-baseline chart will be created with the baselines and interventions showing as separate lines on the chart.

Read more ►

How to Name a Field in Excel 2003

1. Open the Excel Workbook that contains the field you want to name.
2. Select the cell, column or row you want to name. Select a cell by clicking it. Select a column by clicking the column letter at the top of the spreadsheet. Select a row by clicking the row number on the left side of the spreadsheet. Select disconnected cells, columns or rows by holding down the 'CTRL' key while you make your selections.
3. Select a range by clicking and dragging to include cells. Select disconnected ranges by holding down the 'CTRL' key while you make your selections.
4. Find the name box in the spreadsheet. It is to the left of the formula bar directly above the column letters. The address of the first cell you selected is visible in the name box--unless you selected multiple ranges, then the first cell in the last range of cells selected is visible in the name box.
5. Click in the name box and type in the name you are giving the cell or range. Press the 'Enter' key.
6. Click the drop-down arrow in the name box to see the names of all the cells and ranges you have named.
7. Open the 'Define Name' dialog box by pressing 'CTRL F3' to review the names you have created and the cells to which they refer. Click the 'Close' button when done.
8. Use a named cell or range in a formula by replacing the cell or range address with the name you defined. For example,give the range of cells from A1 to A5 (A1:A5) the name 'blue.' Assuming those cells contain numbers, you can use the formula '=sum(blue)' instead of '=sum(A1:A5).'
9. Highlight a named range when creating a formula to insert the range name automatically. For example, using the named range 'blue' in the sum function will insert blue ('=sum(blue)') in place of the range from A1 to A5 ('=sum(A1:A5)').

Read more ►

How to Add Multiple Cells in Microsoft Excel 2003

1. Before you can add multiple cells, you need to define the area. You can easily do this by left-clicking on the desired cell and dragging the mouse cursor over the area where you wish to add cells and then releasing it. The selected area will stay highlighted.
2. Right-click on the highlighted area to access the Cell Properties submenu.
3. Add desired multiple cells. Scroll to “Insert” on the Cell Properties submenu and left-click to insert or add multiple cells.
4. Set cell rotation for the addition of cells. A cell insert properties box will open, in which you can select the rotation and placement of the cells to be added. You can shift the existing cells either to the left or down to make room, all by selecting the corresponding radial button.
5. Implement your changes. To add the multiple cells, click on the 'OK' button.

Read more ►

How do I Use VLookup in MS Excel?

1. Type '=VLOOKUP(' into the cell in that you want the result of this function to be displayed. Don't include the quotation marks.
2. Type in the value that you want the function to look for, followed by a comma. You can either type it in as a literal value. If it is text, make sure to enclose it in quotation marks. You can enter a cell reference.The function will search for whatever value is contained in the cell you refer to.
3. Enter the cell reference for the range of cells comprising the table, followed by another comma. For example, if your table consists of cells A1 through E10, enter in A1:E10. Alternatively, you can just click and drag a box around the table, and Excel will automatically put the cell reference into the formula. The function will search for the value you entered in step two in the first column of this range, so make sure the range you enter begins with the correct column.
4. Type in a number representing the column you want to get your result from, followed by another comma. For example, if you want the telephone number from the third column of the range you entered in Step three, type in 3. The number refers to columns in the range, not the column numbers in the spreadsheet. The first column, the column used to find the key value, is column 1.
5. Type TRUE or FALSE, followed by a closing parenthesis ')', then push Enter. You should use FALSE if you want the function to only find an exact match to your key value, or TRUE if want to let it find the nearest approximation.

Read more ►

How to Use Less Than or Equal to Function in Excel

1. Select the cell to display the calculated result and insert the function for the comparative formula (by selecting 'Function' under 'Insert' in the top menu bar). Make sure to review the format of the formula in the dialog box to identify the information to be entered. For example, the formula format for IF is '=if(logical_test, value_if_TRUE, value_if_FALSE)' where the logical test is the comparative rule or conditional criterion, value-if-TRUE generates a response when both conditions match and value-if-FALSE generates a different response if both conditions do not match.
2. Type '(' and then select the cell containing the value for the criterion or type the desired value. For example, after the function '=if' is generated, type '(' and then select the A3 cell to display '=if(A3' in the formula bar.
3. Type '
4. Type ')', other information as specified by the formula format (in Step 1) and then press the 'Enter' key to complete the function. For example, the desired calculation will generate a display of 4 if the value in A3 is less than or equal to 100 or 500 if the value in A3 is greater than 100. The complete formula would read '=if(A3
5. Explore other functions to create comparative formulas such as COUNTIF and SUMIF where '

Read more ►

How to Insert a Microsoft Graph Chart in a Publisher Document

How to Insert a Microsoft Graph Chart in a Publisher Document
1. Open Publisher by double clicking on the Publisher Icon.
2. Go to the File pull-down menu and click once on new.
3. Go to the Insert pull-down menu. Click on it.
4. Click once on Object. An Insert object menu will pop up.
5. Choose on the Create from file option. You will see two options: Create new or Create from file. You would have chosen Create new if you wanted to create a new Microsoft graph chart. Since we are working on the assumption that you have a graph chart that you have already created and want to import it from somewhere else on your computer, you will need to choose the Create from file option. This is the option we will be looking at since we are focusing on inserting rather than creating a Microsoft graph chart in a Publisher document.
6. Click inside the small circle in front of Create from file.
7. Click on Browse to retrieve the file you want to get the Microsoft graph chart from.
8. Click once on the File you want to open.
9. Click on open. The Microsoft graph chart will automatically appear in you document.
10. Click on the chart and hold down the cursor to move the chart to the position you want it to be in your document.

Read more ►

How to Insert Excel Data Into a Word 2007 Table

1. Open the Microsoft Word and Excel 2007 files. Locate the files from both software programs on the computer hard drive and double click on the file icon to open each.
2. Create the table in the Word document. Choose the 'Insert' tab and from that menu ribbon select 'Table' option. Next, choose the appropriate size of the table to insert in the Word document.
3. Highlight the data in Microsoft Excel to insert in the Word 2007 table. Left click the mouse and while holding the mouse button down, highlight the data in Microsoft Excel.
4. Copy the data from the Excel document. With the data highlighted, right click and choose 'Copy' from the right click menu.
5. Paste the data from the Excel document into the Word table. Select the word document and position the cursor inside the Microsoft Word 2007 table. Then, choose 'Paste Special' from the main menu in the paste dropdown box. From the paste special dialogue box choose the 'Microsoft Excel Worksheet Option' and insert the data into the table.
6. Save and close both documents when done. From the main file menu, choose 'Save' in both Microsoft Excel and Word to make certain the work is not lost.

Read more ►

How to Make a Bar Graph in Excel 2007

1. Start a new document and add data or open the document containing the data you wish to convert into a graph. Arrange the data with the item headers at the top of the column and data in the same column or the headers at the beginning of the row and the data to the right.
2. Select the data you want to include in the graph.
3. Click on the 'Insert' tab in the ribbon.
4. Click on the down arrow under the 'Bar' graph icon.
5. Choose the graph design you like the best. Your data will convert into a bar graph on the spreadsheet.
6. Click on the 'Design' tab to change colors, layout, add a title, switch the rows and columns, move the chart, change the chart type or save as a template.

Read more ►

How to Lock Charts in Excel

1. Open the worksheet with the graph in Excel.
2. Click the 'Review' tab and then click 'Protect Sheet.'
3. Click 'Allow All Users of This Worksheet To' and then select the elements you want people to be able to change. For example, even though the chart is protected, you may want users to be able to format cells, insert rows or perform sort functions on the worksheet.
4. Type a password into the 'Password to Unprotect Sheet' box and then click 'OK.' You need to type the password again to confirm it.

Read more ►

How to Calculate Age in Excel Using a Date of Birth

1. Open a new Microsoft Excel 2010 worksheet.
2. Click on cell A1. Enter the birth date of the person whose age you want to know. You can enter a date with dashes between the numbers, such as '3-30-1983.'
3. Click on cell B1 and enter this formula:=datedif(A1,today(),'y')In this example, 'A1' refers to the cell where you typed in the person's birth date. 'Today()' calls the current date on the machine. 'Y' indicates that Excel should give the result in years. Press 'Enter' on your keyboard to complete the formula entry, and the person's age will appear in cell B1.

Read more ►

How to Delete an Embedded Chart in Excel

Delete an Excel Chart Object
1. Launch Microsoft Excel. Click the “File” tab followed by “Open” and open the workbook document that contains the embedded chart.
2. Click the chart object to select and highlight the item. After it is highlighted, Excel displays a box around the chart with “handle” dots around the edge of the box.
3. Press the “Delete” or “Del” key on your computer keyboard to delete the embedded chart.
Delete an Excel Chart Sheet
4. Highlight the chart sheet in the Excel workbook document.
5. Click the “Home” tab on the main menu ribbon across the top of the document.
6. Click the down-arrow icon in the “Delete” section of the “Cells” group. Select “Delete Sheet” from the pull-down options list.
7. Click “OK” in the confirmation dialog box. Excel deletes the chart sheet and the chart object.

Read more ►

How to Import Excel 97 Macros to Excel 2003

1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Excel' to open Excel 2003.
2. Click 'File' > 'Open,' browse through your computer files to find the Excel 97 worksheet you want to import, select the file and then click 'Open' to open the Excel 97 worksheet in Excel 2003.
3. Click 'Tools' > 'Macro' > 'Security' to access the macro security options in Excel 2003.
4. Select the 'Medium' security setting to ensure that you are able to access most of the safe macros on any file but avoid accessing potentially harmful macros.
5. Click 'OK' to save the new security settings and then you'll be able to do whatever you need to do on the Excel 97 worksheet you just imported to Excel 2003.
6. Click 'File' > 'Save As,' select 'Excel 97-2002' from the 'File Type' menu and then click 'Save' to save the worksheet. Saving the worksheet in this manner will keep the worksheet accessible to any Excel version starting with Excel 97 and ending with Excel 2003.

Read more ►

A Tutorial to Sort in Microsoft Excel

Excel 2003
1. Open the file in Excel 2003 with data that you would like to sort.
2. Highlight the data that you would like to sort. If you want to sort the entire worksheet, click the small rectangle located in the top-left corner between the 'A' column and the '1' row.
3. Click 'Data' from the drop-down menu located above the toolbar.
4. Click 'Sort.'
5. The 'Sort' dialog box is displayed. Specify which column you would like the data sorted by first, second and third.
6. Specify if you want the data sort in ascending (alphabetical or number sequence low to high) or descending (reverse alphabetical and number sequence high to low).
7. Under the 'My list has' section, choose whether your data has a 'Header Row' or 'No Header Row.' This refers to whether you input a title for the columns that you want to sort. For example, is one of the columns titled 'date' or 'name?' If you do have header titles for your columns, you can click the 'Header Row' radio button and Excel will sort the data starting below your header rows. If you do not have header rows, click the 'No Header Rows' radio button and Excel will sort all the data.
8. Click 'OK' to sort your data.
9. If you only want to sort a single column of data, highlight just the column of data you would like to sort and then follow steps 3 through 8.
Excel 2007 and 2010
10. Open the file in Excel 2007 or 2010 with data that you would like to sort.
11. Highlight the data that you would like to sort. If you want to sort the entire worksheet, click the small rectangle designated with a small triangle located in the top-left corner between the 'A' column and the '1' row.
12. Click on the 'Data' tab located across the top of the screen.
13. Locate the 'Sort Filter' box.
14. This box displays the options of 'Sort A to Z' (ascending order) or 'Sort Z to A' (descending order) or to choose custom sort under 'Sort.'
15. Clicking 'A to Z' or 'Z to A' will quickly sort the data you have highlighted.
16. Click 'Sort' to apply additional parameters for the sort.
17. A 'Sort' dialog box is opened displaying the parameter choices of 'Column,' 'Sort On' and 'Order.'
18. Click the 'Column' drop-down menu.
19. A listing of the highlighted columns is displayed. Choose which column you would like to first sort the data by (i.e., date, name, title).
20. Next click the 'Sort On' drop-down menu.
21. Excel allows you to choose which feature you would like to sort the data on. For example, you can choose to sort the data by the values in the cells, the color of the cell (if you have colored coded your data), the cell font color (if you have colored the text within the cell, such as negative numbers being colored red) or cell icon.
22. Next click the 'Order' drop-down menu.
23. Choose whether to sort the data in ascending (A to Z alphabetical or number sequence low to high) or descending (Z to A reverse alphabetical and number sequence high to low) order.
24. At this point, if you would like to sort the data by data in multiple columns, click the 'Add Level' button located at the top-left of the 'Sort' dialog box. This feature allows you to sort first by the data in one column and then by the data in a second column, third column and so on. For example, if you have an address book in Excel, you could choose to sort the address book first by last name, then by first name. At that point, you could even choose to sort it by a third criterion of city. Your data would then be displayed in alphabetical order by last name and then first name, and then categorized by city.
25. Click 'OK' when you are finished setting the parameters.
26. If you only want to sort a single column of data, click in the column header cell of the column of data you would like to sort and then click either the 'A to Z' or 'Z to A' button.

Read more ►

How to Move a Picture, Text Box or Other Object in PowerPoint, Excel or Word Exactly Where You Want it

Removing Word Restrictions
1. Launch the Word 2010 document that contains the object that you want to move.
2. Click the object, and then click the 'Format' tab on the far-right end of the Word ribbon.
3. Click the 'Arrange' button in the ribbon. Select 'Wrap Text' from the menu that appears. Then choose 'Through,'Behind Text' or 'In Front of Text.' Any of these three options release the object so that you can click on the object's border and move it where you want.
Removing PowerPoint Restrictions
4. Open the PowerPoint 2010 presentation that contains the object you want to move.
5. Click the object, and then click the 'Format' tab at the top of the screen.
6. Click the 'Arrange' button in the PowerPoint ribbon, and then click the 'Align' button on the menu that appears. Finally, click 'Grid Settings' to open up a small window.
7. Remove the check mark from the 'Snap objects to grid' option by clicking on the check box. Click the 'OK' button to close the window. Your PowerPoint objects can now be positioned anywhere on the presentation.
Precisely Moving Objects
8. Open the Excel, Word or PowerPoint file that holds the object you want to move.
9. Select the object that you want to move.
10. Press and hold the 'Ctrl' key on your keyboard. If you are moving a text box, click any of the four corners to select the box without placing the cursor inside the box. Tap the arrow keys to move the object one pixel in the direction of the arrow that you press.

Read more ►