강의

멘토링

로드맵

BEST
Productivity

/

Office

Chief Choi's Excel Pivot Table Master Class

This course will teach you how to use Excel Pivot Tables to quickly and easily analyze data and create dynamic automated reports in your daily life and practice. Pivot Tables are easy and powerful. Through this course, you can begin the process of solving problems through data analysis.

(4.8) 113 reviews

606 learners

  • hicrhodus
Excel
MS-Office

Reviews from Early Learners

What you will learn!

  • Data analysis using pivot tables

  • Create accurate reports quickly and easily

  • Data visualization using pivot tables and pivot charts

  • Data filtering to focus analysis on the data you need

  • How to Create an Excel Dashboard Using Slicers and Timelines

  • Data summary technology using various operations

  • Advanced analytics techniques using value display formats

Master Excel data analysis with pivot tables!
Use Excel freely in your work and daily life.

Recommended for
these people

Who is this course right for?

  • People who want to solve problems through data analysis in their work and daily life

  • Office worker who creates data-based reports on a regular basis (daily, weekly, monthly, etc.)

  • Office worker who uses a calculator to create reports using Excel data

  • People who want to try data analysis but don't know how to use R or Python

  • People who have stopped learning Excel because it was boring and difficult

Need to know before starting?

  • This lecture will serve as prerequisite knowledge for other lectures, meaning that no other prerequisite knowledge is required.

  • Even if you have little experience using Excel, you will have no problem taking the course.

  • If you have any experience using Excel, your learning efficiency will be very high.

  • Here, 'a little' refers to cases where you have experience using the SUM function.

Hello
This is

2,353

Learners

133

Reviews

46

Answers

4.8

Rating

2

Courses

Microsoft Excel & Power BI 교육 서비스 '히크로도스'를 만들고 있습니다.

관세와 무역, 생산성 도구와 데이터 분석, 스타트업과 조직문화에 관심이 많습니다.

 

👨‍💻 Actionable Data Analysis
실무에서 행동으로 연결할 수 있는 실용적인 데이터 분석과 생산성 향상 도구를 연구하고 있습니다.
최반장의 엑셀 피벗테이블 마스터 클래스 @인프런 💊
엑셀 시작하기 : Excel 입문 (Inflearn Original) @인프런 💊

 

🎥 Contents Creator
유튜브 채널 '넵 TV'를 운영 중이고, '김정준의 야구수다', '데이터홀릭' 등의 콘텐츠 제작 경험이 있습니다. 

 

🚩프로필 바로가기 (click!)

Curriculum

All

47 lectures ∙ (6hr 14min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

113 reviews

4.8

113 reviews

  • mark [DEL] 20230403051857님의 프로필 이미지
    mark [DEL] 20230403051857

    Reviews 5

    Average Rating 5.0

    5

    100% enrolled

    &lt;&lt;今すぐExcelでデータを活用する必要がある場合は、心配せずに選択してください(Excelについて何も知りません)&gt; この講義はエクセルについての基礎知識なしにすぐに現業でデータを活用しなければならない方が聞いても大丈夫な難易度です。チェ・バンジャンのもう一つの入門講義 <エクセルを始める : EXCEL入門(Inflearn Original)>ご覧いただけます。 (たとえエクセル上部のメニューを「リボンメニュー」と呼ぶのは最後までわかりませんが) 個人的には、Excel入門者がこの講義を 'まず聞いて' &lt; Excel入門&gt;講義を聞く方が効果がないかと思います。もう一度申し上げますが、入門者も聞ける講義です。そしてすぐにデータを活用できるようにする講義です。 最半長様のユーモアも私のスタイルで面白かったし、これからも元気で、良い川のたくさん製作していただければと思います。 ありがとうございます。

    • hicrhodus
      Instructor

      まず受講していただきありがとうございます。 講義をつくりながら受講される方に伝えられてほしい部分について褒めてくださるから、身の回りがわからないですね。 どうぞ、実務に役立つことを願っています。 初めての講義で足りない点も多かったのですが、良い点をよく見ていただきありがとうございます。 また良い内容でご挨拶いたします。

  • 인프런님의 프로필 이미지
    인프런

    Reviews 6

    Average Rating 5.0

    5

    100% enrolled

    良い講義ありがとうございます!説明を簡単にしてくれて楽しくよく学べました!

    • hicrhodus
      Instructor

      ありがとうございます!仕事に役立つことを願っています^^

  • ecstasy7sp5078님의 프로필 이미지
    ecstasy7sp5078

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    実用的な内容とわかりやすい説明で多くのお役に立ちました。

    • hicrhodus
      Instructor

      受講してくれて良い評を残してくれてありがとう!

  • jiyeonsong2070님의 프로필 이미지
    jiyeonsong2070

    Reviews 1

    Average Rating 5.0

    5

    62% enrolled

    ピボットテーブルの理解に役立ちます。

    • seunghansong5598님의 프로필 이미지
      seunghansong5598

      Reviews 5

      Average Rating 5.0

      5

      100% enrolled

      Limited time deal ends in 5 days

      $5,160.00

      23%

      $42.90

      Similar courses

      Explore other courses in the same field!