Tag Archives: Pivot Table

Unstack data across columns with #Excel Pivot Table

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

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

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)

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

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