Chandeep Chhabra

Become Unbelievably "Excel"lent !

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!

Let's Get Started!




How to make your Dashboards more Insightful

June 15, 2017| 2 Comments

Making your Dashboards more Insightful

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 can

Read More

How to improve the Look and Feel of your Dashboards – Guide

June 7, 2017| 2 Comments

Improve the look and feel of your Dashboards 1

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 Dashboards

Read More

Change Pivot Table Values Field using VBA

May 29, 2017| 4 Comments

Dynamically Change Pivot Table Calculations

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

Dashboard Survey

May 23, 2017| No Comments

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

powered by Typeform

 

If for any reason you face a technical difficulty in filling up the form. Please use this link – https://chandeep.typeform.com/to/n6VQjM

 

Read More

What are your most productive excel tricks ?

May 3, 2017| 22 Comments

Productive and Time saving Excel Tricks 1

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

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly