inflearn logo
inflearn logo

[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

24 learners

Level Beginner

Course period Unlimited

Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

What you will gain after the course

  • 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 dmsgml1030

446

Learners

45

Reviews

1

Answers

4.9

Rating

19

Courses



I am teaching office certification courses to help students preparing for employment with their self-development.

And I teach practical Excel classes for office workers to help them improve their job competencies

CEO of Eunhee-ssam Class

■ Professional Qualifications

Vocational Training Teacher Level 2 (General Administration & Office Work) Ministry of Employment and Labor

Vocational Training Instructor (Information Technology Operation & Management) Level 3 Ministry of Employment and Labor

Vocational Training Teacher Level 3 (General Administrative Affairs) Ministry of Employment and Labor

Computer Literacy Level 1 Korea Chamber of Commerce and Industry

ITQ Professional Training Instructor (PTI) Korea Productivity Center

ITQ Hangul A, Excel A, PowerPoint A, Internet A Korea Productivity Center

Computer Utilization Ability Level 2 Korea Chamber of Commerce and Industry

Industrial Engineer Information Processing Human Resources Development Service of Korea

■ Publications

85 Excel Functions to Pick and Use Like a Dictionary & Everything About Analysis Tasks (Bookk 2020)

■ Teaching Experience

Taught OA and ITQ certification courses at the Daechi 4-dong Information Education Center in Gangnam-gu as a member of GIT Academy, commissioned by Gangnam-gu Office 2009.03

Lectured on OA and ITQ certifications for people with disabilities and seniors at Gunpo Welfare Center for the Disabled, March 2011

Conducted OA lectures at the Geumcheon-gu Office Computer Training Center as part of Hanbit Computing, entrusted by Geumcheon-gu Office, 2012.03

Taught OA and ITQ certification courses for people with disabilities and seniors at Seodaemun Welfare Center for the Disabled 2013.03

Taught Computer Literacy Level 2 and ITQ OA Master courses for office workers and the general public at the Hwaseong U&I Center (Women's Vision Center) 2015.01

Taught Computer Literacy Level 2 and ITQ OA Master courses as part of the vocational training program for the unemployed at the Gyeonggi Vocational Education Center, 2015.03

Lectured Computer Literacy Level 1 and 2, and ITQ OA Master courses as vocational training programs for the unemployed at Green Computer Academy 2016.04

Obtained "A" grade in Office Administration Trainee Evaluation, Dec 2018

Awarded Star Instructor at Green Computer Academy 2020.10

Selling practical Excel and certification courses on Inflearn 2022.03

[Teacher Eunhee's Class] Launch of an online lecture site specializing in employment certifications, September 2022

[Mapo Youth Naru] Youth Employment Competency ITQ Excel Special Lecture



More

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.

    dmsgml1030's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!

    $12.10