강의

멘토링

로드맵

Inflearn brand logo image
BEST
Productivity

/

Office

Using Excel: Intermediate EXCEL (Inflearn Original)

This is a class that teaches intermediate and advanced level data analysis and visualization chart creation methods to those who can handle Excel basics. With this class, you can master Excel completely!

(4.9) 72 reviews

34,660 learners

  • inflearn
Excel
Excel PowerQuery
vlookup
MS-Office

Reviews from Early Learners

What you will learn!

  • Skills needed for data preprocessing

  • Data analysis and visualization through practical data

Excel, only the shortcuts you usually use
Are you using it in reverse?

When you use Excel at work, don't you just use a few familiar shortcuts? When you have a lot of data to process because you don't know other functions, don't you manually process it yourself?

Fundamentally, why is Excel still difficult for us? If you think it is a waste of time to study it separately because you deal with it every day, now is your chance. If you want to learn more about Excel and improve your work capabilities, don't miss it!


To these people
I recommend it with confidence.

From data analysis with Excel
Anyone who wants to create visualization charts

I know the basics but there is more
For those who want to know how to use Excel

Repetitive data processing
Anyone who wants to automate


In this one lecture
Excel that finishes perfectly!

Lecture Preview

Dynamic range using table objects

When designing a semi-automatic Excel file, we will practice linking a data range by using a table object in a frequently used combo box (data validation).

Structuring Data

You will practice structuring your data so that it is suitable for analysis in a variety of ways. You will be able to follow the standard process of Power Query processing.

Data preprocessing with PowerQuery

We will collect data and analyze how domestic travel destinations have changed over the past three years by year and region, and derive insights. You can learn how to preprocess data!

Visualize with charts

Visualize data such as performance trends by year, performance by brand, and performance by market in a chart so that you can see them at a glance. Visualize various data and utilize them effectively!

▶️ Things to note before taking the class

  • Learning Materials
    • Lecture materials summarizing the lecture content are provided.
    • Includes a Data set you can practice with.
  • Player Knowledge
  • Web scraping may change the URL and data processing process when the website is renewed.

Chosen by numerous students
Inflearn Original.

Only at Inflearn !

  • Lifelong learning! You can study over and over again.
  • Easy and detailed for beginners!
  • Join special knowledge sharers verified by Inflearn.

Recommended for
these people

Who is this course right for?

  • Those who want to analyze data and find insights using Excel

  • Those who want to show visible analysis results through data visualization

Hello
This is

699,679

Learners

5,883

Reviews

118

Answers

4.7

Rating

130

Courses

배움의 기회는 경제적, 물리적 한계에서 자유로워야 한다고 생각합니다.
우리는 성장기회의 평등을 추구합니다.

Curriculum

All

28 lectures ∙ (7hr 38min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

72 reviews

4.9

72 reviews

  • Jisung Hwang님의 프로필 이미지
    Jisung Hwang

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • 배영자
      Instructor

      감사합니다, Jisung님 (✿◡‿◡)

  • 최혜림님의 프로필 이미지
    최혜림

    Reviews 1

    Average Rating 5.0

    5

    68% enrolled

    많은 강의를 들어봤지만 처음 강의평 씁니다. 이 강의는 엑셀 데이터 분석의 최고의 강의입니다. 정말 군더더기 없는 최고입니다. 자신감 올라가요

    • 배영자
      Instructor

      혜림님 후기 덕분에 저 또한 자신감 올라갑니다. 감사합니다 ♪(^∇^*)

  • MonsTer님의 프로필 이미지
    MonsTer

    Reviews 27

    Average Rating 5.0

    5

    61% enrolled

    • 배영자
      Instructor

      MonsTer님, 감사합니다 (∩^o^)⊃━☆

  • Gy K님의 프로필 이미지
    Gy K

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    파워쿼리에 대한 막연함을 가지고 있었는데 이해에 많은 도움이 되었습니다. 수강하며 알게 된 것을 곧바로 실제 업무에 사용했는데 무척 행복했어요. 좋은 강의 감사합니다!

    • 배영자
      Instructor

      '곧바로 업무에 적용해서 무척 행복하다' 저도 '곧바로 Gy K님의 글에 행복해서 미소 가득입니다' 감사합니다 (*^▽^*)

  • 윤진원님의 프로필 이미지
    윤진원

    Reviews 1

    Average Rating 5.0

    5

    32% enrolled

    실무에서 너무 도움이 될꺼같습니다 정말로 너무 유익한 강의입니다. 재밌네요 감사합니다..

    • 배영자
      Instructor

      진원님, 감사합니다 ( ̄︶ ̄)↗

$42.90

inflearn's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!