MRU Remove From List

MRU is a list of Most Recently Used files. We see that list in File – Open –Recent documents. As you know, this list shows the latest documents opened by you. Documents opened earlier move down in the list and eventually get removed when more files are opened. However, Office allows you to explicitly remove a particular item from the MRU list. Right click on any item and choose Remove from List.

image

The question is, why would you want to do that? Anyway the file will get flushed from the list soon. The answer is not so obvious. There are  many practical scenarios where this is very useful.  I am not going to explain each scenario. Just a list.

  1. You opened a local file and stored it on OneDrive. Now to files are seen in MRU. I want to remove the local file to avoid editing it accidentally.
  2. I am presenting to customer X. I also presented to the competitor Y just yesterday. I want to remove files related to customer Y.
  3. I opened XLS file, saved it as XLSX. This way Compatibility Mode is removed and I can use all the new features. Now, I do not want to accidentally open the XLS file and confuse myself.
  4. I am editing a complex file. I keep saving versions. When I save the latest version, I want to remove the entry of the older version from MRU to avoid confusion

If you can think of more usage scenarios, do post it as comments.

Excel risk Mitigation

This article is for CFOs, CEOs and other members of Senior Leadership Team. It requires just 10 minutes to read. But it will reduce your personal as well as organizational Operational Risk significantly.  Notice the green mark  below.
This is the biggest Excel risk.

Excel Risk - Demo

If you see even a single green mark, you should send the file back.
Ask the sender to handle all the green marks and send the revised file to you.
Of course, they may not know what you are talking about.
Ask them to read these 5 articles: Knowledge Pack: Green Marks in Excel

The rule is, Excel sheet with Green Marks should not be sent to anybody. It is the sender’s responsibility to remove all errors – not the recipient’s.

Continue reading Excel risk Mitigation

Word Mobile Scrolling

Word Mobile is a brilliant product. It exceeds expectations in every possible way. For example, take a simple feature like scrolling. What more can you do to enhance scrolling? But Microsoft has really boosted that feature beyond your imagination. Here is a short visual blog to show you how it works. 

14 sec video. It will repeat automatically.

Word mobile scroll

It allow you to scroll while viewing the thumbnail. So convenient and useful.

The clarify of the thumbnail is perfect, even on the small mobile screen.

Works flawlessly with large documents.

Reach the desired page and stop scrolling. It will move to that page.

There is no way to abort scrolling. Remember, no Esc button on mobiles!

Neither scrolling nor thumbnail is a new feature in itself.

But combining them together in touch context is called innovation.

Using Word Forms

Although Word is most commonly used for creating documents, it can also be used for capturing data like a form. Word Forms do not require any programming knowledge. These are easy to create and will work across ALL versions of Word.

image

The Need for Word Forms

This is very useful for conducting quick surveys or quizzes where you want to control the responses. Of course, there are more sophisticated methods and tools available for bother these scenarios, Word is familiar to everyone and almost guaranteed to be available on every desktop. Hence it is a compelling option even today (2017).

Continue reading Using Word Forms

Pivot Tables and File Size

This is a sneak preview of my upcoming Udemy course on Pivot Tables. This video explains the  relationship between Pivot Tables and File Size. Watch this 6 minutes video and learn from it.

Apply this knowledge to your existing pivots – especially those with large file sizes and see the difference. Make sure you try it out on a copy. Never learn using Live files.

Continue reading Pivot Tables and File Size

Outlook Attachments Usage Guide

Attachments is the most popular and misused Outlook feature. If you are DELIVERING a file – use attachments. If you are Sharing a file – it is best to share the file. Sending CCs is the most important reason why “Teamwork” is inefficient. Here is a practical guide about how you should use Outlook Attachments with Office 365.

Outlook Attachments - Poster

Continue reading Outlook Attachments Usage Guide