Act Now: Discover one new and useful thing from familiar data
We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost. Act
We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost. Act
Some documents seem to be so cluttered with these blue wavy lines that we cannot read the content at all. Here is a solution to this problem and explanation of
Consider a pivot table which has many fields in row as well as column area. Now, for whatever reason, you have to transpose the pivot table. Whatever is in the
You must experience the earlier article in order to make sense of this one. In this article, we will learn two more useful things which help in changing values in
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
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
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.
