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!
Excel 2019 comes with two new types of graphic object,; these are 3D models and icons. 3D models are vector models of objects that we can add from the location on the disk or the Internet, and serve to better illustrate the data in the table. For example, if table contains a work order 3D model may be the product design we make. Icons are 2D graphic objects (SVG) that we can use in a similar way.
Excel 2019 has got a new type of maps that we can use to illustrate the data from the spreadsheets we’ve made. Actually, this is just another chart that we can add from Insert ribbon or after launching the Recommended Charts option. It allows us to create filled maps, where each country from the given dataset is filled by a color according to given values.
One of the updates of the Office365 package, within Excel 2016, has brought functions for conditional aggregation of data that find the minimum or maximum values of the range depending on the given conditions. These are the functions MINIFS and MAXIFS, and in the following text I will show you how to use such functions.
Newer versions of Excel no longer support the document sharing option I have written in one of the earlier texts. It can still be used after manually adding to the quick menu or toolbar, but collaborating on documents has evolved into co-authoring. This means that the documents are saved on the OneDrive repository, and that the right-hand users can change them at the same time.