Monday, March 21, 2011

How to Use Microsoft Excel 2003 as a Normal User


1. Open Microsoft Excel 2003. A blank spreadsheet appears. At the top, the toolbar lists the functions available to you. Use the arrow keys on your keyboard to move one cell at a time throughout your spreadsheet. You can also click into any cell.
2. Enter information by typing it and pressing the 'Enter' key. For example, to keep track of grades for three students, enter the first name in cell A2. Enter the second name in cell A3. Enter the third name in cell A3. Enter 'Test 1' in cell B1. Enter 'Test 2' in cell C1. Then, enter the grades for the students.
3. Format cells to make your spreadsheet easier to read. Click your mouse in cell B1 to add some formatting. Press the 'CTRL/B' keys to add bolding to the cell. Click your mouse in cell C1 to do the same thing. Press the 'CTRL/B' keys to add bolding to the cell. Notice that the numbers automatically align to the right of the cell. Text aligns to the left.
4. Add formula to perform calculations. For example, add a formula to cell D2 that calculates the average grade for the student in that row. Enter the formula below that adds the two numbers in cells B2 and C2 (the grades for the first student) and then divides them by the number of grades (in this case, 2).=(B2 C2)/2
5. Use Microsoft Excel 2003 functions to make your work easier. For example, replicate the formula you just entered by selecting cell D2. Press the 'CTRL/C' key to copy it. Click into cell E2 and press the 'CTRL/V' keys to paste the formula into the cell. To replicate a formula across a range of cells, select the cell that contains the formula and click the bottom right corner. Drag it down several rows and the formula copies into each cell, changing to reflect the current row.
6. Insert a new row by placing your cursor directly below where you want to put the new information. From the 'Insert' menu, select the 'Rows' option. To insert another column, select the 'Columns' option from the 'Insert' menu.
7. Sort information to order and organize it. Excel retains the relationships within the information for you. For example, to arrange student grades in descending order, click the 'Sort' option from the 'Data' menu. Set the sorting to 'Descending' to organize the information in this manner.
Read more ►

How to Have Multiple Users Use One Sheet in Excel


Sharing in Excel 97/2000/XP/2003
1. Create or open the workbook you would like to share.
2. Under the Tools menu, select 'Share Workbook.'
3. The 'Share Workbook' window will appear. The 'Editing' tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
4. The 'Advanced' tab allows you to adjust the options for sharing, such as how long changes are tracked, how often they are updated and what happens when information conflicts. Select the options you wish to implement and click 'OK.'
5. A message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.
Sharing in Excel Office 2007
6. Create or open the workbook you would like to share.
7. Under the 'Review' tab at the top of the page, click on the 'Share Workbook' icon in the 'Changes' group.
8. As with previous Excel versions, the 'Share Workbook' window will appear. The Editing tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
9. Click on the 'Advanced' tab to adjust the options. Select the options you would like to implement and click 'OK.'
10. If it is a new workbook, the program will prompt you to save it. Enter the file name you wish to use and click 'Save.' If the workbook has already been saved, a message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.
Read more ►

How to Select Cells as the Print Area in Excel 2003


1. Click on the first upper-left cell you want to print.
2. Press 'Shift' and the arrow keys until you cover the entire area you want to print.
3. Click 'File' followed by 'Print,' 'Selection' and 'Print' again.
Read more ►

Sunday, March 20, 2011

How to Add Comments to a Worksheet in Excel 2003


1. Open your Excel worksheet.
2. Select the cell to which you wish to add a comment. Click on the cell with your mouse's left button.
3. Select 'Insert' from the top menu bar and in the dropdown menu choose 'Comment.'
4. A text box will appear right after you click 'Comment.'
5. Type your comment into the text box.
6. When you've finished typing, click anywhere outside of the text box. This will save your changes.
Read more ►

How to Convert Lotus to Excel 2003


