Office 365 Storage Guide

Many customers have deployed Office 365. However, the usage of all components is not optimal. That is why I wrote this short and simple Office 365 Storage Guide. Tweak it as per your specific needs but the base concept is same. No documents should be stored on local My Documents. Storing a document on a particular device makes it unavailable to even the person who created it. That is why, it should go on a cloud storage.  In addition, files stored on the cloud are easier to share with others.

Office 365 Storage Guide poster

Continue reading Office 365 Storage Guide

How to Filter on Blanks quickly

A simple but very useful method. All of us use AutoFilter in Excel. The dropdown shows unique values in the column. Sometimes we just want to see the rows with blank cells. Unfortunately, the (blank) item appears at the end of the list. If the data contains many unique values, you have to waste time and scroll manually to the bottom of the long list. Often, after reaching the list we realize that we should actually have unselected all the items first. Then you go up again! Pathetic. Here is a smart way to Filter on Blanks instantly.

Continue reading How to Filter on Blanks quickly

VLOOKUP based text grouping

You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or for correcting spelling mistakes. If new items appear, they remain ungrouped. That way, you have to keep doing the Grouping update repetitively. An alternative is to use VLOOKUP based text grouping. Read on to find out how this is done.

Continue reading VLOOKUP based text grouping

High-res Camtasia Video creation technique

Resolution of the final Camtasia output depends upon two things. The input and the output settings. High-res Camtasia Video creation means retaining the clarity and sharpness of the original resolution as much as possible. This is crucial for creating good screencasts, training content, video manuals and a variety of other needs.

Lot of excellent articles and videos are available on this subject. In spite of that, one simple thing is not very clearly identified. Most content out there talks about tweaking at the editing and output stage. These are important. But one crucial thing is to be understood first. I learnt this the hard way. Hence sharing it here.

High-res Camtasia Video - demo

Continue reading High-res Camtasia Video creation technique

Adding only comments in Word

What if you want people to add comments but NOT edit the document itself? That is what I call Adding only comments in Word. This is possible! With just few clicks. Get amazed by the level of sophistication available in Word. Watch this video ( 8 min).

Don’t have time? I have also published a shorter version of the video (2:30 min)

Continue reading Adding only comments in Word

Data Audit using Pivot tables

I wrote an article about Data Audit using Pivot long back. Now, I have converted it to a comprehensive video. Have a look:

How to perform Data Audit using Pivot

Raw data can contain many columns and thousands of rows. Checking the consistency and accuracy of data cannot be done by simply scrolling and eyeballing the data. Too time-consuming.

Continue reading Data Audit using Pivot tables