How to Use Pivot Tables in Excel to Create Sub-Reports
In this 2 minute video, Nicky explains how you can create sub-reports using the Pivot Tables function in Excel. In this example, Nicky creates a Pivot Table showing evaluation scores from training courses - then creates a sub-report, displaying each trainer's scores on a different sheet.
How could this tip save you time at work?
Hi, we are Happy
We are leading a movement to create happy, empowered and productive workplaces.
How can we help you and your people to find joy in at least 80% of your work?
How to Use Pivot Tables in Excel to Create Sub-Reports
Pivot Tables are an essential feature if you use Excel to analyse lots of data — it's a favourite here at Happy! You can use Pivot Tables to quickly organise your data into different categories, without affecting the original raw data. They can be used to quickly and easily create dashboards and sub-reports, like the one Nicky creates in the video above.
Related blogs
- How to Create a Pivot Table — If you've never used Pivot Tables before, start with this two-minute video.
- How to Group Dates Together in a Pivot Table — Learn how to group your data together by date in this short video.
- Pivot Tables: How to Put Your Filtered Data on Different Excel Sheets — Sometimes it is necessary to spread your filtered data over several different sheets. Learn how in this quick guide.
Why not sign up to our newsletter?
Sign up to our monthly newsletter, full of tips, tricks and news to help you to be happier and more productive at work.
Learn More Pivot Table Tips in Our Training Courses
Learn how to create Pivot Tables and more with our Excel training courses, to help you to make the most from your data.
With our Excel for Intermediate Users course, you will learn how to create a Pivot Table and how to filter the data to show just what you need with Slicers. We will also explore Pivot Charts, a visual representation of your Pivot Table which you can adjust in different ways to show the information you need.
Our Excel for Intermediate Users: Excel Databases course has been designed for those who use Excel to manage data such as lists of residents, birthday lists, or databases. You will learn how to create a Database in Excel and manage this with Advanced Filter options and create Pivot Tables to see the information you need.
Can't see what you need? Get in touch with us and our friendly team will help you to navigate our range of programmes, or for private group sessions, we can create a course just for you.
Your post-course support package
- Included in the price of both online and classroom programmes
- 2 years of free access to our IT Helpline
- Unlimited access - call or email our team as often as you need
- Ask about any content covered on your course
Claire Lickman
Claire is Head of Marketing at Happy. She has worked at Happy since 2016, and is responsible for Happy's marketing strategy, website, social media and more. Claire first heard about Happy in 2012 when she attended a mix of IT and personal development courses. These courses were life-changing and she has been a fan of Happy ever since. She has a personal blog at lecari.co.uk.
