강의

멘토링

로드맵

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) 79 reviews

34,666 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

702,924

Learners

6,006

Reviews

118

Answers

4.7

Rating

131

Courses

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

Curriculum

All

28 lectures ∙ (7hr 38min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

79 reviews

4.9

79 reviews

  • abungp2888님의 프로필 이미지
    abungp2888

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • 엑셀디자인
      Instructor

      Thank you, Jisung (✿◡‿◡)

  • hyerim897112405님의 프로필 이미지
    hyerim897112405

    Reviews 1

    Average Rating 5.0

    5

    68% enrolled

    I have taken many courses, but this is the first time I am writing a review. This course is the best course for Excel data analysis. It is really the best, without any unnecessary things. It boosts my confidence.

    • 엑셀디자인
      Instructor

      Thanks to Hye-rim's review, I feel more confident. Thank you ♪(^∇^*)

  • mons님의 프로필 이미지
    mons

    Reviews 27

    Average Rating 5.0

    5

    61% enrolled

  • gyk09056626님의 프로필 이미지
    gyk09056626

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    I had a vague understanding of Power Query, but this course helped me understand it much better. I was able to immediately apply what I learned in the course to my actual work, and I was so happy. Thank you for the great course!

    • 엑셀디자인
      Instructor

      'I am so happy to be able to apply it to my work right away' I am also 'so happy to see Gy K's post and smile' Thank you (*^▽^*)

  • rotkfrn44441558님의 프로필 이미지
    rotkfrn44441558

    Reviews 1

    Average Rating 5.0

    5

    32% enrolled

    It seems like it will be very helpful in practice. It is a really very useful lecture. It is fun. Thank you.

Limited time deal ends in 4 days

$33.00

23%

$42.90

inflearn's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!