![[10월 정기 교육 세션 다시보기] LLM(거대 언어 모델)과 데이터 분석의 자동화Course Thumbnail](https://cdn.inflearn.com/public/courses/332452/cover/86dd8178-92a6-4896-bd61-5f9c197a8433/332452-eng.jpg?w=420)
[10월 정기 교육 세션 다시보기] LLM(거대 언어 모델)과 데이터 분석의 자동화
HEARTCOUNT
코딩이 필요 없는 무료 데이터 시각화 툴 'HEARTCOUNT(하트카운트)'의 활용법을 다루는 열 번째 웨비나의 다시보기 영상입니다. 데이터 학습이나 툴을 익히는 데 드는 시간을 이제 데이터에서 업무에 필요한 정보를 찾는 데 사용하세요.
Beginner
데이터 리터러시
I'll teach you how to use Excel effectively in your work and how to create data that's good for analysis.
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
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!
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.
We worked with verified Excel expert instructor, Instructor Choi Jae-wan.
Instructor Choi Jae-wan, author of
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>
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
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.
We will practice ms-excel on the Windows operating system.
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)
SQL & Database Introduction by Instructor Kang Seong-wook (*Exclusive release for HeartCount users)
GA4 Fundamentals and Essential Practical Applications by Instructor Kim Dong-woo
More will continue to be added in the future :)
From individual record-level visualization to automatic chart interpretation, factor analysis, and optimization rule discovery.
With HeartCount, anyone can become an analyst.
Heart Count Login (Get Started with Google)
Click the 'Upgrade' button to subscribe to HeartCount Premium (starting from 90,000 won per year)
Check your inbox for the 'Free Data Course Coupon'
Access Inflearn > 'My Page' > 'Coupon Box' > 'Enter Discount Coupon Code'
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).
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!
2,771
Learners
66
Reviews
4.8
Rating
16
Courses
엑셀 데이터셋과 질문만 있으면 누구나 쉽게 분석가가 될 수 있는 AI 데이터 분석 툴, HEARTCOUNT입니다.
실무자들을 위한 다양한 데이터 교육 콘텐츠를 만들고 있습니다.
하트카운트 사용해보러 가기 👉 하트카운트 홈페이지
더 많은 데이터 콘텐츠 👉 하트카운트 커뮤니티
All
31 lectures ∙ (4hr 54min)
Course Materials:
$77.00
Check out other courses by the instructor!
Explore other courses in the same field!