Microsoft Excel Pivot Tables - In-Depth Excel Training

Learn How To Manipulate Your Excel Data With Pivot Tables. An Essential Course For All Excel Users
4.1 (15 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
775 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 43
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2014 English

Course Description

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.

What are the requirements?

  • Excel 2010 or Excel 2013

What am I going to get from this course?

  • Learn how to use Pivot Tables In Microsoft Excel

What is the target audience?

  • Beginning to Advanced Users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Preparing For Pivot Tables
Important - Download These First - Working Files
Article
0101 Series Introduction
Preview
03:52
0102 What You Will Learn
Preview
03:28
0104 How To Access Your Working Files
Preview
02:45
0105 Using The Working Files
03:10
Section 2: Getting Started With Pivot Tables
0201 Getting Started
04:14
0202 Why Use Pivot Tables
06:12
0203 Identifying Parts
04:23
0204 Preparing Data
03:45
0205 What Has Changed With Pivot Tables
06:57
0206 Creating Pivot Tables - The Quick Analysis Tool
04:51
0207 Using Recommended Pivot Tables
03:27
0208 Creating Pivot Tables Manually
10:29
0209 Reviewing Summary Calculation Details
06:21
0210 Using General Pivot Table Tools
06:41
Section 3: Managing Pivot Table Data
0301 Managing Data
02:59
0302 Working With The Data Source
06:25
0303 Controlling Pivot Table Refresh
07:56
0304 Understanding The Pivot Cache
04:58
0305 Working With The Pivot Cache
07:35
0306 Pivoting Data In A Pivot Table
09:48
Section 4: Formatting Pivot Tables
0401 Formatting
04:27
0402 Applying Basic Formatting
04:06
0403 Modifying Pivot Table Design Using Layout Options
07:13
0404 Renaming Pivot Table Fields
04:09
0405 Repeating Row Labels In Pivot Tables
02:42
0406 Formatting Numbers In Pivot Tables
06:53
Section 5: Sorting And Filtering Pivot Tables
0501 Sorting And Filtering - Part 1
07:22
0502 Sorting And Filtering - Part 2
07:41
0503 How To Sort Pivot Tables
06:56
0504 How To Filter Pivot Tables
10:42
0505 Using Data Slicers To Filter Pivot Tables
07:45
0506 Applying Timelines To Filter By Date
05:42
0507 Grouping Data
04:54
0508 Grouping By Date
06:57
Section 6: Manipulating Pivot Table Calculations
0601 Manipulating Calculations
09:44
0602 Changing Summary Calculations
07:02
0603 Transforming Calculations With Show As
07:57
0604 Creating Calculated Fields And Items
06:58
Section 7: Visualizing Data With Pivot Charts
0701 Visualizing Table Data With Charts
03:14
0702 Creating Charts
03:53
0703 Manipulating Charts
07:33
Section 8: Course Closing
0801 What You Now Know
06:38

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

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.

Ready to start learning?
Take This Course