Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Pivot Tables

excel training seminar - Pivot Tables

ResolvedVersion Standard

Wed 17 Jan 2007, 09:45 Delegate Paul said...

Paul has attended:
Excel Advanced course

Pivot Tables

I need to create a monthly, quarterly and annual report on sales productivity taking data from 4 or 5 seperate reports, will a pivot table enable me to create this report more effectively.

Thu 18 Jan 2007, 12:33 Trainer Richard said...

RE: Pivot Tables

Depending on how your data is formatted, Pivot Tables might be a way to summarise the information more effectively. Ensure you can get the data into a single sheet with uniform formatting. If all the data on the 4 to 5 sheets has the same layout and formatting, then you might be able to use consolidation to bring them all together.

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

excel training seminar - Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Formula for last day of month