How to Convert Wb3 Files to Xls

Quattro Pro Users
1. Launch Quattro Pro.
2. Go to 'File,' 'Open' and double-click the WB3 file you wish to convert.
3. Go to 'File,' 'Save As' and choose 'Microsoft Excel 97/2000/2002/2003' from the drop-down list, then click 'Save.'
Excel 97 or 2000 Users
4. Download and install the Quattro Pro converter from Microsoft for Excel 97 or Excel 2000.
5. Launch Excel.
6. Go to 'File' 'Open' and select the WB3 file you wish to change into an XLS file.
7. Go to 'File,' 'Save As' and choose 'Excel Workbook (*.xls)' from the drop-down menu, then click 'Save.'
Excel 2003 Users
8. Launch Excel.
9. Go to 'File,' 'Open' and choose 'Quattro Pro/DOS files' from the 'Files of Type' drop-down. Navigate to the folder where your WB3 file is located and double-click on it.
10. Go to 'File,' 'Save As' and choose 'Excel 97-2003 Workbook (*.xls)' from the 'Save as Type' list, then click 'Save.'

Read more ►

How to Compare Cells in Excel

1. Open a new Excel worksheet. Enter or import the first set of data into column A.
2. Enter or import the second column of data into Column C of the same worksheet. Leave Column B empty.
3. Type this formula in cell B1: '=IF(ISERROR(MATCH(A1,$C$1:$C$#,0)),'',A1)', replacing # with the row number of the last value in column C.
4. Select cells in column B, starting at B1 and dragging your mouse down to the cell that corresponds to the last row in columns A and/or C.
5. Go to the Home tab, click on 'Fill,' then select 'Down' from the drop-down menu to finish comparing the cells. Any duplicate numbers will appear in column B between the relevant cells in columns A and C.

Read more ►

How to Learn Microsoft Office Excel

1. Open up Excel on your computer. You'll be greeted with a fresh spreadsheet. Play around with the software by typing data into blank cells. To get a quick understanding of Excel, some people dive right in to the process. Not every person learns by reading a book, so get an idea of what you can do before moving on to tutorials. Excel shouldn't be seen as on-the-job drudgery. You can balance checkbooks, use it for taxes and even create word puzzles. You can find lots of games to play on websites such as www.willard.k12.mo.us/co/tech/msexcel.htm that will teach you the basics while having fun.
2. Visit Microsoft Office's website for a list of training manuals and demos (see Resources). Manuals will give you step-by-step instructions on how to use Excel. Training sessions run between 30-50 minutes long, so you can choose how long to spend learning. Demos show users how to properly and time efficiently use the program.
3. Buy books that demonstrate the different functions of Excel. 'Microsoft Office Excel 2003 Step by Step' by Curtis Frye, 'Excel 2003 Bible' by John Walkenbach, and 'Excel 2003 for Dummies' by Greg Harvey are wonderful training books. You can find them at Amazon.com or www.powells.com. Check you local library's collection for these books and others written about Excel.
4. Take a class at your local library or community college. There are bountiful classes that will cover the basics and advanced skills of Excel. Prices for a class differ for those who have in-state-residency compared to those who are out-of-state. By taking a class, you are able to have one-on-one time with the teacher who can troubleshoot all of your questions. For people who are new to computers or learn better by instruction, this is the most recommended suggestion.
5. Practice on a free Excel tutorial online. You can go to www.baycongroup.com/el0.htm to use a free trail of Excel and learn how to improve your skills.
6. Meet other people learning Excel on an online message boards at www.ozgrid.com/forum/ or www.mrexcel.com/forum/index.php. You can complain, praise, or ask questions about Excel to people with a wide range of Excel skills. Oftentimes just by having an virtual support group can get you through the trails of Excel.

Read more ►

How to Remove Everything After a Character in Excel 2007

