Wednesday, April 27, 2011

How to Convert Excel 2003 to the 2007 Format

1. Open the file to be converted using Excel 2007. Click 'File' in the menu bar and select 'Open.' Navigate to the file you wish to open and convert. This will open the file in Compatibility Mode.2. Click the 'Microsoft Office Button' located in the menu bar then click 'Convert' in the pop up window. When asked if you are sure you wish to convert this workbook to the new file format, click 'OK' to confirm. If you do not want this warning message to appear again, select the option for 'Do not ask me again about converting workbooks.'3. Click 'Yes' in the window that appears asking if you...
Read more ►

Tuesday, April 26, 2011

How to View Excel Spreadsheets Without Microsoft Office

1. Download and install the free Excel Viewer on your computer. You can find a link to the download in the resources section of this article.2. Open the Excel Viewer. Click 'File' from the Excel Viewer window toolbar and then select 'Open.'3. Select the Excel file you want to view and then click 'Open.' The Excel Viewer will automatically display the Excel spreadsheet you have select...
Read more ►

How to Cross Out on Excel

1. Launch Microsoft Excel 2010 to begin working in a new workbook, or double-click an existing Excel spreadsheet to edit.2. Click on the cell containing the text that you want to cross out. If you want to select multiple cells, hold down the 'Ctrl' key on your keyboard, and then click each desired cell with your mouse.3. Click the 'Home' tab at the top of the window.4. Click the 'Format Cells: Fonts' button at the bottom right-corner of the 'Font' section of the ribbon. The button is a small square with an arrow in it.5. Check the box to the left of 'Strikethrough' in the 'Effects' section...
Read more ►

How to Make a Flowchart in Excel

1. Make the 'Drawing' toolbar available in Excel 2003 by going to the 'View' menu and pointing to 'Toolbars.' Click on 'Drawing'; the 'Drawing' toolbar will appear at the bottom of the window. In Excel 2007, go to the 'Insert' tab of the ribbon and find the 'Illustrations' section.2. Click on 'AutoShapes' in Excel 2003 and point to 'Flowchart.' Click on the first shape you want to use and click onto the worksheet to place it in the appropriate area. In Excel 2007, click the 'Shapes' button and choose the shape you want to use first from the 'Flowchart' gallery. Click onto the worksheet and...
Read more ►

Monday, April 25, 2011

How to Paste Special in Microsoft Excel 2003

1. Select the cells, rows, or columns that you want to manipulate and go to the Edit menu and select 'Copy' (or press Ctrl-C) to copy the data.2. Click the cursor on the cell or cells where you want the manipulated data to be placed.3. Go back to the Edit menu and select 'Paste Special.' This will open up a window where you will choose how to manipulate the selected data.4. The first section, labeled 'Paste,' is where you tell Microsoft Excel what parts of the data you want to paste. 'All' will paste all of the copied data, 'Formulas' will paste just the formulas connected to the copied...
Read more ►

How to Find a Confidence Interval for the True Mean Using Excel 2007

1. Enter the alpha value in cell A1. The alpha value represents '1,' minus the probability the true mean lies within the confidence interval. For example, if you want a 95 percent probability that the true mean lies within the confidence interval, your alpha value equals 0.05.2. Enter the standard deviation of the data in cell A2. The wider the distribution of data, the greater the standard deviation.3. Enter the sample size in cell A3. The larger the sample size, the smaller the confidence interval will be.4. Enter '=CONFIDENCE(A1,A2,A3)' into cell A4. Excel will display the confidence...
Read more ►

How to Balance a Checkbook With Excel 2003

Manual Method1. Open a blank Excel 2003 spreadsheet.2. Type the following headings in the first row: 'Check #,' 'Date,' 'Description,' 'Debit,' 'Credit' and 'Balance.' These mimic your checkbook register. Format the headings however you like. Recommended formatting is to bold, center and underline headings.3. Type 'Initial Balance' or 'Initial Deposit' in the first empty cell under 'Description.' Type your current or starting balance in the first empty cell under 'Balance.'4. Type the following formula in the next empty cell under 'Balance': '=F2-D3 E3. This assumes Debit is in column...
Read more ►

Sunday, April 24, 2011

