Why and how to use recommended charts in Excel
There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are blindly created
There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are blindly created
Office 2016 has introduced two new charts for hierarchical data: Treemap and Sunburst. Let us explore Sunburst in this article. These charts do NOT work as Pivot Charts. We will
Excel provides a direct feature. Select multiple sheets and select the desired range. Home – Clear – Clear Hyperlinks.The default blue color and underline is NOT removed. Therefore, you may
This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single
Outlook is great. But our outlook towards Outlook is not! That is why we waste lot of our precious time in doing the wrong things in and around Outlook. I
This article is for IT professionals only. The language is technical. As a user it is not relevant to you. IT presentations say “IT is an enabler”. But ask any
This is the first thing you should do when you get Office 2016. There are three options available. Choose the one which suits you the best. Try each for few
This is not specific to Office 365 – it is a general phenomenon. IT professionals are especially prone to this “What’s New Syndrome”. Whenever any product is being considered for
Knowledge Pack is like a live book. I write articles in random order. But later I put combine them in the recommended reading order by topic. This list is called
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
