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.
This Microsoft Excel – Pivot Tables training course from Infinite Skills teaches you everything you need to know about pivot tables, one of the most powerful features in Excel. This course is designed for users that already have a basic understanding of Excel.
You will start out by learning the basics of pivot tables, such as how to prepare your data, creating manual pivot tables, and using pivot table tools. You will then learn how to manage pivot table data, including understanding and working with the pivot cache, working with the data source, and pivoting data in a pivot table. This course will show you how to properly format pivot tables, teaching you how to apply basic formatting, rename pivot table fields, and format numbers. Finally, this video tutorial will cover topics such as how to sort and filter pivot tables, manipulate calculations, and visualize table data with charts.
Once you have completed this video based training course, you will be comfortable with creating pivot tables using a variety of different methods and manipulating their structure and functionality. Working files are included, allowing you to follow along with the author throughout the lessons.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Preparing For Pivot Tables|
Important - Download These First - Working Files
0101 Series IntroductionPreview
0102 What You Will LearnPreview
0104 How To Access Your Working FilesPreview
0105 Using The Working Files
|Section 2: Getting Started With Pivot Tables|
0201 Getting Started
0202 Why Use Pivot Tables
0203 Identifying Parts
0204 Preparing Data
0205 What Has Changed With Pivot Tables
0206 Creating Pivot Tables - The Quick Analysis Tool
0207 Using Recommended Pivot Tables
0208 Creating Pivot Tables Manually
0209 Reviewing Summary Calculation Details
0210 Using General Pivot Table Tools
|Section 3: Managing Pivot Table Data|
0301 Managing Data
0302 Working With The Data Source
0303 Controlling Pivot Table Refresh
0304 Understanding The Pivot Cache
0305 Working With The Pivot Cache
0306 Pivoting Data In A Pivot Table
|Section 4: Formatting Pivot Tables|
0402 Applying Basic Formatting
0403 Modifying Pivot Table Design Using Layout Options
0404 Renaming Pivot Table Fields
0405 Repeating Row Labels In Pivot Tables
0406 Formatting Numbers In Pivot Tables
|Section 5: Sorting And Filtering Pivot Tables|
0501 Sorting And Filtering - Part 1
0502 Sorting And Filtering - Part 2
0503 How To Sort Pivot Tables
0504 How To Filter Pivot Tables
0505 Using Data Slicers To Filter Pivot Tables
0506 Applying Timelines To Filter By Date
0507 Grouping Data
0508 Grouping By Date
|Section 6: Manipulating Pivot Table Calculations|
0601 Manipulating Calculations
0602 Changing Summary Calculations
0603 Transforming Calculations With Show As
0604 Creating Calculated Fields And Items
|Section 7: Visualizing Data With Pivot Charts|
0701 Visualizing Table Data With Charts
0702 Creating Charts
0703 Manipulating Charts
|Section 8: Course Closing|
0801 What You Now Know
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.