Each chart consists of more elements that determine its appearance. This is, first of all, the way data are shown within a group (Data Series) or a single series (Data Point). Depending on the type of data, different charts are being used: Column, Bar, Line, Surface, Pie … Accordingly, the elements of such charts are: title, legend, axes, background … By adding or removing elements we ‘re getting the more effective report.
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 …
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.
When entering data into large tables, it often happens that some of the values that we enter are repeated. Excel offers two automations that make it easy to enter. The first one is called Autofill and starts automatically as soon as we start typing the text with a template that already existed in the current column. Flash Fill offers data filling based on forms that Excel recognizes in previous columns within the same table.
Often we fill out tables with data that are meaningful strings. This can be for example the days of the week, the names of months, and so on. Therefore, it would be convenient to have automation using just enough to enter only the first member of the string, for example, “MONDAY”, and when applying a fill-in technique to Excel, automatically fill in the other several selected fields with the names of the remaining days of the week. This automatics are the Custom Lists and will be referred to in the following text.