Each cell in the worksheet can be blank or have some content (text, number). It can also have its own formatting elements. The CELL function allows you to read the attributes of a cell, however it is not nearly as powerful as the old GET.CELL macro function. In the following text, you will learn how to read cell attributes.
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.
The FREQUENCY function is used to calculate how often certain values in a given range are repeated. This is an array function, and we can use it to calculate a distribution by which we can see how many points students have scored on a test and for other similar statistical analyzes. To help you understand how the function works will also illustrate this with a simple chart …
One of the earlier posts referred to date hierarchies, a relatively new functionality that allows the month, quarter, or year to be automatically created based on a column containing a date (depending on the data that column contains). This can cause a problem with previous reports that contain dates, and the user wants to see them as originally created. How to solve this?
Power BI is, for the most part, used for business reporting purposes, and the ultimate goal is to publish company data in the cloud, along with related reports, and then create reporting dashboards that provide the information necessary to support decision making. A free Power BI subscription can also be used for this, but I still recommend that you use (purchase) a Power BI Professional license. Why? More about this in the text that follows …