I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations
I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog
The Offset function is one of the big daddies of the Lookup functions family and brings new possibilities in Excel but is if often suggested to use with caution because of its volatile nature. Lets cover the Offset and its applications in depth!Read More
Hey .. Wish me a Happy Birthday!
Yes, today is my Birthday and I am really happy because I am finally able to launch this Pivot Table Course and a Sales Dashboard which I would like to give you as a present. I have put in a lot of heart to make this a one stop shop comprehensive pivot table course for you and I am sure you’ll enjoy it as much as I have enjoyed making it
Here is the quick snapshot of what will you learn in the 4 part course
Hey Guys, how are you doing? Every once in a while in a trainng session I get a request on “How to hide xyz in Excel ?”, so I though I will dedicate this post on hiding (and un-hiding) the top 9 things that people often ask me about!
So ready for our hide and seek? Alright I count till 3Read More
Excel 2013 gives you a quick feature to space out the command options in the tabs, just in case you are working on a small screen or a touch screenRead More
The above is just an animation (download it here) but most often we need these icons in our presentations. Although PowerPoint shapes does allow you to draw these icons but why do the extra work if they are readily available on the internet.. All you need to learn is how to dig them .. ?
Shall we get started ??Read More