The richness of functions

Excel has a large number of functions, organized according to categories (mathematical, statistical, logical, informative, financial, functions for working with text, etc.). When we start typing the formula and choosing the desired function it automatically displays the syntax in the form of a tooltip that facilitates the input of the function arguments. We can also add functions by selecting a window to insert functions that will be further discussed in the text that follows …

How Excel calculates?

How Excel calculates is seldom asked question, because we perceive this operation as something that is implicit. After all, how much can drive a car while never knowing how’s the engine running ? However, there is a situation where the calculation method can be very important: when the data is downloaded from external sources or when we perform complex calculations of the ones that are important to use the full power of the CPU.

Finding errors

Errors in the calculations are a common thing. The more data in the table and the formula are the more likely we are mistaken. Excel immediately shows us an error as soon as it comes in, but it’s not always easy to find out how it came to it. Also, sometimes it may happen that we miss the error because there was no mistake in mathematical operations. Excel has several options for detecting and finding errors, which will be said in the following text …

Relations between formulas

The reports we analyse are often composed of a large number of interrelated formulas. Then it is convenient, for a moment, to display formulas instead of the expression. It may also be useful to look at the precedents of a formula (the cells on which it was created), as well as its dependents (the values ​​on whose result it affects). The purpose of these procedures is to easily detect errors in the budget, or the logic that led to them.