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 nee...
Browse » Home » All posts
Monday, November 18, 2013
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 b...
How to Use Data Analysis in MS Excel
Excel 20071. 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...
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...
How to Use AutoFit Tool in Excel
Select the Data to AutoFit1. 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...
Sunday, November 17, 2013
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...
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...
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...
Saturday, November 16, 2013
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 'Ope...
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...
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 $...
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...
Friday, November 15, 2013
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...
Thursday, November 14, 2013
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...
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...
Subscribe to:
Posts (Atom)