Categorising Excel Data using VLOOKUP
7:14
YouTubeOut of the Hat Ltd
Categorising Excel Data using VLOOKUP
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 amharc14 DFómh 2010
Data Analysis Tutorial
Data Analyst Full Course 2025 | Data Analytics Tutorial for Beginners | Data Analysis | Simplilearn
10:13:39
Data Analyst Full Course 2025 | Data Analytics Tutorial for Beginners | Data Analysis | Simplilearn
YouTubeSimplilearn
15.3K amharc10 months ago
Data Analytics Full Course 2025 | Data Analytics Tutorial | Data Analyst Course | Simplilearn
11:20:04
Data Analytics Full Course 2025 | Data Analytics Tutorial | Data Analyst Course | Simplilearn
YouTubeSimplilearn
17.9K amharc3 months ago
Data Analytics Full Course 2025 | Data Analytics Tutorial | Data Analyst Course | Simplilearn
11:19:05
Data Analytics Full Course 2025 | Data Analytics Tutorial | Data Analyst Course | Simplilearn
YouTubeSimplilearn
9K amharc5 months ago
Barrfhíseáin
Categorize data in Excel | Easily categorize bank transactions using Excel
4:11
Categorize data in Excel | Easily categorize bank transactions using Excel
YouTubeThe Efficient Accountant
26.6K amharc25 MFómh 2022
Assign A Value Or Category Based On A Number Range With Formulas
4:06
Assign A Value Or Category Based On A Number Range With Formulas
YouTubeExcel Time
6.3K amharc13 Beal 2023
Adding a Category column to Excel data - using Excel techniques
7:13
Adding a Category column to Excel data - using Excel techniques
YouTubePrepYourData
180.3K amharc8 Beal 2014
Excel Pivot Tables
Pivot Table Excel Tutorial
13:36
Pivot Table Excel Tutorial
YouTubeKevin Stratvert
4.8M amharc21 Beal 2019
How to Create Excel Pivot Tables & Pivot Charts - Beginner's Guide
18:02
How to Create Excel Pivot Tables & Pivot Charts - Beginner's Guide
YouTubeTeacher's Tech
154.2K amharc11 Noll 2023
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
13:22
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
YouTubeLeila Gharani
4.1M amharc18 Meith 2020
Categorize data in Excel | Easily categorize bank transactions using Excel
4:11
Categorize data in Excel | Easily categorize bank transactions using E…
26.6K amharc25 MFómh 2022
YouTubeThe Efficient Accountant
Assign A Value Or Category Based On A Number Range With Formulas
4:06
Assign A Value Or Category Based On A Number Range With Formulas
6.3K amharc13 Beal 2023
YouTubeExcel Time
Adding a Category column to Excel data - using Excel techniques
7:13
Adding a Category column to Excel data - using Excel techniques
180.3K amharc8 Beal 2014
YouTubePrepYourData
Categorical scatter plot in Excel
17:30
Categorical scatter plot in Excel
19.6K amharc30 Iúil 2021
YouTubePeter Klappa
How to format data with Categories in Multiple Columns using Excel functions
24:25
How to format data with Categories in Multiple Columns using Excel functio…
1.7K amharc7 months ago
YouTubeIAHSS
Sum By Category Group in Excel
4:38
Sum By Category Group in Excel
9.8K amharc11 months ago
YouTubeYes Excel
Filter Based on Cell Value in Excel | Quick & Easy Data Filtering Trick
0:27
Filter Based on Cell Value in Excel | Quick & Easy Data Filtering Trick
4.9K amharc4 months ago
YouTubeMANOJ KUMAR EXCEL
13:32
How to make a Bar Chart with two data categories in Excel
45.6K amharc5 DFómh 2023
YouTubeData Design Style
2:53
How to sum values based on criteria in another column in Excel
75.4K amharc28 Samh 2022
YouTubeSpreadCheaters
4:17
How to Sum Values Based on Criteria List in Another Column in Excel
5K amharc7 Feabh 2024
YouTubeExcelHow Tech
5:10
Create data validation list from Excel Table... the RIGHT WAY!
29.9K amharc16 Beal 2024
YouTubeExcel Off The Grid
5:05
How to use the FILTER Function in Excel (multiple use cases)
9.5K amharc27 Márta 2024
YouTubeExcel Dictionary
0:53
Excel Pivot Table: How To Group Values By Range
36.7K amharc27 Noll 2023
YouTubeCogwheel Learning
3:03
How to Auto Highlight Row Based on Cell Value in Excel
237.7K amharc13 Márta 2023
YouTubeThe Spreadsheet Academy
5:47
Grouping Rows and Columns in Excel
589.2K amharc3 DFómh 2022
YouTubeTechnology for Teachers and Students
4:13
How to group data in Excel into buckets or groupings
186.4K amharc19 Feabh 2019
YouTubeGareth Thomas
3:16
How to Sum Values Based on Selection of Drop Down List in Excel
93.7K amharc31 Lún 2023
YouTubeExcelHow Tech
7:07
Auto-Populate Cells From Drop-Down Selection in Excel (3 steps)
104.4K amharc7 Aib 2024
YouTubeSpreadsheeto
8:52
How to Do a Multi Column VLOOKUP in Excel (Easy Guide)
7.5K amharc5 months ago
YouTubeProductivity Land
3:47
EASILY Lookup Values from Another Worksheet in Excel!
4.5K amharc7 Meith 2024
YouTubeAnser's Excel Academy
7:11
Lookup value based on two criteria which are Column and Row | Vlooku…
198 amharc1 month ago
YouTubeJopa Excel
2:19
Group data based on column values in Excel
20.8K amharc6 Samh 2019
YouTubePrashant Jain
3:39
How to Group Data based on Percentiles in Excel - Office 365
6 DFómh 2022
YouTubeFind Easy Solution
1:50
Split one excel sheet into multiple sheets based on column value
141.4K amharc11 Lún 2022
YouTubeImprove Your Excel
1:09
How to count unique values with criteria in Excel - Count unique items …
67.2K amharc15 Aib 2024
YouTubeExcel Bootcamp
0:59
Create a multi-level category chart in Excel
19.9K amharc1 Iúil 2019
YouTubeExcel Quick Help
0:19
Color Code Your Excel Data Based on Values with This Custom Format Trick
1.1K amharc4 months ago
YouTubeSpreadsheet Success
1:00
XLOOKUP in Excel in Under a Minute: Return a Category Fast!
2K amharc6 Lún 2024
YouTubeSimon Sez IT
7:34
Scatterplots with Categorical Variables in Excel
16 Ean 2024
YouTubeLinda Williams
Féach tuilleadh físeán
Sealbhóir áite mionsamhlacha statach