Excel - How To Create And Use Pivot Tables
Skill Success
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This course includes lifetime access so you can complete it at your own speed.
Learn the basics of creating a pivot table to easily organize, display, and analyze large amounts of data.
Benefits of taking this course include:
- Unlimited and lifetime access to the course
- Learn the course at your own pace
- Course can be accessed on any platform
- 24/7 Customer support
Certificates
Certificate of completion
Digital certificate - Included
Course media
Description
What you'll learn:
- Learn how to create a pivot table
- Discover how to turn existing data into a pivot table
- Find out how to use useful tools such as slicers
- Learn interesting ways to organize and display your data
Hello and welcome to my course on how to create and use pivot tables.
What is a pivot table?
Pivot tables are a tool exclusive to Microsoft Excel, and they are extremely useful when dealing with large amounts of data. A pivot table is used to summarize a large amount of data into an easy-to-read table. You will find them an invaluable way to save time, and organize and present your data.
In this course, I will take you from the very beginning and show you exactly how to turn your data into a pivot table, enter useful tools like slicers and how to present your pivot table.
This course is for complete beginners as everything is explained fully and in simple-to-understand terms.
Excel - How To Create And Use Pivot Tables will cover the following topics:
Section 1 - Introduction
- Introduction
Section 2 - How To Create A Pivot Table
- Adding Your Data To A Table
- How To Select All Data
- Create A Pivot Table
- Filtering Results
- Recommended Pivot Tables
- Inserting A Slicer
- Adding Data To Your Pivot Table
- Changing Pivot Table Layouts
Who is this course for?
- This course is for anybody who needs to analyze data
- It's for complete beginners and even more advanced spreadsheet users
Requirements
- You'll need a copy of Microsoft Excel
Career path
None
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.