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 ►

How to Group Images in Excel

1. Start Microsoft Excel 2007 and open an existing workbook from your files that contains at least two images that you would like to group together.
2. Hold down the 'Shift' key on your keyboard and click all the images you want included in the group. You will notice that when an image is selected, there's a border around it with white sizing handles.
3. Select the 'Format' tab at the top of the Excel 2007 screen to display the Format ribbon. Locate the 'Arrange' section which is the second to last section in the Format ribbon.
4. Click the 'Group' button from the Arrange section in the Format ribbon to display a small drop-down menu. Choose 'Group' from this menu. You will notice that a large border with sizing handles now surrounds all the images you have selected to be included in this group. You can now treat these images as if they are one image.

Read more ►

How to Copy Paste Hyperlinks to Another Worksheet in Excel

1. Launch Microsoft Excel.
2. Select the worksheet tab at the bottom of the screen which contains the hyperlink you wish to copy.
3. Right-click on the cell containing your desired hyperlink and choose 'Edit Hyperlink.'
4. Select all of the data in the text field next to 'Address,' then press 'Ctrl C' to copy it.
5. Click the worksheet tab at the bottom of the screen which contains the cell to which you want to add your copied hyperlink.
6. Right-click on the cell and choose 'Hyperlink.'
7. Click inside the field next to 'Address' and press 'Ctrl V' to paste the hyperlink. Click 'OK' to close the hyperlink window.

Read more ►

How to Set Print Area in Excel 2007

1. Open the Excel 2007 worksheet in which you want to define a print area.
2. Click a cell and drag the cursor over the rest of the cells you want to print to select them.
3. Go to the Page Setup group located on the Page Layout tab, and click 'Print Area.' Click 'Set Print Area' to define the selected cells as the area of the spreadsheet you want to print.

Read more ►

How to Unlock a Password for Excel Spreadsheets

1. Copy and paste the spreadsheet into a new workbook. Some password-protected spreadsheets can be copied completely, including all formulas. If this does not work, you will have to download and use an Excel password cracking program.
2. Download an Excel password cracker program or find a macro. There are many programs and macros that you can find with a quick Google, Yahoo! or Bing search with the search phrase 'Excel password cracker.' One example is Office Password Recovery Pro, which can be used to unlock the spreadsheet password.
3. After installing your Excel password cracking program, double-click the program's icon or go to the 'Start' menu and select 'Programs.' Click the newly installed program from the list.
4. Click 'Open' in your program and select the option '100% Instant Document Decryption' or similar option. Select the document for which you need the password. This will recover passwords for spreadsheets as well as the password to open the document. An option will appear to either create a new document without passwords or to display the passwords for the given document.
5. Choose where you would like to save the unprotected document if that is the option you chose.
6. Click 'Recover the Password to Open' if you want the passwords displayed. Select the document, if not already done, and click 'Next' twice and select 'Finish.' The program will run and then notify you when the results are ready, showing both document and spreadsheet passwords.

Read more ►

How to Troubleshoot Excel's Autofill

1. Check your formulas for formatting errors. Ensure that all parentheses in your formula are part of a matching pair and enclose all nonalphabetic characters within single quotation marks. Always enter unformatted numbers in your formulas; for example, '$1,000' should be entered as '1000.' The numbers in cells can be formatted at a later time using the 'Format' menu.
2. Avoid losing data in cells when dragging the fill handle by changing your preferences. Under the 'File' tab, select 'Excel' then click 'Options.' Click 'Advanced' then click the checkbox labeled 'Alert before overwriting cells.'
3. Set calculations to 'Automatic' or formulas will not recalculate as you fill cells. To do this, click the 'File' tab, then select 'Excel' and click 'Options.' Select the 'Formulas' category, then under 'Calculation Options' choose the setting labeled 'Workbook Calculation.' Click 'Automatic' to have the formulas automatically recalculate.
4. Disable autofill by selecting 'Excel' under the 'File' tab and clicking 'Options.' Choose 'Advanced', then uncheck the box labeled 'Enable AutoComplete for cell values.'

Read more ►

How to Set a Print Area in Microsoft Excel 2003

1. Highlight the desired print area. Do this by left-clicking with the mouse and holding the button as you drag the cursor over the cells that you wish to highlight. Release the mouse button when you are finished and the area that you selected will remain highlighted.
2. Access the print properties menu. Scroll to the “File” tab on the command bar and select “Print Area.”
3. Set the print area. A submenu will open. Scroll to “Set Print Area” and left-click to set the print area. The print area will be outlined with a dashed border inside of the spreadsheet.
4. Check the print area in the preview screen. Scroll to the “File” tab on the command bar and select “Print Preview” to see how the file will look when it is printed.
5. Adjust the print area. To make any changes, just hover the mouse over a corner of the dashed border surrounding the print area. When the cursor turns to a cross-sectioned arrow, left-click and hold. Drag the print area to the desired size.

Read more ►

How to Activate a Toggle Button in VBA

