Excel - Using Helper Columns When Building Reports - A How To
15:23
YouTubeNickyDee
Excel - Using Helper Columns When Building Reports - A How To
In today's video I'll explain how helper columns can help you (LOL right) when creating reports. We'll also work thru and example showing how we implement the use of helper columns in a sumifs function. You know what the deal is, smash the like and subscribe buttons! Let me know in the comments if you need anymore help. Nick
11.8K viewsMay 30, 2020
Shorts
✅ Step-by-Step: \t1.\tAdd a Helper Column In a new column, use this formula: =IF(OR(A2=“High”, A2=“Critical”), 1, 0) \t2.\tDrag the Formula Down Copy it down the entire column so each row with “High” or “Critical” gets a 1. \t3.\tInsert a Pivot Table \t•\tGo to Insert > PivotTable \t•\tDrag the Item column into Rows \t•\tDrag the Helper Column into Values \t4.\tUpdate Value Field Settings \t•\tSet the helper field to Sum (not Count) \t5.\tCalculate the Average In a new cell, use this formula: =A
1:04
1.1K views
âś… Step-by-Step: \t1.\tAdd a Helper Column In a new column, use this formula:
theexcelguy_
How to add blank rows using a helper column in Excel
0:22
5.8K views
How to add blank rows using a helper column in Excel
ExcelSkillsLab
Excel Formulas
30 Excel Formulas Every Beginner Must Know | Excel Formulas Tutorial
15:36
30 Excel Formulas Every Beginner Must Know | Excel Formulas Tutorial
YouTubeVedakarna
3.8K views3 months ago
Excel Formulas and Functions Tutorial
12:29
Excel Formulas and Functions Tutorial
YouTubeKevin Stratvert
4.3M viewsJul 13, 2019
Excel Formulas and Functions - Tutorial for Beginners
11:43
Excel Formulas and Functions - Tutorial for Beginners
YouTubeKevin Stratvert
337.5K viewsJun 9, 2025
Top videos
Use of Helper Column in Excel
0:54
Use of Helper Column in Excel
YouTubeXL Expert
2.1K viewsJan 10, 2023
VLOOKUP with Multiple Criteria in Excel - Create a Helper column
3:24
VLOOKUP with Multiple Criteria in Excel - Create a Helper column
YouTubeLearn Tech - AI, Automation &
15.8K viewsMar 12, 2020
Part 2: MS Excel Basic Dashboard Creation Tutorial: Adding Helper Columns with Formulas for Slicers
24:47
Part 2: MS Excel Basic Dashboard Creation Tutorial: Adding Helper Columns with Formulas for Slicers
YouTubeXcel Hub Training Services
2.6K viewsJan 25, 2023
Excel Pivot Tables
Excel PivotTables Made Easy in 2026 (+ What's Changed!)
16:47
Excel PivotTables Made Easy in 2026 (+ What's Changed!)
YouTubeMyOnlineTrainingHub
40.7K views3 months ago
Excel Pivot Tables for Beginners [FULL COURSE]
1:21:55
Excel Pivot Tables for Beginners [FULL COURSE]
YouTubeMike Thomas
18.2K viewsMay 30, 2022
Excel Pivot Tables Explained in 15 Minutes | Step-by-Step Tutorial
15:57
Excel Pivot Tables Explained in 15 Minutes | Step-by-Step Tutorial
YouTubeAnalytics Gateway
3.4K views6 months ago

Jump to key moments of How to Add Helper Column in Excel

Use of Helper Column in Excel
0:54
Use of Helper Column in Excel
2.1K viewsJan 10, 2023
YouTubeXL Expert
VLOOKUP with Multiple Criteria in Excel - Create a Helper column
3:24
VLOOKUP with Multiple Criteria in Excel - Create a Helper column
15.8K viewsMar 12, 2020
YouTubeLearn Tech - AI, Automation & Excel
Part 2: MS Excel Basic Dashboard Creation Tutorial: Adding Helper Columns with Formulas for Slicers
24:47
Part 2: MS Excel Basic Dashboard Creation Tutorial: Adding Helper Columns with Formulas for Slicers
2.6K viewsJan 25, 2023
YouTubeXcel Hub Training Services
Using an IF formula to create a helper column
5:02
Using an IF formula to create a helper column
1.3K viewsMay 12, 2021
YouTubeExcel With JT
How Do HELPER COLUMNS in Excel Help with Data Analysis
13:57
How Do HELPER COLUMNS in Excel Help with Data Analysis
108 viewsApr 8, 2025
YouTubeBob Learning Hub
How Do Helper Columns in Excel Help with Data Analysis
13:57
How Do Helper Columns in Excel Help with Data Analysis
253 viewsApr 8, 2025
YouTubeCompetency Vidz
✅ Step-by-Step: \t1.\tAdd a Helper Column In a new column, use this formula: =IF(OR(A2=“High”, A2=“Critical”), 1, 0) \t2.\tDrag the Formula Down Copy it down the entire column so each row with “High” or “Critical” gets a 1. \t3.\tInsert a Pivot Table \t•\tGo to Insert > PivotTable \t•\tDrag the Item column into Rows \t•\tDrag the Helper Column into Values \t4.\tUpdate Value Field Settings \t•\tSet the helper field to Sum (not Count) \t5.\tCalculate the Average In a new cell, use this formula: =A
1:04
✅ Step-by-Step: \t1.\tAdd a Helper Column In a new column, use this formula: =IF(OR(A2=“High”, A2=“Critical”), 1, 0) \t2.\tDrag the Formula Down Copy it down the entire column so each row with “High” or “Critical” gets a 1. \t3.\tInsert a Pivot Table \t•\tGo to Insert > PivotTable \t•\tDrag the Item column into Rows \t•\tDrag the Helper Column into Values \t4.\tUpdate Value Field Settings \t•\tSet the helper field to Sum (not Count) \t5.\tCalculate the Average In a new cell, use this formula: =A
1.1K views1 year ago
TikToktheexcelguy_
0:22
How to add blank rows using a helper column in Excel
5.8K viewsSep 13, 2024
YouTubeExcelSkillsLab
16:43
Create a DYNAMIC Stacked Bar Chart - Using HELPER COLUMNS & Named FORMULAS
831 viewsMar 22, 2025
YouTubeWisdom by Data
0:15
Add Blank Rows in Excel Instantly! ⚡ #Shorts
561 views8 months ago
YouTubeSmart Workflow
2:14
Change Date Using Helper Column Simple Excel Formula for Dynamic Clarity
376 views9 months ago
YouTubeVedabala Vidyalaya
9:52
Stop Using Helper Columns in Excel (Do This Instead)
29.3K views5 months ago
YouTubeOfficeNewb.com
1:01
Effortlessly Adding or Removing Rows and Columns in Excel QUICKLY!
10.5K views8 months ago
YouTubeSharePoint Dougie
0:36
Stop Using Helper Columns in Excel (Do This Instead!)
5.9K views1 month ago
YouTubeEasy Click Learning
0:48
Add a column from an example in Excel
256.7K viewsJan 3, 2019
YouTubeMicrosoft 365
1:48
How to Add Columns in Excel (Advanced Methods) | Smart Excel Tricks for Fast Calculations #pc
102 views3 months ago
YouTubeReyanshNextGen
0:15
Master Excel Like a Pro: How to Insert Columns and Rows with Ease
2.3K views11 months ago
YouTubeIntrovert Excel
3:50
How to Modify Rows and Columns in Excel
455 views4 months ago
YouTubeCoursera
0:44
How to Add Columns in Excel - Full Guide
95 viewsJan 5, 2024
YouTubeOne Minute How Tos
0:37
How to Insert Rows and Columns in Excel - Full Guide
6 views1 month ago
YouTubeWaylohr
6:52
Insert Rows & Columns in Excel Easily | Beginner Excel Tutorial
114 views4 months ago
YouTubeLearn Smart
3:57
How To Calculate Margin Percentage in Excel
848 views5 months ago
YouTubeExcel Insider
1:05
Excel Pivot Table: How to Add a Column with Formula
21.1K viewsSep 30, 2024
YouTubeCogwheel Learning
3:23
How To Insert Columns In Microsoft Excel
4.1K viewsFeb 5, 2024
YouTubeExcel 10 tutorial
1:25
How to Add Column in Microsoft Excel 2024 (Guideline)
246 viewsSep 19, 2023
YouTubeSkill Wave
2:16
4 Easy Ways to Add Columns in Excel (Step by Step)
1.7K viewsApr 11, 2023
YouTubeExtendOffice
2:46
How to Add Up Columns in Excel
825 viewsApr 13, 2024
YouTubeProgrammingKnowledge2
0:17
How to Insert Rows and Columns in Excel
68 views1 month ago
YouTubeTK Tech Tips
0:45
How to Add Column in Excel | Insert a Column in Excel
70 viewsMay 21, 2024
YouTubeTech Related Tips
See more
Static thumbnail place holder

Short videos

0:54
Use of Helper Column in Excel
2.1K viewsJan 10, 2023
YouTubeXL Expert
1:04
âś… Step-by-Step: \t1.\tAdd a Helper Column In a new column, use this formula:
1.1K views1 year ago
TikToktheexcelguy_
0:22
How to add blank rows using a helper column in Excel
5.8K viewsSep 13, 2024
YouTubeExcelSkillsLab
1:19
VLOOKUP Multiple Criteria in Excel Explained
28.2K viewsFeb 7, 2025
TikTokeoman66
0:24
Flipping data through helper column in excel. #excel #shorts #viral
1.2K views2 months ago
YouTubeFun with Excel
0:15
Add Blank Rows in Excel Instantly! ⚡ #Shorts
561 views8 months ago
YouTubeSmart Workflow
2:14
Change Date Using Helper Column Simple Excel Formula for Dynamic Clarity
376 views9 months ago
YouTubeVedabala Vidyalaya
0:36
Stop Using Helper Columns in Excel (Do This Instead!)
5.9K views1 month ago
YouTubeEasy Click Learning
0:39
Meet lambda cumulative totals in Excel
1K views7 months ago
YouTubeXLGenAI
2:57
Variation Analysis With Trend Indicator in Excel Chart - Excel Tips and Tricks
1.1K viewsMay 17, 2025
YouTubeJasmine Jones
0:17
How to Insert Rows and Columns in Excel
68 views1 month ago
YouTubeTK Tech Tips
0:15
Master Excel Like a Pro: How to Insert Columns and Rows with Ease
2.3K views11 months ago
YouTubeIntrovert Excel
1:22
Stop Adding Extra Columns! Use Paste Special (Add & Multiply) in Excel 🔥
530 views3 months ago
YouTubeGSDATALAB
0:48
Excel New Trick 🔥 Large IF & Small IF Without Helper Column | Excel Formula | Excel
139 views4 months ago
YouTubeWebguru jee
0:14
The Excel Function That Adds in Seconds & Nobody Uses! 🤫🤯 ✅ #ExcelTips
11.2K views7 months ago
YouTubeHow To Office
0:34
Add Blank Rows Like a Pro #excel #spreadsheetmagic #microsoftexcel #exceltips
1.8K views8 months ago
YouTubeXLwithAmit
0:49
Advanced XLOOKUP Formula to Sum Multiple Columns | XLOOKUP Excel Formula You
1.3K views5 months ago
YouTubeIDEA
0:18
MS Excel Tip That Helps you Work Faster | #excel #exceltutorial #tutorialexcel
579 views5 months ago
YouTubeRuhit Sehgal
0:51
Mastering Paste Special in Excel: Add Operations Like a Pro! #shorts
817 views4 months ago
YouTubeAnalytics Advisors
0:58
Data Visualization in Excel Part 1... #viraltiktok #viralvideo #exceltips #excelformula
51.4K viewsSep 4, 2024
TikTokthe_excel_experience
Static thumbnail place holder