강의

멘토링

로드맵

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,705

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

  • hyeryangpark9305님의 프로필 이미지
    hyeryangpark9305

    Reviews 1

    Average Rating 5.0

    5

    94% enrolled

    I didn't know there were so many data visualization methods. You explained it in an easy and simple way, so I understood it quickly.

    • jeehyoung
      Instructor

      Thank you for your course review. I hope you will make a persuasive presentation by making good use of everything from the basics to the special.

  • jmkim4649님의 프로필 이미지
    jmkim4649

    Reviews 9

    Average Rating 3.7

    4

    100% enrolled

    It was nice to be able to see examples of not only basic Excel charts but also applied charts. However, it was unfortunate that there was some noise in the voice, which was annoying, and that the last part of the lecture was skipped without finishing.

    • jeehyoung
      Instructor

      Thank you for your lecture review. As you said, the sound quality was bad because it was recorded in the early stages. I thought it was okay at the time, but now that some time has passed, I feel regretful. Although it is a lacking lecture, I hope you make good use of it and develop. Thank you.

  • shinhokim9063님의 프로필 이미지
    shinhokim9063

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    great!

    • it13871655님의 프로필 이미지
      it13871655

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      I heard it well

      • jasonkim2096님의 프로필 이미지
        jasonkim2096

        Reviews 1

        Average Rating 4.0

        4

        100% enrolled

        You can learn about various chart creation methods, but it is limited to Excel.

        • jeehyoung
          Instructor

          Yes, you are right. It is limited to Excel. Thank you for leaving a review of the lecture.

      $42.90

      jeehyoung's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!