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
4.6K views
How to add blank rows using a helper column in Excel
ExcelSkillsLab
Microsoft Excel Excel Tips and Tricks
Top 20 Microsoft Excel Tips & Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTubeKevin Stratvert
888.3K viewsOct 23, 2020
Top 10 Excel Tips & Tricks for Beginners (Must Know)
15:17
Top 10 Excel Tips & Tricks for Beginners (Must Know)
YouTubeReza Dorrani
3.8K views2 months ago
11 Excel Tips That Will Save You HOURS ⏳
11:11
11 Excel Tips That Will Save You HOURS ⏳
YouTubeAccounts Expert
60.3K views8 months ago
Top videos
Use of Helper Column in Excel
0:54
Use of Helper Column in Excel
YouTubeXL Expert
1.9K 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.6K viewsMar 12, 2020
Using an IF formula to create a helper column
5:02
Using an IF formula to create a helper column
YouTubeExcel With JT
1.3K viewsMay 12, 2021
Microsoft Excel 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
1.8K views1 month ago
Excel Formulas and Functions - Tutorial for Beginners
11:43
Excel Formulas and Functions - Tutorial for Beginners
YouTubeKevin Stratvert
296.6K views11 months ago
Excel Full Course 2026 | Excel Tutorial | Complete Microsoft Excel Course In 48 Hours | Simplilearn
45:52:37
Excel Full Course 2026 | Excel Tutorial | Complete Microsoft Excel Course In 48 Hours | Simplilearn
YouTubeSimplilearn
135.4K views1 month ago
Use of Helper Column in Excel
0:54
Use of Helper Column in Excel
1.9K 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.6K viewsMar 12, 2020
YouTubeLearn Tech - AI, Automation & Excel
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
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 C…
2.5K viewsJan 25, 2023
YouTubeXcel Hub Training Services
How Do HELPER COLUMNS in Excel Help with Data Analysis
13:57
How Do HELPER COLUMNS in Excel Help with Data Analysis
94 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
238 viewsApr 8, 2025
YouTubeCompetency Vidz
How to insert a helper column? (2 Solutions!!)
1:38
How to insert a helper column? (2 Solutions!!)
237 viewsAug 1, 2021
YouTubeRoel Van de Paar
10:18
What are Helper Cells? (3 Excel examples w/ these intermediate st…
1K viewsMar 23, 2025
YouTubeAnn K. Emery
9:52
Stop Using Helper Columns in Excel (Do This Instead)
27.1K views4 months ago
YouTubeOfficeNewb.com
1:01
Effortlessly Adding or Removing Rows and Columns in Excel QUIC…
9.4K views7 months ago
YouTubeSharePoint Dougie
0:22
How to add blank rows using a helper column in Excel
4.6K viewsSep 13, 2024
YouTubeExcelSkillsLab
0:54
Where should you insert the helper columns?
604 viewsMar 17, 2022
YouTubeExcel Clinic
0:15
Add Blank Rows in Excel Instantly! ⚡ #Shorts
561 views7 months ago
YouTubeSmart Workflow
2:27
Why Use Helper Columns For Advanced Excel Sorting? - Docs a…
76 views6 months ago
YouTubeDocs and Sheets Pro
0:48
Add a column from an example in Excel
255.3K viewsJan 3, 2019
YouTubeMicrosoft 365
0:15
Master Excel Like a Pro: How to Insert Columns and Rows with Ease
2.3K views9 months ago
YouTubeIntrovert Excel
3:50
How to Modify Rows and Columns in Excel
479 views3 months ago
YouTubeCoursera
1:48
How to Add Columns in Excel (Advanced Methods) | Smart Exce…
100 views1 month ago
YouTubeReyanshNextGen
1:37
How To Insert Or Add A Column (Or Multiple Columns) In An Excel Spr…
10.6K viewsJul 3, 2023
YouTubeWhats Up Dude
8:02
Adding and Deleting Columns and Rows in Excel
86.4K viewsJun 20, 2022
YouTubeTechnology for Teachers and Students
2:16
4 Easy Ways to Add Columns in Excel (Step by Step)
1.7K viewsApr 11, 2023
YouTubeExtendOffice
3:23
How To Insert Columns In Microsoft Excel
4.1K viewsFeb 5, 2024
YouTubeExcel 10 tutorial
0:44
How to Add Columns in Excel - Full Guide
95 viewsJan 5, 2024
YouTubeOne Minute How Tos
0:54
How to insert or delete rows and columns in Microsoft Excel
491.5K viewsFeb 25, 2021
YouTubeMicrosoft 365
3:40
How to Create Column Headers in Excel
46.5K viewsDec 7, 2023
YouTubeExcelDemy
0:52
Adding MORE Columns in Excel Made EASY!
8.2K viewsNov 10, 2024
YouTubeBright Minds Hub
9:03
Advanced Filters in Excel | How to Filter and Copy Data with Multiple …
25.7K viewsJan 31, 2025
YouTubeAnser's Excel Academy
1:18
How to Add Column in Excel
50 views10 months ago
YouTubeMicrosoft Expert
12:53
Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Colum…
42K viewsMar 16, 2014
YouTubeexcelisfun
See more videos
Static thumbnail place holder