What did I learn in NZ: List Separator in Excel

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 …

Excel List Separator

Photo credit: Foter / CC BY-SA

Continue reading What did I learn in NZ: List Separator in Excel

Knowledge Pack: Office 365 Worst Practices

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.

Office 365 Worst Practices - KP

Continue reading Knowledge Pack: Office 365 Worst Practices

Outlook 2016: Insert Attachments – Recent Files

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.

Insert Attachments - Recent files shown in Office 2016

Powerpoint: Gallery Transition to show multiple products

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…

PowerPoint Gallery Transition

Continue reading Powerpoint: Gallery Transition to show multiple products

Office 365 Worst Practices – Part 6 – Power BI tools not deployed / used

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!

image

Continue reading Office 365 Worst Practices – Part 6 – Power BI tools not deployed / used