Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Pivot Tables - In-Depth Excel Training to your Wishlist.

Add to Wishlist

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.4 (18 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.
789 students enrolled
Last updated 1/2017
English
$15 $50 70% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.

Who is the target audience?
  • Beginning to Advanced Users
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn how to use Pivot Tables In Microsoft Excel
View Curriculum
Requirements
  • Excel 2010 or Excel 2013
Curriculum For This Course
Expand All 43 Lectures Collapse All 43 Lectures 04:10:45
+
Preparing For Pivot Tables
5 Lectures 13:16
Important - Download These First - Working Files
00:01




0105 Using The Working Files
03:10
+
Getting Started With Pivot Tables
10 Lectures 57:20
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
+
Managing Pivot Table Data
6 Lectures 39:41
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
+
Formatting Pivot Tables
6 Lectures 29:30
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
+
Sorting And Filtering Pivot Tables
8 Lectures 57:59
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
+
Manipulating Pivot Table Calculations
4 Lectures 31:41
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
+
Visualizing Data With Pivot Charts
3 Lectures 14:40
0701 Visualizing Table Data With Charts
03:14

0702 Creating Charts
03:53

0703 Manipulating Charts
07:33
+
Course Closing
1 Lecture 06:38
0801 What You Now Know
06:38
About the Instructor
4.4 Average rating
33,697 Reviews
664,742 Students
331 Courses
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.

Report Abuse