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

image 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 powerful methods to perform sophisticated grouping in seconds.

Estimated reading time 10 min

The Need

Raw data is usually captured at the lowest level. We need to summarize and categorize it to interpret and analyze it.

This knowledge pack consists of a series of articles which cover Pivot Table, VLOOKUP, and other techniques to group three data types available in Excel : Text, Numbers and Dates.

It is an invaluable reference for common reporting requirements like ABC analysis, Ageing Analysis, Monthly and Quarterly reports, Volume Value Analysis and so on.

Data Grouping Articles

Here is a list of articles. I recommend that you read the articles in the order shown below. Each article builds upon the previous one. All articles have sample files which can be used to follow the instructions.

Once you learn the concepts, try using it on real-life data. This will help you understand the tweaking required to apply this knowledge to your business.

Finally, make sure you share this knowledge with your colleagues, bosses and friends.

  1. Grouping Text in Pivot Tables
  2. How to correct spelling mistakes while analyzing data?
  3. Ageing analysis in seconds (Number Grouping in Pivot)
  4. Ageing Analysis (Numeric Grouping in Pivot) – Part 2
  5. Ageing Analysis (Bucket Analysis) using VLOOKUP – Part 3
  6. Grouping Dates into months, quarters and years – in seconds!
  7. Custom Date Grouping using VLOOKUP
  8. Grouping with Date – Time Data using Pivot

Do post your thoughts, feedback and suggestions. Enjoy.


3 thoughts on “Knowledge Pack – Grouping Data (Text, Numbers and Dates)

  1. Pingback: Knowledge Pack: Data Analytics | Efficiency 365

  2. Pingback: Why do I blog in random order? | Efficiency 365

  3. Pingback: List of Knowledge Packs | Efficiency 365

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s