How to Import Excel Into MS Word

1. Select the data in Excel you want to import into Word. Press 'Ctrl-C' to copy the data. You can also right-click on the selected data and click 'Copy' from the context menu.
2. Select the location in your Word document to enter the copied data. Click the 'Paste' drop-down menu and select 'Paste Special.'
3. Select the 'Paste link' radio dial, choose 'Microsoft Excel Worksheet Object' from the list and click 'OK.'
4. Adjust the formatting of the new table to meet your needs.

Read more ►

How to Link Bloomberg to Excel

1. Close Excel. Download the Bloomberg Excel add-in (www.bloomberg.com). Click the 'Download' link, which will open a separate window. Click the 'Run' button.
2. Install the Bloomberg Excel add-in. Click the 'Start' button and select the 'All Programs' option. Click 'Bloomberg' and select 'Install Excel Add-In,' which will open a separate window.
3. Click the 'Install' button and then close the window when the installation process has completed. Open Excel to view the 'Bloomberg' tab on the menu bar.

Read more ►

How to Use Data Analysis in MS Excel

Excel 2007
1. Open Excel and navigate to a blank or existing spreadsheet file. Locate the Data Analysis tool by clicking the 'Microsoft Office' button, located in the top left-hand corner of your open spreadsheet. This opens a menu with a series of commands. Click the “Excel Options” button at the bottom of this menu.
2. Choose the “Add-ins” option, located in the column on the left side of the Excel Options menu. This will display a set of available add-ins that can be installed in your Excel program. Click the “Analysis ToolPak” add in, which often appears first on the list of add-ins. After selecting this add-in, click “OK.” The Data Analysis tool should appear in your Excel 2007 tool bar, located at the top of an Excel workbook file.
3. Select the Data Analysis tool to analyze a set of data in Excel by clicking the tool in your toolbar. This will open a smaller window that displays a set of statistical procedures and analysis tools.
4. Select the analytical procedure you want by clicking on it, then choosing “OK.” This will take you to the window for that procedure. Here you must specify the range of data you want analyzed by clicking and dragging across the cells, rows or columns that contain the data.
5. Indicate whether you want your results displayed on the same worksheet, in a new worksheet or in a new workbook by choosing the appropriate option. Click “OK.” Excel will then run the analysis and display the results in the manner you selected.
Earlier Versions of Excel
6. Unlock and install the data analysis tool by clicking the “Tools” menu, found in the toolbar at the top of an open Excel workbook file. This will display a drop-down menu of available options.
7. Select “Add-ins” from the Tools menu. This opens a small menu that displays the add-ins that can be installed for use. Choose 'Analysis ToolPak' by clicking the check box next to it, then click “OK.” The tool “Data Analysis” should then appear in the Tools drop-down menu, ready for use.
8. Select the Data Analysis tool to analyze a set of data in Excel by clicking the tool in your toolbar. This will open a smaller window that displays a set of statistical procedures and analysis tools.
9. Select the analytical procedure you want by clicking on it, then choosing “OK.” This will take you to the window for that procedure. Here you must specify the range of data you want analyzed by clicking and dragging across the cells, rows or columns that contain the data.
10. Indicate whether you want your results displayed on the same worksheet, in a new worksheet or in a new workbook by choosing the appropriate option. Click “OK.” Excel will then run the analysis and display the results in the manner you selected.

Read more ►

How to Set Workbook Share Options in Microsoft Excel 2003

1. Open the workbook share menu. Scroll to “Tools” and then click on “Share Workbook.”
2. Set up the workbook to be shared. In the workbook share properties box that opens, check the box labeled as “Allow Changes to More Than One User at a Time.”
3. Set the advanced options. Click on the “Advanced” tab to access these options.
4. Set track changes options. Under the “Track Changes” field, you can set the number of days it tracks changes in the history by clicking on that radial button and using the up and down arrows to set the day limit. Or, you can set it to not track the history by clicking on the “Don’t Keep History Change” radial button.
5. Set update changes options. Under the “Update Changes” field you can have the workbook update changes every time the file is saved by another user. Utilize this feature by clicking on the “When File is Saved” radial button. You can set the workbook to automatically save at various time intervals by clicking on the “Automatically Every” radial button and using the up and down arrows to set the time preferences. This feature also allows users to save changes and see others’ changes.
6. Set conflicting changes between users’ options. Under the “Conflicting Changes Between Users” field you can set Excel to ask you which changes win, or set the options to changes being saved win by selecting the corresponding radial buttons.
7. Set include in personal view options. You can set the workbook to include print settings and filter settings by checking the corresponding boxes.
8. Save the changes. Click on the “OK” button to implement the workbook share options.

