Excel Skills: Mastering Pivot Tables

Course Code: 26890

Teacher: This course is being taught by Paul.

What is this Course about?

This 5-week course is designed to help adult learners build confidence in using Microsoft Excel for data analysis and reporting. Pivot Tables are powerful tools that make it easier to understand, summarise, and present information clearly. Through hands-on practice and real-world examples, you’ll learn how to use Pivot Tables to make sense of data, spot trends, and support decision-making. You’ll learn:

• What Pivot Tables Are and Why They Matter
• How to Create and Format Pivot Tables Step-by-Step
• Using Filters, Sorting, and Grouping to Explore Data
• Real-World Applications for Work and Everyday Life
• Tips for Presenting Data Clearly and Professionally

By the end of the course, you’ll feel more confident using Excel and be able to apply your skills in work, volunteering, or personal projects.

Who is this Course for?

Anyone looking to enhance their Excel proficiency for personal or professional use.

Take our Excel quiz to see if this course is suitable for you.

Entry Requirements to do this Course:

• A basic level of conversational and written English is needed to complete this course.
• Basic computer skills.
• Be comfortable with basic Excel functions such as formatting, sorting, filtering, and using formulas like SUM and AVERAGE.

How you will be assessed?

Question & Answer, Discussions, activities and observations. You will also be asked to complete Learner reflections.

How much studying will I need to do outside of the lesson?

It will be advised to use the skills learnt in the classes and practise on your own Excel documents and devices.

What learners need to bring/supply

Learners must have access to Microsoft Excel and a laptop or desktop with good Wi-Fi and a webcam (if online).

If the course is face -to-face the laptop will need to be brought to the venue. 

What happens after I book this course?

There are two steps to complete before studying with us and booking on here is the first step. Your next step will be to enrol on your chosen course following the instructions in your order confirmation email.

The next steps…

During this course we will talk to you about your next steps which could include attending other courses/workshops such as Introduction to MS Word, Improve your skills in MS Word, Improve your skills in MS Excel, Introduction to PowerPoint and Improve Your Skills in MS PowerPoint, AI in the Workplace. Employability courses are available if you are looking to get into work or change your career. 

Please see the full range of courses we offer.

We have programmes that can support you with your next steps in skills and employment. For further information please see our information, advice and guidance page.

NOTE: This course is for Hertfordshire Residents Only - *With the exception of the registration fee, this course/workshop is fully funded by The Education & Skills Funding Agency for adults who meet a set criteria - please see further details under the 'Further Information' heading.