1. Start Excel 2007. Open the worksheet you want to use by clicking 'Open' in the menu linked to the round 'Office' button.
2. Identify the cell you want to trim. The cell's name is a combination of the letters printed across the top row of the worksheet and the numbers printed at the leftmost column. By default, the first cell in your spreadsheet will be 'A1.' The currently selected cell is always listed just above the first row containing the cell labels.
3. Choose a blank cell close to the cell you want to remove characters from and click on it to make it the currently active cell.
4. Type '=LEFT(' followed by the name of the cell you want to trim, a comma, and 'SEARCH(.' For example, if you want to trim the contents of cell 'A1,' you would write '=LEFT(A1,SEARCH(.' The Excel 2007 formula bar, which is located immediately to the right of the cell label, shows you the formula you're currently writing.
5. Write the final character you want preserved, making sure to put it between quotes, and then type a comma, the name of the cell again and two closing parentheses. For example, if cell 'A1' contains the phrase 'abcefg' and you want to remove everything after the letter 'c,' the formula bar should read '=LEFT(A1,SEARCH('c',A1)).'
6. Hit the 'Enter' key.

Read more ►

How to Change the Decimal Place in Cells in Microsoft Excel 2003

1. Highlight the cell in which you wish to change the decimal place. Simply left-click on that cell with your mouse.
2. Access the cell-formatting menu. Scroll to the “Format” tab on the command bar and select “Cells.” A cell-formatting-properties box will open.
3. Access the number submenu. Scroll to the “Number” section in the drop-down menu of the cell-formatting-properties box and left-click.
4. Change the cell decimal place. A “Decimal Places” subsection will appear to the right. Click on the up and down arrows to modify the decimal places. Then click on 'OK' to implement these changes.

Read more ►

How to Fill an Excel Cell With Two Colors

1. Right-click the Excel cell you wish to format and select 'Format Cells.'
2. Click the 'Fill' tab.
3. Click 'Fill Effects' under the color picker section.
4. Click 'Two colors' at the top-left, and choose the two colors from the right-hand drop-down menus.
5. Select the 'Shading styles,' and view the preview to get the effect you want.
6. Click 'OK' twice to exit both windows.

Read more ►

How to Calculate CPK With Excel

1. Launch Microsoft Excel and type “Data” in A1, “Upper Limit” in B1, “Average” in C1, “StDev” in D1, and “Cpk” in E1.
2. Type “1” in A2, “2” in A3, “3” in A4, “4” in A5, “5” in A6, “6” in A7, “7” in A8, “8” in A9, “9” in A10, and “10” in A11. Type “15” in B2.
3. Add the following formula in C2 to calculate the average for the data:=AVERAGE(A2:A11)
4. Add the following formula in D2 to calculate the standard deviation for the data:=STDEV(A2:A11)
5. Calculate CPK using the upper limit, average, and standard deviation values by adding the following formula in E2:=((B2-C2)/(3*D2))

Read more ►

How to Do Name Badges With Microsoft Excel

1. Launch Excel. A blank spreadsheet will appear.
2. Populate a column with names. If you want to include titles on the badge, populate a second column with this information. Click 'File' and select 'Save.' Give your list a name, and click 'OK.'
3. Launch Microsoft Word.
4. Click 'Tools.' Point to 'Letters and Mailings,' and click on 'Mail Merge Wizard.'
5. Click 'Labels.' Select 'Label options.' Select your name badge size.
6. Click 'Use an existing list' under 'Select recipients.' Click 'Browse.' Select the Excel file with your name badge information. Click 'Open.'
7. Click your Excel list in the 'Select Table' dialog box. Click 'OK.' Click 'File' and select 'Print.'
8. Peel off the printed labels from the label paper and stick them onto the name tag holders.

Read more ►

How to Use VBA Userforms

