How to calculate distance between the two places on the map? The simplest way is by using the formula for calculating the haversine, which for the given coordinates returns the distance of the points on the sphere. However, this is the air distance. If you are planning to take off on the road, you are surely interested in getting from point A to point B by traffic. In the following text I will show you how to use Google Maps to calculate distance.
If you’ve thought that, when you start using PowerPivot, will get rid of array lookup functions you were deadly wrong! Although the concept of a data model does not go hand in hand with the need to use these class of functions, it is sometimes necessary to search the arrays. To do this you will use the LOOKUPVALUE function, and how to use it, in combination with the WEEKDAY function, you will find out in the text that follows.
Recent versions of Power Pivot possess the feature that automatically generates hierarchies and columns that calculate year, quarter, and month for date columns. It is automatically activated when you drag such column into a Power Pivot report. This can be of use, but it can also bother you. In the following text you will find out how you can turn on or off this Excel feature.
Box & Whisker charts are used for a statistical analysis of the data set. They come along with Excel 2016, and serve to show the statistical distribution of data according to quartiles, emphasizing the mean, maximum and minimum values. In business, they can be used, for example, to analyze the turnover of an item byclass or sales group. Then we analyze the value distribution, based on which we can make conclusions about future values.
Sunburst is another new chart brought to us with Excel 2016. It is suitable for displaying sales values (traffic, earnings, merchandise, etc.) according to periods, arranged by hierarchies such as: years, quarters, months, days … It reminiscent of a Doughnut Chart, because the width of the ring shows the value that we want to present. It differs in showing several rings, each corresponding to one of the hierarchies.