Monday, October 15, 2012

How to Create a Pie Chart in Excel

1. Launch Excel and open the file which has the data that you want to base your pie chart on. The data can be created by simply entering the numbers, formulas, or by calling it in from other programs.2. Highlight the data that you wish to base your chart on. The last cell that you wish to include will not be highlighted but it will have a bold outline around it.3. Click 'Insert', 'Chart' and a Chart Wizard window will appear. Scroll down the right side column of Chart Type and click on 'Pie.' This will bring up several sub-types of pie charts on the left hand side of the window. Pick the...
Read more ►

How to Use the Chart Wizard in Access to Create a Chart

1. Open the Access database. Right-click the report or form to which you want to add a chart, and select 'Design View' to open it in Design View, which is a window showing the underlying design of your form or report that displays the details and properties of the boxes, buttons and other items in your object. Using Design View makes it easier for you to make changes to the way an Access object looks and acts.2. Go to the 'Insert' menu and click 'Chart' in Access 2003. Click the 'Chart' button in the 'Controls' group of the 'Design' tab in Access 2007 or 2010. Click on the form or report where...
Read more ►

How Do You Limit the Number of Rows in an Excel Spreadsheet?

1. Open Microsoft Excel from the 'Start' menu.2. Press 'Alt' and 'F11' at the same time to open the visual basic editor.3. Click 'View' on the top toolbar then select 'Project Explorer' from the drop down menu.4. Click 'View' again then select 'Properties Window' from the drop down menu.5. Select the name of the spreadsheet you are working with from the list in the explorer window on the left side of the screen.6. Change the value in the 'ScrollArea' category to limit the number of rows allowed on the spreadsheet. For example, in order to limit the spreadsheet to 365 rows, you would...
Read more ►

Sunday, October 14, 2012

How to Train in Microsoft Excel 2007

1. Talk to your employer. If you need to use Microsoft Excel 2007 for work, your employer may have a training program in place or may be willing to start one to help train employees.2. Work with your instructor. If you need to use Microsoft Excel 2007 for a class, your instructor may be able to help you understand what you need to know to complete assignments. Tutoring services might also be available through your school.3. Go through the Microsoft Excel 2007 intermediate level tutorial. This is a free service offered by Microsoft that takes you through all the basic functions of Excel and...
Read more ►

How to Use VBA to Save in Excel As a PDF

1. Double-click the Excel file name from My Documents or Windows Explorer, or launch Excel and use the 'Open' command from the start button. Browse to your file and click 'Open.'2. Press the 'Alt' and 'F11' keys simultaneously to open the Visual Basic editor. Use the Project Explorer to browse to the module where you need to automate saving the spreadsheet as a PDF file. Place your cursor in your Visual Basic code where you want the save to occur.3. Use the 'ExportAsFixedFormat' function to perform a 'Save to PDF.' This function can be invoked from any worksheet (e.g., ActiveSheet.ExportAsFixedFormat)...
Read more ►

How to Put a Check Box in Excel 2003

1. Open the specific Excel 2003 worksheet that needs to have a check box added. Locate the 'Forms' toolbar at the top of the screen, which shows a series of boxes corresponding to different forms available to be created.2. Click the 'Check Box' icon in the 'Forms' toolbar, which shows a square blue box with a black check mark. Click the starting point anywhere inside the spreadsheet where you want the check box to appear. Drag your pointer down and toward the right to set the borders of the check box. Release your mouse button to create the check box.3. Click the 'Check Box 1' text appearing...
Read more ►

A Line Won't Delete in Microsoft Excel

1. Check to see if you are highlighting the correct line to delete in your document. Point your cursor on the line number on the right side and left-click to highlight. Once highlighted, you should be able to delete the line.2. Remove any document protections. If the Excel document is protected, this may prevent editing including removal of lines. On the 'Review' tab, click to see 'Changes' group to see if there are protections on the worksheet or workbook. These may have to be removed or a password inserted to continue.3. Investigate the explanation of any error messages you receive when...
Read more ►

How to Make a Graph on Excel 2003

1. Open the spreadsheet you want to graph in Excel 2003. Select 'Insert' and 'Chart' from the toolbar. The chart wizard appears.2. Select the type of chart you want to create in the 'Standard Types' tab. To see a sample of how the chart will look, click the 'Press and Hold to View Sample' button and click 'Next.'3. Click the button on the right of the 'Data range' text box to select the area of your spreadsheet you want to graph. The 'Source Data - Data range' toolbar appears.4. Drag your mouse over the area of your spreadsheet that will be graphed.5. Click the button on the right of...
Read more ►

