Monday, March 28, 2011

How to Prevent Excel 2003 From Automatically Converting Dates to Julian


1. Log on to your computer and open Microsoft Excel 2003. Open a new or existing spreadsheet.
2. Click the 'Format' menu and choose 'Cells.' Highlight the 'Date' option.
3. Click the date format you want to use and click 'OK.' Enter a date in the cell to make sure it displays properly.
Read more ►

How to Convert Excel 2003 AutoFormat PivotTables to Excel 2007


1. Open Excel 2007.
2. Click 'File,' 'Open.' Double-click the Excel 2003 workbook that contains the PivotTable. The workbook opens in Compatibility Mode.
3. Click the Microsoft Office Button in the upper-left. Click 'Convert.' Click 'OK' to confirm.
4. Click 'Yes' and the newly converted workbook will open and is ready to use.
5. Click 'File,' 'Save' to confirm the new settings.
Read more ►

How to Write Sideways in Excel


1. Open Excel to a blank spreadsheet or open an existing spreadsheet.
2. Click a cell you want to add text to. Click the 'Home' tab on the ribbon if it is not already open. Click the 'Text Orientation' button in the Alignment group. The button has no name but shows the letters 'ab' with an arrow underneath pointing diagonally.
3. Select the type of rotation you want. You can select 'Vertical text' to have letters appear vertically one at a time in your cell or select 'Rotate up' or 'Rotate down' to face your text left or right.
4. Type the text as you would normally. Press 'Enter' to see your text align sideways.
Read more ►

How to Print Head Rows on Each Page in Excel


1. Click 'Insert.'
2. Select 'Header and Footer.'
3. Click on the left, center, or right header, depending on which one you want to use.
4. Type in your header.
5. Print your spreadsheet and the header will display on every page.
Read more ►

Sunday, March 27, 2011

How to Insert Time Into an Excel Spreadsheet


Static Time
1. Select the cell where you wish to enter the time.
2. Press 'Ctrl' 'Shift' ';'.
3. Click the 'Format' menu and select the 'Cells' option.
4. Click the 'Numbers' tab.
5. Select 'Time' from the drop-down list and select your preferred format in the second column. You can also create a custom display format. When you're finished, click 'OK.'
Dynamic Time
6. Select a cell in your spreadsheet and type '=NOW()' into the cell.
7. Press 'Enter.' The time and date are displayed in the default format.
8. Change the format by following steps 3 to 5 in Section 1.
Read more ►

How to Add a Column Number in Microsoft Excel 2003


1. Choose a cell on your spreadsheet to display the result of your formula.
2. Click the 'Insert Formula' button next to the formula bar.
3. Select 'Lookup and Reference' from the drop-down list of function categories.
4. Select 'COLUMN' from the list of functions and click 'OK'.
5. Provide a reference for the 'COLUMN' formula to use. If you want to use the cell you selected in Step 1, do not enter a reference; if you want to use a different cell, enter that cell's coordinates in the reference box.
6. Click the 'OK' button. Your cell will now display the numerical value of the column you selected.
Read more ►

How to Calculate Linear Regression Using Excel


1. Type these data pairs starting in cell c3. For this and the remaining steps, press the 'Tab' key where a comma is shown. These numbers are data pairs collected from a hypothetical science experiment. In this experiment, assume there's the possibility of a linear relationship between 'x,' the first column of numbers, and 'y,' the second column.X, Y1, 5.22, 7.83, 10.74, 13.95, 16.5
2. Type these additional three columns, starting with the first cell to the right of the cell containing 'y.' These columns are factors in the calculations for the slope, y-intercept and R values of linear equations of the form y = mx b. Letter 'm' is the slope, 'b' is the y-intercept and 'R' is a measure of how closely the computed line matches the actual data points. The closer 'R' is to 1.0, the closer the data points are to forming an actual line whose 'm' and 'b' values are those you're computing.xy, x^2, y^2c4*d4, c4*c4, d4*d4
3. Select the second row you just typed, then click the lower-right corner of the rightmost cell. Drag downward until the selection is five rows high. This action extends the formulas to all the x-y data pairs.
4. Type these additional six cells starting at cell b11. These cells contain summations of the columns you entered in the previous step.n, sum of x, sum of y, sum of (xy), sum of (x^2), sum of (y^2)count(c4:c9), sum(c4:c9), sum (d4:d9), sum (e4:e9), sum (f4:f9), sum(g4:g9)
5. Type these formulas starting in cell c14. These are squares of two of the summation calculations you entered in the previous step.(sum of x)^2, (sum of y)^2c12^2, d12^2
6. Type these labels and calculations starting in cell c17. These are the slope, y-intercept and 'R' values of the estimated line, as described in step 2. After entering these final calculations, look first at the 'R' value, 0.9994. This number is close to 1.0, which means the line you calculated is close to fitting the data points. Next, compare how close the slope, 2.87, is with the value 3.0, which is the slope of the actual line used to create data points for this article. Last, relate the y-intercept value, 2.21, to the value 2.0, which is the y-intercept of the linear equation used to create data points for this article.slope, (B12*E12-C12*D12)/(B12*F12-C15)y-intercept, (D12-D17*C12)/B12R, (B12*E12-C12*D12)/SQRT((B12*F12-C15)*(B12*G12-D15))
Read more ►

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 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 ►

Friday, March 25, 2011

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 ►

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 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 ►

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' 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 ►

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 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 ►

How to Use the Option Buttons in Excel


1. Open Excel. Click 'File' and 'New' in the menu bar. Select 'Blank Workbook' from the pane on the right side of the Excel window.
2. Turn on the Forms toolbar. Right-click in the gray area of any toolbar. Select 'Forms' from the displayed list.
3. Add a group box. Select 'Group Box' from the 'Forms' toolbar. Click and drag in the spreadsheet with the mouse to create a group box of the desired size.
4. Rename Group Box 1 by highlighting the text and typing an appropriate name.
5. Create the option button. Click on 'Option Button' in the 'Forms' toolbar. Click in the desired area of the group box to paste the option button.
6. Customize text for the option button. Right-click the option button. Select 'Edit Text' from the displayed menu. Type the new name.
7. Change the appearance of the option button, if desired. Right-click the option button. Select 'Format Control'. Add color and select line style and weight.
8. Create more option buttons by repeating Steps 5, 6 and 7. Use the arrow keys on the keyboard to align or reposition the option buttons.
9. Save the file. Click 'File' and 'Save' in the menu bar. Name the file. Click the 'Save' button. Click on 'File' and 'Close' in the menu bar to close the file.
Read more ►

How to Export OpenOffice Calc to XML


1. Open your Calc spreadsheet in OpenOffice.org's Calc program.
2. Click 'File' in the top menu and select 'Save As'. Alternatively, hold the 'Ctrl' and 'Shift' keys down and press 'S'.
3. Click the drop-down menu next to 'Save as type' and select 'Microsoft Excel 2003 XML (xml)'.
4. Enter a new name for your spreadsheet if one is not automatically chosen. If you previously saved this document the original file name is filled in. You can use this file name without overwriting the original file, since the extension will be different.
5. Click 'Save' to export your Calc spreadsheet in XML format.
Read more ►

Monday, March 21, 2011

How to Make a Thermometer Chart in Microsoft Excel


1. Open a blank worksheet in Excel. Enter headings for two columns of data, such as 'Month' and 'Total Clients' in cells A1 and B1. Enter the appropriate data into the column cells. The data should be building toward a goal.
2. Enter the goal number at the bottom of the column and enter the actual number reached in the cell beneath the goal amount, which will be the number in the last cell.
3. Skip a cell below the totals, and enter a formula to determine the percentage reached in the next cell. In the Formula Bar, use the formula total amount/goal amount. For example, the formula could be '=B17/B16.' Right-click the cell, select 'Format Cells,' select the 'Number' tab and choose 'Percentage.'
4. Select the cell with the percentage amount. Click the 'Chart Wizard' button in Excel 2003 or earlier and select a clustered column chart. In later versions of Excel, select the 'Insert' menu and choose a clustered column. In step 3 of the chart setup, go to the 'Axes' tab and clear 'Category (x).' On the 'Legend' tab, clear 'Show Legend,' and on the 'Data Labels' tab select 'Value.' Click 'Finish.'
5. Double-click the column of the chart. The Format Data Series dialog will open. Click the 'Options' tab and change the 'Gap Width' to '0.' Go to the 'Patterns' tab and click on 'Fill Effects.' On the 'Gradient' tab, select two colors, such as black and red, and select 'Horizontal' in the shading styles. Click 'OK' twice to apply changes and close the dialog.
6. Drag the left side of the chart toward the right, making the graph thinner. Right-click the chart and select 'Format Chart Area.' On the 'Patterns' tab, select 'None' for both Border and Area. Click 'OK' to apply the changes.
7. Add a circle auto shape at the bottom of the chart by selecting the autoshape from the drawing toolbar in Excel 2000 to 2003, or from the 'Insert' tab in later versions of Excel. Right-click the circle and select 'Format Shape.' Fill the circle with the same gradient colors used in the chart.
Read more ►

