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!

Create Dynamic Text Boxes in Excel

August 16, 2016| 1 Comment

Create Dynamic Text Boxes in Excel

I am sure you would have worked with the text boxes in Word or PowerPoint or even Excel but the trick I am going to share with you will make the text boxes dynamic.. in simple terms the text can change as per the situation

The applications of this technique in Dashboards, Charts and Visualizations is pretty helpful

Read More

Make a Dashboard in 15 Mins – [Case Study]

August 9, 2016| No Comments

Make a Dashboard in 15 Mins

Last week I received an email and this is what it said..

Make a Dashboard in 15 Mins - 3

This mail got me thinking of writing something exclusively on (how tos about) Dashboards. Just out of curiosity, I additionally reached out to a few people and asked them their biggest challenge for making quick and smart dashboard.

2 major responses popped up!

  1. “Chandeep, making a dashboard is difficult”
  2. “Chandeep, it’s time consuming”


So now I understand the problem. In this post I am going to solve both these problems and teach you to make simple and yet powerful dashboards in just 15 mins. And the good part is that the concept will apply on most data sets

Read More

How to Manage Multiple Slicers in a Dashboard

August 6, 2016| 1 Comment

Manage Multiple Slicers in a Dashboard

Very often while making a complex dashboard you would find yourself using multiple slicers to slice and dice the data in multiple ways. But the only drawback could be managing space to fit all of them on the screen!

Let’s see a smart work around for that

Read More

Slicer Formatting Tricks

August 2, 2016| 5 Comments

Slicers Formatting Tricks

Yesterday I wrote a pretty comprehensive post on creating slicers in Pivot Tables. Taking our understanding on slicers a bit further, I today want to talk about formatting slicers.

Now even the default design of the slicers look pretty catchy but when you see the insane possibilities of customizing the looks of the slicer, default formatting becomes a no – no

In this post I am going to talk in detail about

  1. Adding/Deleting elements of the Slicer
  2. Slicer Options and Tools : Alignment, Default Styles, Sizes of Buttons and Slicers
  3. Modifying a Slicer + Its advantages and drawbacks
  4. How to copy Slicer Styles
  5.  General guidelines for formatting Slicers
Read More

Slicers in Excel

August 1, 2016| 4 Comments

Slicers in Excel 1

I am going to start writing about slicers assuming that you don’t know about them at all and then graduate you to more complex nitty gritties of slicers.

Slicers happen to be one of the most interactive and simple to use features in excel. Let’s begin with the basic question..

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly