강의

N
챌린지

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Office

Rediscovering Excel: Encyclopedia of Practical Tips

A practical tip encyclopedia that collects Excel tips that are easy and delicious to use one by one

(4.5) 20 reviews

1,730 learners

  • hicrhodus
엑셀
평생무료
3시간 만에 완강할 수 있는 강의 ⏰
Excel
Thumbnail

Reviews from Early Learners

What you will learn!

  • Basic concepts and principles of Excel

  • Useful tips you can try out right away

  • How to fix errors that occur in Excel

Discover a different side of Excel, the familiar Excel you use every day!

Yep TV Original

It's neither new nor great, but I'm looking for the charm of Excel that I strangely overlooked.
This lecture is a free class that was reconstructed from the video of instructor Choi Banjang's YouTube channel , NepTV .

Yep TV

YouTube channel NepTV

Nice to meet you. I'm Team Leader Choi.

Hello. I run Rhodus Analytics, a specialized learning platform for Excel, spreadsheets, and BI. I also provide lectures and content creation to help businesses and individuals improve their productivity.

Drawing on my practical experience at a customs law firm and an e-commerce startup, I research and develop content that can drive real change. This class is the result of ongoing experience and reflection, producing and updating two to three new content pieces each month.

We will continue to provide new updates, so we recommend that you follow the news.


🔗 Go to Rhodes Analytics

It works! Practical Excel Pivot Table

Chief Choi's book, "It Works! Practical Excel with Pivot Tables"

Study the basic concepts, applications, and utilization methods together.

From Excel basics to data analysis and dashboards!

It is structured so that you can learn the fundamental concepts of Excel and practical tips together.
Excel is a spreadsheet program. Without a clear understanding of its fundamental components, such as cells and sheets, and the properties of data and formulas, it's difficult to improve your skills. Furthermore, even if you understand the basic concepts, you need to continuously observe, hear, and practice various ways to apply them to your work.

This class is structured to allow for a parallel learning experience between fundamentals and application. That's why I included the word "dictionary" in the title. You don't need to study sequentially. However, I strongly recommend studying both basic concepts and applied examples. Naturally, I recommend connecting with various domestic and international content to learn about any gaps in my lectures.

I hope you find joy in change rather than the pressure of taking classes.

Listen to a 10-minute lecture, practice for 30 minutes, and shorten your work time by 60 minutes!

I also take online classes and learn every day, but purchasing and completing lectures or books requires a significant amount of energy, and the pressure from them can sometimes be stressful. I wish this course were free, like a cookie box filled with delicious cookies I could grab and eat whenever I'm bored.

We create them with the hope that even just a few of our tasks will become faster, more accurate, or create new productivity gains. I've enjoyed the thrilling joy and reward of such experiences in my work. The day I implemented something cool in Excel was the second-highest joy after payday. I hope that everyone taking this course will experience such moments several times a month.


I run multiple channels because I want to connect with many people who want to further develop my work.
Please feel free to contact us for anything from lectures and consulting requests to just a quick chat or complaint.

Recommended for
these people

Who is this course right for?

  • For those who want to understand the basic concepts of Excel

  • For those who want to use Excel better in their work

  • For those who want to use Excel more professionally

Hello
This is

2,335

Learners

133

Reviews

46

Answers

4.8

Rating

2

Courses

Microsoft Excel & Power BI 교육 서비스 '히크로도스'를 만들고 있습니다.

관세와 무역, 생산성 도구와 데이터 분석, 스타트업과 조직문화에 관심이 많습니다.

 

👨‍💻 Actionable Data Analysis
실무에서 행동으로 연결할 수 있는 실용적인 데이터 분석과 생산성 향상 도구를 연구하고 있습니다.
최반장의 엑셀 피벗테이블 마스터 클래스 @인프런 💊
엑셀 시작하기 : Excel 입문 (Inflearn Original) @인프런 💊

 

🎥 Contents Creator
유튜브 채널 '넵 TV'를 운영 중이고, '김정준의 야구수다', '데이터홀릭' 등의 콘텐츠 제작 경험이 있습니다. 

 

🚩프로필 바로가기 (click!)

Curriculum

All

19 lectures ∙ (3hr 17min)

Published: 
Last updated: 

Reviews

All

20 reviews

4.5

