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
With the Indian financial year end approaching, there could not be a better time to talk about target charts.
Although, I can’t help you much with your business targets but I can help you create stunning target charts. I promise they’ll look stunning even if your targets are not met. And that was a Joke! 😆
Let’s begin with 2 different types of target chartsRead More
If you and I interact on emails, you know that I asked you this question. Nevertheless even if you are a first timer, let me start from the top and explain you the case
Take a look at the data below.
Nothing much to explain, we have a matrix with
So, if I asked you a question – Tell me the Level wise, salary payout quarter by quarter in the year 2014 and 2015? How would you solve this question
If you are an avid pivot table user you’ll notice 2 things
Often we need to extract unique values from a range of data. Although to do that there is already a built in Remove Duplicates feature in Excel. But here are 2 more ways to do itRead More
I have written and read many posts about making awesome presentations and surprisingly ALL of them (including mine) fail to make a “real impact”, the impact of changing a raw presentation and converting it into a beautiful, thought provoking and impactful display of information
Do you know why?
Because creating an awesome presentation is much more than
So I wanted to do something different..
Rather than just writing piles of text on “How to stuff..” I thought of taking a random but real Presentation and reworking it to make it awesome
I will give you downloadable files (pre and post rework), videos and commentary about my thought process and more importantly the reason(s) behind why I chose something over the other. Hopefully this will give you insights on what works and more importantly what doesn’tRead More
An icon of a car feels so cool when you are talking about cars in a chart. Isn’t so? Let’s see how can we do that!Read More