How to Break Hours Minutes Down into Increments for Excel


1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and type in the time that you want to break down. Enter the time as 'hh:mm.'
2. Click on cell 'B1' and enter the following formula into the cell:=ROUND(A1*(1440/x),0)/(1440/x)Change each 'x' to be a number equal to the number of minutes in your desired time increments. If your increments are in seconds, change both instances of '1440' to '86400' and enter the number of seconds in each increment for 'x.' Press 'Enter' to complete the formula and a small number will appear in the cell.
3. Right-click cell 'B1 and choose 'Format Cells' from the drop-down menu. Click on 'Time' on the left side of the window that appears. Then choose the '37:30:55' option on the right side of the window. This format will allow you to view amounts over 24 hours correctly. Click 'OK' and the small number in cell 'B1' will be changed into your rounded time.
4. Click on cell 'C1' and enter the following formula:=B1/(0.00069444*x)Change 'x' to be the number of minutes in your increments. If your increments are in seconds, change the formula to read:=B1/(0.000011574*x)Change 'x' to be the number of seconds in your increments. Press 'Enter' to complete the formula and cell 'C1' will break your hours and minutes in cell 'A1' down into a number of increments.
Read more ►

How to Restore One Deleted Excel Worksheet


1. Click the 'Office Button' and select 'Save As' from the drop-down menu. Select Excel Workbook from the 'Save As' menu and type a new name for your workbook in the 'File Name' field. Press 'Save.' You will now have two workbooks---your original workbook before you made any changes with the 'deleted' worksheet intact, and the newly saved workbook with all of your changes. Only your newly created workbook will remain open.
2. Open your original workbook. You should now have both workbooks open.
3. Right click on the name tab of the 'deleted' worksheet in your original workbook and click 'Move or Copy...' when the menu appears. Under the 'To book' option, select your new workbook and choose where you would like the worksheet to appear in the 'Before sheet' option. Click 'OK.' Note that Excel takes you to your new workbook and the 'deleted' worksheet is displayed.
4. Check to make sure that links between worksheets, formulas and macros are functioning as expected. The next step will eliminate your original workbook, so be absolutely certain that your new workbook is correct before moving forward. If everything is in order, go back to your original workbook and close it.
5. Save your new workbook, renaming it with the original workbook name. The workbook with the 'deleted' worksheet will be overwritten with your now correct workbook.
Read more ►

How to Learn Excel 2003


1. Learn Excel directly from the maker using the resources available at Microsoft Office Online. This website offers courses ranging from 30 to 50 minutes that walk you through the basics of how to use Excel, so you can be on your way in just a couple of hours.
2. Check the website of your local community or technical college for introductory classes on Excel. These classes may be free or discounted compared to private university tuition. If you are a senior citizen you may be eligible for a discount on tuition. Most classes will focus on newer versions of Excel, but you can ask the instructor which functions are compatible with the 2003 version, and the basic operation of the software remains the same.
3. Teach yourself using the Help files that are included with Microsoft Excel. Simply open up Excel and press 'F1' on your keyboard to launch the Help panel. Browse to 'Training' and click on 'Get to know Excel 2003.' This will walk you through the basics of Excel.
Read more ►

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 ►

Wednesday, March 16, 2011

How to Turn off Gridlines in Excel


1. Launch Excel by clicking on the 'Excel' shortcut in your Windows Start Menu.
2. Open the worksheet for which you want to disable gridlines by clicking on the 'Excel' icon and selecting the 'Open' command.
3. Click on the 'View' tab and de-select the 'Gridlines' check box under the 'Show/Hide' category.
Read more ►

Tuesday, March 15, 2011

How to Go to Precedent Worksheets in Excel


