Fresh Excel Tips

Excel’s Function Wizard can greatly simplify the utilization of functions. You can use this to your advantage for every one of Excel’s functions, even the most complex statistical, financial, mathematical  and engineering function.  You can access the Function Wizard in one of two ways. The first way entails selecting a cell where the result is [...]

When you create a formula, Excel does the necessary calculations and then returns a result. If it happens that Excel cannot calculate a particular formula, then it will displays a corresponding error message in the cell that contains the formula. The Excel Trace feature can be used to track down where this error took place. [...]

When you create formulas, you can embed a formula within another formula. Because there are so many steps involved when you do this, trying to ascertain the accuracy of your results may be difficult. One option that is available to you is the Evaluate Formula dialog box. You can use this to check the result [...]

In Excel, you can name individual cells and groups of cells, called ranges. A cell named Tax or a range named Northern_Region is easier to remember than the corresponding cell address. You can use named cells and ranges directly in formulas to refer to the values contained in them. When you move a named range [...]

Constants are used whenever you want to use the same value in different cells and/or formulas. By using constants, you can refer to a any value by using only the constant’s name. You can use constants in a wide variety applications and settings. For example, interest and tax rates are familiar constants that are regularly [...]

Creating and constructing formulas can sometimes be very complicated, especially when you use several functions in the same formula or when multiple arguments are need for a single function. The use of named constants ranges can make this task and using functions much easier by enabling you to use names and descriptions that you have [...]

One of the more useful features in Excel is the ability to name individual cells and groups of cells, called ranges. Of course, assigning a name to your own cells will be much easier to remember than the corresponding cell address. One of the beauties of doing this is that you can use named cells and [...]