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!




30 Evergreen Productivity Hacks in Excel

July 18, 2016| 2 Comments

30 Productivity Hacks

There are ton of ways to work faster in Excel and often the little nick-nacks take more time than other things. I am sure that there is no end to the available shortcuts in Excel but for now let’s take a look at a few most commonly done little tasks in excel and ways to do them a lot faster

Read More

Cost Structure Visualization – Chandoo’s Visualization Contest

July 12, 2016| 2 Comments

Last week I participated in Chandoo’s Visualization Challenge, where we were given some raw data and had to make a meaningful visualization (Dashboard) out of it. In this post I am going to share everything about how I went along in creating this dashboard.

Compare Companies View
Screen1

Overall Market View
Screen2

Read More

Timeline Chart in Excel

July 9, 2016| No Comments

Timeline Chart in Excel One

Every once in a while I make a timeline in PowerPoint to show how the tasks are scheduled over time. I thought it would be nice to have a template in Excel where I just add events and dates and the chart is created by itself.

So today it is time for a short tutorial on a timeline chart

Read More

Custom Formatting Tricks

July 6, 2016| 4 Comments

10 Custom Formatting Tricks 1

Even if you have no idea what is custom formatting, these tricks will help you win over some common formatting needs for your data

Read More

Learn 100 Excel Formulas

June 30, 2016| 4 Comments

 

EXCEL FUNCTIONS

Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.

I have explained each formula

  1. In a very simple manner
  2. Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
  3. The Downloadable Excel file used as a case in the video

 

As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGE

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly