Store files in the right place with Office 365

This may seem like a simple question. But it is not. After 3 decades of IT, we are still debating and are confused. This article is about where to store files in Office 365.  This simple poster became popular on LinkedIn. Here are the details… based upon the interaction on the post and what I have seen at hundreds of customers.

Where to store files - poster - showing OneDrive, Teams, SharePoint and Yammer

Continue reading Store files in the right place with Office 365

Common Teams Mistakes / Teams Worst Practices

Teams is a very powerful tool. But there are many common mistakes I have observed across customers. Here is a list of 50 mistakes – or – worst practices. Make sure you are not committing these Teams mistakes.

This is just a list. I will expand on some of these mistakes as separate articles or videos. If you do not understand a particular topic or have a different opinion, please post it as comments.

image

Continue reading Common Teams Mistakes / Teams Worst Practices

How to Share OneDrive links

Stop sending attachments – unless it is mandatory. When you Share OneDrive Links you get many benefits. Assumption – you want to share the link to specific people. If the link is forwarded to other people, it should not work. Two ways of sharing . Outlook and from everywhere else.  Reading time 5 min.

image

Continue reading How to Share OneDrive links

Stop Macro viruses instantly

For decades, Macro viruses are a serious problem. Does it mean that Windows, Office and VBA – all Microsoft products – are insecure?
Absolutely not. Microsoft gave you the ability to stop Macro viruses
– instantly – ever since Office existed (25 years+).

This is a technical article – for Security and IT professionals.
Reading time (7 min)

stop macro viruses poster

Continue reading Stop Macro viruses instantly

Morph does not work with Icons

Mini-blog. Just learnt (the hard way) that Morph does not work on SVG images… which basically means Icons available in Office – among other things.

The workaround?

Simple. Just convert Icons (any SVG) to Shapes. Now Morph will work as expected. That’s it.

You don’t even need to ungroup the shapes.
Morph works fine on shape groups – provided you retain the groups in both slides.

image

How to use Power BI free of cost

I have noticed that most customers are reluctant to pay the 9$ license cost for Power BI. Here is how you can use Power BI free of cost. I am a strong proponent of purchasing licensed software. This articles is not meant to show you how to cheat on the licensing cost. In fact, I will show you how to get tangible value by using Power BI free version so that you can easily justify the cost of the license with a strong and compelling business justification.

Power BI free of cost poster showing the logo and a skydiver

The idea is simple. Use Power BI just like we use Excel. Create Power BI Reports, save PBIX files on OneDrive / Teams. Share the reports with each other as links or attachments – exactly the way we do with Excel files. All users must have Power BI Desktop free version. This process does not cost any money. Power BI free version offers all the features and connectors with no time limit or restrictions.

Then the next question is – if this works for free, why pay Microsoft that 9$ per user per month license for Power BI Pro? Good question. Sharing PBIX files may seem satisfy your needs – but it has many disadvantages. Read on to find out more…

Continue reading How to use Power BI free of cost