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
Just as the inseparable musketeers who lived by the motto all for one, one for all, we have something very similar in PowerPoint. Personally I have been a fan of CTRL, ALT and SHIFT keys for their awesome utility.
The awesomeness of these 3 keys was substantially increased in PowerPoint 2010 and above. I’ll be using a mix of PowerPoint 2010 and 2013 to display some kick ass features (mostly they work same in both versions) using CTRL SHIFT and ALT (you are welcome 😆 in advance)Read More
Sometimes when we copy paste the data from the web our data gets distorted i.e. becomes a single columnar.. seriously I would just shoot my self if I have to cut and past each gender against the name (in the picture above) and more so if there are a thousand rows.. could there be an easy way to it, YES indeed 😎 ! and that too without VBA (macro)Read More
If you have been using Filter for a while, it is time now to upgrade to Advanced filter, which I think is more easy to use and offers a great utility than the usual filter in Excel..
Let’s take a dive into thisRead More
This picture speaks miles about what we are going to discuss today.. err.. not a slimming course or anything but how custom formatting can change the way how your data looks like!! 😀Read More
Spreadsheets, Presentations, Word Reports seem to be the forte of Microsoft, but I figured out that Google is as powerful in its mail merge capability… Let’s do this and for a change.. the Google Way!! 😎Read More