Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Excel Pivot tables provide a powerful way to summarise and report on vast amounts of Data. You’ll learn in detail how Pivot Tables work and the structure that must be followed to create useful reports and charts. This course is vital to gaining the most from this powerful feature of Excel.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Create a Pivot Chart from a list|
This section includes the exercise files for Pivots Tables. Please download these before you start the course.
Why do we use a pivot table?Preview
Create a pivot table from a listPreview
Formatting the Pivot tablePreview
Create a pivot chart from a list
Formatting the Pivot Chart
Refreshing a pivot table and pivot chart
Drill down lists
Multiple headings in table
Copy and paste into other worksheets
Copy and paste into Word and PowerPoint
Using action settings
Using Calculation settings
Turning on and off option in Show group
Editing Pivot table options
Extra options in Excel 2013
Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.
Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.