20 reviews

  • neocy36님의 프로필 이미지
    neocy36

    Reviews 1

    ∙

    Average Rating 5.0

    5

    100% enrolled

    It was a very helpful course.

    • youthumxm5889님의 프로필 이미지
      youthumxm5889

      Reviews 4

      ∙

      Average Rating 5.0

      5

      100% enrolled

      I like it because it's easy and free

      • jang97979580님의 프로필 이미지
        jang97979580

        Reviews 1

        ∙

        Average Rating 5.0

        5

        100% enrolled

        I'm glad I learned about this feature I was curious about.

        • ywno0918님의 프로필 이미지
          ywno0918

          Reviews 2

          ∙

          Average Rating 5.0

          5

          100% enrolled

          I enjoyed it

          • dkprolee8981님의 프로필 이미지
            dkprolee8981

            Reviews 1

            ∙

            Average Rating 5.0

            5

            100% enrolled

            Free

            Similar courses

            Explore other courses in the same field!

            Master Excel 2019 Macro VBA from the BasicsCourse Thumbnail

            Master Excel 2019 Macro VBA from the Basics

            comt

            Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

            Basic

            Basic

            Excel, VBA, Business Productivity

            Master Excel 2019 Macro VBA from the BasicsCourse Thumbnail

            Master Excel 2019 Macro VBA from the Basics

            comt

            [Beginner] Basic and Strong Excel Conquer CourseCourse Thumbnail

            [Beginner] Basic and Strong Excel Conquer Course

            edupic

            Through Edupick lectures, students are expected to be able to build a solid foundation in Excel.

            Beginner

            Beginner

            Excel, MS-Office

            [Beginner] Basic and Strong Excel Conquer CourseCourse Thumbnail

            [Beginner] Basic and Strong Excel Conquer Course

            edupic

            Excel 2021 Practical Super-fast Master Class: Excel that Really WorksCourse Thumbnail

            Excel 2021 Practical Super-fast Master Class: Excel that Really Works

            ds8828455

            Excel 2021 Practical Super-fast Master Class covers 6 key tips and features to help practitioners maximize their work efficiency and get off work early. Quickly acquire all the essential skills of Excel, from data processing, editing, formatting, calculation, analysis, and visual effects through this course.

            Basic

            Basic

            Excel, Chart Analysis, MS-Office

            Excel 2021 Practical Super-fast Master Class: Excel that Really WorksCourse Thumbnail

            Excel 2021 Practical Super-fast Master Class: Excel that Really Works

            ds8828455

            [Revised in 2025] This is the real Korean automation [Practical Edition]Course Thumbnail

            [Revised in 2025] This is the real Korean automation [Practical Edition]

            hpxl0518

            Forget the difficult Korean automation! Just follow the instructions and your automation program will be complete.

            Basic

            Basic

            Hancom, Python, Pandas

            [Revised in 2025] This is the real Korean automation [Practical Edition]Course Thumbnail

            [Revised in 2025] This is the real Korean automation [Practical Edition]

            hpxl0518

            Automating VBA tasks using ExcelCourse Thumbnail

            Automating VBA tasks using Excel

            Kyeongrok Kim

            Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

            Basic

            Basic

            Excel, MS-Office, VBA

            Automating VBA tasks using ExcelCourse Thumbnail

            Automating VBA tasks using Excel

            Kyeongrok Kim

            ChatGPT × Excel Practical Application: Easy Start to Work Automation for EveryoneCourse Thumbnail

            ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

            iexceller

            Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

            Basic

            Basic

            Excel, VBA, ChatGPT

            ChatGPT × Excel Practical Application: Easy Start to Work Automation for EveryoneCourse Thumbnail

            ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

            iexceller

            Analyzing and predicting marketing data with ExcelCourse Thumbnail

            Analyzing and predicting marketing data with Excel

            groschool

            A class on analyzing customer/sales data with Excel, even without R or Python!

            Basic

            Basic

            Excel, Performance Marketing

            Analyzing and predicting marketing data with ExcelCourse Thumbnail

            Analyzing and predicting marketing data with Excel

            groschool

            From Excel Basics to PracticeCourse Thumbnail

            From Excel Basics to Practice

            50012980964

            This course is useful for everyone, from beginners to those who use Excel at work.

            Beginner

            Beginner

            Excel, MS-Office

            From Excel Basics to PracticeCourse Thumbnail

            From Excel Basics to Practice

            50012980964

            Powering Your Data! Excel Data AnalysisCourse Thumbnail

            Powering Your Data! Excel Data Analysis

            alpaco

            Are you wondering which tool to use for data analysis? Get started easily with Excel!

            Beginner

            Beginner

            Excel, Excel PowerQuery

            Powering Your Data! Excel Data AnalysisCourse Thumbnail

            Powering Your Data! Excel Data Analysis

            alpaco

            Effective business capacity enhancement, Python business data analysis expert courseCourse Thumbnail

            Effective business capacity enhancement, Python business data analysis expert course

            Masocampus

            Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

            Basic

            Basic

            Python, Excel, Excel Power Pivot

            Effective business capacity enhancement, Python business data analysis expert courseCourse Thumbnail

            Effective business capacity enhancement, Python business data analysis expert course

            Masocampus

            Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)Course Thumbnail

            Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

            usefulit

            Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Practical - Spreadsheet Practice (2021 Revised))

            Basic

            Basic

            Computer Specialist in Spreadsheet & Database, MS-Office, Excel

            Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)Course Thumbnail

            Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

            usefulit

            Business Analytics, Business Status Analysis Practical Master ClassCourse Thumbnail

            Business Analytics, Business Status Analysis Practical Master Class

            Masocampus

            Data-based decision-making ability, an essential competency in the era of digital transformation! As companies rush to find talent with digital capabilities, develop BA capabilities to successfully solve organizational problems through this course!

            Basic

            Basic

            Excel, Management

            Business Analytics, Business Status Analysis Practical Master ClassCourse Thumbnail

            Business Analytics, Business Status Analysis Practical Master Class

            Masocampus

            Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)Course Thumbnail

            Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

            usefulit

            Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

            Beginner

            Beginner

            Computer Specialist in Spreadsheet & Database, MS-Office, Excel

            Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)Course Thumbnail

            Computer Proficiency Level 1,2 Written Test - Spreadsheet General (2021 Revised)

            usefulit

            Basic Statistics with ExcelCourse Thumbnail

            Basic Statistics with Excel

            statisticsplaybook

            Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

            Basic

            Basic

            Excel, Statistics

            Basic Statistics with ExcelCourse Thumbnail

            Basic Statistics with Excel

            statisticsplaybook

            [Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail

            [Pass ITQ Excel A in One Go] in 3 days

            dmsgml1030

            Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

            Basic

            Basic

            ITQ, Excel, MS-Office

            [Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail

            [Pass ITQ Excel A in One Go] in 3 days

            dmsgml1030