1. Click the 'Start' button in Windows and select the 'Microsoft Excel' from the 'All Programs' menu to open a new workbook.
2. Click the 'Tools,' 'Macro' and 'Visual Basic Editor'.
3. Click 'Insert,' then 'UserForm' to insert a user form in your workbook.
4. Add the 'ToggleButton' and 'Label' controls on the user form.
5. Double-click the 'ToggleButton' control to open the 'Code' window for the ToggleButton control.
6. Enter the following code for the 'ToggleButton1Click event:Private Sub ToggleButton1_Click()If ToggleButton1.Value = True Then' Set UserForm background to Red.Me.BackColor = RGB(255, 0, 0)Else' Set UserForm background to Blue.Me.BackColor = RGB(0, 0, 255)End IfEnd Sub
7. Click the 'Run Sub/UserForm' on the 'Run' menu to activate the toggle button in your VBA control.

Read more ►

How to Align Column Numbers on the Decimal in Excel 2003

1. Select a column of numbers that you want to align by clicking on the letter of the column. For example, column C.
2. Click the Format menu and select Cells.
3. Select the Number tab in the window.
4. Select Number from the Category list.
5. Select the number of decimal places you want by clicking the up or down arrow next to the box. If you select four decimal places, for example, Excel will round off any number that has more. For example, 5.89237 will become 5.8924. Any number with fewer decimal places will be padded with zeroes. For example, 4.8 will become 4.8000.
6. Click 'OK.' Excel will now align all the numbers on the decimal.

Read more ►

How to Convert Lotus123

The Steps
1. Open the Media-Convert page. Media-Convert is a free-to-use online converter that can read Lotus 1-2-3 file extensions and convert those files into several other spreadsheet file types.
2. Add the Lotus 1-2-3 file to Media-Convert. To add, click on the 'Browse' button beside 'File.' In some browsers, the button may say 'Open File' instead of 'Browse.' When the 'Open' window pops up, find the Lotus 1-2-3 file on the hard drive and click the 'Open' button to upload the file.
3. Double-check the input format. 'Lotus 1-2-3' is one of the available file types in the 'Input format' list. Media-Convert should select this format automatically, but if the detection fails, you can select the file type from the 'Input format' list.
4. Choose an output format of your choice from the 'Output format' list. Available options for Lotus 1-2-3 file conversions include OpenOffice spreadsheets, PDF and Microsoft Excel workbooks. The type of file that you choose depends on the program that you need the file to open in.
5. Convert the Lotus 1-2-3 file. To begin the conversion, click 'OK.' Media-Convert will begin the process and the status of the conversion will be displayed on the screen.
6. Download the converted file. When Media-Convert is done converting the Lotus 1-2-3 file to your selected file type, you will be transferred to a screen with a download link for the converted file. To download, click on the link provided and save the new file to your computer.

Read more ►

How to Create Microsoft Excel PivotTables

1. Open the Excel 2010 document that contains the information you want to use in a PivotTable.
2. Click the Insert tab on the Excel ribbon. Click the PivotTable button at the left end of the ribbon. This opens the Create PivotTable window.
3. Look for the dotted lines on your Excel worksheet. These lines determine what data the PivotTable uses. The PivotTable defaults to include all the data on the sheet, but if you need to choose a different area, select the top-left cell of the area you want to use. Then navigate to the bottom-right cell, hold shift, and select that cell.
4. Choose between placing the PivotTable on a new worksheet or using an existing worksheet. If you choose an existing worksheet, you need to choose the worksheet from a drop-down box. Click OK to create the PivotTable.
5. Click on the fields in the field list, located on the right side of the screen, to add them to the PivotTable. Each column in your original data area will become a field listed here. As you add fields to the PivotTable, Excel automatically places them into one of the four PivotTable areas, located below the field list.
6. Click a field in one of the four PivotTable areas, and then drag it to a different area to give the PivotTable your desired look. The four PivotTable areas correspond to different aspects of the table itself. Fields in the Report Filter area sit above the PivotTable and allow you to filter the entire table based on the values in that field. Fields in the Column Labels and Row Labels areas make up the columns and rows of the PivotTable. Fields in the Values area make up the bulk of the PivotTable.

Read more ►

How to Make a Bubble Graph on Excel

1. Open a new Excel 2010 spreadsheet.
2. Click on cell 'A1' and type in the title for your first set of data. This data will be shown along the 'X' axis on your bubble graph. Once the title is in place, enter the data into the cell in column 'A.'
3. Select cell 'A2' and enter the title for the second set of data. This data will make up the 'Y' axis on your graph. Once the title is in place, enter your data into column 'B,' underneath the title.
4. Click on cell 'C1.' Enter the title for your third set of data. This set will be represented by the size of the bubbles on your graph. Once the title is in place, fill out the rest of column 'C' with your data.
5. Click on cell 'A1' and hold down the mouse button. Drag your mouse down to the last cell in column 'C' and release the button.
6. Click 'Insert' at the top of the screen. Locate the 'Charts' area of the ribbon and click the 'Other Charts' button found there. Select 'Bubble' or 'Bubble with 3D effect,' depending on how you want the chart to look. The bubble chart will appear on your spreadsheet.

Read more ►