3D models and icons

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.

Filled maps

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.

Funnel chart

The Funnel chart is not a great novelty. In one of the earlier posts there were words about how to graphically represent the sales funnel, and what’s new is that this chart, that previously existed only in Office365 and Office Online editions, became part of Excel 2019. The Funnel chart is most useful when we want to display values ​​(quantities, amounts) in relation to a certain business phase, and how to do it will be shown in the following scenario.

Functions IFS and SWITCH

Excel that comes with Office365 brings two new logical functions: IFS and SWITCH. The first of them consists of a number of conditions, and returns the selected value after the first fulfilled condition. The other starts with a condition, and then, depending on the values ​​that meet the requirement returns appropriate value. Sometimes these functions can be very useful, and how to use them I’ll show in following recipe.

Smallest and highest range 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.