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

Level Basic

Course period Unlimited

Excel
Excel
PowerPoint
PowerPoint
MS-Office
MS-Office
Excel
Excel
PowerPoint
PowerPoint
MS-Office
MS-Office
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

What you will gain after the course

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

1,712

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

11 lectures ∙ (2hr 23min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

3.8

4 reviews

  • zhweilong2460님의 프로필 이미지
    zhweilong2460

    Reviews 1

    Average Rating 4.0

    4

    100% enrolled

    This was a very useful lecture as I was able to learn many functions that I had never used before while using Excel.

    • jeehyoung
      Instructor

      Thank you. I hope you continue to develop further.

  • yurokcho4956님의 프로필 이미지
    yurokcho4956

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    Okay, I learned a lot.

    • yangguibee님의 프로필 이미지
      yangguibee

      Reviews 26

      Average Rating 4.7

      4

      100% enrolled

      I will use it well in my work.

      • studiosaena님의 프로필 이미지
        studiosaena

        Reviews 1

        Average Rating 2.0

        2

        100% enrolled

        It seems like a suitable lecture for the purpose of seeing the actual process of receiving data and visualizing it. It seems like a lecture that can be seen as a warm-up for creating an actual report because it is difficult to see the in-depth contents of each program. In addition to this lecture, I think I need to practice the necessary contents and go deeper. Thank you.

        • jeehyoung
          Instructor

          Yes, that's right. This is a lecture designed to provide an overall overview of the process. Depending on the nature of each data, the charts that should be created and how they should be created will vary greatly, Since each data has a different nature, You can refer to my other lectures, "Excel Data Visualization" or "R Data Visualization", for specific theories or charts that vary by nature. In fact, even those lectures could not cover everything, and could only cover a part of it. There were too many... Thank you for leaving a lecture review.

      jeehyoung's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      $42.90