• Tools | Options | Calculation | Precision as Displayed  checkbox could prevent you from falling into a potentially embarrassing "rounding error" situation 
  
  
• Format | Conditional Formatting might be useful for error checking (invalid values could show up formatted in red)
  
  
• There may be certain portions of the worksheet that you'd like to protect from any possible changes. By default all the cells in the worksheet are locked but the locks are ignored. Tools | Protection | Protect Sheet activates recognition of the locks. Before using Protect Sheet you would unlock all the cells you want to be able to edit when the rest of sheet is protected -- Select Cells, Format | Cells | Protection tab and uncheck the default lock. Then use Tools | Protection | Protect Sheet.
  If most of your cells are going to be unprotected with just a few protected --
  1. Use [Ctrl]-A to select all the cells in the sheet
  2. Format | Cells | Protection tab and uncheck the default lock
  3. Select the cells you DO want to protect
  4. Format | Cells | Protection tab and CHECK the lock back on
  5. Tools | Protection | Protect Sheet
     
     
• When you've imported data sometimes numbers will come in as text. That is, they look like numbers but don't act like numbers. A quick way to identify this problem is to use the Excel feature that when a block of cells is selected the SUM of the cells will appear in the Status Bar. Numbers that are text will have a value of zero in the SUM. To convert text to numbers:
  1. Select the cells to convert
  2. Right-click in the upper left-hand corner of a block of blank cells large enough to accommodate the cells you want to convert
  3. Choose Paste Special
  4. In the Paste Special dialog box choose the Operation, Add
  Doing this arithmetic operation of adding the cells' text value with the zero value of the destination cells forces Excel to convert the text value to a number.
  
  
• To write a formula in one worksheet that references a value in another worksheet (perhaps in another workbook), have both worksheets open in Excel. Write the formula by pointing at the cells of interest -- type the equals sign, then just navigate your way to the other sheet as needed, click on the cell to be used in the calculation, then continue typing your formula, tap [Enter] when you're finished entering the formula.
  
  
• The Wizard used in Data | Text to Columns is the same tool you have available for opening text files you want to import into Excel. File | Open with some text file will bring you to Step 1 of the Data Import Wizard.
  
  
• Sometimes codes used in data entry need to be sorted in some order that is not alphabetical or numeric. You can define a custom sort order in Tools | Options | Custom Lists. Rather than Adding the list, the easiest way to enter the values is to Import list from cells. To use your list, Data | Sort | Options button has a dropdown where you can choose your list for the sort order.

We offer Instant Telephone Support for clients with urgent questions. Call (866) 762-3990 now for fast answers!

• Support
• Training

We offer a money back guarantee if you’re not happy with our services. What other software support firm gives you a risk-free guarantee like that?