Category Archives: Office 365

Office 365 webinar series

This was conducted in March 2020, during the COVID lock-down. All videos are 15 minutes followed by Q&A from live attendees. 15 days, 15 topics, 15 minutes each. Live Event with Q&A.

Watch all completed session videos

Series Videos

Mon, 23-MarWhat is Office 365?Watch Video
Tue, 24-MarWhich Office edition?Watch Video
Wed, 25-MarWordWatch Video
Thu, 26-MarExcelWatch Video
Fri, 27-MarPowerPointWatch Video
Sat, 28-MarOneNoteWatch Video
Sun, 29-MarOneDriveWatch Video
Mon, 30-MarOutlook & To DoWatch Video
Tue, 31-MarTeams & PlannerWatch Video
Wed, 01-AprYammerWatch Video
Thu, 02-AprStreamWatch Video
Fri, 03-AprSway & FormsWatch Video
Sat, 04-AprPower Automate & Power AppsWatch Video
Sun, 05-AprPower BIWatch Video
Mon, 06-AprPutting it all together
Which tool to use when
Watch Video

Enter Hex Colour Code directly with Office

New and very useful feature for artists and designers. Specify accurate colour value using HEX code instead of RGB or HSL. What difference? Well, HEX codes are most commonly used. RGB or HSL require you to put three values. HEX is ONE value. Works with all Office apps: Word, Excel, PowerPoint, Outlook, OneNote, Access, Project, Publisher, and Visio.

image

By the way, this colour shown here – #0F4C81 is special. It is called Classic Blue and it is the Pantone colour of the year 2020.

Enjoy.

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

Office 365 Poster : Learn which product to use when

Office 365 has lot of apps. It can be confusing to know which app to use when. Here is the solution. To solve the problem I designed the Office 365 Poster.

It is simple, action oriented poster. First column lists common activities all of us perform and second column shows the recommended app and feature to be used.

You can download the PDF file from here. Use it, Print it, Share it with colleagues and friends… just spread the word.

The PDF is protected. Only printing is allowed. Of course, you can take a screenshot as well. But editing and copying is not permitted.

Have an idea to improve the poster? Post a comment.

image

Note that all the latest icons have been incorporated as on 15 Nov 2019. As and when new icons are released, I will keep the poster updated.

Incremental Search in QAT customization list

Probably nobody noticed it. But this is an example of how Microsoft is looking at even the smallest inconveniences and resolving them to improve efficiency. In order to understand this topic, you have to know how to perform the QAT customization – Quick Access Toolbar. You can read this article for details.

While customizing QAT, you see two lists. The list on the left side has thousands of items – all available features in the product. The list on the right side contains items which are already there in your QAT.

The idea is to find the desired item from the main list and add it to the right side list. Now, in the longer list, if you wanted to find, let us say the item “Split”, you could not type the characters s p l. Basically, incremental search did not work at all. If you typed s p l it will show you the first entry of l rather than the entry starting with spl.

This required lot of scrolling and manual searching because it is a very long list. It is not a major issue but a small irritant. However, recently, Microsoft solved this and now, the long list supports incremental search. In short, you type spl together and it will go to Split item (in Word).

Incremental Search in QAT customization works.

We usually miss incremental improvements

The reason I am writing this article is that, most probably, I would have missed this improvement altogether. Why? Because for many years the list did not support incremental search. Once we know that something is not going to work, we just don’t try it.

Luckily, I tried it recently, hoping that true to its continuous improvement thought process, Microsoft may provide incremental search some day. And it did work.

A classic example of missing incremental improvements is associated with Excel. In older versions, if you click inside a cell and type CTRL A the entire sheet would get selected. What we wanted is to select the block of data around the selection. People just gave up on CTRL A.

But somewhere down the line (I don’t remember the exact version), Microsoft did enhance Ctrl A to select the current region of contiguous data. Unfortunately, most users who were earlier disillusioned with CTRL A never tried it again and they still don’t know that CTRL A works.

Such if life!

Office 365 Usage Scenarios

O365 contains a lot of tools. Most users do not even know about all the tools available. Even if you know the tools, the next question is – which tool to use when? Most people take this decision either randomly or based upon their habits. Both approaches are wrong. I created a set of 5 videos to illustrate some common Office 365 Usage Scenarios.

Office 365 Usage Scenarios

This is a playlist in YouTube. Each video is about a common business need. For each business need, the video demonstrates the best suited tool. As you know, efficiency is a two step process… step 1 is to know what is available and step 2 is to use the right tool in the right place.

You can view the playlist here.
These videos have a British voice because I created these videos for global consumption.

Here are the videos. Each one is just 5 minutes long. Continue reading Office 365 Usage Scenarios

WhatsApp vs Kaizala

WhatsApp is simple, convenient and popular. Due to this, it is used for official work as well. Whether you like it or not, you have to accept it. Attempts to control it fail miserably. That is where Kaizala comes in. It provides all the convenience of WhatsApp plus all the security and governance you need for managing official work and data. It is a no brainer. But still, let us see WhatsApp vs Kaizala comparison from a business collaboration point of view.

image
Reading time 6 min

Continue reading WhatsApp vs Kaizala