Monthly Quiz – July 2014

Quiz time. This is a special quiz created using Office Mix – a new PowerPoint add-in from Microsoft. This time the stakes are higher USD 50. Ten questions. If you have been reading this blog, you should be able to derive the answers.

Best of Luck. Click here to start the quiz.

You must sign-in using either Microsoft, Facebook or Google account.

image

Choosing the winner – All answers must be correct, minimum attempts, minimum time. If there are many potential winners, then a random number will be generated to choose the winner. Ideally, I should choose the person who answered first in chronological order. However, this site is viewed from 80+ countries across different time zones. Therefore, to be fair to everyone, I will use the random number approach. Hope it is ok with everyone.

Analyzing Big Data? Use 64 Bit Office

Do you have slow performing, large Excel files? Here is the solution.

This is a simple but very important pre-requisite for analyzing large amounts of data. Although technical people are aware of this requirement, most users are not aware about this.

use 64 bit Office for handling large data- Dr. Nitin Paranjape

Let us understand the importance of 64 Bit version of Office

Continue reading Analyzing Big Data? Use 64 Bit Office

Generic Skills: Drop that dropdown!

This is the continuation of the article Basic vs. Advanced – the psychological deterrent to efficient Office usage! It is difficult to teach thousands of features to thousands of users. But there is a different approach available – Imparting Generic Skills rather than specific skills. Let us explore the completely ignored dropdown.

the powerful Dropdown menu in Office
Let us explore and find out more about it with an example.

Continue reading Generic Skills: Drop that dropdown!

Basic vs. Advanced – the psychological deterrent to efficient Office usage!

Many training programs and books are divided into two varieties – Basic and Advanced. This classification gets ingrained in the mind of users who have neither attended any training nor read any book. From what I have observed and analyzed over the last decade, this thought process is a key deterrent to effective and efficient usage of Microsoft Office. At least I have not come across any source which discusses this issue. Therefore, I am addressing it in this article.

Continue reading Basic vs. Advanced – the psychological deterrent to efficient Office usage!