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
A ton of people face this problem: How to convert text heavy slides into visually beautiful presentations. Often you would hear advice like
This is cool but the problem is
Let me show what I did and share one of my recent presentation projectRead More
“Knowing VLookup is cool but just knowing Vlookup is awful”
I few weeks ago I conducted a training session for a large manufacturing company in India and faced an interesting question during the training program.
I want you to take a look at the problem and try knocking it downRead More
If you are reading this in early January of 2017, wish you a very happy new year! This being the first post in 2017, let’s try something new !
In this post I am going to show you how to publish your report or dashboard (that you have created in Excel) online.
By publishing it online I mean that once you have created the spreadsheet in your computer you can then create a shareable link and multiple users can access that report. And sure enough the report will be dynamic with all the slicers, buttons and fancy controls working in sync.
The only difference(s)
Often times you may have the need to perform unusual tasks in Excel. One of such tasks is combining text in multiple rows into a single cell.
Here is a snapshot of a question asked from a friend!
At the first glance it looks like a simple Concatenate function but it is not! Because you’ll have to refer each cell separately in the concatenate function which is as good as doing manual work. Psss..
Here is an interesting way to get this done!Read More