Udemy

Microsoft Excel: Pivot Tables and Analysis - Beginner to Pro

Enroll Now
  • 19,015 Students
  • Updated 11/2024
4.5
(2,047 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
2 Hour(s) 43 Minute(s)
Language
English
Taught by
Kadhiravan Jayachandiran, Kulture Hire
Rating
4.5
(2,047 Ratings)

Course Overview

Microsoft Excel: Pivot Tables and Analysis - Beginner to Pro

Create, Analyze Data and Report with Excel Pivot Tables

PIVOT TABLES are the most sought out feature of Excel and is often used at work environment.

In this course you will learn a lot about Pivot Tables.

You'll get to learn about the below scenarios:

  • Inserting a Pivot table from a simple dataset

  • Inserting Fields and giving a shape to Pivot Table

  • Changing Views and understanding Views for different data

  • Moving Pivot Tables

  • Inserting and Managing Timelines

  • Inserting and Managing Slicers

  • Grouping Data on Excel

  • Filtering Data on Excel

Pivot Tables has been critical for most of the tasks at work. However it had its disadvantages and is often time consuming if the data is complex.

YourExcelGuy is the first and only platform that provides animation videos for excel skills. We have put together more than 100 videos that demonstrate every excel skill you can imagine - whether it's for absolute beginners or advanced users. Our content includes transformations, graphics, conditional formatting, data tables, pivot tables, dashboards, or VBA macros.

About the Instructor: I'm a Microsoft Certified Excel Expert and a full time Excel coach, I train people on Excel and that's something I really love doing.

Currently I have trained over 50000+ students. With over 4 years of training experience and 11+ years of using Excel every single day I've learnt a lot of tricks in excel

Course Content

  • 7 section(s)
  • 58 lecture(s)
  • Section 1 Introduction
  • Section 2 Pivot Table Basics
  • Section 3 Intermediate Level Pivot Table Situations
  • Section 4 Advanced Pivot Tables Features
  • Section 5 Complex Calculations with Pivot Table
  • Section 6 Marketing Analytics using Pivot Tables - Micro Project
  • Section 7 Conclusion

What You’ll Learn

  • Fundamentals to Advanced Techniques: Start from basic data analysis and become proficient with Excel Pivot Tables.
  • Exclusive Insights: Access unique Pivot Table strategies and tools, with insights not found in other courses.
  • Engaging & Effective Learning: Experience interactive lessons from a top-rated Excel instructor.
  • Learn how to use Pivot Tables to streamline and absolutely revolutionize your workflow in Excel


Reviews

  • S
    Sumbal Ijaz
    5.0

    good

  • S
    Simon
    5.0

    Excellent course indeed

  • B
    Blessing Saturday Johnson
    5.0

    Excellent course

  • F
    Fionnuala McCartan
    2.5

    PV3 is missing from the tutorial?

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