Saturday, October 13, 2012

How to Edit a Calculated Field PivotTable

1. Open Excel 2010 and open a workbook containing a PivotTable.2. Click the worksheet containing the PivotTable. Click the PivotTable. The PivotTable Tools Tab appears. Click the 'Options' tab and 'Fields, Items, and Sets.' Select 'Calculated Field.' Your calculated fields are displayed.3. Select the calculated field formula that you want to edit. Click the 'Formula' box and select 'Modify.' Edit the formula and click 'OK.' Your calculated field is edited in your PivotTab...
Read more ►

How to Use Excel's ZTEST Function

1. Learn the syntax for the ZTEST function. It is: ZTEST(array,u0,sigma) where array of data to test the given value against, u0, is the given value to test and sigma is the known standard deviation. ZTEST returns the #N/A error value if array is empty.2. Calculate ZEST when sigma is supplied as follows: ZTEST(array,u0) = 1 - NORMSDIST(x - u0)/(sigma/square root of n)).3. Substitute the sample standard deviation if sigma is omitted as follows:ZTEST(array,u0) = 1 - NORMSDIST((x - u0)/(s/square root of n)).4. Note that x is AVERAGE(array)), s is the known standard deviation and n is the...
Read more ►

Friday, October 12, 2012

How to Use Excel to Make a Queue

1. Open a new Excel 2010 spreadsheet. Click the 'File' tab at the top of the screen and choose 'Options' on the left side of the screen. Select 'Customize Ribbon' from the left side of the new window. Find the 'Developer' listing on the list on the far right side of the window. Click the check box next to 'Developer' to add a check and click 'OK.'2. Select cell 'A1' and type in 'Name.' Select cell 'B1' and type in 'Time.' Click the 'B' at the top of the second column. Right-click anywhere in the column and choose 'Format Cells.' Select 'Time' from the list on the left side of the window. Select...
Read more ►

Thursday, October 11, 2012

How to Password

Microsoft Excel 20101. Open Microsoft Excel 2010.2. Click 'File' on the top menu bar. Choose 'Info.'3. Select the option to 'Protect Document.' Choose 'Encrypt with Password' from the list.4. Enter a password. Click 'OK.' Retype the password. Click 'OK.'Microsoft Excel 20075. Open Microsoft Excel 2007.6. Click the 'Microsoft Office' button. Select 'Prepare' from the list. Choose 'Encrypt' from the menu.7. Enter a password. Click 'OK.' Retype the password. Click 'OK.'Microsoft Excel 20038. Open Microsoft Excel 2003.9. Click 'Tools' on the top menu bar. Choose 'Options' and then...
Read more ►

How to Create a Check Box in Excel 2007

1. Open Microsoft Excel 2007.2. Click the 'Office' button located in the left corner of the window represented by the Microsoft Office Logo.3. Click 'Excel Options' located along the bottom of the menu on the right.4. Click the tab titled 'Popular' and select the check box next to 'Show Developer tab in the Ribbon.' Click 'OK' when you have finished to exit.5. Click the 'Developer' tab along the Office menu. Click 'Insert' and select the check box from the set of options.6. Click-and-drag your mouse to draw the check box to your desired si...
Read more ►

How to Alphabetize a Listing in Excel 2007

1. Click on the Start button on the lower left-hand side of your screen. Point to All Programs at the bottom, to Microsoft Office, and then click on 'Microsoft Office Excel 2007.'2. Click on the top-left circular Microsoft button and click on the second option, Open. Search for the excel spreadsheet you want to sort alphabetically on the left hand panel and double-click the folder it is located in with the main, right-hand panel. Double-click on the file name and click on Open.3. Determine if the column of text you want to sort alphabetically corresponds to the any or all of the columns...
Read more ►

Friday, September 28, 2012

How to Create Multiple Hyperlinks in Excel

1. Open Microsoft Excel. Click the 'File' tab. Click 'Open.' Browse to the spreadsheet to add hyperlinks into and double-click its file name. The spreadsheet opens in the Excel workspace.2. Scroll to or click the cell with the first set of data to hyperlink. Right-click the cell and click 'Hyperlink' to open the 'Insert Hyperlink' window.3. Type the Web address to launch when clicking the hyperlink into the 'Address' box at the bottom of the 'Insert Hyperlink' window. Click the 'OK' button. The cell text becomes blue with an underline signifying a hyperlink.4. Scroll to or click the next...
Read more ►

Blogger news