강의

멘토링

로드맵

Productivity

/

Office

Office Excel that finishes in one room!

You know how to use Excel, but what if you keep doing similar tasks over and over again, and it takes a long time, but the results don't seem to improve? What you need is speed and quality! The engineering girl's function and data analysis tips will neatly solve the Excel worries of office workers. (*Can be learned with Excel 2013 or later versions)

(5.0) 1 reviews

23 learners

  • lmy0016004
Excel
MS-Office

What you will learn!

  • Excel functions and data analysis skills for a work life without overtime

  • 100% practical examples to increase work usability by 200%!

  • Data management tips that are highly useful in the field, regardless of the Office version!

Starting today, I'm a Excel pro! 📊
Master your office Excel skills in one go.

What is Excel for office workers?

Excel is a tool that easily 'structures' the data that is essential for a company.
People who are good at analytical thinking and work well tend to be good at Excel.
Excel helps you gain a sense of inner accomplishment and recognition from those around you, as well as a good reputation.
It's a very useful tool, and above all, it's a very important work skill that calls for a timely dismissal.

Does that mean I need to know every shortcut and function in Excel? No way!
'Engineering Girl Excel Genius' is the most used in practice to improve office Excel skills of office workers.
We will teach you the core functions of Excel for office use through practical examples.

Introduction to the main curriculum

1. Do not manually enter data one by one.

The habit of manually entering data one by one is a very inefficient method.
Not only does this increase work time, but it can also lead to typos, which can reduce the reliability of your data.
We'll show you how to enter data quickly and easily without having to type it in manually.
(Creating shortcuts, Excel preferences, paste options, fill, formatting)

2. Check if you are finding the data correctly.

There's a quick and easy way to find the data you want.
You can extract various data by setting the scope and search location, and quickly find and replace specific data.
You can extract data under various conditions and edit it in a filtered state!

3. Use Excel functions effectively

No matter how many types of functions you know, it's useless if you can't apply them to different situations, right?
Each function has its own rules, and it is important to know how to apply these rules to each situation.

4. Do not share the results of the pivot table without permission.

However, if you carelessly share a pivot table, you could end up giving the other person all of the raw data . Let's explore these aspects through examples and learn about pivot tables.

Recommended for
these people

Who is this course right for?

  • For those who want efficient data organization

  • An office worker who works overtime every day because he doesn't know Excel

  • Anyone who wants to learn Excel know-how for the office

Need to know before starting?

  • If you know what Excel is, that's enough.

Hello
This is

1,059

Learners

93

Reviews

164

Answers

4.4

Rating

8

Courses

소소하지만 확실한 성장 : 소확성

어제보다 조금 더 성장한 오늘의 나를 위해, 소확성이 함께 합니다.

경쟁과 성공, 성과만을 쫓는 경쟁적 자기계발에 지친 현대인을 위해,

일과 삶, 생활을 업그레이드하는 진정한 나만의 성장을 위한 콘텐츠를 제공합니다.

* 온라인교육전문기업 (주)알엠피 홈페이지 www.thermp.co.kr

Curriculum

All

20 lectures ∙ (5hr 34min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • hyunjinpark0362님의 프로필 이미지
    hyunjinpark0362

    Reviews 4

    Average Rating 5.0

    5

    95% enrolled

    • lmy0016004
      Instructor

      Hello, this is Sohwakseong! Thank you so much for taking our course and giving us 5 stars!!!!! ★★★★★ !!!!! Thank you so much for giving us 5 stars~~~ I will become a Sohwakseong who works harder and harder~ Have a nice weekend~~

$34.10

lmy0016004's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!