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!
Most often we merge the cells when we have to center align a headline between a few cells… don’t we? Which is fine, but the problem occurs when you are writing formulas
We have product code and quantity displayed over 3 days (in merged cells). The Problem arises when you write formulas on the cells merged!Read More
If you wish to guard your sheet from unwanted access, the Protect Sheet feature comes really handy! Let’s take a sneak peak into thisRead More
Versatile, Robust, Fast, Simple, Elegant .. oh all that is ME 😆 and The INDEX function too. Since you already know me so let me introduce you to the INDEX function
If you have been using VLOOKUP for a while, it is time now to graduate baby! Let’s start simple with the Syntax =INDEX(array, row_num, col_num)
We have here 5 months sales data of different employees (Emp ID) and we want to look up for EMPCD 255 in March
Aahaa, it is simple VLOOKUP thingy! But let’s get this done with INDEXRead More
The Charts in excel are not just restricted to Chart Objects, we can cleverly use formulas to make Charts.. sounds bizarre and interesting? Lets explore this further with one such functionRead More
A while ago I trained a bunch of professionals on How to make Business Intelligence Dashboards, and trust me the training was mutual (two way). They were smart, sharp, stumped me with there questions, so I became a bit smarter and learnt a few things while solving their doubts in trail and error
Here is our work – We made this Dashboard from raw data in the session.. take a lookRead More