Knowledge Pack: Data Analytics
Data Analysis and Reports has been a major theme for my articles so far. Here is a collection of 50+ articles, categorized and sorted in the recommended reading order. Enjoy!
Data Analysis and Reports has been a major theme for my articles so far. Here is a collection of 50+ articles, categorized and sorted in the recommended reading order. Enjoy!
This feature has been around for two decades. It is high time you know it! Decide the sort order once and use it lifelong. Estimated reading time 10 min
Please read the previous article first. Filters are not just for filtering. They also convey additional information. Very useful feature. Check this out. Estimated reading time 10 min
All of us use the Filter area in Pivot Tables. Do you know there is a more powerful way that has been available for 5 years? Learn it and use
Analytics is all about summarizing and grouping. Numbers are grouped into bins, text is categorized and dates are compressed into months, quarters and years. This series covers various quick and
Yes. We don’t know how to open files! This is the second part. Read the first part first. Estimated reading time 4 min
Creating software demos videos requires you to do Screen Recording. Sometimes you need to record your entire live session. Video camera is NOT needed. Here are various software solutions available
The Recent File List shows few recently opened documents. But if you right click there, many more useful things are available… It is also a good example of how we can
If you use sample files and deliver demos or training sessions, this article is for you. Often we open the demo file and it is saved with changes. This article
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.
