Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 2.5 hours on-demand video
  • 12 articles
  • 21 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Office Productivity Microsoft Pivot Tables

Microsoft Excel Pivot Tables - Master Excel Pivot Tables!

Excel with Microsoft Excel Pivot Tables & Data Analysis - Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365
Rating: 4.5 out of 54.5 (1,088 ratings)
32,435 students
Created by MyExcelOnline John Michaloudis
Last updated 8/2020
English
English [Auto], Polish [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Increase your Excel & Pivot Table SKILLS and KNOWLEDGE within 1 HOUR which will GET YOU NOTICED by Top Management & prospective Employers!
  • Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • We teach you how to use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • How to create an Interactive Dashboard with Slicers & Pivot Charts that will WOW your boss!
  • 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
  • Free Downloadable Excel PDF Cheat Sheets plus MORE!!!
  • Real life fun Quizzes & Homework Practice Activities & Assignments!
  • Personal Excel support from a Professional Excel Trainer with 15+ Years of Excel Training!
  • ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!

Requirements

  • Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016
  • This course is for Excel Beginners, Intermediates or Advanced Users
  • No prior Excel or Pivot Table knowledge is required

Description

You’re Just Seconds Away From Leveraging Excel & Pivot Tables That Will Make It Possible For YOU To:

  1. Increase your Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

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

**** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ****

>> UPDATED APRIL 2020 with several Homework practice activities to increase your skills and an Assignment!

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

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

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

"I am one of the more advanced users in our organization but I have realized 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

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

No matter if you are a Beginner or an Advanced user of Excel,  you are sure to benefit from this quick 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, Excel 2016, Excel 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.

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


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 and eliminating STRESS at work...

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

  • People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Course content

6 sections • 40 lectures • 2h 32m total length

  • Preview00:20
  • BONUS INFOGRAPHIC: 5 Speedy Steps To Creating a Pivot Table
    00:00
  • BONUS CHEAT SHEET: Excel Pivot Tables
    00:00
  • BONUS EXCEL RESOURCES!
    00:08

  • Preview01:25
  • Preview06:20
  • Tabular Format & Excel Tables
    05:57
  • Creating an Excel Pivot Table
    06:04
  • Formatting an Excel Pivot Table
    03:58
  • Summarize Values By
    02:32
  • Show Values As
    07:16
  • Preview07:02
  • Slicers
    03:57
  • Excel Pivot Charts
    02:20
  • Creating an Interactive Excel Dashboard with Slicers & Pivot Charts
    04:12
  • BONUS: Pivot Table Tips & Tricks!
    09:40
  • Course Review
    00:47

  • DOWNLOADABLE EXCEL WORKBOOKS
    00:22
  • Show the Classic Pivot Table Layout
    01:00
  • Show various Grand Totals
    02:28
  • Preview04:36
  • Group two pivot tables independently
    03:45
  • Sort manually
    01:53
  • Filter by Text wildcards * and ?
    03:19
  • Different ways to filter a Slicer
    01:14
  • Excel formulas & Calculated Fields
    03:00
  • Data Bars, Color Scales & Icon Sets
    05:42
  • Create a custom report with GETPIVOTDATA
    05:17
  • Different pivot table views macro
    04:34

  • CASE STUDY #1: Sales Actuals v Plan with Calculated Fields
    06:29
  • Preview15:47
  • CASE STUDY #3: Interactive Balance Sheet Excel Pivot Table
    12:13

  • 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
  • HOMEWORK: CREATE A PIVOT TABLE
    00:14
  • HOMEWORK: SUMMARIZE VALUES BY
    00:14
  • HOMEWORK: SHOW VALUES AS
    00:14
  • HOMEWORK: GROUPING
    00:14
  • HOMEWORK: SLICERS
    00:14
  • Create a Pivot Table Dashboard
    1 question

  • Thank You & Course Review!
    00:47
  • Get our other 5 TOP RATED Udemy courses at a HUGE DISCOUNT!
    00:38
  • Microsoft Excel E-Books
    00:11

Instructor

MyExcelOnline John Michaloudis
Chief Inspirational Officer at MyExcelOnline
MyExcelOnline John Michaloudis
  • 4.4 Instructor Rating
  • 4,636 Reviews
  • 88,397 Students
  • 12 Courses

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. 

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

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.