Pivot Table Masterclass
|
Summary
|
|
|||||||||||
Pivot Table Masterclass
This 75 minute session is a masterclass in pivot tables. It will cover how to create pivot tables, and how to summarise the data in them. It will look at how to sort and filter pivot data, as well as how to format the tables.
We recommend that you attend one of our Learn How to Learn Online sessions before attending this Virtual Classroom to ensure that you get the most out of the course. To book a free place, click here or contact us on 0800 170 7777.
If you want to find out more about Pivot Table Masterclass, you can make an information request below and the school will contact you with further information.
Suitability and application
What will I get out of it?
- Formatting data for use in a PivotTable
- Configuring a PivotTable
- Connecting to an external data source
- Managing PivotTables
- Adding, removing, and positioning subtotals and grand totals
- Changing the PivotTable data field summary operation
- Summarising more than one data field
- Creating a calculated field
- Grouping PivotTable fields
- Using PivotTable data in a formula
- Drilling down to the underlying data
- Sorting PivotTable data
- Creating a custom sort order
- Filtering a PivotTable
- Filtering a PivotTable with report filter fields
- Clearing and reapplying PivotTable filters
- Highlighting cells by applying a rule
- Highlighting the top or bottom values in a PivotTable
- Formatting PivotTable cells using data bars
- Conditional formatting rules
Expenses
Reed Learning PLC
Reed Learning
Short Courses and Professional Qualifications
Reed Learning is one of the biggest business training companies in the UK. We’re part of the Reed group of companies, founded 50 years ago and still family-run.
Public, scheduled training courses
We run more than 250 different short courses. In the last 10 years we’ve trained over 150,000 people, including 20,000 new managers, 12,000 people who were scared of doing presentations, and 14,000 who needed to learn to prioritise.
Our core areas are:
- Management & leadership
- Personal Development including Communication, Anger, Stress & Time Management
- Project Management
- Health & Safety
- Microsoft & Google
- Sales, Customer Service & Marketing
- HR & Training
- PA & Secretarial
We also offer a brand new range of virtual classrooms on our most requested topics. These 75 minute sessions provide tutor-led, concentrated tuition in core subjects."
People choose us because our trainers are experienced, we have a vast choice of programmes, our rates are very reasonable and because our training makes people feel motivated and full of ideas to use back at work.
Try one of our courses – we guarantee you’ll feel it's worthwhile, or your money back.
Professional qualifications
Reed Learning offers one of the widest choices of professional qualifications in the UK, including:
- Chartered Management Institute management qualifications at levels 3 to 5, new CMI one-day qualifications and Chartered Manager qualification
- Postgraduate Certificate in International Business from Royal Holloway, University of London
- ASTD & CIPD qualifications in training, L&D and HR
- Senior management accelerated route to Chartered Banker status
- The UK’s first Certificate in Professional PA & Secretarial Skills, in partnership with the Institute of Professional Administrators
- ISMM Diploma in Advanced Sales and Marketing
- NEBOSH national certificate and the IOSH Managing Safely programme
In-house / on-site training
As well as our scheduled courses, we can come to you. We run successful on-site training for some huge organisations like Sky, the AA and Pepsi, and some smaller ones like the Welsh Language Board, Webworks and London Borough of Brent
Outsourcing & Managed Services
We run outsourced training services, providing trainers, scheduling courses and taking care of all the administration. Our clients span the banking, local government and media sectors, and in the past five years we’ve helped them save hundreds of thousands of pounds.
Get in touch
Whether you want to book a short course, arrange something in-house or discuss your organisation’s learning strategy, we’ll bend over backwards to deliver the right training programme at the right price.
Contact us and tell us what you’re looking to achieve this year here.
Show all courses with
Reed Learning PLC
Request information - obligation free
Contact information for Reed Learning PLC
Phone no: 020 7520 5100 
To request information from Pivot Table Masterclass, please fill out the following details:
