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

160 learners

Level Beginner

Course period Unlimited

Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office

Reviews from Early Learners

Reviews from Early Learners

4.5

5.0

박혜량

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.

5.0

shinhokim

100% enrolled

great!

5.0

박민후

100% enrolled

I heard it well

What you will gain after the course

  • 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 jeehyoung

1,716

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

88 lectures ∙ (6hr 34min)

Published: 
Last updated: 

Reviews

All

17 reviews

4.5

17 reviews

  • shinhokim9063님의 프로필 이미지
    shinhokim9063

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    great!

    • 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.

    • 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.

    • it13871655님의 프로필 이미지
      it13871655

      Reviews 4

      Average Rating 5.0

      5

      100% enrolled

      I heard it well

      jeehyoung's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      $42.90