Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 2007

Thu 22 Jul 2010, 16:48 Delegate Jonathan said...

Jonathan has attended:
Excel Advanced course

Pivot Tables

Where can I find a well broken down discription of how to produce a pivot table to learn from?

Sun 25 Jul 2010, 17:08 Trainer Simon said...

RE: Pivot Tables

Hi Jonathan,

Thank you for your question.

Please find the YouTube link and other link below which details how to create a Pivot Table:

http://www.youtube.com/watch?v=7zHLnUCtfUk

http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data

I hope this helps.

Regards

Simon

Sun 1 Aug 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Formula for last day of month