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.
Monthly Archives: August 2016
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.
Announcing Pivot Table to Power BI course
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already know – Pivot Tables. That is why the course is called Pivot Table to Power BI.
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.
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.
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)
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.
DAX RelatedTable and behind the scene PowerPoint animation
Here is an interesting way to learn two things in one go. While creating the Power BI course for UDEMY, I created lot of explanatory videos. One of the DAX functions which is difficult to understand is the RELATEDTABLE function. So here is a dual video which explains DAX RelatedTable animation. 8 minutes.
APPendectomy reduces APPetite
Apps are great. But we are not great at using them. Useful ones do not get enough attention and useless ones we get addicted to.
We waste our precious life in using apps which are reducing the value of your life. APPendectomy reduces APPetite is a nice way of saying that if you reduce excessive dependence on apps, your life will improve.
If you have noticed the problem and feel that you need a solution, try this approach. These are random ideas. But I have used these at various points of time.
One or more of these ideas may be useful to you. No harm in trying these out.
Let me know your feedback.
Using Ads to your advantage
Yes I know. Nobody wants to see ads. But unfortunately that is not possible. If FB does not get some revenue, they will close down – like any other business. So what choices do we have? Well, it turns out that we have three different approaches available. It turns out that there is a way of Using Ads to your advantage!