Hi, My name is Chandeep!
Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel
Let me get you started by sending you smart ebooks on Excel and Powerpoint!
Today let me share with you some of my favorite techniques to bring more insight and pack more killer information in your Dashboards. Although these tips are in no particular order but you should adhere to them as much as you canRead More
I have seen a lot of awesome and terrible Dashboards and have realized that there are just a few things to fix to drastically change the way your Dashboard looks
I am going to share with you my top fixes to improve the look and feel of your DashboardsRead More
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!Read More
I want to understand your biggest challenges when it comes to creating Business Dashboards.
I have put together a set of 6 questions that’ll help me understand what kind of material should I write and produce that will help you create kick ass Dashboards
Please spare a few minutes and open your heart out to the following questions..
If for any reason you face a technical difficulty in filling up the form. Please use this link – https://chandeep.typeform.com/to/n6VQjM
Hello there, all you lovely and goodly people! Read this short story
The other day I was sitting with a friend helping him with some Recruitment Analysis Dashboard
Friend : Hey can we also see the demographics by position applied for ?
Me : (doing while I was saying it) So let’s add position in the Inputs Sheet and covert this into a Table, now let’s refresh our Pivot and add a slicer on Positions Field and apply our sexy formatting on it and stack it in our Dashboard!
Done! Dude check this now..
Friend : (with his jaw dropping) Man, you are fast. I love the speed
Sorry, I dint mean to brag at all :D. If you have stayed with me for a while you know this is easy, no brainer stuff.
Today let’s exchange some speed tricks and make each other a hell lot faster and to do that I need your help. Here is the plan!Read More