In the previous article, we saw a video of how the New Year progresses across time zones. This video shows you how to use Power Map to create the animated time zone video. Download this file and try it yourself.
Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.
Yes. That is right. If you have worked with lots of customers, providing a list of customers consumes lot of space and nobody reads it anyway! Why not show the customers you have worked with in a region or globally by plotting them on a map? Here is how you do it – in just 2 minutes – if you have the data ready.
Feature introduced in 2013. Brilliant implementation. But no use. Because nobody noticed it. Those who noticed it did not understand EXACTLY how to use it. Sad story.
We are used to bar charts. But do you know that we can add bar charts within cells? Have a look and see what you were missing all this while! (These have been there for 8 years).
Lot has been written about it. With Excel 2013, Microsoft did the smartest thing. They added a chart type called Recommended Charts. Now Excel is smart enough to look at what data you have selected and choose the most appropriate chart types for you.
It shows the preview of those charts using YOUR data.
Final decision, of course, is yours. So you choose the one which depicts the information in the most relevant way. Also notice a feature called Recommended Pivot Tables.
The most important thing is to STOP using the habitually familiar chart and explore what recommendations are given by Excel. It is not about making the chart which someone is asking for.
It is about finding out every piece of useful information from available data and to use it to your advantage. By the way, that THOUGHT PROCESS is called Business Intelligence!
It is also a part of Quick Analysis feature (which we will cover in the next article).
This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.
|This is not just a catchy title.
It actually happens.
Read on to find out the secret.
Estimated reading time 4 min