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

Unpivot data in Excel through formulas, Power Query, and User interface

vemeganathan

Oct 282 min read

Formula

Unpivot data in Excel through formulas, Power Query, and User interface

Today we are going to discuss about numerous methods in Excel to Unpivot data. Our input data is presented in a cross-tabulated or...

2 views0 comments

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

vemeganathan

Oct 211 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,...

7 views1 comment

vemeganathan

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

7 views0 comments

vemeganathan

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

45 views0 comments

1

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