I love New Zealand – the natural beauty, professionalism, work ethic and fun. Heavenly!
Recently, while I was there, I learnt a great lesson about Excel. My Excel formulas stopped working. The reason was so simple but I was stupid enough not to discover it till I did some deep dive. Here is my learning …
Continue reading What did I learn in NZ: List Separator in Excel
This is an utterly useless activity. Learn how multiple products can come together to create unimaginable things. Check it out! 500 slides in 50 seconds without programming.
Direct YouTube link
Earlier I wrote about how to show bottom-up approach using simple bullets. Now let us do the same thing using SmartArt. Here we can use various visuals and enhance the visualization.
Continue reading Bottom-Up approach using SmartArt
While working with hundreds of customers globally, I see lot of mistakes being done. This leads to poor ROI and business value. Best Practices get all the limelight. But mistakes are never documented publicly. Hence I am writing this series – Office 365 Worst Practices
Some mistakes are strategic, some technical, some operational. The worst practices article list is growing! Here is a list of all articles I have written on this topic so far. Future articles will also be added to keep this knowledge pack current. Your comments and suggestions are welcome.
Continue reading Knowledge Pack: Office 365 Worst Practices
As you know, the new version of Office is almost ready. I will be covering the new features in future articles. Here is the first one. Simple but extremely useful capability.
While inserting attachments, older versions just allowed you to choose the files. But now, you can see recent files in the same drop-down. That saves you lot of trouble because it is highly likely that you will insert a recently edited file.
Powerpoint transitions should be used to emphasize some change from pervious slide to next slide. Usually the changes are opposite – before/after, less/more, negative/positive, problem/solution etc. But there are transitions which are useful when there is continuity rather than dramatic change. Here is an example: How to show your product range – one product at a time…
Continue reading Powerpoint: Gallery Transition to show multiple products
Office 365 plans which include Office Pro Plus are capable of running Power Pivot, Power Query, Power View and Power Map. Extremely powerful tools. Highly popular with users and top management. Unfortunately, in many cases, these tools are just not deployed!
Continue reading Office 365 Worst Practices – Part 6 – Power BI tools not deployed / used