At times you need the user to not be able to unhide the sheet that you hide in excel. But if you use the regular right click hide option, anyone can unhide your sheet (if your workbook is not protected) Let me share with you a trick using which the user won’t be able to easily unhide the sheet

One of the most common things that I witness people (pros or amateurs / seniors or juniors) doing is applying filters to data. I mean it is so common that everyone knows it around. Agreed ! What I am going to share with you is 3 uncommon, incredibly smart ways of applying filters and not just filtering data but will also show you uncanny ways of automating filters

Recently while working on an HR Dashboard I worked out a nifty solution to change the calculations for a pivot table dynamically using a short VBA code. I am going to do a complete tear down of how did I do it. Let’s take a dive!

I called over my friend, Puneet Gogia from www.excelchamps.com (once again) to teach us how can we use VBA to copy a Chart from Excel to a PowerPoint Presentation

This post is an advanced application of the previously written posts on Advanced Filter and Automation of Advanced Filter using VBA If you have not read the above 2 posts I strongly recommend reading them before you dive into this