Read more ►

How to Use AutoFit Tool in Excel

Select the Data to AutoFit
1. Open the Excel workbook.
2. Select an entire worksheet by clicking the square in the top left corner.
3. Select a column by clicking the letter at the top of the column.
4. Select a row by clicking the number of the row on the left side of the spreadsheet.
5. Select an individual cell by clicking the cell.
6. Select multiple sequential columns, rows or cells by left-clicking on the first item, holding down the mouse button and dragging the mouse to include the items you want. Then release the mouse button.
7. Select multiple non-sequential columns, rows or cells by holding down the 'Ctrl' key while you make your selections using the instructions above.
Use AutoFit
8. Navigate to the Home tab on the top menu and look for the 'Cells' section.
9. Find the 'Format' button in the 'Cells' section and click it to reveal the drop-down menu.
10. Select 'AutoFit Column Width' to adjust the column width automatically. If you selected a worksheet, each column's width will adjust to fit the widest item in it. If you selected a column, the column width will adjust to fit the widest item in it. If you selected a row, each column's width will adjust to fit the widest selected cell in each column. If you selected one cell, the column width will adjust to fit the one cell.
11. Select 'AutoFit Row Height' to adjust the row height automatically. If you selected a worksheet, each row's height will adjust to fit the tallest item in it. If you selected a row, the row height will adjust to fit the tallest item in it. If you selected a column, each row's height will adjust to fit the tallest item in the selected cell in each row. If you selected one cell, the row height will adjust to fit the one cell.
12. Adjust the width of a column by selecting the column using the address at the top of it, and double-click on the line on the right side of the first column address selected.
13. Adjust the height of a rows by selecting the row using the address to the left of it, and double-click on the bottom line of the first row address selected.

Read more ►

How to Convert Dates Times Into Decimals in Excel 2003

1. Click the Windows 'Start' button and type 'excel' in the search text box. Press 'Enter' to open the Excel 2003 software on your desktop.
2. Click the cell you want to format. Click the 'Format' menu item at the top of the window. Click 'Cells' from the list of options. This menu option opens a format window where you set up your cells' display options.
3. Click the 'Number' tab. Click the 'Number' option in the list. In the right panel with the list of number format options, click the decimal format you want to use.
4. Click 'OK' to save your settings. Type a date in the cell and watch the value change to a decimal number. Press 'Ctrl S' to save your changes.

Read more ►

How to Delete Blank Lines in Excel 2007 Lists

1. Open the Microsoft Excel 2007 application on your computer. Click the 'Office' button.
2. Click the 'Open' option and select the file that contains the information you want to edit. Click the 'Open' button.
3. Highlight all of the cells within the column that contains the blank rows that you want to delete. If you have multiple columns that need to remain in a specific order then select all of the cells in the columns.
4. Click the 'Data' tab. Click the 'Sort' button. Select the column heading, e.g., 'Column A,' that contains the blank rows in the 'Sort by' drop-down list. All of the blank rows will move to the bottom of the column.
5. Highlight all of the rows you want to delete. Click the 'Home' tab. Click the arrow under the 'Delete' option. Click the 'Delete Sheet Rows' option.

Read more ►

How to Protect a Workbook in Microsoft Excel 2003

