Lost in a long Word document: Use Shift F5

This was a shortcut I knew. But did not find a practical use for it. Till recently when I was conducting a session for the legal team of an insurance company. If you work on large and complex documents, I am sure you will find this useful.

image

The Need

You are editing a complex and long document. While scrolling or navigating, something goes wrong and you suddenly land up in a completely different, far away place in the document. You did not know where you were, nor do you know where you are. You just want to go back to the original place where you were editing. Bookmarking is not an option because you could be editing anywhere, you cannot keep adding bookmarks all over the place.

The Solution

The solution is simpler than you think. Just press SHIFT F5. Word remembers last THREE editing positions. That solves the problem elegantly.

Also appreciate someone who thought of this need and provided a solution 20 years back!

Thumbs up

Office Politics: Cheat Chat

Chat is a well established part of our lives. WhatsApp, WeChat, Line, Skype, FB Messenger, Google Talk, etc. – So many options. Even in corporate context we have Lync (now Skype for Business), and others. Whether personal or corporate, we can use Chat for engaging into some cheating. Not in the true sense of the word – as in – not to violate law, but to get some political advantage. Here is how you can do it.

image

Photo credit: coco+kelley / Foter / CC BY-NC  and compxl / Foter / CC BY-ND

Continue reading

Instant benefit: Try Distinct Count wherever you are using Count

SUM and COUNT are the most common methods of summarizing data. It is easily done in Pivot Table or any other analytical tool. What is equally important is DISTINCT COUNT. But it is not commonly used. Why not? Firstly, due to lack of awareness and secondly, due to lack of that feature in Pivot Table. Let us solve both problems in the next 10 minutes.

image

Continue reading