How to Use Excel to Calculate a Confidence Interval

1. Enter the alpha value in cell A1. The alpha value equals 1 minus the confidence level. For example, if your confidence level equals 96 percent, you would enter 0.04 in cell A1.
2. Enter the standard deviation in cell A2. For example, if your standard deviation equals 1.1, enter '1.1' in cell A2.
3. Enter the sample size in cell A3. For example, if your sample size equals 3,000, enter '3,000' in cell A3.
4. Enter 'CONFIDENCE(A1,A2,A3)' in cell A4 and Excel will display the confidence interval. In this example, Excel will display '0.041245769' meaning your confidence interval equals plus or minus 4.12 percent.

Read more ►

How to Get Rid of Gridlines in Microsoft Excel 2007

Remove Gridlines from Excel
1. Open an existing or new Microsoft Excel 2007 spreadsheet.
2. Right-click with your mouse on the 'Tools' menu, located on the top toolbar.
3. Locate and right-click on 'Options.'
4. Select the 'View' tab.
5. In the 'Windows Options' section, located in at the bottom of the pop-up window, right click in the check box next to: 'Gridlines.' Click 'OK' to save your changes.
Remove Gridlines from Excel Print Job
6. Open an existing or new Microsoft Excel 2007 spreadsheet.
7. Right-click on the 'File' menu, located on the top toolbar.
8. Locate and right-click on 'Page Setup.'
9. Select the 'Sheet' tab.
10. In the 'Print' section, located in the middle of the pop-up window, right-click in the check box next to: 'Gridlines.' Click 'OK' to save your changes.

Read more ►

How to Insert a Grid in Microsoft Excel 2003

1. Click 'Insert' in the top toolbar of Microsoft Excel 2003. It's the third option after 'File.'
2. Select 'Picture' and then 'Clip Art' from the drop-down menu.
3. Type 'Grid' in the box labeled 'Search.' This box is located on top of the 'Clip Art' box that opened on the left-hand side of the screen.
4. Press the 'Go' box to begin searching for the different types of grids available to insert into your Microsoft Excel 2003 document.
5. Double-click the box of the grid you want to insert into the document. This will place the grid into Excel automatically.
6. Hold down the 'Ctrl' and 'S' buttons on the keyboard at the same time to save the changes in your Microsoft Excel 2003 document.

Read more ►

How to Make Posters in Excel

1. Open Excel. Click on the 'File' menu at the top of the screen once it opens. Select the 'Page Setup' command.' Choose the 'Page' tab.
2. Adjust the page scaling to '200%' and click on the radio button next to 'Landscape' for the page orientation. Click on the 'Margins' tab.
3. Click into the text boxes for the top, bottom, left, and right and type '0.5'. Click into the text boxes under 'Header' and 'Footer' and type '0.' This will adjust the margins of each sheet of paper.
4. Click the 'Zoom' tab and set the zoom rate to '40 percent.' Click on the 'OK' button.
5. Click on cell 'A1' and highlight the range 'A1:M42.' This should encompass four full sheets of paper (you can see where the sheets begin and end by the dotted lines on the screen). Click the 'File' menu at the top of the screen, click the 'Print Area' command, and select 'Set Print Area.' Excel will now only print those four pages
6. Click on the 'View' menu and select 'Toolbars'. Click on the 'Drawing' option if it doesn't have a check mark by it to display the 'Drawing' toolbar.
7. Click the Rectangle tool on the 'Drawing' toolbar (it will look like a rectangle). Click on the top left corner of cell 'A1' and drag your mouse to the bottom right corner of cell 'M42.' This will create a blank rectangle across the four pages that will be your poster.
8. Click on the paint can icon on the 'Drawing' toolbar to open the effects menu. This menu will provide you with a list of color options to fill the rectangle with. Click on the 'Fill effects' button to add a picture to your poster.
9. Click on the word art icon on the 'Drawing' toolbar to add text to your poster. Click anywhere on the poster to add a text box. Type what you like in the poster.
10. Click the 'File' menu and select 'Print' when you are ready to print the poster. Click 'OK' to begin printing.
11. Tape the separate sheets of paper which print out together to form the poster. Hang the poster in your office or classroom.

Read more ►

How Do I Change Margins on an Excel Spreadsheet?

Change Margins by Dimension
1. Open Microsoft Excel.
2. Click the 'File' button on the menu and then click the 'Page Setup' button.
3. Click the 'Margins' tab and then enter the size you want the margins to have.
Change Margins Graphically
4. Open Microsoft Excel.
5. Click the 'File' button on the menu and select the 'Print Preview' option.
6. Select the 'Margins' button and then drag the margin handles to change their size.