How to Edit Cells With Multiple Users in Excel 2007

1. Format the document prior to sharing it across a network. Once an Excel 2007 file is shared, many common formatting procedures are no longer available until the sharing is deactivated. These include conditional formatting, charts, pictures, links, outlines and PivotTables. It is best to prepare the file for mass data entry with the features everyone will need during editing.2. Click on the 'Share Workbook' button. This will open up the features dialog for network sharing of the Excel 2007 document with multiple users. The button is found on the Review tab of the Excel 2007 toolbar, in the...
Read more ►

How to Change the Order of the Legend in an Excel Graph

1. Locate the chart data in the Excel spreadsheet. To locate the applicable data, click on the graph: the data will be surrounded on the worksheet by a blue box.2. Copy the data, then paste it to a clear area on your workbook. Alternatively, paste it into a new worksheet.3. Change the data into the order you want it to appear on the graph then copy and paste the columns.4. Copy and paste the new data order back into the original spot on the workbo...
Read more ►

How to Remove Leading Zeroes in Excel

1. Open the spreadsheet that you want to edit in the Microsoft Excel program.2. Highlight the cells that contain decimal information for which you'd like to remove the leading zero.3. Right-click the highlighted cells and choose 'Format Cells.' This will open a cell-formatting options window.4. Click the 'Number' tab and select 'Custom' from the category list.5. Click the text box underneath the 'Type' heading and press the 'Backspace' key multiple times to clear the contents of the field.6. Type a decimal point and then type the number of zeroes that correspond to the number of decimal...
Read more ►

How to Create an Alphanumeric Custom List in Excel 2007

Create the List1. Open Excel and click on the Office button, which is located in the top left-hand corner of the window.2. Click the 'Excel Options' item from the menu that drops down.3. Click on the category labeled 'Popular.' Locate the section called 'Top options for working with Excel.' Click the 'Edit Custom Lists' item in this section.4. Click the 'New List' option located in the 'Custom Lists' box.5. Type the first item of the custom list. Choose any combination of alphanumeric text characters. Enter the item into the 'List entries' box. Press the Enter key on the keyboard.6....
Read more ►

Saturday, April 23, 2011

How to Insert the Time Date in an Excel Spreadsheet

1. Navigate to the cell to which you want to add the date and time. Click on the cell to highlight.2. Move your mouse up to the 'Fx' bar above the spreadsheet. This is the bar where you enter formulas for specific cells.3. Type '=Now()' without the quotation marks. This enters the current date and time into the Excel spreadsheet in the selected ce...
Read more ►

Friday, April 22, 2011

How to Merge 2 Excel Workbooks in Excel 2007

Share the Workbook1. Launch Microsoft Excel on your computer. Click 'File' and then 'Open' on the ribbon bar. Navigate to the file to share, highlight it and click the 'Open' button.2. Click 'Tools' and then 'Share Workbook.' Click the 'Editing' tab and then enable the 'Allow Changes by more than one user at the same time' option.3. Click the 'Advanced' tab and then click 'Track changes.' Click the 'Keep change history for:' option. In the 'Days' text box, enter a number of days for the estimated time needed for others in the group to edit the file and review changes. Click the 'OK' button.4....
Read more ►

How to Save Margins in Excel

1. Open Excel and click the 'Page Layout' tab and then click 'Margins.'2. Click 'Custom Margins' in the menu that appears. Click the 'Margins' tab in the 'Page Setup' window that appears.3. Click the number in the 'Top' box and type the margin size you wish to use in the 'Top' box. Repeat this step for the 'Left,' 'Right,' and 'Bottom' boxes.4. Click the 'OK' button to save the settings for the workshe...
Read more ►

How to Use a Microsoft Excel 2003 Dashboard

1. Produce an annual report or magazine quality visuals reports using Excel. Use templates downloaded from the Microsoft website. Create a chart by arranging the data (that you want to plot in your chart) in columns and rows. Select the cells you want to include and from the Insert menu, click the Chart option. Select the type of chart you want to represent your data. For example, select a pie chart, and decide where you want to place the chart.2. Replace charts that do not reflect the data you want used. Because Excel is so flexible, you can lay out the flow of business processes and drill...
Read more ►

Blogger news