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.