Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel-xp-training - pivot tables

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

excel-xp-training - Pivot Tables

ResolvedVersion Standard

Pedro has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Whilst on Pivot Tables, how do i make a Qtr1 go from April instead of Jan?

RE: Pivot Tables

Hi Pedro,

Thanks for your question.

All Pivot Tables are based on the data source. So if you want QTR1 ranges from Apr - Jun, you will need to set that in the original table.

Regards,

Katie

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.