inflearn logo
inflearn logo

10 Excel Tips for Complete Beginners, Regardless of Version

A lecture for those who don't know much about computers but want to learn Excel! We'll teach you 10 essential functions in an easy-to-understand manner.

(4.7) 43 reviews

598 learners

Level Beginner

Course period 3 months

Excel
Excel
Excel
Excel
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.7

5.0

hoo0chan

100% enrolled

I learned it easily thanks to the easy-to-follow explanation.

5.0

정공수

100% enrolled

This is really beginner level content, but I think it will be helpful for beginners.

5.0

mjessicalee7

100% enrolled

It's been so long since I've used Excel that I listened to it to refresh my memory. It's not boring and the explanations are easy to understand. I listened to it at 2x speed because I wanted to quickly skim it. If you're not a complete beginner, this is a great lecture to listen to at 2x speed and finish quickly.

What you will gain after the course

  • Learn the screen layout and basic data entry in Excel.

  • Learn how to input easily using the autofill feature.

  • You can easily work with formulas using Excel's basic functions.

  • You can organize your deposits and withdrawals with automatic totals.

  • Learn how to display dates, numbers, and percentages to help you make better use of Excel.

Even if you are a complete beginner in Excel, there is no need to worry!
Learn just 10 essential Excel functions ✅

Essential for any job
Excel!

Any version is fine.
Use Excel in various ways.

  • A spreadsheet that automatically calculates by adding the columns and rows of cells, which are the smallest units of a sheet, as a function.
  • A program for working with integrated documents, including spreadsheet functions, macros, graphics, and database functions.

  • From very simple bookkeeping to corporate tax calculations, statistics, reports, and school grade management.
  • The best program that handles complex calculations quickly and easily through various functions and formulas.

🐥

This course is for complete beginners.
So that everyone can understand
This is a very easy-to-understand lecture.

📈

Difficult and hard to memorize
Other than functions, it is used in practice
We only deal with functions.

😜

When using Excel, you must
Need to know
Learn 10 skills.

Just know this!
10 Features 💁‍♂️

1st

  • Excel screen layout and basic data entry methods

2nd

  • How to enter multiple lines of data, dates, and calculation formulas

3rd

  • Create a calendar easily with the autofill feature.

4th

  • Sorting and merging data using Flash Fill

5th

  • Setting the date, number, and percentage display format

6th

  • Initial steps for creating a document form in Excel, how to merge cells

7th

  • Insert border lines and enter calculation formulas

8th

  • Added auto-sum function, displayed amount in Korean in cell format, completed purchase order form

9th

  • Learning Excel's most basic functions: average, max, min, count, and counta.

10th

  • Reference content from other sheets and learn sorting functions

Recommended for
these people

Who is this course right for?

  • I need to learn Excel, but I have no computer knowledge at all.

  • For those who are complete beginners in computers

  • People who need to organize books or do accounting work using Excel

  • People who need to use simple ledgers to do business

Need to know before starting?

  • No~

Hello
This is comt

1,626

Learners

142

Reviews

4

Answers

4.7

Rating

33

Courses

Back when Apple's MAC computers made it possible to design even better.

It's already been well over 25 years since I first started teaching Adobe Photoshop and Illustrator at the academy~~^^

I remember the days when, instead of calling the instructors Teacher Eom, Teacher Ha, and Teacher Gu, we used to call them Eom-T and Gu-T.

Together with those teachers, we started using ComTee as an abbreviation for Computer Teacher!

I will continue to be a "Computer Teacher" who works hard to share knowledge for all those who are learning.

Thank you!!

Thank you!!

Together with everyone, we've come to use "Com-T" as a shorthand for Computer Teacher! We will continue to be a Computer Teacher that works hard to share knowledge for all learners. Thank you!!

Together with everyone, we've come to use "Com-T" as a shorthand for Computer Teacher! We will continue to be a Computer Teacher that works hard to share knowledge for all learners. Thank you!!

More

Reviews

All

43 reviews

4.7

43 reviews

  • kjs4250005449님의 프로필 이미지
    kjs4250005449

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    thank you

    • mjessicalee7님의 프로필 이미지
      mjessicalee7

      Reviews 4

      Average Rating 5.0

      5

      100% enrolled

      It's been so long since I've used Excel that I listened to it to refresh my memory. It's not boring and the explanations are easy to understand. I listened to it at 2x speed because I wanted to quickly skim it. If you're not a complete beginner, this is a great lecture to listen to at 2x speed and finish quickly.

      • jh8869kim1997님의 프로필 이미지
        jh8869kim1997

        Reviews 4

        Average Rating 3.8

        4

        100% enrolled

        • hoo0chan1909님의 프로필 이미지
          hoo0chan1909

          Reviews 2

          Average Rating 5.0

          5

          100% enrolled

          I learned it easily thanks to the easy-to-follow explanation.

          • ks4cheong3930님의 프로필 이미지
            ks4cheong3930

            Reviews 1

            Average Rating 5.0

            5

            100% enrolled

            This is really beginner level content, but I think it will be helpful for beginners.

            comt's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            Limited time deal ends in 17:36:07

            $9,900.00

            25%

            $11.00