How to Disconnect a User From a Shared Workbook

1. Click on the 'Review' tab in Microsoft Excel. Select 'Share Workbook' in the 'Changes' section.
2. Click the 'Editing' tab. Review the listing of user names under 'Who Has This Workbook Open Now.'
3. Click to highlight a user's name. Click on the 'Remove User' button.
4. Click the 'View' tab. Select 'Custom Views' in the 'Workbook Views' group.
5. Click to highlight a user's name in the 'View' list. Click the 'Delete' button.

Read more ►

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 one you think will best describe your data. Click 'Next.'
4. Review the data that you are seeing on this new window. If you do not see a pie chart with your data or the numbers look incorrect, click 'Cancel' and highlight your data and try the process again. If all is correct, select 'Next.'
5. Enter labels and a title for your pie chart on the next window. The next tab, Legend, allows the placement of the titles. The Data Labels tab allows manipulation and changes of the labeling of the pie chart. Click 'Finish' when the pie chart appears the way you want it to.
6. Manipulate the size of the chart on the spreadsheet by clicking the box it is in and dragging the mouse. Right clicking the chart and box that the chart is in brings up many options to edit the chart also.

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 you want to place the chart. The Chart Wizard will open. The Chart Wizard is a small window that walks you through the steps to create precisely the chart that you require.
3. Select the table or query from which you want to obtain data to create a chart. To choose a table, click the 'Tables' button and click on the table you want to use from the list presented. To choose a query, click the 'Query' button and click on the name of the query you want to use from the list presented. Click the 'Next' button at the bottom of the window.
4. Choose the fields containing data that you want included in the chart. To select a field, click on the field name in the 'Available Fields' list. Click the single right-arrow button in the middle of the window to move that field to the 'Fields for Chart' list. Repeat, adding up to six fields to the 'Fields for Chart' list. Click the 'Next' button at the bottom of the window.
5. Select the type of chart you want to create by clicking on the chart type under 'What Type of Chart Would You Like.' To find out more about a specific chart type, click on the type to view a description in the right side of the Chart Wizard window. Click the 'Next' button at the bottom of the window after selecting a chart. Select layout options. Drag and drop field buttons from the right side of the Chart Wizard onto the sample chart in the main Chart Wizard window. Click the 'Next' button at the bottom of the window.
6. Type in a title for the chart in the 'What Title Would You Like for Your Chart' Box. Select 'Yes' or 'No' under 'Do You Want the Chart to Display a Legend?' A legend is a box next to or beneath the chart that provides further detail by identifying the colors or patterns used in the chart. Click the 'Finish' button at the bottom of the Chart Wizard window.
7. Click the 'Save' button on the 'Standard Toolbar' in Access 2003 or the 'Quick Access Toolbar' in Access 2007 or 2010 to save the chart added to your Access report or form.

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 enter the text '$1:$365' (without the quotation marks) into the ScrollArea box. To limit the spreadsheet to another number of rows just put that number in the place of 365 when entering '$1:$365' in the ScrollArea box.
7. Close the visual basic editor when you are done and the number of rows in the spreadsheet will be limited based on your specifications.

Read more ►

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 using a hands-on approach to help you retain what you learn. The tutorial takes 30 to 40 minutes.
4. Use the Excel 2007 'Support/Training' page when you have general questions about Excel or want to find out how to access or accomplish a specific task. From this page, you can access multiple informative articles.
5. Utilize other Microsoft Excel training courses. Microsoft offers separate programs for different uses of Excel, such as creating workbooks, entering formulas and adding charts. These courses give you more in-depth information about each major use.
6. Practice what you learn. Each time you learn something new in your Excel training, practice it. For example, if you learn how to use a formula, create a practice spreadsheet with data to test your knowledge. This helps you retain what you learn.

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) or for the workbook as a whole (e.g., ActiveWorkbook.ExportAsFixedFormat).You can set a number of options with this command; the option values shown below are Excel's default values.[Mandatory] Type:= xlTypePDF[Mandatory] Filename:=
[Optional] Quality:= xlQualityStandard (xlQualityStandard or xlQualityMinimum)[Optional] IncludeDocProperties:= True ('True' means that the document properties, such as author name and document title, will be included in the PDF file; 'False' means that these properties will not be set in the PDF file.)[Optional] IgnorePrintAreas:= False ('True' means that all content in the spreadsheet should be included; 'False' indicates that only the information within your set printing areas will be included.)[Optional] From:= 1 (This is the page number where Excel should start the save. If this is omitted, then Excel begins at the first page.)[Optional] To:= 5 (This is the page number where Excel should finish the save. If this is omitted, then Excel ends on the last page.)[Optional] OpenAfterPublish:= False ('True' indicates that Excel should launch your default reader for PDF files with the PDF file open; 'False' indicates that the new PDF file should not be automatically opened.)
4. Execute the code function to ensure that the 'Save to PDF' works properly. Save the spreadsheet file.

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 next to the box and type whatever label you'd like to use for the box. Click the 'Control Properties' icon located in the 'Forms' toolbar to open a new window containing the check box's properties.
4. Navigate to the 'Control' tab. Type the name of the cell that should correspond to the check box in the 'Cell Link' box. For instance, if you want the box to be checked in correlation to data stored in cell 'A4,' type 'A4' in the box. Click the 'Checked' or 'Unchecked' radio button to change whether the box should check or uncheck when data is entered into the corresponding cell.
5. Click 'OK' to save your changes. If you need to make changes to the check box in the future, click the box and then click the 'Control Properties' button.

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 attempting to delete a line in Excel. The error message may provide insight into why the command cannot be executed. If you do not understand the message, visit Microsoft Online to search for Excel help.
4. Highlight all rows and press F5 and 'Go To' and click 'Special.' Select 'Visible Cells' and click 'OK.' This may now allow you to delete lines as necessary, especially if there are multiple or hidden lines.
5. Close the Excel document and exit the application. Delete any temporary or extra files off your computer as you may have a memory or resource issue. Shut down your machine and reboot. Open your Excel document and retry to delete your line.

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 the 'Source Data - Data range' toolbar to return to the chart wizard. A sample of your chart appears in the dialog box.
6. Select 'Rows' or 'Columns' under 'Series in' and click 'Next.'
7. Select the tab containing the options you want to customize: 'Titles,' 'Axes,' 'Gridlines,' 'Legend,' 'Data Labels' or 'Data Table.' Click 'Next.'
8. Select 'As new sheet' to place the graph in a separate worksheet or 'As object in' to place it into the current worksheet. Click 'Finish.'
9. Select the graph on your worksheet if you chose 'As object' in the previous step and drag it where you want it to appear.

