# Tag: Pivot Tables

###### Knowledge Pack – Data Grouping (Text, Numbers and Dates)

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

###### Date Time Grouping using Pivot Table

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

###### Custom Date Grouping using VLOOKUP

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

###### Grouping Dates into months, quarters and years – in seconds!

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

###### Ageing Analysis (Bin Analysis) using VLOOKUP – Part 3

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

###### Ageing analysis in seconds (Number Grouping in Pivot Table)

Bin or Bucket Analysis is a common requirement. We will see how easy this is using Grouping feature of Pivot Table. Estimated reading time 10 min

###### Microsoft Excel: Grouping Text in Pivot Tables

Grouping is very powerful. It allows you to combine multiple related items into fewer (or one) item. The most primitive form of grouping is with Text. However, it is extremely

###### The amazing Calculated Items in Pivot Tables

In the last article we saw how to use Calculated Fields. Now we will explore Calculated Items. Most people have never noticed them for 20 years. But WOW!! What a

###### Pivot: Running Totals and Ranking

In this article we will see how to manage running totals and Ranking within Pivot Table calculations. Estimated reading time 7 min

## Pivot Table Pro Course

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.

## Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

##### Subscribe to Blog

Join 1,757 other subscribers

0
Efficiency Best Practices by Dr Nitin

## Dr Nitin Paranjape

0
Efficiency Best Practices