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
I am dedicating this post to my brother, who asked me a simple question last night to find out quarters for a given set of dates. For example
I have 2 ways to solve thisRead More
What’s happening ? Lately (16 August) I visited a holy place for Sikhs in Amritsar (Northern India) known as the Golden Temple, more on this later 😀 but as of now lets continue with a problem asked by one the participants in an Excel session. So the question was..
As you delve deeper into excel formulas you have to be insanely good at some ‘bird’ called Cell Referencing. If you have not heard of it.. that’s okay, heard of it but not know much .. that is also okay. Let’s go and unravel this concept..Read More
Interesting is’nt it?
Often I find managers and analysts making standard charts (or sometimes even pie charts) to map the city wise sales. Here is an interesting way to plot the cities on any country’s map..Read More
How are you doing? I thought I have been speaking enough about financial modeling (getting started and taking interviews), let me get on to show you a very effective time scale trick and what it can do to our modelsRead More