Adding a Category column to Excel data - using Excel techniques
7:13
YouTubePrepYourData
Adding a Category column to Excel data - using Excel techniques
A common problem in getting data clean and ready for analysis is adding a column that classifies the rows into a set of types (or groups, or categories). In this video we are assigning cities to sales regions based on their state. Three different techniques are shown and compared. The final technique is much quicker and less error prone than ...
180.3K viewsMay 8, 2014
Shorts
Dynamic Dependent Dropdown Lists in Excel: create and manage all the categories you need - T0032
29:44
31.2K views
Dynamic Dependent Dropdown Lists in Excel: create and manage all the
Celia Alves - Solve & Excel
How to Create Table with Subcategory in Excel
6:42
How to Create Table with Subcategory in Excel
ExcelDemy
Microsoft Excel Excel Tips and Tricks
Top 20 Microsoft Excel Tips & Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTubeKevin Stratvert
826.4K viewsOct 23, 2020
50 Ultimate Excel Tips and Tricks for 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTubeSele Training
1.9M viewsMar 17, 2020
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTubeSimon Sez IT
96.9K viewsJan 9, 2024
Top videos
Create a multi-level category chart in Excel
0:59
Create a multi-level category chart in Excel
YouTubeExcel Quick Help
19.9K viewsJul 1, 2019
Sum By Category Group in Excel
4:38
Sum By Category Group in Excel
YouTubeYes Excel
10.9K views11 months ago
MS Excel how to sum data by MONTH and CATEGORY without using a PivotTable.
16:58
MS Excel how to sum data by MONTH and CATEGORY without using a PivotTable.
YouTubeAdam Johnson
5.1K viewsNov 25, 2020
Microsoft Excel Excel Formulas
How to create formulas in Microsoft Excel
1:38
How to create formulas in Microsoft Excel
YouTubeMicrosoft 365
386.2K viewsFeb 17, 2021
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
9:51
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
YouTubeSubjectmoney
12.1K viewsDec 30, 2012
How to use Formulas and Functions in Microsoft Excel
26:26
How to use Formulas and Functions in Microsoft Excel
YouTubeTeacher's Tech
425.4K viewsApr 19, 2021
Create a multi-level category chart in Excel
0:59
Create a multi-level category chart in Excel
19.9K viewsJul 1, 2019
YouTubeExcel Quick Help
Sum By Category Group in Excel
4:38
Sum By Category Group in Excel
10.9K views11 months ago
YouTubeYes Excel
MS Excel how to sum data by MONTH and CATEGORY without using a PivotTable.
16:58
MS Excel how to sum data by MONTH and CATEGORY without u…
5.1K viewsNov 25, 2020
YouTubeAdam Johnson
Dynamic Dependent Dropdown Lists in Excel: create and manage all the categories you need - T0032
29:44
Dynamic Dependent Dropdown Lists in Excel: create and manage all th…
31.2K viewsFeb 20, 2023
YouTubeCelia Alves - Solve & Excel
How to Create Table with Subcategory in Excel
6:42
How to Create Table with Subcategory in Excel
Apr 21, 2024
YouTubeExcelDemy
Create a Multi-Category Chart in Excel | Multi-Level Category Labels in Excel Chart
6:45
Create a Multi-Category Chart in Excel | Multi-Level Category Label…
22.4K viewsSep 30, 2021
YouTubeChester Tugwell
How to categorize data in Excel with QuickRows
1:15
How to categorize data in Excel with QuickRows
1.5K viewsAug 29, 2021
YouTubeQuickRows
3:18
Excel - Adding Subtotals to Specific Categories in Excel - Episode 2432
4.1K viewsOct 7, 2021
YouTubeMrExcel.com
7:26
How to Create Multi-Category Chart in Excel
182.1K viewsJun 14, 2017
YouTubeExcel Board
7:35
Setup CATEGORIES to Track Expenses in EXCEL | SYNC for FR…
84.7K viewsJan 21, 2022
YouTubeMoney with Dan
9:54
How to Make Multi Category or Subcategory Chart in Excel
47K viewsJun 29, 2020
YouTubeHasaan Fazal
4:39
How to Add Category AND Data Labels to the Same Bar Chart in E…
33.2K viewsFeb 9, 2022
YouTubeSpotlight Impact Data Design
11:25
How to Add a Multi-racial Category to Select-all-that Apply Demograp…
1.9K viewsMar 1, 2024
YouTubeSpotlight Impact Data Design
0:22
Group & Summarize Data Instantly! Use GROUPBY in Excel!
1.1K views6 months ago
YouTubeSpreadsheet Success
7:40
How to use the SUMIF and SUMIFS Functions in Microsoft Excel for B…
287.8K viewsOct 25, 2021
YouTubeTeacher's Tech
11:13
How to do SUMIF with Multiple Columns Tutorial - SUMIFS in Excel
158.8K viewsMar 29, 2021
YouTubeSimon Sez IT
8:10
How to Create Multi-Category Column/Bar Chart in Excel
75.5K viewsJan 12, 2021
YouTubeTeaching Junction
0:56
How to use the SUMIF function in Microsoft Excel
2.2M viewsDec 4, 2019
YouTubeMicrosoft 365
0:38
How to use the SUM function in Microsoft Excel
2.9M viewsDec 4, 2019
YouTubeMicrosoft 365
4:25
How to SUMIFS With Multiple Criteria In the SAME Column in Ex…
465.1K viewsAug 19, 2021
YouTubeLeila Gharani
3:16
How to Sum Values Based on Selection of Drop Down List in Excel
93.7K viewsAug 31, 2023
YouTubeExcelHow Tech
1:23
SUM Unique Values With the UNIQUE function in Excel
25.3K viewsDec 27, 2021
YouTubeJie Jenn
2:53
How to sum values based on criteria in another column in Excel
75.4K viewsNov 28, 2022
YouTubeSpreadCheaters
6:12
The Excel SUMIFS Function
918.4K viewsOct 26, 2020
YouTubeTechnology for Teachers and Students
3:35
Adding category name to a pie chart in Excel
37.8K viewsMay 18, 2020
YouTubeRicky Manders
8:13
Track Expenses by CATEGORY in Excel | SYNC with bank for FREE #3
27.1K viewsJan 26, 2022
YouTubeMoney with Dan
1:00
XLOOKUP in Excel in Under a Minute: Return a Category Fast!
2K viewsAug 6, 2024
YouTubeSimon Sez IT
1:06
How to Add Categories in Excel (2025)
5 months ago
YouTubeMoon Tutorials
6:25
Adding a Category Column to an Excel Spreadsheet - using PrepYo…
2.7K viewsMay 29, 2014
YouTubePrepYourData
See more videos
Static thumbnail place holder

