Home
Courses
- Application Training
  - PowerPoint training
  - Access training
  - Word training
  - Outlook training
  - ChatGPT training
  - Power Automate training
  - MS Project training
  - Visio training
  - View all 200+ courses
  Training Programs
  Professional & Management Development
  - Over 70 courses available for Individuals, Corporates, Resellers
  - View all courses
Promotions
- Our Promotions
  Promotions
  
  Last minute deals
  
  Excel Courses London
  We offer London's largest schedule of genuine dates (1104 as of 4:14pm Thu).
  
  Book with confidence up to 12 months ahead. Our MS Desktop & Management Skills courses are never cancelled.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Schedule
- Our Schedule
  We offer London's largest schedule of genuine dates (1104 as of 4:14pm Thu).
  
  Book with confidence up to 12 months ahead. Our MS Desktop & Management Skills courses are never cancelled.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Formats
- Course Formats
  All formats
  
  Public Scheduled Courses
  
  On-site Training
  
  Online Training (Virtual)
  
  Training Programs
  
  Closed Company Events
  
  Consultancy
  One to One training
  
  Training Needs Analysis
  
  Floorwalking
  
  Roll-out
  
  eLearning
  
  Executive Coaching
  When it comes to training, one size does not fit all. We have the ability to be flexible through our experience and commitment to quality.
  
  Whether it's training one person in your office, or assistance with migrating to a new system, we can help you.
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews
Our Clients
- Our Clients
  Client List
  
  Online Reviews
  
  Client Testimonials
  
  Client Feedback
  
  Case Studies
  "The friendliest service... Plus high quality training...could this be the best value training company in London!?"
  
  - Graham C., Learning & Development Manager, Home Office
  More Reviews
  
  98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
  View Live Stats View Reviews

excel-xp-training - Pivot Tables

Resolved · Low Priority · Version Standard

Thu 24 Jan 2008, 14:44 Delegate Pedro said...

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?

Wed 6 Feb 2008, 14:47 Trainer Katie said...

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-xp-training - Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel tip:

Charts

Request A Callback

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

excel-xp-training - Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Charts

Training Programs
Professional & Management Development