YouTube Channel Optimization and Monetization

Video recording of the YouTube Channel Optimization session conducted at CIO Crown event in Mumbai, Hyatt Regency, Aug 2019. Attended by 180+ CIOs from across India. The importance of YouTube for corporate usage was explained along with tools and techniques.

The 30 minute video is fast-paced and covers content creation, SEO, Metadata, Community Engagement, Channel Customization and more…

YouTube Channel Optimization: Table of Contents

Continue reading YouTube Channel Optimization and Monetization

Adding Multiple Icons in Office

There are hundreds of icons in Office. Many new ones were added recently (May 2019). Adding icons is easy – Insert – Icons – search for an icon or see it and choose it. Multiple icons can be added. It is easy enough. Why do I need to write how to add icons?

Because there is a very nice feature available which makes adding multiple icons really easy – but it is not obvious. Why is it not obvious? Because we usually don’t think of our convenience. We are used to inefficiency!

Adding multiple Icons in Office

Suppose I want to add three icons – one for laptop, one for idea and one for mobile. What will you do? One of the two things…

  1. Add one icon at a time by going to the Insert Icon three times.
    This is obviously inefficient.
  2. Go to Insert Icon – when you find the mobile icon by scrolling, you see the Laptop icon next to it – so you add two of them together. But for the Idea icon, you have to do more scrolling or go to the dialog once more. Again – inefficient.

Add multiple unrelated icons in one stroke

Go to the Insert – Icons dialog. Use the search text box to find what you want. Select the icon. DO NOT insert it yet. Search for another one, find it, select it. Repeat it till all icons are found. Even if the search results do not show it, your selections are remembered.

The Insert button shows how many it has remembered in brackets. So, don’t worry about inserting icons. Just find the set of icons you want and then insert all of them once and for all.

We usually don’t notice this level of sophistication and end up going to the dialog repeatedly to add multiple Icons.

Here is the video of how to insert multiple Icons in Office

Icons in Office - how to insert GIF animation

Now that you know, use it to your advantage. Cheers!

Rainbow

PowerPoint Jigsaw Creator

This article consists of a video and a macro. PowerPoint Jigsaw Creator works on any picture. First step is to split the picture into random pieces and second step is to put those pieces in random position. Then you can use Morph to create a nice effect where the pieces of the puzzle automatically fit in and create an amazing effect like this…

PowerPoint Jigsaw Creator demo: Jigsaw animation of Kuala Lumpur skyline

Watch this video to know how to do this. In addition, you will need to download and use this macro.  See instructions below. Continue reading PowerPoint Jigsaw Creator

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 Efficiency Crash course

This is a jump start for using Office efficiently. It is called Office Efficiency Crash Course because it contains 120 “must know” things across Word, Excel, PowerPoint, Outlook, OneNote and OneDrive.

This session was conducted for 400+ MBA new joiners at WeSchool, Mumbai.

3 hr, 20 min video. Fast paced. With lot of demos.

Dr Nitin delivering the session at WeSchool, Mumbai

Office Efficiency Crash Course Table of Contents

It is a long video. You may want to see a particular product. Here is the product specific Table of Contents. Click on the link to jump to that part in the video.

OneDrive
Excel
Outlook
OneNote
PowerPoint
Word

120 topics are covered. Here is the detailed table of contents. Continue reading Office Efficiency Crash course

Work Efficiency Transformation using Office 365

This is a recording of the session conducted at WeSchool – Welingkar Institute of Management, Mumbai on 23rd Jun 2019. All business users will find this video useful. Work Efficiency Transformation using Office 365 is relevant to any organization using the Office 365 platform.

Duration: 3 hr 12 min

This video demonstrate efficient usage of various tools including Outlook, Excel, Power BI, OneDrive, Teams and Planner.

The audience consisted of 200+ working professionals pursuing the WeSchool MBA course. Smart and attentive audience. In spite of it being a Sunday, everyone was fully engrossed and interested in learning more. Special thanks to Prof. Pradeep Pendse who invited me to conduct the session, it was a pleasure addressing such a large and intelligent audience.

Table of Contents

Jump to a specific topic in the video.
Outlook
Excel and Power BI
Office
3D Map in Excel
OneDrive
Teams and Planner
PowerPoint
Summary

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