Short videos

7:13
Adding a Category column to Excel data - using Excel tec…
180.3K viewsMay 8, 2014
YouTubePrepYourData
0:59
Create a multi-level category chart in Excel
19.9K viewsJul 1, 2019
YouTubeExcel Quick Help
4:38
Sum By Category Group in Excel
10.9K views11 months ago
YouTubeYes Excel
16:58
MS Excel how to sum data by MONTH and CATEGORY wi…
5K viewsNov 25, 2020
YouTubeAdam Johnson
29:44
Dynamic Dependent Dropdown Lists in Excel: c…
31.2K viewsFeb 20, 2023
YouTubeCelia Alves - Solve & Excel
6:42
How to Create Table with Subcategory in Excel
Apr 21, 2024
YouTubeExcelDemy
6:45
Create a Multi-Category Chart in Excel | Multi-Level Categ…
22.4K viewsSep 30, 2021
YouTubeChester Tugwell
1:15
How to categorize data in Excel with QuickRows
1.5K viewsAug 29, 2021
YouTubeQuickRows
7:40
How to use the SUMIF and SUMIFS Functions in Micro…
287.8K viewsOct 25, 2021
YouTubeTeacher's Tech
7:26
How to Create Multi-Category Chart in Excel
182.1K viewsJun 14, 2017
YouTubeExcel Board
11:13
How to do SUMIF with Multiple Columns Tutorial …
158.8K viewsMar 29, 2021
YouTubeSimon Sez IT
7:35
Setup CATEGORIES to Track Expenses in EXCEL | SYN…
84.7K viewsJan 21, 2022
YouTubeMoney with Dan
9:54
How to Make Multi Category or Subcategory Chart in Ex…
47K viewsJun 29, 2020
YouTubeHasaan Fazal
4:39
How to Add Category AND Data Labels to the Same Ba…
33.2K viewsFeb 9, 2022
YouTubeSpotlight Impact Data Design
11:25
How to Add a Multi-racial Category to Select-all-that …
1.9K viewsMar 1, 2024
YouTubeSpotlight Impact Data Design
0:22
Group & Summarize Data Instantly! Use GROUPBY i…
1.1K views6 months ago
YouTubeSpreadsheet Success
3:18
Excel - Adding Subtotals to Specific Categories in Exce…
4.1K viewsOct 7, 2021
YouTubeMrExcel.com
6:25
Adding a Category Column to an Excel Spreadsheet - usi…
2.7K viewsMay 29, 2014
YouTubePrepYourData
0:56
How to use the SUMIF function in Microsoft Excel
2.2M viewsDec 4, 2019
YouTubeMicrosoft 365
0:38
How to use the SUM function in Microsoft Excel
2.9M viewsDec 4, 2019
YouTubeMicrosoft 365
Static thumbnail place holder