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

vemeganathan

Aug 20
3 min

Excel tricks

How to Create Scrollable Table in Excel

Today we are going to discuss about the simple methods in Excel to create scrollable table. In general practice, Data visualization nerds...

6 views0 comments

All about Filter in Excel User interface - Part 1

vemeganathan

May 13
4 min

Excel tricks

All about Filter in Excel User interface - Part 1

Today we are going to discuss about filtering in excel in user interface. Will try to unbox all hidden features in filter to ease your...

25 views0 comments

Hidden tricks in Excel functions and User interface

vemeganathan

May 3
4 min

Excel tricks

Hidden tricks in Excel functions and User interface

Today we are going to discuss about hidden abilities of excel functions and user interface techniques. We will see 3 tricks in each...

157 views0 comments

Method to create dynamic chart range in Excel - Formula and named range

vemeganathan

May 2
3 min

Excel tricks

Method to create dynamic chart range in Excel - Formula and named range

Today we are going to discuss about, dynamic chart range in excel using formula and named range. Lot to learn, let's dive in. We will...

7 views0 comments

All about Advanced Filter in Excel- User interface

vemeganathan

Apr 23
4 min

Excel tricks

All about Advanced Filter in Excel- User interface

Today we are going to discuss about advanced filter - user interface option in excel. This is not dynamic like formula but can-do complex...

23 views0 comments

Discussion about excel formulas which delivers range reference as output

vemeganathan

Apr 9
3 min

Excel tricks

Discussion about excel formulas which delivers range reference as output

Today we are going to discuss about excel formulas which has the ability to deliver the range reference as an output. There is no...

28 views0 comments

Testing the boundaries of Excel functions - Part 1

vemeganathan

Mar 21
2 min

Excel tricks

Testing the boundaries of Excel functions - Part 1

Today we are going to discuss about hidden capabilities of excel functions. If we get to know about these flexibilities, then we can...

48 views0 comments

Hack in WORKDAY.INTL and NETWORKDAYS.INTL functions in weekend argument

vemeganathan

Mar 19
2 min

Excel tricks

Hack in WORKDAY.INTL and NETWORKDAYS.INTL functions in weekend argument

Today we are going to discuss about unknown gem of hack in date functions, WORKDAY.INTL and NETWORKDAYS.INTL. Let me give you a glimpse...

27 views0 comments

Difference between INDEX and VLOOKUP function - Advanced level

vemeganathan

Mar 14
2 min

Excel tricks

Difference between INDEX and VLOOKUP function - Advanced level

Today, we are going to discuss about the advanced level of details in INDEX function. In our blog, we used INDEX in coordination with...

34 views0 comments

vemeganathan

Feb 15
2 min

Excel tricks

Hacks in SUMIF fx in Excel

This post is not about basics in SUMIF function but about some hacks in that function. So, let's dive into the topic., The Arguments of...

21 views0 comments

1

2

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

Subscribe to Our Newsletter

How to Enhance Excel skill

YOU’VE ARRIVED!
NICE TO MEET YOU