Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Office

[Useful Excel Tips to Know (1)] that will get you recognized by your boss

Are you using Excel well in your work? Small tips for Excel can help you reduce mistakes and increase work efficiency! In this course, we will carefully select 16 useful Excel tips and explain them in detail.

(5.0) 2 reviews

22 learners

  • dmsgml1030
3시간 만에 완강할 수 있는 강의 ⏰
Excel
MS-Office

What you will learn!

  • You can learn the correct way to enter various data into a sheet.

  • Create professional-looking tables using custom formats

  • You can change incorrectly entered data to correct one.

  • You can use it in formulas by defining names.

  • Learn the text splitting function and use it in tables.

  • You can also learn useful Excel tips and apply them to your work.

It's so useful to know
Learn various Excel tips 🍯

Excel Hacking 🤸‍♀️

While it's good to know a lot, it's equally important to apply that knowledge effectively. We'll share a variety of useful Excel tips, so apply them to your work to increase efficiency! This course will help you gain confidence in Excel.

[Useful Excel Tips (1)] If you know this,
You can become a newbie who doesn't seem like a newbie , and be recognized by your superiors.

I recommend this to these people 🙋‍♀️

When working at the company
People who work a lot with Excel

In addition to the features you already know,
For those who want to know other features

Use Excel tips for your work
Those who want to increase efficiency


Student's concerns 👀

1. Why do I get a #Value error when calculating a formula?

Data in a cell may appear as numbers, but it may actually be text. This can cause the #Value error to appear and prevent formula calculations. In this case, you can convert the data to numeric data.

2. Can I set a separate format even when a cell contains positive numbers, negative numbers, 0, characters, etc.?

Yes, you can. You can format it separately with a custom format like positive; negative; 0; character.

3. Is there a way to quickly enter data into cells all at once according to the rules?

Among the fill handle functions, you can use the 'Quick Fill' function to quickly input according to the rules.

4. I want to divide the cell data into multiple fields.

The Split Text feature allows you to split data in a cell into multiple fields.


Lecture Content ✏️


When data such as positive, negative, and 0 are mixed, custom formatting is used.
You will learn how to format data that meets your conditions.

Incorrectly entered numbers or date data
You can easily change it all at once.

You can divide the data entered in a cell into multiple fields.
This feature allows you to skip the process of inserting/entering new columns.


16 Excel Tips
Let me tell you 🕹️

Tip #1

  • Try entering various data into cells

Tip #2

  • Learn about cell formatting and customization.

Tip #3

  • Several ways to specify a range (block) of cells

Tip #4

  • Try using the fill handle

Tip #5

  • Sorting data

Tip #6

  • Learn about the status bar

Tip #7

  • Useful features that can be utilized as movement options

Tip #8

  • Useful features that can be utilized with auto-correct options

Tip #9

  • How to fit data to the width of a column

Tip #10

  • Enter data easily using list boxes

Tip #11

  • Quickly open frequently opened files

Tip #12

  • Learn about name definitions

Tip #13

  • Calculating time exceeding 24 hours

Tip #14

  • Replace incorrectly entered dates/numbers

Tip #15

  • Split text

Tip #16

  • Treating empty cells as 0 in a line graph

Q&A 💬

Q. Is this a course that non-majors can also take?

Yes, Excel is a program that is widely used in all types of work, so it is useful for anyone to know it, regardless of their major or non-major.

Q. Why should I learn useful Excel tips?

This course will help you feel confident in Excel and improve your work efficiency by utilizing Excel tips that others don't know about.

Q. Are there any notes regarding the course (environment requirements, other precautions, etc.)?

Please prepare MS Office Excel 2016 or higher.


Introducing the Knowledge Sharer ✒️

Hello, I'm Eunhee. I hope that my knowledge of office administration, which I enjoy and excel at, can be of help to others in need. I currently teach practical office administration (Excel, PowerPoint) and office-related certifications (Computer Skills Level 1/2, ITQ) at a vocational training institute.

  • Information Processing Industry Engineer
  • 2nd grade vocational training instructor (general affairs, general affairs)
  • Computer Proficiency Level 1 and 2
  • ITQ (Korean, Excel, PowerPoint) expert instructor

Recommended for
these people

Who is this course right for?

  • Anyone who wants to improve work efficiency by using Excel tips in their work

  • For those who want to know other useful functions in addition to the Excel functions they know

  • People who work a lot with Excel

Hello
This is

356

Learners

23

Reviews

5.0

Rating

10

Courses

 

취업을 준비하는 학생들에게 자기계발에 도움을 주는 사무자격증을 강의하고 있습니다

그리고 직무 역량을 향상시키기 위해 직장인 대상 실무엑셀 강의를 합니다

은희쌤 클래스 대표

■ 전문 자격

직업훈련교사2급(일반총무사무) 고용노동부

직업훈련교사(정보기술운용관리)3급 고용노동부

직업훈련교사3급(일반총무사무) 고용노동부

컴퓨터활용능력 1급 대한상공회의소

ITQ정보기술전문강사(PTI) 한국생산성본부

ITQ 한글 A, 엑셀 A, 파워포인트 A, 인터넷 A 한국생산성본부

컴퓨터활용능력 2급 한국상공회의소

정보처리산업기사 한국산업인력관리공단

■ 저서

사전처럼 쏙쏙 뽑아쓰는 엑셀함수 85선 & 분석작업의 모든것(부크크 2020)

■ 강의 이력

강남구청에서 위탁한 GIT아카데미 소속으로 강남구 대치4동 정보화교실에서 OA, ITQ자격증 강의 2009.03

군포장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2011.03

금천구청에서 위탁한 한빛전산 소속으로 금천구청 전산교육장에서 OA 강의 2012.03

서대문장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2013.03

화성유앤아이센터(여성비젼센터)에서 컴퓨터활용능력2급, ITQ OA 마스터 과정을 직장인, 일반인 대상으로 강의 2015.01

경기직업교육센터에서 실업자 직업훈련과정으로 컴퓨터활용능력 2급, ITQ OA 마스터과정 강의 2015.03

그린컴퓨터아카데미에서 실업자 직업훈련과정으로 컴퓨터활용능력 1급, 2급, ITQ OA 마스터과정 강의 2016.04

사무행정부문 이수자 평가 "A" 취득 2018. 12

그린컴퓨터아카데미 스타 강사 수상 2020.10

인프런에서 실무엑셀, 자격증 강의 판매 2022.03

[은희쌤 클래스] 취업 자격증 전문 인강사이트 개설 2022.09

[마포청년나루] 청년 취업 역량 ITQ 엑셀 특강



Curriculum

All

17 lectures ∙ (2hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

2 reviews

5.0

2 reviews

  • to84318986님의 프로필 이미지
    to84318986

    Reviews 1

    Average Rating 5.0

    5

    35% enrolled

    • yeonsoochoi님의 프로필 이미지
      yeonsoochoi

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      You explain it so well and logically.

      • dmsgml1030
        Instructor

        Thank you ^-^ I'm glad you understood it well I hope the Excel tips will help you with your work. If you have any questions while working with Excel, please ask at any time.

    $12.10

    dmsgml1030's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!