Read more ►

How to Delete an Excel 2007 Button Face ID

1. Open the Microsoft Excel 2007 application on your computer and then click the 'Microsoft Office' button. Click the 'Open' option.
2. Select the Excel 2007 spreadsheet file that contains the button face ID you want to remove. Click the 'Open' button again.
3. Click the 'Developer' tab and then click the 'Macros' option from the 'Code' group. The 'Macros in' list will then appear,
4. Click the workbook containing the macro for the button face ID. Select the name of the macro for the button face ID in the 'Macro name' box.
5. Click the 'Delete' button and then the macro and button face ID will be completely removed. Click the 'Microsoft Office' button and then click the 'Save' option to save all of your changes.

Read more ►

How to Insert Check Boxes

Inserting a Check Box in Word (2010)
1. Display word's developer tab. Click on the 'Office' button, then 'Word Options,' followed by 'Customize Ribbon.' Check the 'Developer' box if it is not already selected. Click 'OK.' The developer tab should appear.
2. Click on the developer tab. Find the controls group. Click on 'Legacy Tools.' Click on 'Check Box Form Field.' The box appears on your document.
3. Move or resize the check box as needed, using the cursor.
4. Click 'Restrict Editing' in the 'Protect' group on the developer tab. a 'Restrict Formatting and Editing' box should appear. Check the box that says, 'Limit formatting to a selection of styles' and 'filling in forms' (under 'Editing Restrictions'). The tab asks you if you're ready to start enforcing the restrictions. Mark 'Yes, Start Enforcing Protection.'
5. Type a password in the box that pops up, or leave it blank for no password protection to later edit the check boxes.
Inserting a Check Box in MS Infopath
6. Click 'Insert,' then 'More Controls' or press 'Alt,' 'L' and 'C' buttons simultaneously. A tab called 'Insert Controls' shows up. Click the box next to it.
7. Change the text label for your check box by clicking on the default text and typing yours. Change the size and locations of check boxes by selecting them and typing the 'Alt' and 'Enter' keys simultaneously. Choose your desired size on the 'Size' tab.
8. Change the border style or color of your check box by selecting the appropriate check box, then clicking 'Format,' followed by 'Borders and Shading.' Choose the style and color you want for your border and check box.
Inserting a Check Box in MS Excel (2010)
9. Follow Step 1 in Inserting a check box in Word.
10. Drag your mouse over the 'Insert' group on the developer tab. Click on the check box image under the 'Form Controls' group.
11. Change the default text on the check box label by clicking on it and typing your own label. Resize text or the check box by selecting them and browsing 'Font' or 'Formatting' options under the 'Format' menu.

Read more ►

How to Make a Form in Excel

1. Turn on your computer and open the Excel program. A blank workbook will automatically open at start-up.
2. Create your form the way you'd like it to appear, including entering formulas.
3. Format the form using borders, shading, color and text formatting until you are satisfied with the appearance.
4. Unlock the cells where you'd like users to be able to enter data. To do so, select these cells, then click 'Format/Cells/Protection' and make sure the 'Locked' feature is not checked.
5. Select your print area. To make the process even simpler for users, select the area of the spreadsheet that should be included when printing, then click 'File/Select print area'.
6. Protect your form from changes. The final step to creating a form in Excel is to protect the form by clicking 'Tools/Protect/Protect Sheet'. After you do this, users will only be able to change the cells you selected, making all of your labels, formulas and other fields safe from changes.

Read more ►

How to Make Gridlines Print in Microsoft Excel 2007 Spreadsheets

1.
Select the 'Page Layout' tab. It is located on the 'Ribbon,' the group of icons above the work area in Excel.
2.
Put a check in the 'Print' box. Once on the Page Layout Tab, look toward the right side and you will see a group called 'Gridlines.' This will cause the gridlines to show when you print your spreadsheet.
3. If you change your mind and would like to have the gridlines hidden on print jobs again, simply remove the check from the 'Print' box.

Read more ►

How to Create a MS Excel Skin

1. In MS Excel, select 'Format' from the Menu Bar.
2. Select 'Sheet.'
3.
Select 'Background.'
4.
Click on the picture you would like to use as a skin.
5.
Click on the 'Insert' button.

Read more ►

How to Put a Decimal Place in Excel 2003