Enable the Display Options
1. Open the saved Excel worksheet.
2. Click the 'File' tab on the command ribbon. A list of commands will appear.
3. Click 'Options.' The 'Excel Options' dialog box will open.
4. Click the 'Advanced' button on the left pane. The 'Advanced' pane will appear.
5. Scroll down the right pane to the 'Display' section.
6. Select the named workbook in the 'Display Options for This Workbook' text box.
7. Select the radio button for 'All' in the 'For Objects, Show' option.
8. Open another workbook if it contains the formula's reference cells. An open workbook makes the cells accessible for the 'Trace Precedents' option.
9. Click 'OK.' The 'Excel Options' dialog box will close.
Apply the Trace Precedents Command
10. Click and drag on the cell that contains the formula. The selected cell will appear highlighted. The formula will appear in the Formula Bar.
11. Click the 'Formulas' tab.
12. Click the 'Trace Precedents' button in the 'Formula Auditing' group. Tracer arrows will appear superimposed on the cells. Blue arrows indicate no errors. Red arrows indicate cells that cause errors. A black arrow points to a worksheet icon if the selected data cell is referenced by another worksheet's cell.
Read more ►

Monday, March 14, 2011

How to Use VBA to Import Data From Excel Into Access


1. Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.
2. Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel
Object Library.'
3. Start by typing the following VBA code to create new sub procedure:Private Sub importExcelData()
4. Type the following to create variables you will use to read Excel:Dim xlApp As Excel.ApplicationDim xlBk As Excel.WorkbookDim xlSht As Excel.Worksheet
5. Type the following to create variables you will use in Access:Dim dbRst As RecordsetDim dbs As DatabaseDim SQLStr As String
6. Type the following to define database objects and also define the Excel workbook to use:Set dbs = CurrentDbSet xlApp = Excel.ApplicationSet xlBk = xlApp.Workbooks.Open('C:\Temp\dataToImport.xlsx')Set xlSht = xlBk.Sheets(1)
7. Create a new table with two columns in Access to import data from Excel. Type the following VBA code to create the table using the 'DoCmd' object:SQLStr = 'CREATE TABLE excelData(columnOne TEXT, columnTwo TEXT)'DoCmd.SetWarnings FalseDoCmd.RunSQL (SQLStr)
8. Open the table you just created by using a the Recordset object. Type the following to open the table and add a new row:Set dbRst = dbs.OpenRecordset('excelData')dbRst.AddNew
9. Type the following to get values from the Excel workbook, save them to your table and update the record:xlSht.Range('A2').SelectdbRst.Fields(0).Value = xlSht.Range('A2').ValuexlSht.Range('B2').SelectdbRst.Fields(1).Value = xlSht.Range('B2').ValuedbRst.Update
10. End your procedure by typing the following VBA code:dbRst.Closedbs.ClosexlBk.CloseEnd Sub
11. Press 'F5' to run the procedure. The data in your Excel workbook has just been imported into your Access table.
Read more ►

How to Open Excel 2007 Without a Blank Document


1. Click on the 'Microsoft Office' button.
2. Click on 'Excel Options.' The Excel Options dialog box will open.
3. Click on the 'Advance' tab, then scroll down to 'General.'
4. Type the name of your file location in the 'At startup, open all files in:' text box. For example, type 'C://MyDocuments/myfile.xls.'
5. Click on the 'OK' button. The next time you open Excel, the selected files will open automatically.
Read more ►

How to Use Calendar Control in VBA Excel


1. Start Microsoft Office Excel, select the 'Developer' tab then click 'Visual Basic.' Click the 'Insert' menu and select 'UserForm.'
2. Right-click the 'Toolbox' menu and select 'Additional Controls...'. Check the box next to 'Calendar Control 12.0' then click 'OK.'
3. Click the calendar control and add it to 'UserForm1.' Click the 'CommandButton' control and add one to your 'UserForm1.' Double-click the 'CommandButton1' to open Microsoft Visual Basic.
4. Copy and paste the code below inside the 'CommandButton1_Click()' subroutine.Dim dataString As StringdataString = Calendar1.ValueActiveCell = dataStringActiveCell.NumberFormat = 'mm/dd/yy'
5. Press 'F5' to run the program then click 'CommandButton1.' The program will get the calendar date chosen by user and will add it to the active cell in the Excel spreadsheet.
Read more ►

Sunday, March 13, 2011

How to Find Hidden Columns in Excel 2007


1. Inspect the column headers at the top of the Excel 2007 spreadsheet. The headers are gray and are labeled with letters in consecutive alphabetical order. Note which letters are missing from the headers. These missing letters indicate which columns are hidden.
2. Reveal single or consecutively hidden columns by clicking on the two columns that would be on either side of the hidden columns. For example, if column 'B' is missing (hidden), you will click on columns 'A' and 'C' to select them. To continue that example, if columns 'B' through 'F' are hidden, you will click on columns 'A' and 'G' to select them. Be sure to click on the actual gray column header to select the complete column rather than a specific cell within the column.
3. Click the 'Home' tab if you are not already on that tab. Then click the 'Cells' group to show the drop-down menu. Click the 'Format' button, which will reveal another drop-down menu. On this new menu, scroll down to the 'Hide Unhide' option (under Visibility). This will reveal one more menu that contains the options to 'Unhide Rows' and 'Unhide Columns.' Select 'Unhide Columns.' Your missing columns will be revealed.
4. Alternatively, you can follow Step 2 to select the two columns adjacent to your hidden columns and then right-click to reveal a shortcut menu. Click 'Unhide' on that menu to reveal the hidden columns.
Read more ►

How to Highlight Changes in Microsoft Excel 2003


1. Access the highlight menu. To access this menu, scroll to the “Tools” tab and select “Track Changes.”
2. Open the Highlight Changes Options menu. Under the submenu that opens scroll to “Highlight Changes” and left-click to access the 'Highlight Changes' menu. Make sure to check the box labeled “Track Changes While Editing.”
3. Set up the “When” attributes. By checking this box, you can access a dropdown menu where you can choose from the following: All (which will track changes by everybody), Since I Last Saved (which will track changes from your last save), Not Yet Reviewed (which will track all changes that have yet to be reviewed by you) and Since Date (which will track changes since a certain date you enter.)
4. Set up the “Who” attributes. Under this box you can choose to track changes by Everyone or by Everyone But Me (which will track all other user changes but yours) by selecting the desired attribute from the dropdown menu.
5. Set up the “Where” attributes. Under this selection, you can enter a span of cells, rows, columns, or all three, by entering their corresponding data into the field provide, which will track all changes made to the specified cells, rows or columns.
6. Set the screen options. If you wish to see the changes tracked on-screen and highlighted, check the box labeled “Highlight Changes on Screen.”
7. Implement the changes. To implement your changes click on the “Okay” button.
Read more ►

Saturday, March 12, 2011

How to Find the Author of an Excel Document in 2007


1. Open the Excel document in Microsoft Excel 2007.
2. Click the top left 'Office' button, select 'Prepare' and click 'Properties.'
3. Look at the top left 'Author' field of the 'Document Properties' panel that appears just above your spreadsheet. This field lists the author of the Excel document.
Read more ►

How to Insert a Cell Drop


Microsoft Excel 2003
1. Open the Microsoft Excel 2003 application on your computer. Enter the data you want for your drop-down box into a single column of your spreadsheet.
2. Click on the cell where you want the drop-down list to begin so that it’s selected. Click on the “Data” option from the top toolbar menu.
3. Click on the “Validation” option and then click on the “Settings” tab. Click on the “List” option from the “Allow” box.
4. Enter the reference for all of the cells to be used in the drop-down list into the “Source” box. Click on the box next to the “In-cell drop-down” field so that it’s selected.
5. Change any other drop-down settings to meet your preferences and then click on the “OK” button. Your drop-down cell box will then be created.
Microsoft Excel 2007
6. Open the Microsoft Excel 2007 application on your computer. Enter a list of data that you want for your drop-down list into a single column of your spreadsheet.
7. Click on the cell where you want your drop-down list to begin so that it’s selected. Click on the “Data” tab and then click on the “Data Validation” option from the “Data Tools” group.
8. Click on the “List” option from the “Allow” box. Click on the “Source” box and then select the column of cells you want for your drop-down list.
9. Click on the box next to the “In-cell dropdown” field so that it’s selected. Make any other changes to the drop-down list settings and your drop-down box will be created in your spreadsheet.
Read more ►

Friday, March 11, 2011

How to Create Dynamic Charts in Excel Using Data Filters


1. Organize the source data in your spreadsheet.
2. Create the type of chart specific to your data needs using the Chart Wizard tool.
3. Insert data filters to the source data by selecting 'Menu' then 'Data.' Next choose 'Filter' and then 'Auto Filter.' In Microsoft Excel 2007, use the home ribbon and then select 'Filter and Sort Button' followed by 'Filter.'
4. Apply the data filter to select the type of data you wish to use in the chart. The chart will automatically change depending upon how the data is filtered.
Read more ►

How to Add Add


