Fixing cell addresses

When copying formulas Excel automatically updates the address of cells that it contains. This is a very useful feature, since it allows us to create a formula once and then only copy it into the cells where it is applied, similar to the initial cell. However, sometimes there is a need for one or more address-operands to change. In this case, we use techniques for fixing addresses in a cell.

Freezing rows or columns

Data entry in large tables can be complicated, first of all because, by adding new rows, the header disappears from the screen. Therefore, we are not sure in which column we enter which data, so the work is much slower. “Freezing” rows or columns is a technique by which we fix one or more rows or columns so that they always appear on the screen. At the same time, we can continue to fill in the data of new rows and/or columns with a clear idea of where we need to enter.

Views on a worksheet

Depending on what we want to acomplish it is possible to use several different views on the worksheet. These views make it easier to get into large tables or to adjust the appearance of the work environment in accordance with our own desires. In this way, Excel can be configured to resemble more like a data entry form or print preparation software. Personally, when preparing to print a document, I often use the Page Layout view, and in the text that follows, you will see and why!

Ribbons and shortcuts

Excel 2007 brought a new work environment based on ribbons. This novelty was annoyed by many experienced users (who were able to set shortcuts to the most commonly used options) and delighted new users (who saw some options they did not even suspect that existed). In order to “calm down passions,” Office programmers first added the Quick Access Toolbar and the ability to adjust the toolbar content (Office 2010).

Data series within a chart

Charts can be based on one or more data sets. More series are used when we want to show business results by quarter or over a few years. When making such charts, it is important to pay attention to the subtype as it determines their appearance. That is, we should choose whether to make a Stacked or Clustered chart. Also, during work with such charts, users may need to add, edit or delete series of data…