Microsoft Excel - Excel with Excel Pivot Tables Bootcamp! (Udemy.com)

Excel with the A-Z Microsoft Excel Pivot Tables & Excel Data Analysis [Excel 2010, Excel 2013, Excel 2016, Excel 2019]

Created by: MyExcelOnline John Michaloudis

Produced in 2020

icon
What you will learn

  • ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!
  • Become an Excel & Pivot Table ADVANCED user within HOURS which will get noticed by top management & prospective employers!
  • Learn to use Excel Pivot Tables PROFESSIONALLY & CONFIDENTLY, with the most IN-DEPTH Pivot Table course on Udemy with 250+ video tutorials!
  • Knowing Pivot Tables & Data Analysis will increase your PROFESSIONAL DEVELOPMENT and lead to greater opportunities like a HIGHER Salary and PROMOTIONS!
  • Learn ALL the Pivot Table features: Slicers, PivotCharts, Filtering, Grouping, Sorting, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting plus MORE!
  • DOWNLOADABLE Excel workbooks so you can keep on your desktop & practice!
  • Access 16 Finance & Accounting Real World Case Studies PLUS learn the NEW Excel 2013, 2019 & 2019 Pivot Table

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

***** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! *****
***** THE MOST VIDEO TUTORIALS (250+ VIDEOS & 11 HOURS) IN ANY OF THE UDEMY EXCEL PIVOT TABLE & DATA ANALYSIS COURSES *****
>> UPDATED NOVEMBER 2019 with the New Excel Pivot Tables Features For Excel 2019 & Office 365!
>> 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
----------
Listen to a few of our satisfied students who have taken this TOP-RATED Excel Pivot Table & Data Analysis course and advanced their Excel skills in days:
"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
"I thought I was good in Excel before starting this course, but this course showed me how much more I can do in Excel. I used most of the techniques taught in the course to create a Dashboard at work. John's teaching style is perfect. Unlike other courses, he used real examples to explain the concepts. I highly recommend this course" - Sumit
"I would highly recommend this course for anyone who is keen to learn all features of Pivot Tables. The practical examples i.e. Interactive Balance Sheet Pivot table, Top 10 macro are just a few of the great examples. Tutor also helped by promptly answering questions when I stuck. All in all, a highly recommended course!" - A.R.
----------
If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!
This is the most comprehensive Excel Pivot Table online course ever made which has over 250 short and precise tutorials.
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.
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. The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!
There are 17 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies. Here are the main topics that we will cover in this course:
  1. CUSTOMIZE YOUR PIVOT TABLE
  2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
  3. VALUE FIELD SETTINGS > SHOW VALUES AS
  4. GROUPING
  5. SORTING
  6. FILTERING
  7. SLICERS
  8. CALCULATED FIELDS & ITEMS
  9. PIVOT CHARTS
  10. CONDITIONAL FORMATTING
  11. GETPIVOTDATA Formula
  12. MACROS
  13. DATA MANAGEMENT
  14. BONUS VIDEOS
  15. NEW EXCEL 2013 PIVOT TABLE FEATURES
  16. NEW EXCEL 2016 PIVOT TABLE FEATURES
  17. NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES
----------
Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...
saving HOURS each day, DAYS each week and WEEKS each year
...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job
...All whilst impressing your boss and STANDING OUT from your colleagues and peers...
...THEN THIS COURSE IS FOR YOU!
Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!
To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...
----------
>> Get LIFETIME Course access including over 250 downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and a 100% money-back guarantee! ***
>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***Who this course is for:
  • New users, beginners, intermediates and advanced Excel users
  • Excel users who want to learn Excel quickly, increase their Excel level and get noticed by their boss!

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

MyExcelOnline John Michaloudis

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am the Chief Inspirational Officer at MyExcelOnline.
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 & save you time, 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 50,000 students on Udemy alone plus over 100,000 people on my website - MyExcelOnline. I have an active Excel 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

icon
Students also recommend

Free

Free

$14.53

icon
Reviews

4.6

98 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Walter Maryniuk on a week ago

It met my need for taking the course when I had the time.

By Peter Lindeman on 4 weeks ago

This course was exactly what I needed having struggled to get my head around pivot tables and graphs! Most lessons was perfectly aligned to my skill level. The only downside is the 10 sec intro in the beginning of every lesson that in some parts of the course with, a lot of short lessons, gets a bit disturbing. Apart from that it is a great cause if you want to learn more, maybe everything, about pivot tables and charts.

By Stefano Busanello on a month ago

Very comprehensive, user-friendly pace and explanations, and brought my pivot tables skills to a higher level. Thanks John for being such a good instructor!

By Rafiullah Shaheedullah on 2 months ago

I waited until I had completed most of the course before leaving this review. He gives graphical explanations, then explanation by example, all the way from beginner to advanced.Superb course.

By Fleur Pepper on 3 months ago

Excellent Excel Pivot Tables course. Thorough explanations and some innovative topics. Definitely worth a five star rating.

By Nouer Uz-Zaman on 6 months ago

It is very good and informative for novice users but experienced users like myself its decent.I am an intermediate user of excel so I registered for this course to really comprehend more about pivot table charts and power pivots, to go from intermediate to advance.But, still everything is good.

By Ben Holtzman on 4 months ago

I enjoyed learning about pivot tables in much more depth than I've done in the past. The videos were the right length for the most part. The course had clear explanations and enthusiastic lectures given in an engaging style.Overall, I got was I was hoping from this course. The bonus for me were the lectures dealing with issues and workarounds. Great to have a heads up for missing functionality and creative problem-solving.

By Mark Olson on 4 months ago

Excellent courseWas very comprehensive and the short videos was great. If they are too long, it can get tiring.

By Naveen Bopearatchy on 6 months ago

I really am getting a lot of value out of this course.(Update 1) I love the way this has been structured... so even on busy days I feel that I have accomplished something.(Update 2) Finishes the course...and I felt that it was fully worth the cost. It really helped give a very good understanding of Pivot charts.The only thing that I did not feel was great were the quizzes... it felt they were not really necessary.

By Oana O. on 4 months ago

I cannot think about a better course to attend. John is the absolute master of Excel. And he's also a great teacher. So my advise to students is: attend his courses, even if you consider yourself an advanced user as John's knowledge is beyond anything you could imagine. Thank you John!

By Nikunj Shah on 7 months ago

Statistical analysis through pivot table is very time saving and accurate and speedy run time changeble amazing analysis... Very very good

By Chak Hung Ling on 4 months ago

Happy to learn a lot from this course!