1. Open Excel and click the Office button. You can open, save or print a document and view the default settings for Excel using this menu.
2. Click the 'Excel Options' button located at the bottom of the menu that opens.
3. Select 'Add-Ins' located in the options list. You can view and manage your add-ins here.
4. Click the arrow next to 'Manage' and select 'COM Add-Ins' from the drop-down list that opens and click 'Go.' A box will open that shows the add-ins that are available for you to add or remove from Excel.
5. Select an add-in you want to use in Excel and click 'Add.' The add-in will be added to Excel.
Read more ►

How to Do Add


1. Open Microsoft Excel, and click on the 'Office' button.
2. Click on 'Excel Options' located at the bottom right corner of the Office menu window.
3. Select 'Add-Ins' from the vertical navigation bar on the left of the 'Excel Options' window.
4. Check the boxes next to the add-in programs you would like to download, and then click 'OK.'
5. Follow the installation prompts to install the add-ins, and then click on 'Add-Ins' located in the toolbar at the top of the Office Excel page to load and use your add-in programs; you can also access them through the data, formula and add-in tabs.
Read more ►

How to Create High Resolution TIFF Files From Excel Files


1. Create your file in Microsoft Excel. This can be anything from an invoice to a chart to a simple listing of data.
2. Select the area of your Excel spreadsheet that you want to convert to a TIFF file. Go to the 'Page Layout' menu then click 'Print Area' and 'Set Print Area' (this option may appear under 'File' menu in some older versions of Excel).
3. Print the file to a standard postscript printer (download a free file at Adobe.com). Name the postscript file and type in '.ps' without the quotation marks as the file extension.
4. Open the .ps file in Adobe Photoshop. A dialog box will open, asking you to confirm information about the file size and resolution. Type in the resolution you would like---300 pixels per inch and up is considered 'high-resolution' in most design applications. Set 'Mode' to CMYK. Click 'OK' to continue.
5. Look at the file in Photoshop to ensure that the output is the same as you saw in Excel. The text inside of an Excel chart may be different after the conversion---if you don't like it you can delete and re-add the text elements in Photoshop.
6. Adjust the size of the image in Photoshop if you'd like. You can crop it down, make it larger and even add photos and additional text as you see fit.
7. Go to 'File' then 'Save As' on the Photoshop menu. Select 'TIFF' from the 'Format' drop down list. Click 'Save' to create the TIFF file.
Read more ►

How to Make an X Axis in Excel 2007


1. Open the spreadsheet with the data for which you wish to create a graph. Place all the X values in one column and the Y values in a second column. Each row should contain the matching values for both axes.
2. Click 'Insert' on the Menu bar and go to 'Chart.' Pick your desired picture and input the description of the graph in the box provided.
3. Move to Step 2 of the Chart Wizard to arrange the Chart Source Data. Highlight the columns and their respective headings and click 'Enter.' Choose the 'Series: in columns' button.
4. Go to Series tab and fill out the X and Y value fields. Check this area carefully to make sure that Excel 2007 correctly identifies the columns for the X and Y axes. Since you are creating an X axis, be sure that it contains the correct data for that column before hitting the 'Next' button.
5. Fill out all the other tabs in the next step for the titles of the axes as well as the legend and labels of the data.
6. Click on the next step of the chart wizard to select the position of the graph. You can choose to create the graph on a separate workbook sheet or on the same page.
Read more ►

How to Use a Letter to Represent a Value in Excel


1. Launch Microsoft Excel.
2. In the Excel spreadsheet, type a letter in the column 'A' (for example, in the cell 'A1'). Type the value, which should be represented by the letter, in the same row in the column 'B' namely in the cell 'B1.'
3.
Repeat Step 2 to add to the spreadsheet other letters you wish to associate with values. Make sure to add one such 'letter-value' entry per row. In the example shown in the figure, the array 'letter-value' spans six rows from the cells 'A1' and 'B1' to 'A6' and 'B6.'
4. In the Excel spreadsheet, select a cell in which you want to insert the value using a letter. Type the following function: '=LOOKUP('T',A1:B6)', then press 'Enter.' Note that 'A1' and 'B6' are the first and last cells in the array defined in Step 2. 'T' is the letter. In our example, the value '9.06' appears in the cell.
5. Use the form 'LOOKUP('letter',A1:B6)' as an argument for any function. For instance, select a cell and type '=SUM(LOOKUP('u',A1:B6),LOOKUP('A',A1:B6))'. Press 'Enter.' The sum of two numbers represented by letters 'u' and 'A' appears in the cell. In our example, it is 18.17 (12.5 5.67).
Read more ►

Blogger news