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
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
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
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
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
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
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.
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
This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
