Udemy

Office Fundamentals - PivotTables in Microsoft Excel

Enroll Now
  • 1,029 Students
  • Updated 3/2022
4.6
(245 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) 44 Minute(s)
Language
English
Taught by
Johannes Ruof, Timothy Meixner
Rating
4.6
(245 Ratings)
1 views

Course Overview

Office Fundamentals - PivotTables in Microsoft Excel

Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards

Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.


In this course, you'll learn everything you need to know about pivot tables to work with them confidently in everyday life.


We start with the absolute basics and then build on that to learn more advanced and complex topics.


We'll talk about formatting, sorting, filtering, grouping, working with values, calculated fields, and pivot charts, and even build our own dashboard to visualize our data and manipulate and customize these charts live.


The course is designed to be hands-on. We will work with an extensive and practical example that will help you follow and understand the subject matter well. 


Our goal with this course is to make your daily work with Excel easier, and pivot tables are ideal for this.


Since pivot tables are a special sub-topic of Microsoft Excel, it is, of course, helpful if you are already familiar with the program. Ideally, you should already know the basics of Excel if you want to work with pivot tables.


We have already helped thousands of people to become office professionals in our courses, and I would be more than happy to welcome you to the course!


Course Content

  • 7 section(s)
  • 58 lecture(s)
  • Section 1 Einführung
  • Section 2 PivotTable Fundamentals - Learning the basics
  • Section 3 Formatting PivotTables
  • Section 4 Sorting, Filtering and Grouping with PivotTables
  • Section 5 Working with values in PivotTables
  • Section 6 Working with calculated fields in PivotTables
  • Section 7 Visualizing data analysis with PivotCharts & Dashboards

What You’ll Learn

  • Properly structure raw data for analysis with Pivot
  • Insert and create PivotTables
  • Editing PivotTable fields
  • Analysis and organization of data
  • Sort, filter, and group pivot data
  • Working with values in PivotTables
  • Calculations with calculated fields
  • Create visual representations with PivotCharts & Dashboards

Skills covered in this course


Reviews

  • G
    Godwin De Guzman
    5.0

    good so far

  • A
    Alimi-Yao Adam
    5.0

    great learning opportunity.

  • S
    Shefali Angrish
    5.0

    Amazing

  • A
    Alfredo Pedroza
    4.5

    I like the content, the examples used, and also the focus to a clean view of data in worksheets.

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