Read more ►

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 PivotTable.

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 number of observation in COUNT(array). Furthermore, if AVERAGE(array)
5. Determine the two-tailed probability. This is the probability that the sample mean is further from the given population mean than AVERAGE(array) and is expressed as follows:2 * MIN(ZTEST(array,u0,sigma),1 - ZTEST(array,uo,sigma)) where u0 is the given population mean.
6. Use Excel 2003 and later for improved accuracy of NORMDIST. Previous versions of Excel used a single computation for all values of z, providing accuracy to about seven decimal places.

Read more ►

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 the option that says '*1:30:55 PM' and click 'OK.'
3. Click the 'Developer' tab at the top of the screen. Click the 'Insert' button in the 'Controls' area of the ribbon. Click the 'Button' icon in the top-left corner of the small field of icons that opens up. Move your mouse over the spreadsheet. Click and hold the mouse button and drag it down and to the right. Release the mouse button to create a button on your spreadsheet. Type 'Add' into the 'Macro Name' field and click the 'New' button. The VBA console will open up automatically. Click the 'Minimize' button to get this window out of the way for now.
4. Click the 'Insert' button again and repeat the process. This time, name the macro 'Remove.' The VBA console will come up automatically again.
5. Click on the line between 'Sub Add()' and 'End Sub' in the VBA console. Enter the following text into the console:Rows('2:2').Insert shift:=xlDownRange('C1').CopyRange('A2').PasteSpecialActiveCell.Offset(0, 1) = NowRange('A:B').Sort Key1:=Range('B1'), order1:=xlAscending, Header:=xlYesThis code will take a name from cell 'C1' and add it to the queue.
6. Click on the line between 'Sub Remove()' and 'End Sub.' Enter the following text into the console:ActiveCell.EntireRow.DeleteThis code will delete the selected row from the queue. Click the 'X' in the top-right corner of the console to close it and go back to your Excel spreadsheet.
7. Click the 'Design Mode' button on the toolbar. Right-click the first button you created and click 'Edit Text.' Delete the text in the box and type in 'Add.' Do the same thing for the second box and type in 'Remove.'
8. Type in the name of the first person or thing you want to enter into the queue into cell 'C1.' Click the 'Add' button. The name will appear in column 'A' and the current time will appear in column 'B.' When you want to add another person to the queue, change the name in cell 'C1' and click 'Add.' When you want to remove an entry from the queue, just click on the name in column 'A' and click the 'Remove' button.

Read more ►

How to Password

Microsoft Excel 2010
1. 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 2007
5. 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 2003
8. Open Microsoft Excel 2003.
9. Click 'Tools' on the top menu bar. Choose 'Options' and then 'Security.'
10. Enter a password in the box labeled 'Password to Open.' Click 'OK.' Retype the password. Click 'OK.'

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 size.

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 of text within that one spreadsheet. For example, a column of student names would correspond to student exam grades, essay grades, and overall grade point average (GPA).
4. Highlight all of the columns that correspond to each other. Do not highlight the column titles, such as 'Name' or 'Averages.'
5. Click on the Data button, the fifth option on the ribbon.
6. Click on the Sort option near the middle of the ribbon.
7. Click on the first arrow on the left-hand side next to 'Sort by' and choose the column you want to be sorted alphabetically. Click on the last arrow on the right-hand side and choose A-Z sorting or Z-A sorting.
8. Click on 'Add level' if you want to sort by other data after that one alphabetical column from the last step. You will want to include all of the columns associated to the first column you sorted by. For example, if you sort student names alphabetically you will want to sort all of the grades with the names. Click on the drop-down arrow right next to 'Then By' and choose the next column. Click on the last arrow on the right-most side and choose how you want the data sorted; if it's numeric data, it will say 'Smallest to Largest' or 'Largest to Smallest.'
9. Repeat step 8 to sort however many cells you wish.

Read more ►