The curious case of Column Widths in Word tables
There is a story hidden behind these options. The story of how we work and how Word is trying to help us. Learn these options and manage column widths in
There is a story hidden behind these options. The story of how we work and how Word is trying to help us. Learn these options and manage column widths in
Yes, you have been copying formulas for decades. I know. But you don’t know the most efficient method – most probably! Try it out. Spend just 4 minutes of your
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!
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
Grouping is turning out to be a loooong series! But this looks like the last article in the series. How to handle date time grouping using Pivot Table. Summarize without
Date grouping using custom quarters or periods can be done using VLOOKUP. This is a very powerful and quick method for creating reports. Estimated reading time 7 min Potential time
We continue to explore Pivot Table Grouping. This time we work with grouping dates. If you do this manually, the method shown here is like a miracle for you. Estimated
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.
