Excel Pivot Table Easy to Learn Even for Beginners

If you follow the pivot table, you will soon become an expert. Once you know it, you will regret the times when you struggled because you didn't know. Why didn't you know something this easy (actual reaction)

(4.8) 8 reviews

30 learners

Level Basic

Course period Unlimited

Excel
Excel
Excel
Excel
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

박형관

100% enrolled

It was a good lecture.

5.0

김현철

100% enrolled

Thank you, I needed a pivot and this helped me a lot

5.0

김덕수

100% enrolled

It's good~~

What you will gain after the course

  • Pivot Table Basics

  • Various applications of pivot tables

  • Chart using pivot table

No need to know Excel functions! Analyze your data with intuitive pivot tables.

Topic Introduction 📝

Learn about pivot tables, from the basics to applications, and even pivot tables.


Why you should learn ✒️

Pivot tables, which look amazing and difficult from the name alone!
But in fact, this pivot table is something that even the most beginners can do almost intuitively without knowing much about functions.

Once you learn pivot tables, you'll regret not having learned about them sooner. And, whenever you encounter data, you'll start with pivot tables.


What you will learn in this course ✏️

By using carefully selected example files, developed from years of lectures for beginners, you'll master all the functions of PivotTables before you know it.

After following the video a few times, you will be captivated by the natural and intuitive charm of pivot tables, just like using KakaoTalk or blogging.

Recommended for
these people

Who is this course right for?

  • Data Scientist

  • Accounting, Academic Affairs, and Administrative Office staff

  • Those who are weak in Excel functions but have to use Excel

Need to know before starting?

  • Anyone who has tried handling numbers in Excel but found it difficult

  • Anyone who thinks they should learn pivot tables someday

Hello
This is jeehyoung

1,712

Learners

72

Reviews

9

Answers

4.6

Rating

8

Courses

Lecture History

Seoul National University, Yonsei University, Kyung Hee University University of Seoul, Myongji University, Keimyung University, Hanyang University, Soonchunhyang University, Konkuk University, Chungbuk National University, Microsoft(MS), KB Kookmin Bank, Credit Union, SKChemicals, ConvaTec, Ministry of Food and Drug Safety, Korea Centers for Disease Control and Prevention, Korea Health Personnel Licensing Examination Institute , National Medical Science Knowledge Center, Seoul National University Hospital, Seoul National University Bundang Hospital, Boramae Medical Center, Asan Medical Center, Korea Cancer Center Hospital, Korea University Guro Hospital, Catholic University Hospital, Kwangju Christian Hospital, Samsung Medical Center, Wonju Christian Hospital, Gachon University Gil Medical Center, National Rehabilitation Center, Dongguk University Ilsan Hospital, Chonnam National University Hospital, Chosun University Hospital, The Seoul Institute, Korea Health Industry Development Institute Middle East Center, Korea Publishing Contents Center etc.

Books / Publications

Orthopedics for Primary Care Physicians(Korean Medical Book) 1st Edition, 2nd Edition

Let's Write Papers Easily and Comfortably(Korea Medical Book) 1st Edition, 2nd Edition, 3rd Edition

Learning Medical Statistics at a Glance(2013 Ministry of Culture, Sports and Tourism Excellent Academic Book Award) 1st Edition, 2nd Edition

Sample Size Calculation(Daehan Medical Books)

Graphing for Researchers(Book&Edu) 1st Edition, 2nd Edition

Presentation Work Guide(Book & Edu)

Taming dBSTAT(Barun Medical Research Institute)

Randomized Controlled Trials for Clinical Research(Hannarae)

Playing with Data, R Data Visualization(Book&Edu)

Easy and Convenient, Meta-Analysis(Book&Edu)

Smart Reports, Speed Public Documents(Book&Edu)

Pick and Eat Only the Delicious Parts, Excel Pivot Tables(Book & Edu)

Using Zotero (Book & Edu)

Predictive Models Anyone Can Make Easily and Funly(Book & Edu)

Welcome, Is This Your First Academic Conference?(Book&Edu)

Let's Play with Data, R Data Visualization-Advanced Application(Book&Edu)

Excel+R Data Analysis(Hannarae)

ggplot2+α Told by Dad』(Hannarae)

More

Curriculum

All

15 lectures ∙ (1hr 20min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

8 reviews

4.8

8 reviews

  • ymjo1817님의 프로필 이미지
    ymjo1817

    Reviews 1

    Average Rating 5.0

    5

    60% enrolled

    • coolloveu8344님의 프로필 이미지
      coolloveu8344

      Reviews 4

      Average Rating 4.8

      4

      100% enrolled

      Please explain it to me easily.

      • hc8974kim1591님의 프로필 이미지
        hc8974kim1591

        Reviews 3

        Average Rating 5.0

        5

        100% enrolled

        Thank you, I needed a pivot and this helped me a lot

        • jeehyoung
          Instructor

          Thank you. I hope you will apply it in various ways to real data, and develop your own things further.

      • yangsookang6495님의 프로필 이미지
        yangsookang6495

        Reviews 1

        Average Rating 4.0

        4

        60% enrolled

        It helps me understand by pointing out the problems and why it doesn't work.

        • hyunggwanpark5747님의 프로필 이미지
          hyunggwanpark5747

          Reviews 3

          Average Rating 5.0

          5

          100% enrolled

          It was a good lecture.

          • jeehyoung
            Instructor

            Thank you for your course review. I look forward to your continued progress.

        jeehyoung's other courses

        Check out other courses by the instructor!

        Similar courses

        Explore other courses in the same field!

        $33.00