Tag Archives: Pivot Table

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 , , , , , , | 1 Comment

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