1. Open Excel 2003 and select the 'File' drop down menu. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Review the spreadsheets in the workbook and locate a workbook that needs decimal places in the data. Highlight the range the contains data that needs a decimal place.
3. Select the 'Format' drop down menu and select 'Cells.' Click the 'Number' tab. Select the 'Number' option in the left 'Category' section. Change the decimal places to '1.' Click 'Ok.' The decimal places are added to the Excel 2003 spreadsheet.

Read more ►

How to Use Excel's FREQUENCY Function

1. Remember the formula breaks down to the following: FREQUENCY(data_array,bins_array). Data is the set of values for which you will compute the frequencies. If you don't enter any data in the cell, you'll receive zeros in return. Bin is how you want the data broken down, or the ranges into which you want the data to fall.
2. Note that the FREQUENCY function will always give you one more frequency than data entered. For example, if you're a teacher and you enter in the test scores of 20 students, then you'll receive 21 frequency values.
3. Set up your worksheet to contain the data and the ranges you desire. Using the test score example, column A should contain individual test scores (data) and column B should contain the ranges corresponding to specific letter grades (bin).
4. Select vertical cells in column C plus one cell more than the number of cells used in column B. Enter '=FREQUENCY(A1:A#,B1:B#)' in the formula bar, replacing '#' with the last row number for your column A and B cells.
5. Press the following after you enter the function in the formula bar: 'Control' 'Shift' 'Enter' if you're working in a Windows-based program or 'Command' 'Enter' if you're working on a Macintosh/Apple computer.
6. View your results and notice the one additional number at the end of column C.

Read more ►

How to Use Excel to Generate Random Samples

1. Determine a range of numerical data in an Excel worksheet from which you want to generate a random sample. For example, generate a random sample from the numbers 1 through 10 listed in the first column in cells A1 through A10.
2. Click the 'Data' tab at the top of Excel and click 'Data Analysis' in the 'Analysis' group.
3. Click 'Sampling' in the 'Analysis Tools' list, then click 'OK.' This brings up a small window called 'Sampling.'
4. Click the button with the red arrow next to box called 'Input Range' in the 'Input' section. This shrinks the sampling window to a single row in which you can enter an input range.
5. Click and hold the left mouse button in the top left cell of the range of data from which you want to generate a random sample. For example, click and hold the left mouse button in cell A1.
6. Drag the mouse to the bottom right cell in the range of data, then release the mouse button. This shows the range of cells that contain the population data in the sampling window. For example, drag the mouse to cell A10 and release. Excel shows '$A$1:$A$10' in the sampling window.
7. Click the button with the red arrow in the sampling window to expand the window to its original size and show the other options.
8. Click the 'Random' button in the 'Sampling Method' section of the sampling window and type the number of samples you want Excel to generate in the box titled 'Number of Samples.' For example, click the 'Random' button and type '10' in the box.
9. Click the 'New Worksheet Ply' button in the 'Output options' section to tell Excel to place your sample in a new worksheet.
10. Click 'OK.' Excel generates a list of random samples and lists them in a column in a new worksheet with the first sample in cell A1. In the example, Excel lists random numbers between 1 and 10 in cells A1 through A10 in a new worksheet.

Read more ►

How to Add a Drop Down Calendar in Excel 2007

1. Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the 'Office' button at the top left, then choose 'Excel Options'. This will bring up a pop up window. Put a check mark in the 'Show Developer Tab in the Ribbon' option, then click 'OK'.
2. Click on the 'Developer' tab. Click on the small arrow below the 'Insert' tab and choose 'ActiveX Controls'. Click the last icon in the list ('More controls').
3. Choose 'Calendar Control' and press 'OK'.
4. Click on a cell in your worksheet where you would like to place the calendar. Click the 'Design Mode' button to turn off design mode and return to normal operation.

Read more ►

How to Create a Template for Excel 2003

1. Open Excel 2003 and locate a workbook that you want to base you template on. Click 'File' and 'Open' on the menu bar. Search your computer for the workbook. Click the workbook and select the 'Open' button. The workbook opens.
2. Review the workbook and decide what information will remain in the workbook after it becomes a template. Information that would remain would be date formulas, contact information, company logo and other information relevant to your project. Remove any information that refers to a specific customer or vendor if this workbook will be used for all of customers and vendors.
3. Save the workbook by clicking 'File' on the menu bar. Click 'Save As.' Change your save as type to 'Template.' Type a template name in the 'File Name' field. Click 'Save.' Your template is now saved and is available for use in your future projects.

Read more ►