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)
Student Stories
Charlie Priestley
Computing
HND Networking & Cloud Infrastructure (NextGen)
“I honestly don’t think university could have taught me the skills I have learned here.”
Read more about Charlie's story
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
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:
Similar courses for you
Here are some courses you may also be interested in.
