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
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
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
We explore a very powerful and extremely useful approach to bin analysis using VLOOKUP. Estimated reading time 10 minEstimated time saving many hours (if you were doing this manually)This is
Let us explore numeric grouping in Pivot Table with the Ageing Analysis scenario. Estimated reading time 7 min Estimated time saving – hours!