Entry requirements
There are no formal entry requirements for this course, however delegates should have an intermediate understanding of Microsoft Excel.
Why take this course?
This course provides an introduction to Microsoft Excel pivot tables, followed by an in-depth look at some of its advanced features.
Delegates will gain a solid understanding of using pivot tables for effective data analysis, and also receive a high-level overview of Microsoft Power Pivot.
This course is suited to both those with no experience of pivot tables, as well as those looking to refresh their existing knowledge.
What you will experience
This one-day course is available for delivery online using Microsoft Teams for up to ten delegates.
As well as being introduced to Excel pivot tables and Microsoft Power Pivot, you will learn how to:
- Convert data to tables
- Adjust field list settings
- Create multiple reports with one click
- Add data bars to pivot tables
- Master pivot table settings
- Add and remove calculated fields to pivot tables
- Calculate the difference between columns
- Add smart custom number formatting
- Create custom groupings to pivot tables
- Group dates as unique
- Add slicers to easily filter data
- Add dynamic charts
- Add a timeline to pivot tables
Key Facts
Key information you should know about this course.
What you will get
A NESCol continuous professional development certificate.
What you will need
- Laptop or computer
- Stable internet connection
- Two displays (beneficial but not essential)
Fees
- £195 per delegate
- £750 for 4 or more delegates (maximum of 10)
Entry requirements
There are no formal entry requirements for this course, however delegates should have an intermediate understanding of Microsoft Excel.
What you will get
A NESCol continuous professional development certificate.
What you will need
- Laptop or computer
- Stable internet connection
- Two displays (beneficial but not essential)
Fees
- £195 per delegate
- £750 for 4 or more delegates (maximum of 10)
Entry requirements
There are no formal entry requirements for this course, however delegates should have an intermediate understanding of Microsoft Excel.
What you will get
A NESCol continuous professional development certificate.
What you will need
- Laptop or computer
- Stable internet connection
- Two displays (beneficial but not essential)
Fees
- £195 per delegate
- £750 for 4 or more delegates (maximum of 10)
Student Stories
Rebekka McLaughlin
Business & Management
SVQ Management
“I’ve had such a positive experience with the College and can’t recommend the workplace learning route highly enough. I think it’s important to recognise that there are various routes to achieving qualifications and this was the right path for me.”
Read more about Rebekka's story
Katelyn Louise Share
Business & Management
HND Administration & Information Technology
“NESCol is such a supportive place to study, and the staff go above and beyond to help you achieve your goals.”
Read more about Katelyn's story
Danielle Craig
Computing
HND Web Development (including Digital Design & Development)
“I loved that the course covered a broad range of topics, from animation and graphic design to programming”
Read more about Danielle's story
Kate Wolska
Business & Management
HND Accounting
“My daughter is so proud of me. I’m doing it for her – to show her if you want it, you can do it now for tomorrow.”
Read more about Kate's story
Drew Smith
Business & Management
Business Skills Foundation Apprenticeship
“If you’re not too sure about what you want to do, then I would definitely recommend a Foundation Apprenticeship because it gives you an insight into working while you’re still studying.”
Read more about Drew's story
Morven Garden
Business & Management
Business Administration Modern Apprenticeship
“I feel confident moving forward as the experience of a Modern Apprenticeship and the skills I have managed to develop stand as a strong base structure for the rest of my career.”
Read more about Morven's story
Rebecca Clements
Computing
HND Web Development (including Digital Design and Development)
“I’ve had a passion for computing from a very young age. I decided when my son was starting school that it was the best time to go back and follow a dream I had put on hold.”
Read more about Rebecca's story
Ella-May Quinn
Computing
HND Web Development (including Digital Design & Development)
“I really enjoyed the course and the hands on nature of the learning. Being able to build websites was great and I got a real sense of achievement from the work we were asked to produce.”
Read more about Ella-May's story
Scott Duncan
Computing
HND Digital Development & Design (Games Development)
“I feel the course has prepared me well for my new role and I’m excited to put my new skills into practice and have the opportunity to do something I love every day! “
Read more about Scott's story
Martin Meszaros
Computing
HND Cyber Security
“I really have so much to thank NESCol for. I’m sure it is an experience that will have a positive impact throughout my life.”
Read more about Martin's story
Applications
North East Scotland College offers hundreds of courses each year, apply for one now.
To book your place or find out more, contact our Workforce Development team:
Email workforce@nescol.ac.uk
Please note that timetabling changes can often occur after the Part-time Course Guide is published, and as a result the printed version of the guide may not hold the most up-to-date information.
We therefore advise you that all start dates and times listed on the website are at all times accurate, and should be used as your main point of reference before booking your course.
Fees quoted apply to individuals who meet our residency criteria for home fee status. A higher fee may apply if criteria cannot be met; evidence may be required. Please contact enquiry@nescol.ac.uk for further information.
If you take up a place on a College course, at the start of the course you will be asked to complete an enrolment form. In completing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.
Similar courses for you
Here are some courses you may also be interested in.
