This channel is all about various job competency learning e.g. soft skills, technical skills, leadership, professional & technical competency, et al.

Help us make this channel grow by subscribing, liking, commenting and sharing.

Delete empty rows using VBA code.
4:39
Delete empty rows using VBA code.
How to create a weekly planner with dynamic dates
7:56
How to create a weekly planner with dynamic dates
Save file with timestamp using vba code
4:48
Save file with timestamp using vba code
Add validation dropdown using VBA code
5:39
Add validation dropdown using VBA code
Create dynamic chart in VBA
6:09
Create dynamic chart in VBA
Auto-generate invoice from dropdown selection
6:36
Auto-generate invoice from dropdown selection
When to use IFERROR or IFNA. #exceltips #exceltricks
4:56
When to use IFERROR or IFNA. #exceltips #exceltricks
How to record a macro.
3:59
How to record a macro.
Naming ranges #exceltips #exceltricks
4:55
Naming ranges #exceltips #exceltricks
Use SORT + FILTER together in Excel 365 & sort filtered values in descending order
3:58
Use SORT + FILTER together in Excel 365 & sort filtered values in descending order
Use Subtotal for your Data Analysis
4:08
Use Subtotal for your Data Analysis
Declare different kinds of variables in VBA
15:21
Declare different kinds of variables in VBA
How to determine the IHP and BHP of CAT 3516 V16 Engine in Excel format
5:38
How to determine the IHP and BHP of CAT 3516 V16 Engine in Excel format
How to create a Gravity Flow Rack Slope Calculator | Dynamic Rack System
12:26
How to create a Gravity Flow Rack Slope Calculator | Dynamic Rack System
How to calculate double declining depreciation using DDB. #exceltricks #exceltips #excelformula
3:15
How to calculate double declining depreciation using DDB. #exceltricks #exceltips #excelformula
Using the IFNA Function in Excel #exceltips #exceltricks #excelformula #excelfunction
5:58
Using the IFNA Function in Excel #exceltips #exceltricks #excelformula #excelfunction
Exploring Exponents and the Power Function in Excel
26:25
Exploring Exponents and the Power Function in Excel
How Do Helper Columns in Excel Help with Data Analysis
13:57
How Do Helper Columns in Excel Help with Data Analysis
Extracting the First Name, Middle Name, Last Name using the LEFT, MID, & RIGHT Functions, and VBA
40:50
Extracting the First Name, Middle Name, Last Name using the LEFT, MID, & RIGHT Functions, and VBA
Effortless Data Updates: FIND & REPLACE in Excel Explained || Speed Up Your Workflow
13:41
Effortless Data Updates: FIND & REPLACE in Excel Explained || Speed Up Your Workflow
Excel Standard Deviation STDEV.S vs STDEV.P Explained | Find Data Variability Fast.
6:57
Excel Standard Deviation STDEV.S vs STDEV.P Explained | Find Data Variability Fast.
Advanced Lookup using Index and Match with An Array Formula
6:07
Advanced Lookup using Index and Match with An Array Formula
Using Transpose to Flip Data Rows to Columns and Vice Versa
3:44
Using Transpose to Flip Data Rows to Columns and Vice Versa
Using an Array Formula to Find and Add Large Numbers in Excel
3:08
Using an Array Formula to Find and Add Large Numbers in Excel
How to Create a Dynamic Running Total using an Array Formula
3:23
How to Create a Dynamic Running Total using an Array Formula
How VLookUp and XLookUp Work for Data Searching
5:02
How VLookUp and XLookUp Work for Data Searching
Array Formulas
1:24
Array Formulas
How to Create a Dynamic Broiler Production Planning Calculator Using Excel VBA
1:17:15
How to Create a Dynamic Broiler Production Planning Calculator Using Excel VBA
Automated Cost Performance Analysis for Managers
58:17
Automated Cost Performance Analysis for Managers
Automating the Preventive Maintenance Scheduling of Heavy Equipment Using the Excel VBA
49:53
Automating the Preventive Maintenance Scheduling of Heavy Equipment Using the Excel VBA