Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Mac 3: Pivot Tables Intro & Masterclass
Highest Rated
Rating: 4.8 out of 5(178 ratings)
1,286 students

Excel for Mac 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
Highest Rated
Created byPhillip Burton • over one million students so far, I Do Data Limited
Last updated 12/2024
English

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.

Course content

12 sections • 87 lectures • 5h 46m total length

  • Welcome2:16
  • Welcome to Udemy0:35
  • Introduction to Udemy3:05

    Navigate the Udemy video experience using playback controls, speed, volume, subtitles, and 1080p; access course content, resources, notes, Q&A, announcements, ratings, and a certificate of completion.

  • Do you want auto-translated subtitles in more languages?1:20
  • Curriculum3:30

Requirements

  • You should be able to open and save Microsoft spreadsheets. You should also be able to enter data.
  • That's it! We'll create our first Pivot Table in just a couple of minutes - that's all.

Description

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. This includes using conditional formatting, adding slicers and timelines so that you can create dashboards, and advanced calculations, such as Percentage of total, Cumulative totals, and calculated fields and items. We'll also have a look at Pivot Charts and their relationship to Pivot Tables.

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.

Who this course is for:

  • This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
  • This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-)
  • We'll also go into the more advanced functions, and create charts as well, quickly and easily.

Report abuse