1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'
2. Click 'File,' then 'Open.' Click the file type drop-down menu and select 'All Files and Folders.'
3. Locate your Lotus 1-2-3 file, then select it and click 'Open.'
4. Click 'File,' then 'Save As.'
5. Click the file type drop-down menu and select 'Microsoft Excel Workbook.' Choose a name for your converted file and click 'Save.' You have now converted Lotus to Excel 2003.
Read more ►

How to Align a Worksheet Horizontally Vertically in Excel 2003


1. Open the Excel file that contains the worksheet that you want to align horizontally and vertically. Click the appropriate worksheet.
2. Click the 'File' menu and select the 'Page Setup' option, which opens a separate window. Click the 'Margins' tab on the Page Setup window.
3. Click the 'Horizontally' and 'Vertically' check boxes under the Center on Page section.
Read more ►

Saturday, March 19, 2011

How to Create a Line Graph in MS Excel


Create Graph
1. Open Excel and enter your information onto a worksheet. For a line graph, you can arrange the data in rows or columns. For example, if you are showing the monthly average temperatures for a location, you could head each column with the month and each row could represent a different year.
2. Click on the first cell you want included in your line graph and while holding down the mouse button, drag your mouse to highlight the rest of the data you want on your graph.
3. Click on the 'Insert' tab and select 'Line' from the 'Chart' options. The picture shows a line graph. Choose and click on the chart subtype you want from the pictures. If you move your mouse over each subtype, it gives you a description of the graph.
4. Move the chart to the desired location on your worksheet by clicking on it and dragging when you see the four-way arrow.
5. Adjust the size of the chart by moving each side, and the top and bottom in or out with your mouse.
6. Click on the chart so that your chart formatting tool options, 'Design,' 'Layout' and 'Format' appear in your ribbon choices at the top.
7. Select 'Layout' from your ribbon and set your format preferences. Click on the arrow by each heading such as 'Chart Title,' 'Axis Titles,' 'Axes,' 'Plot Area' and 'Gridlines' to see preformatted choices.
8. Look at the options and click on the choices you want for your layout.
9. Choose 'Design' from your ribbon options to adjust the chart layout or style. If you choose a layout you don't like, you can click another one and it will automatically change. You can switch the row and column information if Excel is laid it out differently than you wanted.
10. Go to 'Format' to change the format of any of the elements you added. Click the arrow in the 'Chart Elements' box and choose the element you want to format. You can change the color, size or appearance of that element now.
11. Double-click on the different elements in your chart and type in the information you want for your chart. For example, click twice on 'Chart Title' and highlight the words. Type in 'Average Temperatures' or your desired title. Do the same for the axis titles and any other elements you added.
Separate Chart
12. Click on the chart if you want to move it to a separate worksheet or have it appear on a new worksheet. It automatically appears as an embedded chart on the current worksheet.
13. Select the 'Design' tab and then choose 'Move Chart.'
14. Click 'New Sheet' or 'Object in' and choose the worksheet where you want the chart to appear.
Read more ►

How to Make a Gradebook in Excel


1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and enter in 'Name,' as this is the column where the student's names will go. Click on cell 'B1' and enter 'Points,' as this is where the student's points will be totaled. Click on cell 'C1' and enter 'Percentage,' as this is where the student's grade percentage will go.
2. Select cell 'D1,' and then progressing down the rest of the spreadsheet's top row, enter the names of the quizzes, homework assignments, tests, projects and anything else the students will be graded on. If you aren't sure how many of these you will have, just type in 'Assignment' as a placeholder, so that you have created enough assignment spaces to fill the entire quarter, semester or year.
3. Click on cell 'A2' and type in 'Points.' This row will be where you enter in the number of points each assignment will be worth. The number that you enter into this row will be for the assignment listed in that same column. Click on cell 'B2' and enter in '=sum(D2:Z2)' where 'Z' is the last column you have used for your assignments. This will give you a total number of points so the spreadsheet can make its calculations.
4. Click on cell 'A3' and type in the name of your first student. Continue to add names down the first column until you have added the entire class.
5. Click on cell 'B3' and enter the following formula: '=sum(D3:Z3)'. Then click on cell C3 and enter the following formula: '=sum(D3:Z3)/$B$2'.
6. Click and hold the mouse button on cell 'B3,' then drag the mouse over to cell 'C3' and release the button. Move your mouse over the fill handle in the lower right corner of 'C3,' then click and hold the mouse button. Drag the mouse down your spreadsheet to copy these formulas down the columns. When you reach the row where your last student is located, release the mouse button.
7. Click on the 'C' above the third column. Click the 'Home' tab at the top of the window. Then click the drop-down box in the Number area of the ribbon. Choose 'Percentage' from the list of choices and your grades will now display as percentages.
Read more ►

