Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Office

Visualize public data easily and beautifully with Excel and PowerPoint

Visualize and present the overflowing public data skillfully using the most common and familiar Excel and PowerPoint.

(3.8) 4 reviews

38 learners

  • jeehyoung
Excel
PowerPoint
MS-Office

What you will learn!

  • How to download public data and create reports

  • I mainly use Excel and PowerPoint for visualization and presentation.

Let's create and present visualizations using Excel and PowerPoint.

Almost 80-90% of the visualizations you encounter can be easily created in Excel. Let's learn these concepts together, which are convenient if you know them but incredibly difficult if you don't. You might be surprised to find such features hidden in the familiar PowerPoint!


Learn things like this 📑

1. Let's download public data and easily visualize it in Excel .

2. Let's make a presentation easily in PowerPoint .

3. Learn the common mistakes to avoid when transferring Excel charts to PowerPoint .

4. Make your presentation more engaging by using chart animations in PowerPoint!

5. Let's learn about and resolve cases where the quality of a well-made chart deteriorates and editing is poor when transferred to PowerPoint or Word .

6. Is Ediya really near Starbucks?

Let's visualize maps without coding, much easier than with Python or R.
Let's learn about the unique advantages of Excel maps that cannot be found in Python or R, including the ability to explore them as if traveling.

In class content

Recommended for
these people

Who is this course right for?

  • public official

  • Public institution worker

  • Applicants and related persons for national and local government projects

Need to know before starting?

  • Basic skills in using Excel and PowerPoint

Hello
This is

1,696

Learners

71

Reviews

9

Answers

4.6

Rating

8

Courses

출강 이력

서울대, 연세대, 경희대학 서울시립대, 명지대, 계명대, 한양대, 순천향대, 건국대, 충북대, 마이크로 소프트(MS), 국민은행, 신용협동조합, SK제약, 콘바텍, 식약처, 질병관리 본부, 보건인력개발원 , 국립의과학지식센터, 서울대병원, 분당서울대병원, 보라매병원, 현대아산병원, 원자력병원, 고대구로병원, 가톨릭대병원, 광주기독병원, 삼성서울병원, 원주기독병원, 길병원, 국립재활원, 일산동국대병원, 전남대병원, 조선대병원, 서울연구원, 한국보건산업진흥원 중동센터, 한국출판콘텐츠센터

저서

일차진료의를 위한 정형외과(대한의학서적) 1, 2

논문 쉽고 편하게 쓰자(대한의학서적) 1, 2, 3

한눈에 쏙쏙 의학 통계 배우기(2013년 문화체육관광부 우수학술도서상) 1, 2

샘플 수의 계산(대한의학서적)

연구자를 위한 그래프 그리기(북앤에듀) 1, 2

프레젠테이션 작업 가이드(북앤에듀)

dBSTAT 길들이기(바른의학연구소)

임상 실험을 위한 무작위 대조 연구(한나래)

데이터랑 놀자, R 데이터 시각화(북앤에듀)

쉽고 편하게, 메타분석(북앤에듀)

스마트 보고서 스피드 공공문서(북앤에듀)

맛있는 부분만 골라 먹자, 엑셀 피벗테이블(북앤에듀)

Zotero 활용하기(북앤에듀)

누구나 쉽고 재미있게 만드는 예측모형(북앤에듀)

어서와 학술대회는 처음이지(북앤에듀)

데이터랑 놀자, R 데이터 시각화-응용심화편(북앤에듀)

Excel+R 데이터 분석(한나래)

아빠가 들려주는 ggplot2+α』(한나래)

Curriculum

All

11 lectures ∙ (2hr 23min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

3.8

4 reviews

  • heejungyang3435님의 프로필 이미지
    heejungyang3435

    Reviews 18

    Average Rating 4.7

    4

    100% enrolled

    業務にうまく活用します。

    • yurokcho4956님의 프로필 이미지
      yurokcho4956

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      わかりました。

      • zhweilong2460님의 프로필 이미지
        zhweilong2460

        Reviews 1

        Average Rating 4.0

        4

        100% enrolled

        これまでのExcelを利用しながら使ってみなかった多くの機能を学ぶことができ、かなり有益な講義でした。

        • jeehyoung
          Instructor

          ありがとうございます。さらに進化してください。

      • studiosaena님의 프로필 이미지
        studiosaena

        Reviews 1

        Average Rating 2.0

        2

        100% enrolled

        データを受け取り、可視化する実践的なプロセスを見るための目的に適した講義のようです。各番組ごとに深い内容を見るには難しく、実際の報告書を作るための体験くらいに見える講義のようです。この講義に加えて、もっと必要な内容は練習してみて、私が深さを加えていかなければならないようです。ありがとうございます。

        • jeehyoung
          Instructor

          はい、そうです。コースを全体的にオーバービューするための目的で作られた講義です。 それぞれのデータの性質に応じて、どのチャートをどのように作成するのか データごとにすべての性格が異なり、非常に多様です。 各論や性格によって変わる様々なチャートは 私の他のレッスン" Excelデータの可視化"または、"Rデータの視覚化"を参照してください。 実はその講義さえも全部扱うことができず、一部しか扱うしかありませんでした。多すぎて… 講義評を残していただきありがとうございます。

      $42.90

      jeehyoung's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!