Using color to simplify interpretation and enhance analysis
Older version of Excel could display only 52 colors. New version (2007 onwards) can display 16 million colors. Yes, that sounds like an overkill, but Excel uses this extra capability
Older version of Excel could display only 52 colors. New version (2007 onwards) can display 16 million colors. Yes, that sounds like an overkill, but Excel uses this extra capability
Power Query is undergoing rapid enhancements based upon feedback received from users. On 29th May another new update was announced. If you are using Power Query, please update it to
Multiple columns are easier to read – especially when printed. That is a good thing. But when we have to read a multiple column document on-screen, it becomes more cumbersome.
This is a practical problem I faced recently. Found a simple but useful solution. So I am sharing it with you. I am sure you will also find it useful…
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up
How to keep the audience awake? That is the biggest problem we have while presenting. The less boredom you create, the higher is the chance of people being awake Boring
Using PowerPoint you can convert simple bullets to high-impact diagrams in seconds. Here we learn how to create SWOT analysis diagram and more. Refer to these articles to learn a
Please read the previous article so that you understand the context of this article. In the previous article we saw how to divide available data into three categories: High, Medium,
We get lot of data and reports every day. Usually, to understand the information easily, we draw charts. Nothing wrong with that. Except that there are other methods available which may
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.
