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

/

Office

Easy and fun [Data visualization] with over 80 examples

As you follow along with fun, you will naturally learn the basic concepts and techniques. You will be able to easily create visualization tools that are accurate, clear, pretty, and attractive. You will naturally understand the features and advantages of each from Excel 2007 to 2016, and learn what advantages and disadvantages they have. You will learn how to make the impossible in Excel indirectly.

(4.5) 17 reviews

159 learners

  • jeehyoung
Excel
MS-Office

Reviews from Early Learners

What you will learn!

  • How to quickly create and customize a variety of charts using Excel 2016

  • How to create and interpret scatter charts, dot plots, and bubble charts

  • In-depth understanding of advanced chart types and techniques

  • Create and interpret effective charts for data visualization

1. Course Introduction

This course will help you learn data visualization quickly and easily. Each lesson is comprised of videos less than five minutes long, and each video produces ready-to-use visualizations. As you follow along, you'll naturally master the fundamental concepts and techniques. You'll easily create visualization tools that are accurate, clear, beautiful, and attractive. You'll naturally understand the features and strengths of Excel 2007 through 2016, as well as their pros and cons. You'll also discover ways to achieve the impossible in Excel.

2. Learning Objectives

I create most of my charts quickly and easily myself. I often get asked by other researchers and presenters how I created them.

3. People who can help

Graduate students, researchers, professors, teachers, company employees, and civil servants who handle data

4. Instructor Introduction

Kim Ji-hyung

Education
Graduated from Seoul National University College of Medicine in 1994. Residency at Samsung Medical Center in 2002. Head of Orthopedic Surgery at Seoul Sacred Heart Hospital. Secretary of the Korean Orthopedic Association Information and Communication Committee. Statistical editor for Clinics in Orthopedic Surgery. Statistical editor for Hip and Pelvis.

Teaching experience (data visualization)
2013 Seoul National University, Konkuk University, Catholic University of Korea 2014 Korea Centers for Disease Control and Prevention, Baekbeom Kim Gu Hall, Seoul National University College of Medicine 2016 Korean Association of Medical Journal Editors, Seoul National University, Catholic University of Korea 2017 Seoul National University, Seoul Research Institute, Catholic University of Korea, Yonsei University, Korea Cancer Center Hospital, Korea Human Resources Development Institute for Health and Welfare

Books

Graphing for Researchers (1st and 2nd editions)
“Let’s write papers easily and conveniently (1st, 2nd, 3rd edition)”
Orthopedics for Primary Care Physicians
"Learning Medical Statistics at a Glance" (2013 Ministry of Culture, Sports and Tourism Outstanding Academic Book Award)

5. Lecture Table of Contents

You'll learn basic charts and the fundamental techniques for creating them, then apply them to apply data visualization charts. If you'd like to see each table of contents in one image, click "See More" below.

Recommended for
these people

Who is this course right for?

  • People interested in data visualization

  • People who are not confident in creating charts using Excel

  • People who want to acquire advanced data analysis skills

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

88 lectures ∙ (6hr 34min)

Published: 
Last updated: 

Reviews

All

17 reviews

4.5

17 reviews

  • 박혜량님의 프로필 이미지
    박혜량

    Reviews 1

    Average Rating 5.0

    5

    94% enrolled

    데이터 시각화 방법이 이렇게 많은 줄은 몰랐습니다. 쉽고 간단하게 알려주셔서 이해가 빠르게 되었습니다.

    • 김지형
      Instructor

      네 수강평 감사합니다. 기본적인 것부터, 특별한 것까지 잘 활용하셔서 설득력 있는 발표 되시길 기대하겠습니다.

  • 김정민님의 프로필 이미지
    김정민

    Reviews 9

    Average Rating 3.7

    4

    100% enrolled

    엑셀 기본 차트뿐만아니라 응용차트의 실례를 볼 수 있어 좋았습니다. 다만 음성에 노이즈가 있어 거슬리는 부분, 강의의 마지막을 마무리하지 못하고 스킵되는 부분은 아쉽습니다.

    • 김지형
      Instructor

      강의평 감사합니다. 말씀하신 것처럼 초창기 미흡한 상태로 녹화하여 음질이 나빴습니다. 당시는 괜찮다고 생각했는데, 좀 지나고 나니 저도 아쉽습니다. 부족한 강의지만, 잘 활용하시고, 발전있으시길 기댜하겠습니다. 감사합니다.

  • shinhokim님의 프로필 이미지
    shinhokim

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    좋아요!

    • 박민후님의 프로필 이미지
      박민후

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      잘 들었습니다

      • 김석범님의 프로필 이미지
        김석범

        Reviews 1

        Average Rating 4.0

        4

        100% enrolled

        다양한 차트 생성방법에 대해 알 수 있지만 엑셀에 한정된 부분임

        • 김지형
          Instructor

          네, 맞습니다. 정확하게 말씀하셨습니다. 엑셀에 한정된 것입니다. 강의 평 남겨 주셔서 감사합니다.

      $42.90

      jeehyoung's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!