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.
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.
- 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.
- I am presenting to customer X. I also presented to the competitor Y just yesterday. I want to remove files related to customer Y.
- 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.
- 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.
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…
Continue reading How to calculate YOY growth in Excel Pivot Table
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.
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).
When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.
Continue reading Quality Management 6: Scatter Chart
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
Continue reading Quality Management 5: Histogram and Pareto
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.
Continue reading Quality Management 5: Pareto Chart
Capture important moments while conference videos, eLearning, etc. using a powerful OneNote shortcut. These could be specific slides / demos / whiteboard content. Find out how to do it.
Continue reading OneNote: Instant visual notes while watching Videos
Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.
Continue reading Quality Management 4: Histogram in Excel 2016
This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.
Continue reading Quality Management 4: Histogram using Pivot Table
Run charts are simple line charts drawn against time. The idea is to visualize the pattern and trend of captured data. The data could be about defects, issues, observations or variability. Let us see how to manage this using Excel.
Continue reading Quality Management 3: Create Run Charts in Excel