|Checking Your Formulas
Summary: When you create a nesting formula it is challenging to determine the accuracy of the numbers. Here is how to use the Evaluate Formulas dialog box to do this:
The Evaluate Formula dialog box steps you through the calculation, one expression at a time, so you can see the answer to each step. Here's how you do this:
- Click in the cell that contains the formula you want to check
- Click on the Formula Tab on the Ribbon
- Click Evaluate Formulas in the Formula Auditing Group
- When the Evaluate Formulas box appears click on Evaluate
- Excel will evaluate the first part of the expression
- Continue clicking to review each expression
- Click Step In to review the results of an expression
- Click Step Out to return to the expression
- When Excel reaches the end of the formula, it displays the results
- Click Restart to evaluate the formula again
- Click Close to close the dialog box
The Evaluate Formulas tool is a great way to debug a complex formula.
Summary: Excel allows you to create custom styles, but that style is unique to the workbook it is created in. Many times you will want to use that style in another workbook. Here is how to copy a custom style from one workbook to another.
To copy styles you need to open both the workbooks from which you want to copy the style and the workbook to which you want to apply it. Here are the steps:
- Open the file that contains your custom style
- Open the workbook into which you want to merge your custom style
- Click on the Home Tab
- Click on Cell Styles
- When the Style Gallery appears click on Merge Styles
- When the Merge Styles dialog box appears, click on the workbook whose style you want to use
- Click OK
The copied styles are now available in the new workbook
How to Maintain Data Integrity by Identifying Blank Cells in a Worksheet
Summary: To maintain data integrity in your worksheet you can start by identifying cells that are blank.
This could be due to a data capturing error or because they have been left as place holders for vital information and forgotten. Identifying these blank cells gives you the opportunity to complete capturing and have an accurate data set, which is vital for data analysis.
Here is how to use Conditional Formatting to highlight blank cells in a worksheet.
- Highlight the data range you want to check
- Click on the Home Tab in the Ribbon
- Select Conditional Formatting
- Select New Rule
- Select Format Only Cells That Contain
- Click on the Down Arrow beside the Cell Value box
- Click on Blanks
- Click on the Format button
- Select the color of choice and click OK.
- Click OK to complete the process
Note that all the blank cells are now highlighted in blue. Thus, the missing cells can quickly be filled in with information and the data integrity of the worksheet maintained.
Back to top
Inserting One File Into Another
Summary: There are times when you want to insert another Word file into your document. Here is how to do this:
To add a file to the document you are working on.
- Position the insertion point where you want the file inserted
- Click on the Insert Tab on the Ribbon
- In the Text group, click the down-arrow to the right of the Object tool
- Select Text from the File option.
- Browse to the File you want to Insert
- Click on OK.
The file will now be inserted below you insertion point