Hi, this is V E Meganathan.
Welcome to Excelist channel,
The sole purpose of this channel is to assist you in gaining knowledge and experience with Excel and Power Query. Here, you'll discover a plethora of tips and tricks for mastering Excel's user interface techniques and functions.
I specialize in data cleansing, transformation, and analysis using M Language. Additionally, I can assist in creating dashboards in Excel and Power BI that provide refreshable and actionable insights.

How to Generate First N Fibonacci Sequence Numbers in Excel
1:51
How to Generate First N Fibonacci Sequence Numbers in Excel
Trick in List.Accumulate Function to Add Multiple Columns in One Step
6:29
Trick in List.Accumulate Function to Add Multiple Columns in One Step
Unpivot in Excel using IFS, TOCOL and HSTACK Functions
1:57
Unpivot in Excel using IFS, TOCOL and HSTACK Functions
Two-Way Lookup using XLOOKUP Function
1:57
Two-Way Lookup using XLOOKUP Function
Reverse the Text in Excel using MID and SEQUENCE Function - 2 Methods
4:09
Reverse the Text in Excel using MID and SEQUENCE Function - 2 Methods
Extract Last Name from Full Name in Excel - 3 Methods
5:22
Extract Last Name from Full Name in Excel - 3 Methods
How to Sum the Numbers Across Diagonals in Excel - 3 Methods
2:44
How to Sum the Numbers Across Diagonals in Excel - 3 Methods
Extract Quarter from Date in Excel - 2 Methods
1:35
Extract Quarter from Date in Excel - 2 Methods
Unstack Rows into Columns using Table.Pivot - Power Query
2:17
Unstack Rows into Columns using Table.Pivot - Power Query
Custom Grouping in Power Query - Group Every 5 Rows
4:28
Custom Grouping in Power Query - Group Every 5 Rows
Custom Grouping in Excel - GROUPBY Function
2:17
Custom Grouping in Excel - GROUPBY Function
Cartesian Product in Excel - REDUCE Function
2:26
Cartesian Product in Excel - REDUCE Function
Running Total in Power Query w/o Index Column
3:10
Running Total in Power Query w/o Index Column
How to Extract Substring using TEXTAFTER and TEXTBEFORE Function
1:16
How to Extract Substring using TEXTAFTER and TEXTBEFORE Function
How to Extract Substring from Text using MID and REPLACE Function
2:30
How to Extract Substring from Text using MID and REPLACE Function
Fill Down in Excel using MAP Function
1:49
Fill Down in Excel using MAP Function
Fill Down in Excel - Using SCAN Function
1:23
Fill Down in Excel - Using SCAN Function
Excel Filter Shortcuts - Basics
2:01
Excel Filter Shortcuts - Basics
Table.Group Function in Power Query
2:16
Table.Group Function in Power Query
GROUPBY Function in Excel - Texts as Values
1:41
GROUPBY Function in Excel - Texts as Values
How to Horizontally Stack Tables in Power Query
2:59
How to Horizontally Stack Tables in Power Query
Extract Largest Number from Alphanumeric String using MID and SEQUENCE Function in Excel
2:08
Extract Largest Number from Alphanumeric String using MID and SEQUENCE Function in Excel
Normalization of Table in Power Query
1:51
Normalization of Table in Power Query
Normalization of Table in Excel using LAMBDA Helper Function REDUCE.
2:42
Normalization of Table in Excel using LAMBDA Helper Function REDUCE.
𝗔𝗻 𝗲𝗮𝘀𝗶𝗲𝗿 𝘄𝗮𝘆 𝘁𝗼 𝘂𝘀𝗲 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗮𝘀 𝗔𝗿𝗴𝘂𝗺𝗲𝗻𝘁 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆.
1:35
𝗔𝗻 𝗲𝗮𝘀𝗶𝗲𝗿 𝘄𝗮𝘆 𝘁𝗼 𝘂𝘀𝗲 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻 𝗮𝘀 𝗔𝗿𝗴𝘂𝗺𝗲𝗻𝘁 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆.
Generate Multiple columns From a List in One Step - Power Query
2:24
Generate Multiple columns From a List in One Step - Power Query
Solution to address handling arrays in text argument of TEXTSPLIT Function.
2:04
Solution to address handling arrays in text argument of TEXTSPLIT Function.
Untapped Potential of Excel Functions
1:09:55
Untapped Potential of Excel Functions
Tricks in SUMIF Function
1:47
Tricks in SUMIF Function
Trick to Extract Multiple Tables in One Step - Power Query
2:49
Trick to Extract Multiple Tables in One Step - Power Query