Old is gold: Scroll bar in Excel (not that one)
I just wrote many articles on what is new in Excel 2016. But there is a goldmine of useful stuff in Excel since decades – which is completely unknown to
I just wrote many articles on what is new in Excel 2016. But there is a goldmine of useful stuff in Excel since decades – which is completely unknown to
Arranging two windows side by side: This in itself is not a new feature. But it was enhanced in Windows 10. Have a look. You may not know it, but
Now that we know about Excel Recommended Charts, let us explore it in-depth. This is an implementation of artificial intelligence or machine learning at your fingertips. Don’t underestimate it… exploit
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
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.
