日本語
All
Search
Images
Videos
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
NicoVideo
Yahoo
MSN
Dailymotion
Ameba
BIGLOBE
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
7:14
YouTube
Out 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 views
Oct 14, 2010
Data Analysis Tools in Excel
7:11:45
Excel Data Analysis Full Course Tutorial (7+ Hours)
YouTube
Learnit Training
May 31, 2024
1:53:40
Introduction to Data Analysis with Excel: 2-Hour Training Tutorial
YouTube
Simon Sez IT
640K views
Mar 7, 2023
12:09
Learn 80% of Data Analysis in Excel in Just 12 Minutes
YouTube
Kenji Explains
119.6K views
7 months ago
Top videos
4:11
Categorize data in Excel | Easily categorize bank transactions using Excel
YouTube
The Efficient Accountant
26.6K views
Sep 25, 2022
4:06
Assign A Value Or Category Based On A Number Range With Formulas
YouTube
Excel Time
6.3K views
May 13, 2023
7:13
Adding a Category column to Excel data - using Excel techniques
YouTube
PrepYourData
180.3K views
May 8, 2014
Pivot Tables in Excel
8:36
Pivot Table Excel | Step-by-Step Tutorial
YouTube
Kevin Stratvert
458.6K views
11 months ago
20:49
How to Create Pivot Table in Excel
YouTube
Kevin Stratvert
2.1M views
Oct 10, 2022
13:36
Pivot Table Excel Tutorial
YouTube
Kevin Stratvert
4.9M views
May 21, 2019
Jump to key moments of How to Category Data Based On Value in Excel
7:14
From 0:00
Introduction to Categorising Data
Categorising Excel Data using VLOOKUP
YouTube
Out of the Hat Ltd
4:06
From 00:11
Introduction of Assign A Value Or Category Based On A Number Range With Formulas
Assign A Value Or Category Based On A Number Range With Formulas
YouTube
Excel Time
5:07
From 02:45
How to Add a Category to the Front
Inputting Data - Excel Basics
YouTube
Determined Data
4:11
From 03:04
Categorizing Expense Category
Categorize data in Excel | Easily categorize bank transactions using Ex
…
YouTube
The Efficient Accountant
5:35
From 02:13
Adding Links to Source Data
Consolidate Excel Data By Category or Label
YouTube
Danny Rocks
7:13
From 00:01
Introduction to Prep Your Data
Adding a Category column to Excel data - using Excel techniques
YouTube
PrepYourData
16:58
From 00:01
Introduction of MS Excel how to sum data by MONTH and CATEGORY without using a PivotTable.
MS Excel how to sum data by MONTH and CATEGORY without using a Pivot
…
YouTube
Adam Johnson
1:58
From 0:00
Introduction of Categorize Data in Excel with IFS function
Categorize Data in Excel with IFS function
YouTube
Excel Island
0:59
From 0:00
Introduction of Excel tip to get data and search from a database
Excel tip to get data and search from a database
YouTube
Excel tips & tricks XecuteTheVision
13:32
From 00:36
Formatting the Data
How to make a Bar Chart with two data categories in Excel
YouTube
Data Design Style
4:11
Categorize data in Excel | Easily categorize bank transactions usin
…
26.6K views
Sep 25, 2022
YouTube
The Efficient Accountant
4:06
Assign A Value Or Category Based On A Number Range With Formulas
6.3K views
May 13, 2023
YouTube
Excel Time
7:13
Adding a Category column to Excel data - using Excel techniques
180.3K views
May 8, 2014
YouTube
PrepYourData
16:58
MS Excel how to sum data by MONTH and CATEGORY without u
…
5.1K views
Nov 25, 2020
YouTube
Adam Johnson
4:38
Sum By Category Group in Excel
10.9K views
11 months ago
YouTube
Yes Excel
13:32
How to make a Bar Chart with two data categories in Excel
45.6K views
Oct 5, 2023
YouTube
Data Design Style
7:10
Assign Categories Based on Keywords in Excel | Check if Cell
…
85.7K views
Aug 17, 2021
YouTube
Chester Tugwell
0:27
Filter Based on Cell Value in Excel | Quick & Easy Data Filtering Trick
4.9K views
4 months ago
YouTube
MANOJ KUMAR EXCEL
2:53
How to sum values based on criteria in another column in Excel
75.4K views
Nov 28, 2022
YouTube
SpreadCheaters
1:20
How to sort data in Excel | Microsoft
84.3K views
Dec 18, 2022
YouTube
Microsoft Helps
8:03
Conditional Formatting: Highlight Rows Based On Another Cell's Val
…
491.4K views
Nov 15, 2019
YouTube
Excel Campus - Jon
1:09
How to count unique values with criteria in Excel - Count unique ite
…
67.2K views
Apr 15, 2024
YouTube
Excel Bootcamp
3:41
Excel: Populate List Based on Cell Value | Populate Rows Based on C
…
37K views
May 25, 2023
YouTube
Chester Tugwell
4:04
Discover the 1 Simple Trick to Auto-Populate Cells in Excel
6K views
7 months ago
YouTube
Anser's Excel Academy
0:19
Color Code Your Excel Data Based on Values with This Custom Form
…
1.1K views
4 months ago
YouTube
Spreadsheet Success
8:04
Auto-Populate Other Cells When Selecting Values in Excel Drop-Do
…
371K views
Nov 4, 2022
YouTube
Chester Tugwell
1:49
How to separate data in Excel based on criteria
122.5K views
Jan 12, 2023
YouTube
SpreadCheaters
8:20
Sorting by Custom Lists in Excel
50K views
Aug 28, 2023
YouTube
Technology for Teachers and Students
3:47
EASILY Lookup Values from Another Worksheet in Excel!
4.5K views
Jun 7, 2024
YouTube
Anser's Excel Academy
7:11
Lookup value based on two criteria which are Column and Row | Vloo
…
198 views
1 month ago
YouTube
Jopa Excel
3:16
How to Sum Values Based on Selection of Drop Down List in Excel
93.7K views
Aug 31, 2023
YouTube
ExcelHow Tech
4:20
How to Group by Rows and Columns in Excel
79.7K views
Aug 12, 2024
YouTube
Teacher's Tech
2:59
Split Excel Worksheet into Separate Worksheets Based on Column Val
…
57.4K views
Aug 2, 2023
YouTube
Chester Tugwell
5:47
Grouping Rows and Columns in Excel
589.2K views
Oct 3, 2022
YouTube
Technology for Teachers and Students
0:59
Create a multi-level category chart in Excel
19.9K views
Jul 1, 2019
YouTube
Excel Quick Help
1:43
How to Count Unique Categories Using COUNTA UNIQUE Function
…
5.4K views
May 13, 2024
YouTube
Data For Knowledge
4:17
How to Sum Values Based on Criteria List in Another Column in
…
5K views
Feb 7, 2024
YouTube
ExcelHow Tech
24:25
How to format data with Categories in Multiple Columns using Excel f
…
1.7K views
7 months ago
YouTube
IAHSS
12:13
Power Query Pro Tip: Lookup Keywords & Assign Categories Au
…
392 views
4 months ago
YouTube
Anser's Excel Academy
See more videos
More like this
Feedback