1. Open the workbook that you wish to protect. You will need to first open a workbook before you can protect it. You can do this by scrolling to the “File” tab on the command bar and left-clicking on “Open.”
2. Open the workbook protect menu. To open the workbook protect menu, scroll to the “Tools” tab on the command bar and select “Protection.” Then scroll to “Protect Workbook” and left-click.
3. Set the workbook protect options. You can set two options by checking their boxes: structure (which will not allow the structure to be changed) and windows (which will not allow any modification windows to be opened). Check the boxes as desired.
4. Set the workbook protect password. Under the “Password” field you can enter the desired password, if you wish the workbook to be password protected.
5. Implement the changes. To implement the changes and protect your workbook, click on the “Okay” button.

Read more ►

How to Copy Excel Macros From One PC to Another

1. Open the Visual Basic Editor (VBE) on the computer you want to transfer the file from by clicking on 'Alt' and 'F11' on your keyboard.
2. Right click on the module you want to export. The module list is on the left hand side of the VBE window.
3. Click on 'Export File.'
4. Select a save location on a thumb drive.
5. Move the thumb drive to the other PC.
6. Open the VBE on the PC you want to copy the file to.
7. Click on 'File' and then click on 'Import File.'
8. Click on the file location in the thumb drive, then click on 'Open.'

Read more ►

How to Round Up to the Nearest 10 in Excel

1. Open your spreadsheet and click on a cell next to the cell(s) you would like to round up to the nearest 10.
2. Input the formula '=MROUND(Cell Reference Number,10)'. The Cell Reference Number is the number to round to and 10 is the multiple it will round to.
3. Familiarize yourself with the concept of different formulas using MROUND to make your task easier. The following provide examples of the output for putting the following formulas in a cell.=MROUND(7, 10) Rounds 7 to a nearest multiple of 10 (10)
=MROUND(-9, -10) Rounds -9 to a nearest multiple of -10 (-10)
=MROUND(18.5, 10) Rounds 18.5 to a nearest multiple of 10 (20)
4. Download this function if it is not available on your toolbar. On the Tools menu, click 'Add-ins.' Select the 'Analysis TookPak' box and click 'OK.'

Read more ►

How to Add or Subtract Percentages

1. Convert the percentage you want to add or subtract to a decimal. For example, 60 percent in decimal form is equal to .60.
2. Multiply the amount to add or subtract to by the decimal percentage.
3. Add or subtract the result from the previous step from the original amount. If you want to find 60 percent off an item that is normally $10, multiply $10 by .60. The result is $6; subtract that from the original amount and you know the sale price is $4. Alternatively, if you wanted to add 60 percent, the new price would be $16.

Read more ►

How to Create a Bar Graph in Microsoft Works

1. Open Microsoft Works Spreadsheet by clicking 'Start,' 'All Programs,' 'Microsoft Works' and then 'Microsoft Works Spreadsheet.' If you wish to create a bar graph for previously entered data, click 'File' then 'Open.' Locate the file and click 'Open.'
2. Enter the data you wish displayed on the bar graph including row and column headers. When entering numerals in a spreadsheet, commas are generally not used. For example,A1 (blank)A2 JimA3 SueA4 Region TotalB1 Region 1B2 2589B3 4778B4 7367C1 Region 2C2 5456C3 5584C4 11040D1 Total SalesD2 8045D3 10362D4 18407Save your spreadsheet by clicking 'File' then 'Save.'
3. Select the data you want in the bar graph by clicking in the top-left cell (A1) and then dragging to the bottom right (D4) and releasing the mouse. The cells included in the bar graph will be those displayed in white text with a black background.
4. Click 'Create New Chart' under the 'Tools' menu. Select the first chart in the top row. Enter a name for your chart in 'Chart title.' You may optionally click 'Show border' or Show gridlines.' Click 'OK' to display your bar graph.

Read more ►

How to Track Changes to a Workbook by Others in Excel 2007

1. Open Microsoft Excel 2007. Click on the “Office” button.
2. Select 'Open' from the menu. Find and highlight the file where you want to track the changes. Click the 'Open' button.
3. Select “Share Workbook” from the “Changes” group of the “Review” menu. Check the box beside “Allow changes by more than one user at the same time” in the “Editing” menu.
4. Select the “Advanced” menu. Press “Keep change history for” under the “Track changes” group. Type the number of days to maintain a history of tracked changes in the “days” box.
5. Click “OK” to apply the changes. Click “OK” to save the workbook.
6. Select “Track Changes” from the “Changes” group on the “Review” menu. Click “Highlight Changes.”
7. Check the box beside “Track changes while editing. This also shares your workbook.”
8. Click in the check box next to “When” to select it. Select “All” from the “When” drop-down box.
9. Click in the check box beside “Who.” Select “Everyone” from the “Who” drop-down box.
10. Check the box next to “Highlight changes on the screen.” Click the “OK” button.
11. Click the “Save” button to save the file.

