Saturday, March 26, 2011

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...
Read more ►

How to Get Rid of Gridlines in Microsoft Excel 2007

Remove Gridlines from Excel1. 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 Job6. 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...
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...
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...
Read more ►

Friday, March 25, 2011

How Do I Change Margins on an Excel Spreadsheet?

Change Margins by Dimension1. 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 Graphically4. 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 si...
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...
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...
Read more ►

Thursday, March 24, 2011

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...
Read more ►

Wednesday, March 23, 2011

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' b...
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' butt...
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 spreadshe...
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...
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...
Read more ►

Tuesday, March 22, 2011

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...
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...
Read more ►

Blogger news