An Open Book

Welcome to my blog, a place where we can test the boundaries of Excel functions and M-Code. I invite you to explore my contents and learn some advanced excel tricks and hacks. Please reach out and engage—I’m happy to hear from you, as well.

YOU’VE ARRIVED!
NICE TO MEET YOU

Search

The Efficacy of Dynamic Array Functions in Excel: Part - 2

V E Meganathan

3 minutes ago1 min read

The Efficacy of Dynamic Array Functions in Excel: Part - 2

The task at hand involves generating a sequence of numbers based on a specified pattern. The pattern dictates that for an input value of...

0 views0 comments

Grouping in Excel and Power Query - Find Max and Min sales for Each Zone

V E Meganathan

Feb 22 min read

Formula

Grouping in Excel and Power Query - Find Max and Min sales for Each Zone

Today we are going to discuss about Grouping the data to determine maximum and minimum sales for all zones. Our dataset includes the Zone...

2 views0 comments

The Efficacy of Dynamic Array Functions in Excel

V E Meganathan

Feb 12 min read

The Efficacy of Dynamic Array Functions in Excel

Today, I will demonstrate the effectiveness of Dynamic Array Functions using two examples. Example 1: The first example is to obtain a...

3 views0 comments

Function as Parameter inside LAMBDA in Excel

V E Meganathan

Feb 11 min read

Formula

Function as Parameter inside LAMBDA in Excel

Today, I will demonstrate how to utilize Excel functions as Parameter within LAMBDA with simple example. Our dataset includes the Zone...

3 views0 comments

Method for Applying Default Transformation to All Columns Simultaneously in M-Code

V E Meganathan

Jan 292 min read

Power Query

Method for Applying Default Transformation to All Columns Simultaneously in M-Code

Today, we will discuss how to apply a default transformation to all columns at once in Power Query using the Table.TransformColumns...

7 views0 comments

2 3 4 5

Our Happy Clients

SICAME is an exciting new client for our projects, and we are thrilled to collaborate with them. Their commitment to innovation and quality aligns perfectly with our values. We look forward to delivering exceptional results that meet their needs and exceed expectations. Stay tuned for updates on our progress!

SICAME

How to Enhance Excel skill

Once in a day,

Learn at least one new content in excel,

Practice it with sample raw data.

Think about the concept of that function during leisure time.

Start Now

An Open Book

YOU’VE ARRIVED! NICE TO MEET YOU

The Efficacy of Dynamic Array Functions in Excel: Part - 2

Grouping in Excel and Power Query - Find Max and Min sales for Each Zone

The Efficacy of Dynamic Array Functions in Excel

Function as Parameter inside LAMBDA in Excel

Method for Applying Default Transformation to All Columns Simultaneously in M-Code

Subscribe to Our Newsletter

Our Happy Clients

How to Enhance Excel skill

YOU’VE ARRIVED!
NICE TO MEET YOU