Excel With Excel Pivot Tables
4.6 (276 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.
14,159 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel With Excel Pivot Tables to your Wishlist.

Add to Wishlist

Excel With Excel Pivot Tables

Learn the Best Microsoft Excel Pivot Table Features in Excel 2007, Excel 2010, Excel 2013 & Excel 2016
4.6 (276 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.
14,159 students enrolled
Last updated 2/2017
English
English
Current price: $10 Original price: $190 Discount: 95% off
18 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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!
View Curriculum
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
Description

                              *** COURSE UPDATED FEBRUARY 2017 ***

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

I have also included the following bonus downloadable material:

  1.  My latest Excel Infographic about creating a Pivot Table in 5 Speedy Steps!
  2.  My Pivot Table Cheat Sheet that you can print out and stick on your desk, showing you the must know shortcuts (16 in total) to create, format, analyse & supercharge your Excel data!

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

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 ...

Who is the target audience?
  • New users, beginners, intermediates and advanced Excel users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 34 Lectures Collapse All 34 Lectures 02:25:08
+
EXCEL PIVOT TABLES
17 Lectures 01:01:49

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

Preview 00:18

BONUS INFOGRAPHIC: 5 Speedy Steps To Creating a Pivot Table
00:00

BONUS CHEAT SHEET: Excel Pivot Tables
00:00





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.

Tabular Format & Excel Tables
05:57

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.

Creating an Excel Pivot Table
06:04

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.

Formatting an Excel Pivot Table
03:58

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

Summarize Values By
02:32

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

Show Values As
07:16

How to Group by Sales numbers, Weeks and Text.

Grouping
07:02

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

Slicers
03:57

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

Excel Pivot Charts
02:20

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

Creating an Interactive Excel Dashboard with Slicers & Pivot Charts
04:12

Several time saving tips & tricks that will WOW YOU!

BONUS: Pivot Table Tips & Tricks!
09:40
+
BONUS VIDEOS
12 Lectures 38:35

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

DOWNLOADABLE EXCEL WORKBOOKS
00:23

Show the Classic Pivot Table Layout
01:08


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
+
EXCEL BUSINESS CASE STUDIES
3 Lectures 34:52

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

CASE STUDY #1: Sales Actuals v Plan with Calculated Fields
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

Preview 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

CASE STUDY #3: Interactive Balance Sheet Excel Pivot Table
12:21
+
QUIZZES
0 Lectures 00:00
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
+
MY COMPREHENSIVE EXCEL PIVOT TABLE COURSE
2 Lectures 09:54

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

Xtreme Pivot Table Course - Lifetime Online Access & Downloadable Videos
08:28

THANK YOU!
01:26
About the Instructor
John Michaloudis
4.4 Average rating
797 Reviews
19,664 Students
3 Courses
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!