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

Convert YYYYMMDD to DD/MM/YYYY in Excel - 2 Methods

V E Meganathan

Oct 21, 20241 min read

Excel tricks

Convert YYYYMMDD to DD/MM/YYYY in Excel - 2 Methods

Today we are going to discuss about different methods in excel to convert dates from YYYYMMDD format to DD/MM/YYYY format. Lot to learn,...

13 views1 comment

V E Meganathan

Oct 10, 20242 min read

Excel tricks

List all Sheet Names in Excel

Today we are going to discuss about different methods in Excel to list all sheet names. When the number of sheets in a workbook exceeds...

8 views0 comments

V E Meganathan

Oct 8, 20242 min read

Excel tricks

All about Name Box in Excel

Today we are going to discuss about Name Box in Excel and its hidden capabilities. Lot to learn, let's dive in. ALT + F3 is the shortcut...

51 views0 comments

V E Meganathan

Aug 20, 20243 min read

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...

13 views0 comments

All about Filter in Excel User interface - Part 1

V E Meganathan

May 13, 20244 min read

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...

28 views0 comments

Hidden tricks in Excel functions and User interface

V E Meganathan

May 3, 20244 min read

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...

164 views0 comments

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

V E Meganathan

May 2, 20243 min read

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...

9 views0 comments

All about Advanced Filter in Excel- User interface

V E Meganathan

Apr 23, 20244 min read

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...

24 views0 comments

Discussion about excel formulas which delivers range reference as output

V E Meganathan

Apr 9, 20243 min read

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...

30 views0 comments

Testing the boundaries of Excel functions - Part 1

V E Meganathan

Mar 21, 20242 min read

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...

50 views0 comments

1

2

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

Convert YYYYMMDD to DD/MM/YYYY in Excel - 2 Methods

List all Sheet Names in Excel

All about Name Box in Excel

How to Create Scrollable Table in Excel

All about Filter in Excel User interface - Part 1

Hidden tricks in Excel functions and User interface

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

All about Advanced Filter in Excel- User interface

Discussion about excel formulas which delivers range reference as output

Testing the boundaries of Excel functions - Part 1

Subscribe to Our Newsletter

Our Happy Clients

How to Enhance Excel skill

YOU’VE ARRIVED!
NICE TO MEET YOU