Excel With Excel Pivot Tables

Learn the Best Microsoft Excel Pivot Table Features in Excel 2007, Excel 2010, Excel 2013 & Excel 2016
4.4 (229 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.
13,355 students enrolled
$19
$190
90% off
Take This Course
  • Lectures 32
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English, captions
  • 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 2/2015 English Closed captions available

Course Description

                              *** COURSE UPDATED OCTOBER 2016 ***

11 new tutorials have been added to the newly created Bonus chapter as well as 3 case studies under the Case Study chapter! 

---------------------------------------------------------------------------------------------------------

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this 2 and a half hour course which goes through the most important tools that are available in an Excel Pivot Table. The course is designed for Excel 2007, Excel 2010, Excel 2013 and Excel 2016.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.

What you will learn?

  • How to set up your data and create an Excel Pivot Table in less than 3 minutes which will increase your efficiency!
  • How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Excel Pivot Table, taking your analytical skills to another level!
  • How to create an Interactive Excel Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management!
  • Pivot Table tips & special Bonus material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!
  • Scroll down this page to view the full Course Curriculum...

What you get?

  1. An HOUR LONG Excel Pivot Table tutorial that touches on the most important tools you need, in order to get you up and running and start applying to your job straight away...with CONFIDENCE!  
  2. BONUS Pivot Table tips & tricks video tutorial;
  3. BONUS CHAPTER (60 MINUTES) which shows the most used Excel Pivot Table features plus a CASE STUDIES CHAPTER (30 MINUTES) with 3 real life Excel business case scenarios!
  4. All tutorials come with DOWNLOADABLE VIDEOS in mp4 format, so you can watch while you are offline or traveling;
  5. Access to the Excel workbook that is shown in the training video, so you can follow along and practice the new tricks learned;
  6. High Definition quality videos viewable from your PC, laptop, tablet or mobile phone.
  7. LIFETIME online access, anywhere in the world, 24x7!
  8. My personal support if you ever get stuck with a Pivot Table problem;
  9. When you have finished with this course you will receive a Certificate of Completion, which you can add to your resume!

What some of the thousands of students who have viewed this tutorial have said...

The webinar was fantastic! I had quite a few jaw-dropping moments! - Tan - Livingston

I am one of the more advanced users in our organisation but I have realised that I knew next to nothing.
Jocelyn - Melbourne

Not a question but just wanted to say in the space of 9 minutes I've learnt a lot. Richard - London

Wow! No question, just wow! Amazing!
John - Hamburg

Simply awesome, with in an hour I found myself a Pivot expert - Natalie - Boston

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way and I want to help you out as well because you deserve it! These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

So go ahead and learn from the following Pivot table subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...

What are the requirements?

  • Excel 2007, 2010 & 2013. This course was recorded using Excel 2010 but all the concepts taught are compatible with Excel 2013 and 2007.
  • Microsoft & Apple compatible

What am I going to get from this course?

  • How to set up your data and create a Pivot Table in less than 3 minutes which will increase your efficiency!
  • How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Pivot Table, taking your analytical skills to another level
  • How to create an Interactive Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management
  • Pivot Table tips & special Bonus attendee material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!

What is the target audience?

  • New users, beginners, intermediates and advanced Excel 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: EXCEL PIVOT TABLES
Article

There are two Excel workbooks for you when you download using the Resources button.

One is in a "Start" format so you can follow along and create the Pivot Tables as I teach you  in each video.

The other one is in a "Finished" format so you can see how each Pivot Table looks in its final format.  This way you can play around and see how the Pivot Table was created.

Thanks,

John

EXCEL RESOURCE BLOG
Preview
Article
MYEXCELONLINE PODCAST SHOW
Preview
Article
Introduction
Preview
01:25
Why Most People Don´t Know How To Use Excel Pivot Tables?
Preview
06:20
05:57

How to clean up your data set so you can create a flawless Pivot Table plus I show you why you should always convert your data in to an Excel Table.

06:04

Insert your first Pivot Table and explain the different Fields that you should put in the Row Labels, Column Labels, Report Filter and Values area.

03:58

How to Refresh a Pivot Table when you add more information in your data source;

Number formatting a Pivot Table;

Pivot Table Design: Styles, Grand Totals & Report Layout, Repeat All Items when in Outline Form layout.

02:32

How to add different calculations in your Pivot Table like Sum, Count and Average.

07:16

How to show your Sales Field as $ of Running Total In or YTD and the $ Difference from Previous Month.

07:02

How to Group by Sales numbers, Weeks and Text.

03:57

How to insert a Slicer and the different ways you can style & format a Slicer.

02:20

How to insert a Pivot Chart from a Pivot Table or a Slicer.

04:12

How to use a Slicer & a Pivot Chart to create an Interactive Dashboard by using Pivot Table Connections

09:40

Several time saving tips & tricks that will WOW YOU!

Section 2: BONUS VIDEOS
Article

Dear Student,

I have included the Excel workbooks for Lectures 16-26 which you can download and keep on your desktop to practice forever!

This workbook is in a "Finished" form with the Pivot Table already created for you, as I show you during the video.

You can follow along by creating a NEW Pivot Table simply by clicking in the data within the Data_Table worksheet of each workbook and going to Insert > Pivot Table.

You can then follow along as I go through the instructions in each tutorial. 

Thanks, John

Show the Classic Pivot Table Layout
01:08
Show various Grand Totals
Preview
02:36
Actual v Plan Variance Report
04:43
Group two pivot tables independently
03:52
Sort manually
02:01
Filter by Text wildcards * and ?
03:27
Different ways to filter a Slicer
01:22
Excel formulas & Calculated Fields
03:07
Data Bars, Color Scales & Icon Sets
05:49
Create a custom report with GETPIVOTDATA
05:24
Different pivot table views macro
04:43
Section 3: EXCEL BUSINESS CASE STUDIES
06:36

Dear Student,


I have included the Excel workbook for this tutorial which you can download and keep on your desktop to practice forever!


This workbook is in a "Finished" form with the Pivot Table already created for you, as I
show you during the video.


You can follow along by creating a NEW Pivot Table simply by clicking in the data within the
Data_Table worksheet of each workbook and going to Insert > Pivot Table.


You can then follow along as I go through the instructions in each tutorial. 


Thanks,
John

15:55

Dear Student,


I have included the Excel workbook for this tutorial which you can download and keep on your desktop to practice forever!


This workbook is in a "Finished" form with the Pivot Table already created for you, as I
show you during the video.


You can follow along by creating a NEW Pivot Table simply by clicking in the data within the
Data_Table worksheet of each workbook and going to Insert > Pivot Table.


You can then follow along as I go through the instructions in each tutorial. 


Thanks,
John

12:21

Dear Student,

I have included the Excel workbook for this tutorial which you can download and keep on your desktop to practice forever!

This workbook is in a "Finished" form with the Pivot Table already created for you, as I
show you during the video.

You can follow along by creating a NEW Pivot Table simply by clicking in the data within the
Data_Table worksheet of each workbook and going to Insert > Pivot Table.

You can then follow along as I go through the instructions in each tutorial. 

Thanks,
John

Section 4: QUIZZES
Recognize which button is used to update a Pivot Table
1 question
Recall the way to change a "Count Of" to a "Sum Of"
1 question
Identify the steps to showing the values as a Year to Date
1 question
State which command is used to group a PivotTable report by weeks
1 question
Recall the way to connect a Slicers to Pivot Tables
1 question
Section 5: MY COMPREHENSIVE EXCEL PIVOT TABLE COURSE
08:28

Dear Valued Student,

First of all I would like to thank you for purchasing the Excel With Excel Pivot Tables - Intro course.

I know that you have learned some new tricks that will make you better at Excel, so you can show off to your colleagues and boss!

With this course you have only just scratched the tip of the iceberg!

The next step in advancing your Excel skills and taking your Pivot Table analysis to the next level is the Xtreme Pivot Table Online Course!

This is an AWESOME course...especially considering you will be able to get all of the below from this online course:

 

  • Lifetime Online Access + Course Updates so you can view at any time and are up to date with new Pivot Table features;
  • 14 chapters ranging from Analysis, Slicers, Pivot Charts, Conditional Formatting & Macros with over 200 videos and 10+ hours of content
  • Downloadable Excel Workbooks so you can follow along & practice or skip directly to the answers
  • Downloadable MP4 Videos to keep on your desktop and view the course offline or when travelling
  • Certificate of Completion to enrich your CV/Resume as well as add to your LinkedIn profile
  • 7 x Limited Time Bonuses ($1,193 in value) which include:

·          30 Day Money Back Guarantee so you can view the course without any risk

·         Course Bonus #1 ($490 Value): 12 Months of Dedicated Pro-Level Email Support

·         Course Bonus #2 ($197 Value): 25% Lifetime Discount on Any MyExcelOnline.com Courses

·         Course Bonus #3 ($25 Value): Power Pivot & Power BI Downloadable E-Book

·         Course Bonus #4 ($90 Value): Pivot Table Cheat Sheet, Workbook Progress Tracker & Top 20 Keyboard Shortcuts

·         Course Bonus #5 ($197 Value): Pivot Table webinar replay

·         Course Bonus #6 ($97 Value): Intro to Power Query Online Course

·         Course Bonus #7 ($97 Value): Intro to Power Pivot Online Course

STUDENT TESTIMONIALS:

 

“I have learned more about Pivot Tables within a week of taking this course than I have over the last couple of years. Really amazing stuff!” Joyce – England

 

“This is the best Excel course that I have taken! It not only talks about Pivot Tables in great detail, it also touches on charts, conditional formatting and macros. I can also track my progress and enter in Discussions with the lecturer who is always quick to respond. Excellent course for any Excel level” Jose - Spain

 

“This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money” James - USA

 

Now I want you to become better at your job and by taking this course you will be able to analyze data quicker, prepare awesome looking reports & interactive dashboards that will make you a key part of your team!

 

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc.....then this is the course for YOU!

 

Get off the fence and get started NOW and join over 14,000 professionals who have taken this course and enhanced their Excel skills. Every hour you delay is delaying your professional progress.

UDEMY STUDENT DISCOUNT:

As a valued Udemy student you get lots of benefits and this is no exception! You will get a 25% discount on the course price simply by entering the following coupon code: udemystudent

 

Click the links below to join the course today.  This will take you to a webinar page where you need to enter your details, watch the webinar where you will receive your invitation & special instructions on how to join this course which is open only a few times per year:

 

                                                   Click to join the Xtreme Pivot Table Online Course


If you have any queries please email me at john@myexcelonline.com and I will get back to you asap.  To your success!

Regards,

 

John Michaloudis

JOHN MICHALOUDIS

 

Chief Inspirational Officer

www.MyExcelOnline.com

THANK YOU!
01:26

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

John Michaloudis, Founder of MyExcelOnline | 25,000+ Excel Students

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline.  I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

Join one of my courses and get ready to change your life!

Ready to start learning?
Take This Course