Read more ►

How to Draw a Box Plot in Excel

1. Launch Excel. It should open up to a blank worksheet. Put your mouse in box A1 and type in the word 'Statistic.' Type 'Median' in cell A2, 'Q1' in cell A3, 'Min' in cell A4, 'Max in cell A5 and 'Q3' in cell A6. Next click on box B1. Type in 'a.' Continue entering data moving down the columns for cells B2 through B6, C1 through C6 and D1 through D6. Type the following numbers and letters, one in each cell, in this order: 40, 20, 10, 100, 70, b, 45, 22, 15, 110, 75, c, 50, 30, 18, 90 and 57.
2. Click on cell A1 and then drag your mouse to cell D6 with your finger still on the button. This will highlight all of the cells you just typed into. Click on the insert tab at the top left of your Excel window. Click on 'Other Charts' and then on 'Stock.' You will see icons for four types of stock charts. Roll over them with your mouse. Click on the icon for the one that says 'Volume-Open-High-Low-Close.' Then click 'Next.'
3. Click on the tab that says 'Data Range.' Look for a header that says 'Series In.' In the list below, select 'Rows.' Click 'Next.'
4. Click on the tab that says 'Axes.' Look for the words 'Secondary Axis.' Click on the box next to 'Value (Y) Axis.' Click 'Finish' at the bottom right.
5. Go to your chart, which should have popped up on the screen. You will see both white box columns and colored box columns. Click on a colored column to select it. Go back to the 'Chart' tab and select 'Line' under chart type to change how the graph is displayed. Click 'OK.' You now have your box plot.

Read more ►

How to Create a Grade Book Using Microsoft Excel

1. Open a new spreadsheet in Excel. Save it using a name such as 'Gradebook template.xls.'
2. Type in a column name in the top left cell of your spreadsheet. This column will serve as the identification column for your students. For instance, the column name could be 'Student Name' or 'Student ID.'
3. Type in brief descriptions of all the assignments for the semester in the cells of the top row, starting with the second column. For example, the column headers could have titles like 'Exam 1,' 'Term Paper 1,' 'Group Project,' 'Exam 2' and so on.
4. Type 'Sum' into the top row of the column immediately following the assignment columns.
5. In the cell immediately below where you typed 'Sum,' type the formula '=sum('. In the second row of your spreadsheet, click the second cell and then drag the cursor all the way to the last assignment cell in the second row. This will select all of the class assignment cells on this row, and you will see the range of selected cells in your formula cell as well. For instance, if you selected cells B2 through G2 in the second row, the formula cell will now read '=sum(B2:G2'. Now type ')' in that cell to complete the formula, so that the formula cell reads '=sum(B2:G2)'. This cell will now contain the sum of all the grades for that row.
6. Save the grade book template spreadsheet, and create a copy for the current semester by clicking on 'File' on the upper left of your spreadsheet, then choosing 'Save As' and then giving it a new name such as 'History Grade Book Fall 2010.' Save the original template for future use.
7. Enter the names or other identification information of your students in the first column.
8. Click on the cell below 'Sum' in the last column, right-click on it, and choose 'Copy' from the next menu.
9. Highlight all the cells in the last column, starting with the third row and going all the way down to the last student row, by clicking and dragging your cursor over the relevant cells.
10. Place your mouse anywhere over the highlighted cells and right-click. Choose 'Paste' from this menu. Now all the cells in the last column will contain the total grade of all the assignments of each student. Every time you enter a new grade for a student, the total will be updated accordingly.
11. Manually assign letter grades for students at the end of the semester based on their total points, or use other formulas in Excel to do this task for you.

Read more ►