The Data Table is an old and somewhat neglected Excel option that allows you to see the results of applying different scenarios within a table. For a given formula and criteria, it returns alternative values of that formula. Criteria can be drawn from rows or columns, and there is the possibility of a report containing two groups of criteria. This is perhaps a better tool than a scenario if we perform simpler analyzes …
Calculated Items allow you to create formulas based on arithmetic operations between elements in rows and/or columns within a pivot table. Sometimes Excel can get confused and display incorrect results due to a misinterpretation of the order of computational operations. Solve order is an option with which we can change the order to get the correct result.
Fixing cell addresses is an old topic. However, when you create a structured table (data table) and try to copy a formula that points to a cell inside it, the rules of the game change. That is, the address will not be updated as desired. These addresses can also be fixed, and in the text that follows you will learn how to do this.
Excel has not changed essentially from its origin, and one of its features is that it does not have data types other than text and numbers. All other (derived) types are only differently formatted numbers. In this respect, Excel 2019 (O365) brings two new types: Stocks and Geography. Since it is unlikely that any of you will be trading on stock exchange, this “recipe” will most of the time deal with geographical data and their application.
The most commonly used charts in Excel are Column and Bar Chart. Although they do the job perfectly, sometimes it is necessary to emphasize the displayed values. For this purpose, you can create a nice chart called “Lollipop” (or Lollypop). It is still not a part of Excel’s standard charts palette and in the following text I will show you how to create one by modifying the Clustered Column chart.