Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify
Because of these two villains, millions of people waste their life struggling in Excel. Read on to find out how to handle them and eliminate them from your life.
Select regular data and choose Insert – Tables or Press CTRL T. Agreed. But there is more to it. Read on to find out the nuances…
This is a series about Excel Tables. I have covered this topic in the past but now we need more details. So let us start at the beginning. What are
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
[youtube https://www.youtube.com/watch?v=KzQiY0OFTLw?rel=0] Share data from Head Office to field staff or vice versa. All using the powerful List feature of SharePoint. Zero Programming. Anyone can do it in minutes. Try
Unbelievable analytics using Excel: [youtube https://www.youtube.com/watch?v=vcwPk3eUxkg?rel=0] Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
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
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.