How to Create a List Box in Microsoft Excel


1. Double-click the Excel spreadsheet you want to alter. This loads the spreadsheet and the Excel software at the same time.
2. Click a cell in which you want the list box to display. Click the 'Data' menu item in the main toolbar. In Excel 2007, click the 'Data' ribbon tab.
3. Click the 'Validation' menu option. In Excel 2007, click the 'Validation' button and select 'Data Validation' again. This opens a new window where you set the list box settings.
4. Click 'List' in the first window. This sets the type of drop down box for the cell. When the drop down type is selected, a text box is enabled. Click the arrow next to the text box. This opens a new window where you select the cells that hold the values for the list box.
5. Highlight each Excel cell with the values for the list box. When you are finished, press the 'Enter' key. The cell selection window will close. Click the 'OK' button. This closes the configuration window and the list box is created in the spreadsheet.
6. Click the list box arrow to view the information. This shows you all the values and tests the list box functionality.
Read more ►

Friday, March 18, 2011

How to Perform Factor Analysis


Performing a Factor Analysis
1.
Generate a correlation matrix on the data set. A correlation matrix is a table of correlation coefficients. A correlation coefficient is the quantifying unit of correlation. This number expresses the direction and strength of a linear relationship measured between two random variables.
2. Establish baselines for desired factors (compiled variables). For example, if the data collection instrument is a survey and responses are measured from 1 -- Least Desirable Outcome to 10 -- Most Desirable Outcome, values of 8, 9 and 10 may be examined and the corresponding variables grouped according to similarities to create factors.
3.
Rotate factors to maximize the linear relationships between factors and variables. For this function, the statistical application demonstrates its value. The number of manual calculations required would be massive on a large data set.
4.
Generate and print the Output report. The Output report will include the following sections: Descriptive Statistics, the Correlation Matrix, Kaiser-Meyer-Olkin and Bartlett's Test, Communalities, a Scree Plot, a Factor Matrix and a Rotated Factor Matrix.
5.
Interpret the output from the statistical application based on intuitive knowledge of the data and empirical questions to be answered.
Read more ►

How to Change an Excel Spreadsheet Into an Interactive PDF


1. Open Adobe Acrobat on your computer. In the 'Getting Started' window, click 'Convert an Existing Document' to launch the 'Create New Forms' wizard. Alternately, you can select 'Create New Form' from the 'File' menu or the 'Forms' menu. In Acrobat 9, click 'Forms' and select 'Start Form Wizard.'
2. Select 'An Existing Electronic Document.'
3. Follow the on-screen instruction to upload the data from your spreadsheet file. The wizard will be slightly different depending on the version of Acrobat you are using. Make sure your spreadsheet is saved in a place where you can access it.
4. Proceed through the instructions to create Acrobat form fields. If the wizard doesn't prompt you, click the 'Forms' menu and select 'Edit Form in Acrobat.'
5. Select a forms tool such as the 'Select' tool in the Forms toolbar. Drag the cursor to create rectangular form field. A 'Properties' dialog box will open for the form field, in which you can set up the form field behavior. Repeat this for each form field you need to create.
6. Save the interactive form under the 'File' menu.
Read more ►