1. Display VBA by choosing the 'Tools' menu, then 'Macro' and finally, 'Visual Basic Editor.' The VBA window appears.
2. Choose the 'Insert' menu and 'Userform.' A blank userform with handles appears on the right and a 'Toolbox' window appears below that. A userform icon appears in the 'Project' window in the upper left. The 'Properties' window in the lower, left changes to display the userform properties. If these windows are missing, choose them from the 'View' menu.
3. Resize the userform by clicking on a handle, holding down the left mouse button and dragging the handle.
4. Rename the userform to something more relevant by clicking the name in the 'Properties' windows. Type in a new using the form 'frm
,' which follows recommended programming style. Example names include 'frmStartup' or 'frmMain.'
5. Change the caption by clicking on the 'Caption' property and entering a new name. Because this name appear at the top of the userform, enter one that is meaningful to the user such as 'Sign-in' or 'Main.'
6. Adjust additional properties as needed by clicking on their values. You can then set new values by typing them in or selecting them from a dropdown. For example, to change the background color, click the 'BackColor' property, choose the 'Palette' tab and choose a new color.
7.
Add controls from the Toolbox. If this window is not visible, choose the 'View' menu and select 'Toolbox.' Click on the Toolbox control you want to add and drop it into the userform. Note that the information in the 'Properties' window changes to relate to the current control. To define the properties of other controls or the userform, choose a new control in the dropdown at the top of the window.
8. Change a control property by clicking on the property and typing a new value or choosing one from the dropdown. Resize controls by their handles, or click on their centers to move them around the form.
9.
Enter code for the userform itself by clicking the first 'Select Objects' button in the Toolbox and then by double-clicking on any blank part of the form. The code window appears on the right with a blank 'Click' subroutine. Enter code as needed or enter a new subroutine by choosing a name from the 'Subroutine' dropdown in the upper right. Note that you can enter code for different controls by clicking the 'Control' dropdown in the upper left.
10. Return to the userform as needed by double-clicking its icon in the 'Project' window. Don't forget to save frequently as you build the form.
11. Test your creation by clicking the 'Play' button of the 'Standard' toolbar in the top toolbar. If this bar is missing, choose the 'View' menu, then 'Toolbars' and finally, 'Standard.'
12. Close the window and return to the Word document by choosing the 'File' menu and then the 'Close' option.

Read more ►

How to Create a Cumulative Frequency Distribution Chart in Excel 2003

1. Click cell A1 and type 'Class Limits'.
2. Click cell B1 and type 'Frequency'.
3. Click cell C1 and type 'cumulative frequency'.
4. Type the class limits (categories) for your data in column A, starting in cell A2 and continuing down the column. Enter one set of class limits per cell. For example, if your study is about IQ scores you might have class limits of 0-50, 51-100, and 101-150. Type '0-50' in cell A2, '51-100' in cell A3 and '101-150' in cell A4.
5. Type the frequencies in column B, starting in cell B2 and working down the column. A frequency is how often a particular item was found. For example, if you are studying the IQ scores for a group of 20 children, you might have frequencies of 5 children with IQ score between 0 and 50, 7 with IQ scores of 51 to 100 and 8 with IQ scores between 101 to 150. Type '5' in cell B2, '7' in cell B3 and '8' in cell B4.
6. Click cell C2, type an equal (=) sign and type the cell of the first frequency listed in column B. In this example, the first frequency is listed in cell B2, so type '=B2'.
7. Click cell C3, type an equal (=) sign followed by 'C2', a plus ( ) sign and the location of the second frequency in column B. In this example, you would type '=C2 B3'.
8. Click the fill handle at the bottom-right of cell C3. The fill handle looks like a little black square. Drag the fill handle down the column until it is equal with the last filled-in cell row in column A.

Read more ►

How to Use Cells in Countif on Excel 2003

1. Run the Microsoft Excel application and open the worksheet that you wish to edit.
2. Determine the cell addresses of the range that you want to count. For example, to count all instances of an object in the first 50 rows of column A you refer to cells A1:A50.
3. Click a cell that you want to use to perform the COUNTIF calculation and display the observed value.
4. Type the following in the cell:=COUNTIF(A1:A50, 7)Substitute the cell addresses of your range in place of 'A1:A50', and substitute the value that you wish to count in place of '7'. You can search for either a number value or a character string. In order to search for a character string you must surround the value with quotation marks. For example, this formula will count all cells in the range that contain the word 'Trouble':=COUNTIF (A1:A50, 'Trouble')Alternately, you can use a cell reference as your criterion. For example, the following search counts all items that match the value in cell B3:=COUNTIF (A1:A50, B3)
5. Press Enter. Excel will calculate the frequency of your search criterion in the data range and will display the observed value in the formula cell.

Read more ►

