How to Categorize Data in Excel

How to categorise data into value bands. Much more elegant and maintainable than nested IFs, this technique enables you to allocate categories based on the values in a particular column. In the example, a list of people's ages is categorised into bands such as 17-39, 40-44, 45-50, etc.

85.5K viewsOct 14, 2010

Data Analysis in Excel

5:52

Excel Data Analysis Tutorial

YouTubeTEKNISHA

667.3K viewsJun 12, 2017

6:33

Excel Multiple Regression

YouTubeSoftTech Tutorials

239.6K viewsMar 9, 2021

7:16

Data analysis using Microsoft Excel

YouTubeResearch Tips

186.7K viewsAug 28, 2019

Top videos

1:20

How to sort data in Excel | Microsoft

YouTubeMicrosoft Helps

80.6K viewsDec 18, 2022

4:11

Categorize data in Excel | Easily categorize bank transactions using Excel

YouTubeThe Efficient Accountant

26.6K viewsSep 25, 2022

5:47

Grouping Rows and Columns in Excel

YouTubeTechnology for Teachers and

589.2K viewsOct 3, 2022

Pivot Tables in Excel

4:35

Excel: Intro to PivotTables

YouTubeLearnFree

561K viewsFeb 8, 2016

9:22

MS Excel Pivot Table in Tamil

YouTubeEndless Knowledge

Mar 30, 2020

9:10

Excel 2010 - Creating Pivot Tables

YouTube30MinuteStats

270.4K viewsNov 9, 2012

1:20

Find in video from 00:01Sort the data in your table

How to sort data in Excel | Microsoft

80.6K viewsDec 18, 2022

YouTubeMicrosoft Helps

4:11

Find in video from 02:01Categorizing Vendor

Categorize data in Excel | Easily categorize bank transactions usin…

26.6K viewsSep 25, 2022

YouTubeThe Efficient Accountant

5:47

Find in video from 00:29Hiding Data from Divisions

Grouping Rows and Columns in Excel

589.2K viewsOct 3, 2022

YouTubeTechnology for Teachers and Students

16:51

Find in video from 00:47Checking Your Data

How to SORT Data in Excel | 7 Tips

118.9K viewsJul 26, 2022

YouTubeChris Menard

How To Sort Data In Excel But Keep Rows Together - Full Guide

1:03

Find in video from 00:10Selecting Data and Sorting by Month

How To Sort Data In Excel But Keep Rows Together - Full Guide

1.9K viewsAug 2, 2024

YouTubeGuideRealm

13:29

Find in video from 00:01Introduction to Sorting and Filtering Data

Excel Sorting and Filtering Data

1M viewsJun 7, 2018

YouTubeThe Organic Chemistry Tutor

7:38

Find in video from 00:02Introduction to Sorting

Sorting in Excel - Basics and Beyond

502.5K viewsNov 15, 2021

YouTubeTechnology for Teachers and Students

4:31

Find in video from 00:08Introduction to Sorting Data

Excel: Sorting Data

1.1M viewsFeb 8, 2016

YouTubeLearnFree

1:58

Categorize Data in Excel with IFS function

292 viewsSep 20, 2023

YouTubeExcel Island

5:05

Find in video from 0:00Introduction to Sorting and Filtering Data

Sorting and Filtering Data in Excel | How to Organize and Search Data …

2.3K views10 months ago

YouTubeLet Me Explain

1:14

Find in video from 0:00Introduction to Organizing Excel Data

5 Simple Tips To Organize Excel Data

29.8K viewsJun 22, 2022

YouTubePete - HowToAnalyst

1:15

How to categorize data in Excel with QuickRows

1.5K viewsAug 29, 2021

YouTubeQuickRows

1:27

Find in video from 01:05Verifying the Sorted Data

How to sort in Excel but keep rows together

165.5K viewsOct 26, 2022

YouTubeSpreadCheaters

12:29

Find in video from 03:06Sorting Categories

Excel spreadsheet with macros for (super quick) categorizing of data.

38.2K viewsDec 3, 2017

YouTubeMichael Dew

6:16

Find in video from 0:00Introduction to Sorting and Filtering

How to Sort and Filter Data in Excel 2016

147.8K viewsMar 5, 2018

YouTubeKnowledgeCity

7:13

Find in video from 00:01Introduction to Prep Your Data

Adding a Category column to Excel data - using Excel techniques

180.3K viewsMay 8, 2014

YouTubePrepYourData

8:20

Find in video from 00:02Introduction to Custom Sorting

Sorting by Custom Lists in Excel

50K viewsAug 28, 2023

YouTubeTechnology for Teachers and Students

4:20

How to Group by Rows and Columns in Excel

70.1K viewsAug 12, 2024

YouTubeTeacher's Tech

0:59

Create a multi-level category chart in Excel

19.8K viewsJul 1, 2019

YouTubeExcel Quick Help

24:25

How to format data with Categories in Multiple Columns using Excel f…

1.7K views7 months ago

YouTubeIAHSS

11:40

Find in video from 01:46Types of Data in Excel

Microsoft Excel Tutorial - Organizing Data

21.5K viewsMar 14, 2020

YouTubeProgrammingKnowledge

20:14

Find in video from 00:23Setting Up the Data

How to Create a Frequency Distribution with Categorical Data …

98.2K viewsJul 14, 2017

YouTubeLearn Something

4:47

Find in video from 00:56Copying and Pasting Data

How to Sort and Synchronize two list together and align two set of D…

171.6K viewsAug 15, 2021

YouTubeEXCEL DOERS

3:38

Find in video from 02:01Sorting Alphabetically

How to Sort Alphabetically in Excel

635.7K viewsSep 24, 2019

YouTubeExcel Tutorials by EasyClick Academy

4:13

Find in video from 00:03Introduction to Grouping Data

How to group data in Excel into buckets or groupings

186.4K viewsFeb 19, 2019

YouTubeGareth Thomas

11:42

Sort Data in Excel | DATA SORTING | DETAILS EXPLAINED

293 views4 months ago

YouTubeExcel Wale Sir

3:28

Find in video from 0:00Introduction to Sorting Data

How to sort data in Excel

Feb 15, 2023

YouTubeTechOnTheNet

4:23

Find in video from 00:22How to Sort by Clos Date

Mastering Excel Sorting: Organize Your Data Like a Pro | Excel Tutori…

47 viewsAug 21, 2024

YouTubeMr. Tutorial

4:26

How to Use the Percentile Function in Excel to Categorize Large Datas…

406 viewsMay 25, 2024

YouTubeEngineeringly

See more videos

Top suggestions for How to Categorize Data in Excel