How to Open Xlsx in Excel 2003

1. Access the Microsoft Downloads website. Type 'Compatibility Tool' in the search box. Download the Compatibility Tool. Once it has downloaded to your computer, double click the execution file and follow the installation instructions. Click 'OK' once the installation is complete.
2. Open Excel 2003 and locate an Excel 2007 workbook. Click 'File' on the menu bar, then click 'Open.' Browse your files and locate the workbook. Click the workbook, then click 'Open.'
3. View the xlsx workbook in Excel 2003. You can work with this new format since the compatibility tool is installed.

Read more ►

How to Change the Language in Microsoft Excel

1. Click the Microsoft 'Office' button in Excel and click the 'Excel Options' button to open a dialog box.
2. Click the 'Popular' tab on the left side of the screen if it isn't already selected.
3. Click the 'Language Settings' button. A new window opens.
4. Click any language on the left side of the screen that you want to be able to work with. Click the 'Add' button to move that language to the box on the right, enabling it for use in Excel and your other Office products.
5. Click the down arrow in the Primary Editing Language section to change the default language for Excel and all of Office.
6. Click 'OK' to close the window and then click 'OK' again.

Read more ►

How to Add the Sum Function to an Excel 2003 Toolbar

1. Open Excel 2003 and select 'Tools' on the menu bar. Select 'Customize.' The Customize dialog box appears. Click the 'Toolbars' tab. Select 'New.' The New Toolbar dialog box appears. Type a name for your new toolbar and click 'OK.'
2. Review your new floating toolbar. Click the 'AutoSum' button on the standard toolbar to reveal a drop-down list of functions. Click 'SUM.'
3. Drag 'SUM' from the standard toolbar to your new floating toolbar. Click 'Close' to close the Customize dialog box.

Read more ►

How to Get a Running Total by Subtraction in Excel 2007

1. Enter the numbers you want to subtract from beginning total in a column on the left. For example, if you want to subtract 10, 14, 19 and 16 from 1000, you would place 10, 14, 19 and 16 in cells A2, A3, A4 and A5. Place the beginning total in a second column. For example, 1000 would go into cell B1.
2. Write the formula for the running subtraction, or balance. In cell B2, type '=SUM(B1-A2)'. This will subtract 10 from 1000 and put the result, 990, in cell B2.
3. Copy the formula to the lower cells to create a running total. Click on cell B2. Move the cursor to the bottom right corner, then click and drag the cell downward to drag the formula down the column. This will copy the formula to the lower cells so you won't have to rewrite the formula for each cell.

Read more ►

How to Do Percentages

1. Divide the number (N) by 100 to obtain a decimal, and then move the decimal point two places to the right to obtain your percentage (P).For example, if you have 100 items, what percent is N, where N=24?
N / 100 = P
24 / 100 = .24 or 24%
2. Convert a fraction or decimal to a percent by multiplying by 100.For example, 1 girl (N) out of 5 (T) receives an equal share of the money from a bake sale. Divide the given amount (N) by the total amount (T) and multiply by 100 for the percent (P).
N/T x 100 = P
1/5 x 100 = 20 or 20%
3. Convert a percentage to a fraction by dividing by 100 and then simplifying.20% = 20/100 = 1/5
4. Convert a percentage to a decimal by moving the decimal two places to the left.20% = 20.0 = .20
200% = 200.0 = 2.0
5. Convert to like measurements before calculating percent. When determining a percentage of differing measurements, you must first have all elements the same.For example, to determine the percent of 2 inches out of 12 feet, first convert the feet to inches.
12 inches = 1 foot
12 x 12 = 144 inches2 inches is what percent of 144?
2 = Percent x 144
2 ÷ 144 = .0138
Move the decimal point two places to the right of multiply by 100 for a percentage of 1.38%.

Read more ►

How to Create a Histogram in Excel

1. Type or import data into an Excel spreadsheet. Organize data into columns representing the 'Input Range,' representing data range on the y-axis, and the 'Bin Range,' representing frequency values on the x-axis.
2. Verify the 'Analysis ToolPak' option under Tools/Add-Ins has been checked or activated. If 'Data Analysis' option isn't available, please see the 'Tips' section for activating the Analysis ToolPak under the 'Add-Ins' menu.
3. Click on the 'Data Analysis' option under the 'Tools' menu.
4. Open the 'Histogram' option window.
5. Select 'Input Range' by dragging your mouse over the data you want to include in the analysis.
6. Choose 'Chart Output.'. Your chart will appear within the same Excel worksheet as your data.
7. Use 'Chart Options' and 'Format Data Series' menu to adjust the final appearance of the chart. You can use these options to adjust, size, position and labeling.

Read more ►

How to Make a Spreadsheet in Excel 2003

