강의

멘토링

커뮤니티

Productivity

/

Office

From Excel Basics to Practice

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

(4.9) 174 reviews

18,560 learners

  • 50012980964
Excel
MS-Office

Reviews from Early Learners

From Excel Basics to Practice

Excel is the most widely used program among office workers. It offers features for easily handling complex calculations and efficiently managing and analyzing data, enabling rapid processing of large amounts of data. Furthermore, it allows you to create tables and charts to effectively present analysis results, allowing you to present data intuitively and clearly.

The Excel Basics to Practice course is designed for everyone, from beginners to professionals who use Excel at work. It consists of 16 sections and 1 mission.

=============================================================================

0. Excel Basics, Data Entry and Management
1. Database - Easy to manage with proper input
2. Data Management - What Makes Excel Special for Professionals
3. Excel's Flowers: Formulas and Functions
4. Logic and Conditions - Basic Skills for Smart Excel Use
5. Text - How to handle character data
6. Date and Time - Excel is fast and accurate for time calculations.
7. Data Aggregation - The First Step to Creating a Report
8. Filtering - How to Find Values
9. Charts - Easy-to-read charts are also easy to understand.
10. PivotTables and PivotCharts - Summarize Complex and Large Data
11. Mission (from 0 to 10)
12. Power Query New
13. Everything you need to know about dynamic range usage
14. Array formulas
15. Practical Use of Excel
16. Excel Tips
17. Developing Excel skills
18. Macros & VBA
=============================================================================
If you're new to Excel, study Lessons 1 through 10 in order. You'll soon feel confident using Excel.
Anyone familiar with the basics of Excel can select and learn only the courses they need. Each course is concise, making it easy to learn.
7-Day Practical Excel If you're learning from a book, you can study Sections 0 through 11 in order. I've listed the book pages below the video.
And for the material that couldn't be included due to the length of the book, I've marked it with " Useful to Know ." The lecture notes are linked to the blog address below the video.
Rather than just watching the video, I recommend that you download the practice files and practice them yourself .
I hope this course will be helpful to everyone who needs a course on Excel, from basics to practical use .

Learning Objectives

  • You can learn the basics of Excel and acquire skills that can be applied in the workplace.

Helpful people

  • For those new to Excel
  • Those who have learned the basics of Excel but find it difficult to apply it in practice
  • Those preparing for employment or office certification

Introduction of knowledge sharers

Short lecture
  • Short lecture YouTube channel (youtube.com/@hantip), blog operation (hantip.net)
  • Lectures at government offices, public corporations, and universities
  • CLASS101, Teacherville, Suwon District Prosecutors' Office, Daegu Education and Training Institute e-learning production (Teacherville)
  • EBS Computer Proficiency Levels 1 and 2 Practical Proofreading, Proofreading, and Excel Practical Appendix Writing
  • Book: 7-Day Practical Excel | 7-Day Practical Excel, PowerPoint, Word, and Hangul

Hello
This is

18,560

Learners

174

Reviews

12

Answers

4.9

Rating

1

Course

Curriculum

All

190 lectures ∙ (25hr 11min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

174 reviews

4.9

174 reviews

  • j17154668님의 프로필 이미지
    j17154668

    Reviews 1

    Average Rating 5.0

    5

    8% enrolled

    I found out about it through YouTube, but I've been studying hard since joining Infraon. Thanks to that, I was able to buy the textbook... The only thing I regret is that you could make the table of contents of the class a little easier to understand. Is this too much to ask for since it's a free class?

    • serratus401812님의 프로필 이미지
      serratus401812

      Reviews 4

      Average Rating 4.8

      5

      70% enrolled

      An incredibly amazing and great lecture on life

      • 50012980964
        Instructor

        Haha thank you. That's a great compliment.

    • owenchoi96님의 프로필 이미지
      owenchoi96

      Reviews 11

      Average Rating 4.7

      5

      100% enrolled

      I highly recommend this to anyone who wants to start Excel properly for the first time. Each lecture is not too long and it explains in detail with many examples, so I think it is the best lecture for beginners.

      • kyungdu6811님의 프로필 이미지
        kyungdu6811

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        I think it will be very helpful in practice. I think I will have to keep looking at it repeatedly because I don't have enough time. I also bought the Excel book this time. Thank you.

        • jhhong3486님의 프로필 이미지
          jhhong3486

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          Free

          Similar courses

          Explore other courses in the same field!