Prepare source data
Create a pivot table
Configure a pivot table
Pivot table features
Summarize & analyze
Unique distinct list
Unique distinct records
Count unique distinct
See data behind
Insert pivot chart
Refresh a pivot table
No link to source data
Customize the layout
Articles in category
Discover Pivot Tables – Excel’s most powerful feature and also least known
Pivot table calendar
Sum stock portfolio
Time sheet by project
Disable auto col width
Normalize data [VBA]
Auto populate a worksheet
Drop-down - source
Count uniq. dist. 
Based on condition (2)
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Today I am going to demonstrate how amazing pivot tables are! Take a look at this time sheet.
You can expand each month and see time spend on each project. The pivot table also shows a summary of both months and projects.
I made the pivot table from a simple table containing fake project time data.
This table can have duplicate dates, as you may be working on multiple projects in a single day.
Picture of a monthly timesheet by project with overtime hours.
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
Extract unique distinct values from a filtered Excel defined Table [UDF and Formula]
Robert Jr asks: Oscar, I am using the VBA code & FilterUniqueSort array to generate unique lists that drive Selection […]
Count unique distinct values in a filtered Excel defined Table
This article demonstrates a formula that counts unique distinct values filtered from an Excel defined Table. Debra Dalgleish described in […]
Auto refresh a pivot table
In a previous post: How to create a dynamic pivot table and refresh automatically I demonstrated how to refresh a pivot […]
Use hyperlinks in a pivot table
Sean asks: Basically, when I do a refresh of the data in the "pivotdata" worksheet, I need it to recognise […]
How to create a dynamic pivot table and refresh automatically
This article shows you how to refresh a pivot table automatically using a small VBA macro. If you add or delete […]
Calendar – monthly view
Tesh asks: How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe […]
Plot date ranges in a calendar part 2
I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]
I've been experimenting with various formats (in Excel ofcourse) for tracking my time, but have never been totally satisfied. This PivotTable might just be the ticket! Thanks for sharring!
I am happy you like it!
Mail (will not be published) (required)
Notify me of followup comments via e-mail
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
You can contact me through this contact form