How to Balance Your Checkbook Using Microsoft Excel 2010

Create a Register Template
1. Open a new spreadsheet in Excel 2010. Leave cell A1 empty, and label the various columns you will need beginning in cell B1. Common examples of column headers to add to your spreadsheet include date, check number and transaction information. The last three column headers should be debit, credit and balance.
2. Apply any desired formatting to your register. This includes changing font size and adding a colored background to your column headers so they stand out more. You should also adjust the size of the columns to compensate for the information that you will enter into them. Those that will be used for transaction or memo information should be considerably wider to allow you to enter more detailed notes.
3. Enter data into your spreadsheet to test its functionality. Do not use real data, but instead create generic information so you can make sure that the columns you created in Step 2 are adequate for the information that you need to enter.
4. Create a formula in your spreadsheet so Excel can keep track of your account balance automatically. Make note of the first balance cell on your spreadsheet. If Column G is marked as your balance, then your first balance cell would be G2. This cell will remain untouched, as it will be where you enter your beginning balance. To create the formula with a balance column at G, credit column at F and a debit column at E, enter the formula =SUM(G3-E3 F3) into cell G2. This instructs Excel to add any credit and subtract any debits on that line from your total balance.
5. Move your cursor to cell G3 and enter the following formula: =IF(AND((ISBLANK(E3)),(ISBLANK(F3))),'',SUM(G3-E3 F7)). Ensure that cell G3 is still active and press the auto fill button with your mouse. Drag your curser down the balance columns in your spreadsheet until you reach the 100th line. You can now enter debit and credit information and Excel will add or subtract it form your balance automatically on all lines between 2 and 100.
Enter Account Information
6. Reconcile your checkbook by subtracting any transactions that you have completed since your last statement date. If you have access to online banking, you can also use that to help you determine your current balance by comparing those transactions that have cleared to those that are still pending.
7. Enter your beginning balance on the first cell of your spreadsheet. In the above example you would enter your beginning balance into cell G2.
8. Enter all credit and debit transactions that you complete into the appropriate column so your balance is accurate at all times.

Read more ►

How to Define Cell Ranges in Excel 2003

1. Open Excel from the Start menu.
2. Choose your cell range. For example, highlight 'F5' through 'F28.' (Letters represent columns while numbers represent rows.) To highlight cells, just click and drag. To select a group of cells that are not touching, click each cell separately and hold down the 'Ctrl' key.
3. Click on the name box, which is directly above the 'A1' cell.
4. Type the new cell range name. For example, on a schedule, you might name all the time that you are commuting to work 'Commuting.' Hit the 'Enter' key.
5. Use the cell range names in your next formula. These names can make your formulas much easier to use.
6. Visit the Help section of the Microsoft Web site for more information on how to use cell range names in formulas.

Read more ►

How to Use the Freeze Pane Command in Excel to Create Static Headings

1. Open a spreadsheet file.
2. To freeze the top horizontal pane, select the row below where you want the split to appear.
3. To freeze the left vertical pane, select the column to the right of where you want the split to appear.
4. To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.
5. Open the Window menu and select Freeze Panes. When you scroll through the worksheet, the area you selected remains on the screen.

Read more ►

How to Format the Values of Vertical Axis Currency in Excel

1. Click and drag to select the cells for the vertical axis. To select the entire row or column, click the cell header.
2. Click the 'Home' tab on the command ribbon.
3. Click the down-arrow for the 'Accounting Number Format' button in the 'Number' group. This button displays a currency symbol. A list of currencies and symbols appears.
4. Click the currency, such as U.S. dollar or the Euro.
5. Click the arrow in the bottom-right corner of the 'Number' group. A window entitled 'Format Cells' opens.
6. Click the 'Number' tab.
7. Click the 'Currency' option. The selected currency appears in the 'Symbol' and 'Negative Numbers' text box.
8. Select the number of decimal places in the 'Decimal places' text box. For example, '2' for U.S. dollars.
9. Click an option in the 'Negative numbers' text box. For example, a negative number can appear in red text or inside parenthesis.
10. Click 'OK.'
11. Type the values for the vertical axis. The values automatically format to the selected currency.

Read more ►