Thursday, March 17, 2011

How to Create an Organization Chart From Excel


1. Open a new document in Microsoft Excel 2007 and click on the 'Insert' tab.
2. Click on 'SmartArt'. In the 'Choose a SmartArt Graphic' window, click on 'Hierarchy'.
3. Select the first chart, which is the Organization Chart. Click OK.
4. Begin typing the name of the first person at the highest level in the organization such as the CEO in the 'Type your text here' window. Click on the indented text areas to add names for the rest of the employees. You can add additional boxes by pressing Enter in the 'Type your text here' window at the desired position.
Read more ►

How to Include Indian Currency as Part of the Currency Symbols in Excel


1. Open a Web browser, and navigate to the download page for the Windows Rupee symbol update (support.microsoft.com). Click the download link next to the version of Windows that you have installed.
2. Click the 'Continue' button on the next page. Click 'Continue' again, and save the file 'GenuineCheck.exe' to the desktop. Run the tool, and copy the code displayed into the field under 'Enter your validation code' on the Microsoft Genuine Windows Validation page. Click 'Validate.'
3. Click the 'Download' button, and save the Rupee symbol update to the desktop. Double-click the update file -- depending on the version you downloaded, one possible file name is 'Windows6.0-KB2496898-.msu' -- and wait for the update to complete. Click the 'Restart Now' button to restart your computer.
4. Launch Excel 2010, and click the 'Home' tab in the upper-left corner of the main window.
5. Click the drop-down menu next to the Dollar sign in the 'Number' section of the top toolbar, and then click 'More Accounting Formats.' A new window titled 'Format Cells' appears. Alternatively, select the row or column containing Rupee values, right-click the highlighted cells and select 'Format Cells' to reach this window.
6. Click the drop-down menu next to 'Symbol' and select the Rupee symbol, which should now appear near the top of the list.
7. Click 'OK.' Excel now displays the Rupee symbol next to currency values.
Read more ►

How to Make Everything Uppercase in Excel


1. Open the Excel worksheet.
2. Press Alt and F11 to bring up the Excel 2010 VBA console. Once the console opens, find the name of your workbook on the list on the left side of the screen. Right-click the workbook name, move your mouse over 'Insert' and select 'Module.' Double-click the module that appears.
3. Click anywhere in the blank white space on the right side of the VBA console. Type in the following: 'Sub UpperCaseConvert()' and press Enter. VBA will automatically insert the 'End sub' command at the bottom of the code.
4. Type 'Dim x As Range' into the line directly beneath the 'Sub' line. This will create a variable, 'x,' that you will need later in the VBA code. Press Enter to access the next line.
5. Enter the following code into the VBA console:For Each x In Cells.SpecialCells(xlConstants, xlTextValues)x.Formula = UCase(x.Formula)NextThis will go one-by-one through every cell that contains text on your worksheet and convert it to uppercase. Click the 'X' in the top-right corner of the VBA console to close it.
6. Click the 'Developer' tab at the top of the Excel screen. Click the 'Macro' button, which is located in the 'Code' area of the ribbon. Select 'UpperCaseConvert' from the list of macros and click 'Run.'
Read more ►

How to Make a Checklist in Microsoft Word 2003


1. Create your list entries. Create the desired entries of the list and click the “Return” key after making each individual entry.
2. Highlight the entries. Left-click and hold the mouse button in as you drag the cursor over all of the entries that you just created. Then release the mouse button and the entries will remain highlighted.
3. Create the checklist. On the font formatting toolbar, found on the command bar, you will see several icons that allow for font formatting, billet points and list creation. The list creation icon appears as the numbers 1 through 3 and each number has a line next to it, sequentially from top to bottom of the icon. Click on this icon to create the checklist.
4. Remove the checklist number formatting. To remove the checklist that you just created, follow Step 2 to highlight the list and then simply click on the list icon, as demonstrated in Step 3, and the list will be removed.
Read more ►

Blogger news