1. Launch Excel 2003 and open a blank document. Click the 'File' menu and select the 'New' option, which opens a task pane to the right of the screen. Click the 'Blank Workbook' link in the 'New' section.
2. Enter your desired data into the individual spreadsheet cells. You may input text or numbers into cells. Format your data, as necessary, by highlighting the appropriate cells and clicking the 'Format' menu. Select the 'Cells' option to open a separate window. Click one of the options in the 'Category' section of the 'Number' tab -- for example, 'Number' to format the data in the selected cells.
3. Use preformatted formulas to calculate data in the spreadsheet. Select a blank cell and click the 'Insert Function' button to the left of the 'Formula Bar,' which opens a separate dialog window. Select a function, such as 'SUM,' from the Insert Function menu and click the 'OK' button. Select the cells that you want to use your formula, according to the required information to complete the selected formula. Click the 'OK' button.
4. Save your spreadsheet. Click the 'File' menu and select the 'Save As' option; select a folder in the resulting dialog window in which to save the XLS file using the 'Look in' menu. Type a name for the file in the 'File name' field and click the 'Save' button.

Read more ►

How to Calculate Age From Date of Birth in Excel

1. Write the date of birth in cell A1. For example, write 2/9/1967.
2. Type the TODAY function in cell B1. The TODAY function is:
=TODAY()
This will always return the current date.
3. Type the following into cell C3:
=(B1-A1)/365.25.
The person's age in years will appear once you hit 'Enter.'

Read more ►

How to Import XLR Files

Microsoft Excel
1. Go to your 'Start' menu. Click 'All Programs,' 'Microsoft Officer Starter (English),' and then click 'Microsoft Excel 2010' to open Excel.
2. Click the 'File' menu and then click 'Open' to browse your hard drive for the XLR.
3. Browse your computer for the XLR you want to import and then click 'Open' to import the spreadsheet to Microsoft Excel.
OpenOffice Calc
4. Download and install the OpenOffice Suite from OpenOffice.org. Calc is the name of the spreadsheet software that is bundled with OpenOffice.
5. Click 'Start,' 'All Programs,' 'OpenOffice' and then click 'OpenOffice Calc' to run the spreadsheet program.
6. Click the 'File' menu and then click 'Open' to find the XLR you want to import into OpenOffice Calc.
7. Click 'Open' again to import the XLR file.

Read more ►

How to Calculate the Time Difference in Excel

Calculate Differences Between Hours
1. Open a new Microsoft Excel workbook.
2. Select the top cell in column 'A' and type 'Start Time,' and press 'Enter.'
3. Select the top cell in column 'B' and type 'End Time,' and press 'Enter.'
4. Select the top cell in column 'C' and type 'Time Difference,' and press 'Enter.'
5. Enter the start and end times in the appropriate columns by selecting the cell under the appropriate column and typing the time function, '=TIME(hour, minute, second)' and pressing 'Enter.' To enter times without using the TIME function, skip this step.
6. Format the cells for time by selecting the 'Home' tab on the top menu and clicking the arrow in the 'Font' section to open the 'Format Cells' window.
7. Click the 'Number' tab and select the 'Time' category. Select your preferred format in the 'Type:' box and click 'OK.' Enter times using proper syntax. Examples are '5 p' for 5:00 p.m., '5:42 p' for 5:42 p.m., or if you want to include seconds, '5:42:15 p' for 5:42:15 p.m. To display seconds, be sure to select a format that shows seconds.
8. Calculate the time difference by using the formula end time minus start time, using the 'TEXT' function for proper formatting (h=hour, m=minute and s=second). Select the cell under the appropriate column and type the combined text function and time formula, '=TEXT(B2-A2, 'h:mm:ss')' and press 'Enter.'
9. Select the cell containing the formula and hold down 'Ctrl' and 'C' to copy it. Paste the formula in column C next to all rows that contain start and end times to be calculated.
Calculate Differences Between Dates
10. Open a new Microsoft Excel workbook.
11. Select the top cell in column 'A' and type 'Start Date,' and press 'Enter.'
12. Select the top cell in column 'B' and type 'End Date,' and press 'Enter.'
13. Select the top cell in column 'C' and type 'Date Difference,' and press 'Enter.'
14. Enter the start and end dates in the appropriate columns by selecting the cell under the appropriate column and typing the date function, '=DATE(year, month, day)' and pressing 'Enter.' To enter times without using the DATE function, skip this step.
15. Format the cells for dates by selecting the 'Home' tab on the top menu and clicking the arrow in the 'Font' section to open the 'Format Cells' window.
16. Click the 'Number' tab and select the 'Date' category. Select your preferred format in the 'Type:' box and click 'OK.'
17. Enter dates using proper syntax. Click the cell and type '5-8' and press 'Enter' for dates in the current year. In the year 2010, Excel would read this date as May 8, 2010.
18. Include the year for dates not in the current year. Click the cell and type '5-8-9' or '5-8-09' and press 'Enter.' Excel would interpret this date as May 8, 2009.
19. Enter the full year for dates in other centuries. Type '5-8-1942' and press 'Enter.' Excel would interpret this date as May 8, 1942.
20. Calculate the date difference by using the formula end date minus start date. Type '=B2-A2' and press 'Enter.'
21. Calculate the date difference using workdays only by using the NETWORKDAYS function (=NETWORKDAYS(Start Date, End Date)). Type '=NETWORKDAYS(a2, b2)' and press 'Enter.'
22. Select the cell containing the formula and hold down 'Ctrl' and 'C' to copy it. Paste the formula in column C next to all rows that contain start and end dates to be calculated.

