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!
Animations are a key part in presentations & I use them often, but I abide by one rule for using animations
” Use animations to communicate your message effectively rather than just for artistic purpose “
Of the many animation styles that I use to display data, here are 5 classic ones and definitely with a purposeRead More
Here are a few exclusive border shortcutsRead More
A while ago I wrote a post on how to use Advanced Filter? Today let’s delve further into a bit of automation of the advanced filter applicationRead More
Looking up pictures can be interesting and can possibly be used in different scenarios. Here is a quick sneak peak into how can you do a Picture Vlookup!!Read More
Sometimes you may have a need to create a dropdown list which should be dependent on another dropdown. For instance in the above example depending on the company that you choose (A, B or C) in the Company dropdown, the respective products appear in the products dropdown.
Trust me its not difficult but just a couple of logics combined together to make this dropdown pudding. Let’s do it.. Shall we?Read More