Welcome 2015, My Goals for 2015………

Hi there, Hope you had great year 2014. I also had a mixed year in 2014 where I switched myself from Freelancer to Blogger and I learned a lot in this process. To make the year 2015 most fruitful, I have decided to make a Goal-sheet in advance and start following it from December 16, […]


Most Powerful Excel Keyboard Shortcuts + Excel Shortcut PDF

Hey Excel Shortcut savvy guys, Have you ever removed all the filters applied in separate columns with a shortcut? Many of us might not have done so instead they would be removing filter from the data and again applying filter. I was doing this long exercise upto few years back. But from 2007, we have […]


How to create drop down in Microsoft Excel?

Hello Excel Lovers, In this animated GIF below, I have shown how to create drop down list in cells in Microsoft Excel with Data Validation Function. Share your views on this trick and how it helped you at your work in comments! To Subscribe to the courses go to Courses page and be effective user […]

Lock Format Painter

Have you ever double clicked Format Painter in Excel!!!

Hello Excel Enthusiasts, You all must know the use of Format Painter brush. But have you ever double clicked the Format Painter i.e. locked the Format Painter Mode. Press Escape to switch off the Format Painter Mode. I am sure once you learn and experiment this trick, it will save a lot of time in […]


Welcome to the XLGURU Blog

Hi there,   Welcome to my blog on xlguru.in.   Here you can find solution to your queries on Excel and learn new and time saving techniques in Excel.   Enjoy Excelling….!!   DJP


Subscribe for Newsletter