Udemy

Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Enroll Now
  • 1,900 Students
  • Updated 12/2024
4.6
(349 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 57 Minute(s)
Language
English
Taught by
Phillip Burton • over one million students so far, I Do Data Limited
Rating
4.6
(349 Ratings)

Course Overview

Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779

Review:

"The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!" -- Daniel Sandberg

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.


It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.

After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

Course Content

  • 10 section(s)
  • 83 lecture(s)
  • Section 1 Introduction
  • Section 2 Creating our first PivotTable and PivotChart
  • Section 3 Expanding our PivotTable
  • Section 4 Going deeper in our PivotTable
  • Section 5 Modify field selections
  • Section 6 PivotTable Options
  • Section 7 Slicers (Excel 2010 and later)
  • Section 8 Dates and Timeline
  • Section 9 Formatting
  • Section 10 Advanced calculations

What You’ll Learn

  • Create Pivot Tables with a just a few clicks, simply and quickly.
  • Maintain and expand Pivot Tables.
  • Update data sources, and maintain formatting during refreshes.
  • Create Pivot Charts in a few simple clicks.
  • Know and use about the more advanced features, and create advanced Pivot Tables.
  • Find out how much powerful it is, and how quickly it can improve your data analysis.


Reviews

  • M
    Machell Russaw
    5.0

    Awesome class of study! This was a great match for me. I knew how to move around in excel and work with pivot tables, but this particular class taught me some more in depths education around excel. Will review this course again. The professor was great! Very easy to follow and understand his teaching. Way to go!

  • R
    Raja T
    5.0

    its nice

  • C
    Chandra Sekhar Besta
    5.0

    NICE

  • S
    Sara Charlesworth
    5.0

    learnt a lot thnak you

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed