The “D” functions are used for multiple data aggregation in the given table. In essence, they do the same thing as “IFS” functions in a slightly more elegant way, and whether this way is better – you estimate yourself! By the way, I am an adversary when the “experts” describe tables as databases. Sometimes the database actually makes one table, but this is very rare. Now, at least you know what letter “D” in ther prefix stands for!
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.
Comments in Excel are not new option. Nevertheless, from the version to the version, there was more and more work to improve the possibility of collaborative work on the documents. Consequently, Excel has a new type of comment. They refer to commenting on shared documents, which in most cases are on the OneDrive repository, and you can view them in a simple way: by clicking the Comments button in the upper right corner of the window.
Excel is increasingly being used on mobile devices. Although, due to their size, they are not the ideal solution for making reports, as they enable mobility, these computers or tablet devices are a great solution for the presentation of reports. Recently Excel got a group of options, integrated in the Draw ribbon, which allow you to doodle over report and leave comments, just like you would do with the pencil.
Power BI has for some time been equipped with feature that enables it to analyze data, and then on the basis of them it is proposed to create appropriate visuals. From recent time such option exists in Excel, and for the time being it can only be used by Office 365 subscribers. This option is called Ideas. Let’s look at how Excel can offer you clues to help you get the most out of your data!