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
Hi Guys, the second and the final post in the Time Scale series got a bit delayed, my sincere apologies. Let’s begin
In the earlier post we had seen how can we map the project period in a calendar and link that to our financial model. Do a quick review of the earlier post here – Time Scales in Financial Modeling Part 1
Sometimes mere mapping of the relevant project period is not enough but we also have to calculate the number of days during the project period. The number of days would help us calculate accurately things like..
Charts and PowerPoint Presentations are like two friends which are seen together in boardrooms around the world. Wouldn’t you like to know the sanctity of keeping them together in multiple ways 😀Read More
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