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!
Custom Data Validation is one of the lesser used features in Data Validation. It can accept a formula to validate a cell input. Let’s take a look at how custom data validation works and then explore 2 of its applicationsRead More
2 things are pretty evident from this Chart
By selection I mean just clicking on the bar the represents Customers for Tuesdays. The selection could be for any reason (putting it up on the secondary axis, formatting the data series, adding data labels… etc etc)Read More
I got through a few interesting formula challenges in the Round 2 of Excel World Champ. One of the formula based question was similar to this Excel Challenge
Let’s see if we can knock this down!Read More
Quick brief and Listicles (for random visitors and not so Goodly people ;D)
For all Goodly folks and friends, below is a more meaty and a real time talk!Read More
Often there are tasks in excel that seem impossible to perform. Array formulas can handle a lot of that impossibility and do miraculous things. The problem is that array formulas is one difficult topics in Excel
“With great formula power comes great complexity”
Chandeep’s lame claim to fame 😀
For that very fact I am going to discuss with you 5 extremely helpful array formulas that I find myself using very often.