Read more ►

How to Create a Bar Graph From an Excel Spreadsheet

Creating a Chart
1. Start Microsoft Excel, and open the file you want to use to make a chart.
2. Drag the cursor over the columns you want to show in your chart.
3. Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar.
4. Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left.
5. Press Finish if you do not want to label or format your chart.
6. Press Next to label and format your chart.
Formatting Your Graph
7. In the box that appears after you clicked Next, click the Series tab.
8. Click on Series1, and enter a label for your data, such as 'Number of Widgets per Month,' in the Name field.
9. Click on any additional series, and name those as well.
10. Click Next.
11. Select the Titles tab to label your chart and both its x-axis and y-axis.
12. Select the Axes, Gridlines, or Legend tabs to format the look of your chart.
13. Select the Data Label tab to label specific points on your chart.
14. Select the Data Table tab to add a table of chart data under your chart.
15. Click Next.
16. Decide whether you want your chart on a new worksheet or on the same worksheet with your current Excel entries.
17. Click Finish.

Read more ►

How to Secure Excel Data

1. Turn on your computer, open Excel, and find the spreadsheet that you need to secure.
2. Click on 'Tools' in the toolbar and then select 'Protection'.
3. Now you have several options on how to protect the spreadsheet. If you have a single sheet, then choose 'Protect Sheet'. If you have several tabs on the spreadsheet then select 'Protect Workbook'. Finally, if you want the recipients to be able to alter data, choose 'Allow users to edit ranges'. In this example you should choose 'Protect Sheet'.
4. When the Protect Sheet windows opened, type in a password in the password box, then check the appropriate boxes for the options that you need for the spreadsheet. Normally if you are protecting a sheet from being altered you should only check 'Select locked cells' and 'Select unlocked cells'. Click 'OK' to continue.
5. Save the spreadsheet, and if you want extra protection simply choose 'Save as', then click 'Tools' and then 'General Options'. This will open a Save Options window where you can add an additional password and make the document 'Read-Only' as well.
6. Once you have entered the password and selected the 'Read-Only' box, click 'OK' and then 'Save'.

Read more ►

How to Use Excel's Covar Function

1. Learn the syntax for Covar. It is Covar (array_1,array_2) where array_1 is the first range of integers and array_2 is the second range of integers. The covariance of these two arrays will be returned.
2. Study the restrictions on the arguments. They must be arrays, references, names or numbers. If the arguments contain empty cells, logical values or text, those values will be ignored. However, the value zero is included.
3. Compare the number of values between array_1 and array_2. If they are not equal, Covar will return the #N/A error value. If either array is empty, Covar will return the #DIV/0! error value.
4. Calculate the covariance. Covar(X,Y) = The sum of (x - Average (array_1))(y - Average (array_2))/n where x and y are individual values in array_1 and array_2 respectively and n is the sample size.
5. Look at the following example: Data_1 = (3, 2, 4, 5, 6) and Data_2 = (9, 7, 12, 15, 17). Average (array_1) = 4 and Average(array_2) = 10. The sum of (x-4)(y-10) for all values of data_1 and data_2 is (3-4)(9-10) (2-4)(7-10) (4-4)(1-10) (5-4)(15-10) (6-4)(17-10) = 1 6 0 5 14 = 26. 26/5 = 5.2 so Covar (Data_1,Data_2) = 5.2.

Read more ►

How to Generate Random Numbers in Excel 2003

1. Open an Excel spreadsheet.
2. Click on a cell where you want your range of random numbers to start.
3. Enter the following into the formula box:=RAND()and hit 'Enter.' This is the default RAND function and will generate the first random number between 0 and 1 to 9 decimal places. You can expand the cell to see all 9 decimal places. To generate a whole random number between numbers other than 0 and 1, enter the following into the formula box: =INT(RAND()*(b-a)) awhere 'a' is the minimum random number you want and 'b' is the maximum random number you want. For example, to generate random numbers between 1 and 100, you would enter: =INT(RAND()*(100-1)) 1.
4. Click on that cell, then move your mouse to the bottom right corner until a solid, black cross appears.
5. Drag this black cross down or across the number of cells that you want. For example, if you want to generate 20 random numbers, drag the cursor down 19 additional cells. All the cells, including the first one should now have a new random number.

Read more ►

How to Change the Default to Excel 2003 Instead of Excel 2007

1. Click on the Office button at the upper left-hand corner of the screen. A menu will come up.
2. Click on 'Excel Options' at the bottom of the menu that comes up. A two-pane dialog window appears.
3. Click 'Save' in the left-hand side of the pane. On the right-hand side of the pane, the panel will change to show save options.
4. Select 'Excel 97-2003 Workbook (*.xls)' from the menu on the first option on the panel.
5. Click 'OK' at the bottom of the panel.

Read more ►