강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Office

Getting Started with Excel & Data Preprocessing Made Easy with Heart Count

I'll teach you how to use Excel effectively in your work and how to create data that's good for analysis.

10 learners are taking this course

  • HEARTCOUNT
실습 중심
데이터전처리
Excel
Excel PowerQuery
ms-excel

What you will learn!

  • Data Preprocessing Techniques Using Excel

  • Understanding 'Tidy Data' Structure Suitable for Analysis

  • Cell formatting, pivot tables, subtotals, and other Excel techniques frequently used in practical work

  • Excel Work Automation Using ChatGPT

  • Data cleaning methods for missing values, duplicate values, outliers, etc.

  • Data Quality Check and Data Integration Using Power Query

✔️ Learn how to create data in Excel that's good for analysis

I'll show you how to better use EXCEL, an essential tool for office workers to improve work efficiency.

Even non-experts can easily preprocess data through Excel!

Why should you learn data preprocessing through Excel?

  • Simple preprocessing (cleaning) tasks - how long will you keep asking someone else to do them?

By taking this course, you'll be able to perform simple data preprocessing on your own.

Stop hesitating and start performing the tasks you need yourself. You can quickly learn the data literacy and data preprocessing methods needed at a professional level using Excel, the most familiar tool.


As a bonus, we'll also show you how to automate Excel tasks using ChatGPT. Learn to smartly utilize tools in your work.

  • Data that's good for analysis. You can create it sufficiently through Excel as well.

Even if you want to use data analysis tools like HEARTCOUNT,have you struggled with preparing data that's good for analysis? Have you found it difficult to know where and how to integrate, organize, and aggregate data?

Data preprocessing is so important and time-consuming that it's no exaggeration to say it accounts for more than 80% of the entire data analysis process.

Learn how to quickly and effectively organize data using the tool called Excel.

The advantages of this course alone

  • We worked with verified Excel expert instructor, Instructor Choi Jae-wan.
    Instructor Choi Jae-wan, author of and active Excel expert instructor, along with the HeartCount team composed of data specialists, have prepared a course for practitioners who are thirsty for 'data and Excel utilization'.

  • Composed of over 90% hands-on practice, we only teach Excel usage methods frequently used in actual work.
    We will teach you through practice how to organize data by effectively utilizing basic Excel tools such as pivot tables and cell splitting. We will also share the files used in practice so you can review and learn the content again. Learn how to quickly and visually structure data and obtain the values you need.

  • Unlimited access period! Detailed curriculum!
    Once you enroll, you can efficiently select and listen to only the topics you need, anytime and anywhere. Updates to maintain lecture quality will be directly updated by the instructor on the Notion page used as the textbook for this course.

  • Communicate with community members to learn and grow more
    Meet other students through HEARTCOUNT community's Slack channel, communicate with practitioners interested in data, and share knowledge and information.
    HEARTCOUNT Community Official Page>

Instructor Introduction

🧑‍🏫Introducing Instructor Jaewan Choi!

  • Excel, Power BI Expert Instructor

  • Lecture History
    🎥CEO Choi's Pivot Table Master Class (Go directly)


    🎥Practical Excel for Immediate Use at Work (Fastcampus)
    🎥Complete SQL and Data Visualization Super Gap Package Online (Fastcampus)
    🎥Unrealistic 400 ChatGPT Usage Bible for AI Era High Performers (Fastcampus)


    👨‍🏫OA Utilization Skills: Excel Basics (Korea Management Association)


    👨‍🏫Pivot Table Master Course (SK Hynix)


    👨‍🏫Excel God, Function Master (SK Hynix)


    👨‍🏫Academic Guidance Using Excel (Chungnam Office of Education)


  • Book:

  • More lectures from the instructor: YouTube channel NepTV

  • If you have any questions for the instructor: Open chat room Excel119

Course Preview

Through kind theoretical explanations and hands-on practice, Excel utilization methods and work automation techniques that form the foundation of practical work,

You can learn data preprocessing methods for non-data professionals in one course.

👀 Hands-on Lecture Preview (1)

👀 Hands-on Lecture Preview (2)

✔️ Please refer to the lecture practice environment!

  • We will practice ms-excel on the Windows operating system.

Benefits Exclusive to This Course

  • Course Review Event

    • We are giving a 10,000 won discount coupon for the Heart Count Data course to everyone who thoughtfully left course reviews.

  • Lecture 1+3 Event

    • If you subscribe to HeartCount Premium (starting from 90,000 won per year), you can access all four data courses, each normally priced at 99,000 won, for free for life. (Please refer to the information box below for details)

Take three more data courses for the same price!

When you subscribe to HeartCount Premium

All data courses from HeartCount

'Free' lifetime access coupon available.


360,000 (regular price) >90,000 won (Heart Count user benefit price)

For just 90,000 won per year, use Heart Count and receive a 'Lifetime Free Access Pass for Data Courses'.

[HeartCount's Subject-Based Data Lectures]

More will continue to be added in the future :)


🖱 Go Subscribe to HeartCount Premium

What is HEARTCOUNT?

HEARTCOUNT: A tool that enables data analysis, visualization, and insight discovery without requiring specialized knowledge

From individual record-level visualization to automatic chart interpretation, factor analysis, and optimization rule discovery.
With HeartCount, anyone can become an analyst.


🖱Visit Homepage Now

💸 How to Use HEARTCOUNT User Exclusive Coupons

  1. Heart Count Login (Get Started with Google)

  2. Click the 'Upgrade' button to subscribe to HeartCount Premium (starting from 90,000 won per year)

  3. Check your inbox for the 'Free Data Course Coupon'

  4. Access Inflearn > 'My Page' > 'Coupon Box' > 'Enter Discount Coupon Code'

  5. Using Coupons on the Payment Page After Course Registration

※ We notify you of the coupon expiration date via email. Please use the coupon within the specified period as it cannot be used after that date.
※ For related inquiries, please contact the person in charge via email (support@idk2.co.kr).

Recommended for
these people

Who is this course right for?

  • People who want to use Excel more smartly

  • Those who want to handle Excel better in practical work

  • People who want to do simple preprocessing themselves through Excel

Need to know before starting?

  • No prior knowledge is required :) Just bring your passion!

Hello
This is

2,771

Learners

66

Reviews

4.8

Rating

16

Courses

엑셀 데이터셋과 질문만 있으면 누구나 쉽게 분석가가 될 수 있는 AI 데이터 분석 툴, HEARTCOUNT입니다.

실무자들을 위한 다양한 데이터 교육 콘텐츠를 만들고 있습니다.


하트카운트 사용해보러 가기 👉 하트카운트 홈페이지

더 많은 데이터 콘텐츠 👉 하트카운트 커뮤니티 

Curriculum

All

31 lectures ∙ (4hr 54min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$77.00

HEARTCOUNT's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!