Tag Archives: Applied Knowledge

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.

How to calculate YOY growth in Excel Pivot Table

Estimated reading time 3 min. Works with ALL versions of Excel.
The data is a list of sales transactions, two columns – amount and date.
We have 5000 transactions over many years. We want to know how the business grew year on year. Here are the steps…

SNAGHTML48223f                  image

Continue reading How to calculate YOY growth in Excel Pivot Table

Legal: How to manage 6 min billing in Outlook Calendar

Here is something I learnt yesterday at Wellington. I was conducting a session on Outlook for a team of EA and PAs for Government of NZ. I showed them the Outlook calendar can be managed at different levels of detail starting from 1 hour down to 5 minutes. Just right click on the time display in the daily or weekly view to change the setting.

6 minutes time slot in Outlook calendar

You will notice that there is a 6 minute option available there. Like most of us, I had never understood why would anyone want a 6 minute time slot. But then one of the participants enlightened me! Legal professionals always manage billing in 6 minute increments so that they can have 10 convenient slots per hour. I learnt something new.

This happens all the time. The more you teach, more you will learn!

If you think that a particular feature is useless – think again. This incident teaches you that every feature is designed with a purpose in mind. Discovering that purpose is called learning.

Want to learn more about effective email and time management?  Check out my Outlook Knowledge Pack (50+ articles).

 

Quality Management 5: Pareto Chart

Pareto chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

Pareto chart Quality Management

Continue reading Quality Management 5: Pareto Chart