Tag Archives: Pivot Table

Hide and Seek in #Excel – PivotTable Fields

Posted on November 28, 2020 by MF

Have you ever encountered a situation like this? How are we supposed to work with a PivotTable without seeing the data fields? I was so lost when I saw this from a workbook on my friend’s notebook. He came to … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Input data on one worksheet… Get summary on another worksheet in #Excel

Posted on October 17, 2020 by MF

It is a common task that we want to input and maintain all data on one worksheet, and display summary on different worksheets. A typical layout will be similar to the screenshot shown above. One “Input” sheet, and then one … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , | Leave a comment

Unstack data across columns with #Excel Pivot Table

Posted on May 29, 2019 by MF

Another commonly seen problem in daily work.  Many hours are spent on reshaping data, we all know that.  Nevertheless, if you are good in Excel, doing this task is not difficult at all.   Indeed, there are many ways to solve … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

The making of an interactive CV in #Excel

Posted on January 27, 2018 by MF

What to do with Linked Picture to create something interesting in #Excel? How about an Interactive CV to show off your Excel skills!? First, why? Once upon a time when I updated my CV, I was thinking… Everyone states something … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , , , | 5 Comments

Get a list of pending tasks and sort by due dates

Posted on December 3, 2017 by MF

A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Repeat all item labels in Pivot Table (aka Fill in the blanks please)

Posted on October 28, 2017 by MF

Quite a long time ago, I wrote a post Fill in the blanks – quickly to talk about the tip to turn a human-reading-freindly table into an Excel-friendly table, as shown below: Have you ever thought about why we are doing … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

Insert or move a field into Pivot table without drag and drop

Posted on August 20, 2016 by MF

If you do Pivot Table, the following won’t be a stranger to you as you must do a lot drag and drop to pivot. But did you know that you may insert a field name and / or  swap the … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 2 Comments