How to Convert Microsoft Excel 2003 to 2007

Using Microsoft Excel XP or Excel 2003
1. Open a Web browser window and navigate to the Microsoft Windows Update website. Follow the on-screen instructions to download and install all high-priority updates for your operating system version.
2. Navigate to the Microsoft Download Center page for the Microsoft Office Compatibility Pack. Click the 'Download' button and save the installer file to your computer.
3. Close all open Microsoft Office programs.
4. Double-click the icon of the installer file you downloaded previously. Follow the on-screen instructions to install the Office Compatibility Pack on your computer. The software allows you to save files to XLSX format using Excel XP or Excel 2003.
5. Open Microsoft Excel XP or Excel 2003.
6. Click the 'File' drop-down menu and select 'Open.'
7. Locate the XLS file you want to convert and double-click its icon.
8. Click the 'File' drop-down menu again and select 'Save As.'
9. Give the file a name and select a save location. Choose the 'Excel 2007' option from the 'Save as type' drop-down menu. Click 'Save' to convert the XLS file to XLSX format.
Using Microsoft Excel 2007
10. Open Microsoft Excel 2007.
11. Click the round 'Office' button in the top left corner of the window and select 'Open.'
12. Locate the XLS file you want to convert and double-click its icon.
13. Click the 'Office' button again and select 'Save As.'
14. Give the file a name and select a save location. Choose the 'Excel Workbook' option from the 'Save as type' drop-down menu. Click 'Save' to convert the XLS file to XLSX format.
Using Zamzar
15. Open a Web browser and log on to the Zamzar website.
16. Click 'Choose File' and select the XLS file you want to convert.
17. Select 'xlsx' from the 'Choose the format to convert to' drop-down menu.
18. Enter your email address in the adjacent field.
19. Click 'Convert.' Your file will be converted to XLSX format within minutes. Once finished, a download link will be sent to the email address you provided.

Read more ►

How to Use Excel's MONTH Function

1. Learn the syntax of MONTH. It is MONTH (start_date) where start_date is the date for which you are trying to find the month.
2. Enter start_date using the DATE function or some other function that returns a date to prevent the problems that can occur when a date is entered as text. For example, DATE(2007,4,12) would be used for April 12, 2007.
3. Observe that Excel uses serial numbers internally to store dates. This is a number that represents the number of days beginning from a default date. Windows uses January 1, 1900, as serial number 1 and Excel for the Macintosh uses January 2, 1904, as serial number 1.
4. Examine the return values for the MONTH function. Excel returns the integers 1 to 12, representing the months in the Gregorian calendar, regardless of the display format of serial_number.
5. Study some examples of MONTH by entering 17-Apr-2008 as a date in cell A2. Example 1: =MONTH(A2) will return 4 because April is the fourth month of the year. Example 2: =MONTH(DATE(2007,3,12) will return 3. Note the use of the DATE function to ensure the argument for MONTH is in date format when entering it directly.

Read more ►

How to Edit Charts in Excel 2010

1. Open the spreadsheet containing your chart in Microsoft Excel 2010.
2. Click anywhere on the chart to enable the Chart Tools, which consist of the Design, Layout and Format menu tabs.
3. Click the 'Design' tab to edit the appearance of your chart. Clicking 'Change Chart Type' allows you to select a different format, such as Column, Line or Pie charts. To choose chart data or add a new data series, use the 'Select Data' group. Clicking an option from the Chart Layout group applies a design template that alters the positioning of labels and data. Clicking an option from the Chart Styles group changes the chart's color scheme.
4. Select the 'Layout' tab to change labels or add special formatting to the chart. The Insert group offers the option to add pictures, shapes and text boxes. The Labels group lets you change titles, labels and legends. The Analysis group allows you to add trend lines and error bars to the chart.
5. Click the 'Format' tab to access additional design features, such as borders, color fills and shape effects. Clicking an option from the WordArt Styles group changes all text on the chart. The Size group allows you to edit the horizontal and vertical size for the chart.

Read more ►

How to Remove Blank Cells in Excel 2007

1. Select the range of cells that contains blanks to remove.
2. Click 'Find Select,' at the far right of the Home tab.
3. Choose 'Go to Special....'
4. Click the 'Blanks' radio button in the resulting window.
5. Click 'OK' to close the window and highlight all blank cells in the selected range.
6. Click the 'Delete' arrow button on the Home tab and choose 'Delete Cells....'
7. Choose an option for filling in the blanks: Shift cells left or up, or delete entire rows or columns.

Read more ►

How to Insert a Degree Symbol in Excel

1. Turn on the number lock function on your keyboard's number pad by pressing the 'Number Lock' button. You can only enter the degree symbol by using the number pad (not the row of numbers above the letters.)
2. Click in the cell into which you wish to type the degree symbol.
3. Locate the 'Alt' key on your keyboard.
4. Hold down the 'Alt' key with your left hand, and type '0176' simultaneously on the number pad. You should see the degree symbol appear in your cell.

Read more ►

How to Create High Resolution TIF Files From Excel

1. Open Microsoft Excel by selecting it from the Start menu or double clicking on the Microsoft Excel icon on your desktop. Open the worksheet you want to convert by clicking 'File' and 'Open.' This will open a search window. Locate your document and then click 'OK.'
2. Edit your worksheet, if needed, until you have achieved the final version that you want to appear in the TIFF file. This is the time to hide any columns or rows you do not want to appear in the final document as well as add design elements such as shading and borders. Click 'File' and 'Print Preview' to preview the file and make sure it looks exactly the way you want.
3. Press the 'Print' icon on the upper left corner of the print preview screen to open the print dialog box. Click on the arrow next to the printer 'Name' box to select a different printer. Locate 'Microsoft Office Document Image Writer' and select. Then click the 'Properties' button to open the properties dialog box.
4. Select the 'Layout' tab on the upper left corner of the properties dialog box. Click the 'Advanced' button to open the 'Microsoft Office Document Image Writer Advanced Options' box. Under 'Output Format' select 'TIFF- Monochrome Fax.' Then click 'OK' to accept the option. Keep clicking 'OK' until you return to the Printer dialog box and then click 'OK' one last time to start the process. A small pop-up window will tell you that the document is printing. Then a 'Save As' dialog box will open.
5. Enter the name you want to save the file under in the 'Name:' box. Make sure the document is saving in the correct file location or click the down arrow next to the 'Save in:' box to select a new location. Then click 'Save' to finish the process. Your new TIFF file is now ready to be opened.

Read more ►

How to Delete Data in Excel Not Formulas

1. Click on the cell containing the data you wish to delete. Select more than one cell by holding down the 'Ctrl' key while clicking on the other cells.
2. Go to the 'Edit' menu at the top of the page and highlight the 'Clear' option.
3. Choose 'Contents' by clicking on it to delete only the data and not the formulas from the selected cells.

Read more ►

How to Make a Gantt Chart

Outlining Your Project
1. Document an overview or synopsis of the project before plotting a Gantt chart.
2. Make a list of the tasks required for completion of the project and the dates that each of these tasks needs to be completed by.
3. Create a new spreadsheet.
4. List each of the tasks that must be completed during the course of the project in the far left-hand column. Skip a row at the end of the list.
5. Place the dates of completion for each of the required tasks in a cell on the following row. Allow spaces between the date cells if they are needed for readability.
6. Select the cell that represents the start date of the task, click the 'Format Cells' function and fill the cell with color to indicate the beginning of a task. Repeat this action across the row. Click and drag the mouse over a group of cells to select the cells all the way to the project's end date. Each task needs to be plotted according to its beginning date and end date.
7. Format the text with bolding or italics; add headings and shading to enhance the visual appeal and readability of the chart; or create borders if appropriate.

Read more ►

How to Create a Form for the Web in Excel

1. Go into Microsoft Excel and open the worksheet you want to make into a Web form.
2. Open the Tools menu and select Wizard, then select Web Form.
3. Follow the instructions in the Web Form wizard.
4. In the second set of instructions, select which cell or range of cells you need data for.
5. Click Next.
6. Select your server type.
7. Click Next.
8. Enter the location and file name of the Web page you're adding the form to.
9. Click Next.
10. Enter your closing message. This message will appear after the Web user enters the required data.
11. Follow the instructions in the Web Form wizard.
12. Click Next.
13. Click Finish.

Read more ►

How to Set Up Monte Carlo in Excel 2003

1. Access the Monte Carlo program by either placing the CD in your computer's CD drive or by connecting to the program's network drive if the program is located on a network server. Wait a minute or two while the program loads onto your system.
2. Click 'Start' and go to 'All Programs.' Click on 'Microsoft Excel' to launch the program.
3. Click the 'Tools' tab on the main menu bar and choose 'Add-Ins.' The add-in manager will open. Check 'Monte Carlo' in the add-in list. If the program is not in the list, click 'Browse' and locate the 'MCSim.xla' file under 'Computer' in the removable storage section. Click 'OK.'
4. Click 'Yes' to copy the program to the Excel add-in folder. Monte Carlo is now set up in the Excel program. Click 'OK' to launch the add-in.

Read more ►

How to Convert New Excel From R1C1 to A1

1. Double-click the Excel file you want to work with to open it using Excel 2010.
2. Click the 'File' tab at the top of the Excel ribbon, then click 'Options' from the bottom of the list on the left side of the screen. The Excel Options window appears.
3. Select 'Formulas' from the list on the left side of the window, then look for the 'Working with formulas' area on the right side of the window. Click the check next to 'R1C1 reference style' to remove the check.
4. Click 'OK' to close the Excel Options window. Your spreadsheet now uses the A1 reference style and Excel automatically changes all the current references to the A1 style.

Read more ►

How to Create a Pivot Table in Excel 2010

Use Excel Data
1. Open the Excel 2010 file that holds the data you want to make into a PivotTable.
2. Check the top of each column to ensure that your data has headers. If any columns do not have headers, type a word into the cell atop the column that briefly describes the data. If you don't have any headers at all, right-click on the row number for the top row in the data field and choose 'Insert' from the pop-up menu. You can then enter headers into the new row.
3. Click any cell within the data field. Select the 'Insert' tab at the top of the screen, and then click the 'PivotTable' button on the left end of the ribbon.
4. Choose whether to place the PivotTable on a new worksheet or an existing worksheet at the bottom of the small window that appears. If you choose an existing sheet, you will then need to click on the worksheet and cell where you want the PivotTable to go. Click 'OK' to continue and a blank PivotTable will appear.
5. Place a check mark next to any fields you want to include on the PivotTable on the 'Field List' that appears on the right side of the Excel window. As you add fields, Excel will automatically place them into one of the four PivotTable areas, represented by the four small boxes at the bottom of the 'Field List.' You can then drag and drop the fields from one box to another to change how they appear on the PivotTable.
Use External Data
6. Open the Excel 2010 spreadsheet where you want to create the PivotTable.
7. Select the cell where you want to insert the PivotTable. Select the 'Insert' tab and click the 'PivotTable' button.
8. Select the radio button next to 'Use an external data source.' Click 'Choose Connection,' located in the middle of the window.
9. Select your desired connection from the list of existing connections that appears. Click 'Open' to continue. If you don't see your desired connection, click the 'Browse for More' button and then locate the data source you want to use. Click 'Open' once you have selected the data file, and then 'Open' again.
10. Click 'OK' to create the blank PivotTable. Place check marks next to the fields that you want to add to the PivotTable and Excel will automatically assign them to one of the four PivotTable categories, which are located in four boxes beneath the field list. You can drag and drop fields from one box to another to alter how the PivotTable looks.

Read more ►

How to Use Excel's AveDev Function

1. Learn the syntax of AVEDEV. It is (number_1,number_2,...,number_n) where number_1,number_2,...,number_n are 1 to 30 arguments for which the average of the absolute deviations using the arithmetic mean will be determined.
2. Study the valid arguments for AVEDEV. They must be names, numbers or arrays and references that contain numbers. Logical values and text representations of numbers that are entered directly into the argument list also will be included. FALSE is implicitly converted to 0 and TRUE is implicitly converted to 1.
3. Examine the way AVEDEV uses arguments that are arrays or references to arrays. Empty cells, logical values and text will be ignored. Cells with the value zero will be included, however.
4. Determine the result for AVEDEV. It is determined by first calculating the arithmetic mean m where m = t/n such that t is the population total and n is the population size. The average deviation is then given by the sum of |x-m|/n for all members x of the population.
5. Look at simple example of AVEDEV.=AVEDEV(4,5,6,7,5,4,3) returns 1.020408. The arithmetic mean m is (4 5 6 7 5 4 3)/7 = 34/7 = 4.857143, so the average deviation is (|4-m| |5-m| |6-m| |7-m| |5-m| |4-m| |3-m|)/7 = 7.142857/7 = 1.020408.

Read more ►

How to Delete Redundant Cells in Excel

1. Right-click the Excel file you want to edit, and click 'Open With.' Click 'Microsoft Excel' in the list of programs.
2. Highlight all the cells you want to check for redundancy. You can highlight all cells at once by clicking the corner square in the upper-left corner of the spreadsheet.
3. Click the 'Data' tab and click the 'Remove Duplicates' button. A window opens prompting you for a list of columns on which you want to run the duplication utility.
4. Click the 'Select All' button if you want to check all columns. Otherwise, check each column you want to check.
5. Click 'OK' to remove the redundant cells. Excel returns a report of how many cells were deleted from the spreadsheet.

Read more ►

How to Convert Lotus to Excel 2007

1. Open the file you need to convert in Lotus. Click on the 'File' menu button in the top bar then click on 'Save As.' This will open up a save dialog box.
2. In the dialog box, browse folders until you find the location you want to save the file in and rename the file. Click on the drop down menu next to 'Save as Type' and save the file as a .wk1, .wks, or .123 file. These are earlier versions of Lotus files.
3. Download the OpenOffice suite at openoffice.org. OpenOffice is a free set of office productivity programs which includes a word processor, spreadsheet, presentation, database, drawing program and a calculator.
4. Double click on the OpenOffice icon to bring up the launch screen. Click on the button 'Spreadsheet' to open the spreadsheet program.
5. Click on the 'Open' button in the top menu bar (it looks like an file folder). Search for the file you saved, click on it to select it, and then click 'Open' to open the file in OpenOffice.
6. Click on the 'File' menu in the top bar to open a drop down menu. Click on 'Save As' to open the 'Save File' dialog box.
7. Browse though the folders to determine where you would like this file to be saved and rename the file. Click on the drop down menu next to 'Save as type' to bring up a list of acceptable file types. Click on 'Microsoft Excel (.xls).' Click on 'Save.'
8. Open Excel 2007. Click on the Windows icon at the top left of the screen and click on 'Open.' Browse through the folders until you find the file you saved in OpenOffice, click on it to select it, and click on 'Open' to open it in Excel.

Read more ►