How to compare percentage values accurately
This dangerous mistake while comparing percentages: I really don’t know how the world is still working. This is probably the most useful service I have done to humanity till date! It
This dangerous mistake while comparing percentages: I really don’t know how the world is still working. This is probably the most useful service I have done to humanity till date! It
Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real
Feature introduced in 2013 for quick analysis in Excel. Brilliant implementation. But no use. Because nobody noticed it. Those who noticed it did not understand EXACTLY how to use it.
Power Query is an amazing tool for importing and cleaning up data from various sources. The problem was that it required you to have professional version of Office. Now that
There are two simple approaches in reversing row order. One is to add an extra column with serial numbers and then sort on that column in descending order. This works
See any report – data comes first and then the grand total (or other summary calculations). What does the viewer of the report want to look at first? The Grand
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!
Well, table row breaking across page is a common frustration. I will give the answer. But there is a much more important learning to be done here. Read on…
Usually, everyone talks about Best Practices. However, we should not underestimate the importance of Worst Practices. What is that? It is not just a reverse of Best Practices. It is
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.
