강의

멘토링

로드맵

Productivity

/

Office

Excel for Office Workers - Master Excel with 8 Practical Projects

Learn Excel most efficiently in a short period of time by creating an Excel report used at work in a project format.

(4.2) 6 reviews

112 learners

  • onwings
실습 중심
엑셀함수
Excel
Excel PowerQuery
MS-Office

What you will learn!

  • Processing downloaded data to create a production management report for each product

  • Create a report analyzing the status of consumer claims received

  • Create a monthly inventory report to check inventory at a glance

  • Create business meeting minutes that automatically fill in the format just by entering data

  • Create a shipment status table by supplier by extracting only unique data

  • Create a bid summary report by editing merged cells

  • Create a report analyzing the results of a customer satisfaction survey

  • Create a dashboard report that analyzes production status by process

With 8 practical projects
Survival Excel for Office Workers Who Leave Work Early! 📈

This course is designed to help you learn essential Excel functions in a short and efficient manner, while directly working with Excel reports used in the workplace. It includes eight practical documents and 15 practical tips from the instructor .

This course focuses on the essentials for those who hold Excel certification but struggle to understand how Excel is used in the workplace or what essential Excel features are essential. By mastering all the content covered in this course, you can confidently claim to be proficient in Excel at work.

The instructor's practical know-how goes beyond learning the functions and presents a perspective on how to use Excel properly, easily, and quickly, incorporating the instructor's 20 years of practical and teaching know-how.

💡 Lecture Point

  • You can learn Excel skills by writing eight company practice reports in a project format.
  • Learn 15 instructor tips to shorten your work hours and get off work on time.
  • You can use Power Query to process/compile external data and create dashboard reports .

I recommend this to these people 🙆‍♀️

I have an Excel certificate, but
Job seekers who don't know the practical aspects

I know the basics of Excel, but
Office workers who are having difficulties with their work

As an experienced person, I have Excel around me.
Office workers who are embarrassed to ask

Excel skills
Office workers who want to upgrade

"It's a hassle to enter data and format it every time."
"I want to write a differentiated and sophisticated report."
"I want to extract only the unique data and calculate the total by group."

✏️ I'll show you how to automatically format data when entering it, create dashboard reports, and use dynamic functions!


What you'll learn 📚

#1.
Download data processing,
Writing production management reports

By quickly processing raw data with Power Query and creating pivot tables, you can avoid repetitive tasks even when data is updated daily.

#2.
Consumer Claims Filing
Status Analysis Report

The list of claims received can be analyzed from various angles through Excel reports, which are aggregated using functions and visualized in charts and display formats.

#3.
Check monthly inventory at a glance,
Incoming and Outgoing Report

Create reports that allow you to manage inventory by business location and item at a glance using daily updated incoming and outgoing data.

#4.
Extract only unique data,
Shipment status table by delivery location

Create a list by extracting unique data using just one UNIQUE dynamic array function, and create a table that aggregates shipment quantities using the SUMIFS function and conditional formatting.

#5.
Customer satisfaction survey results
Analysis Report

Create dynamic reports that analyze performance by branch for two years using aggregated customer satisfaction survey data stored across multiple sheets.

#6.
Analysis of production status by process,
Dashboard Report

Create dynamic dashboard reports that allow you to see the production status of each product at a glance, by line and process.


Expected Questions Q&A 💬

Q. I have an Excel certification. Do I need to learn company practical skills separately?

The Excel skills you learn in an Excel certification program are vastly different from the Excel skills you use in your actual work. Furthermore, no one teaches you Excel once you join the company. You have to learn it on the job.

Q. Will taking this course help me use Excel effectively at work?

This course will give you a firsthand experience of the Excel skills you'll learn while working in a company and facing real-world challenges. Therefore, once you master the content of this course, you'll be able to immediately begin working at your company without fear.

Q. What types of work examples are available?

We have prepared a variety of reports that are frequently used in general office work, marketing, purchasing/production, and customer service.

Q. I want to create my own report that is more unique than the Excel report format that the company always uses.

How about dashboard reports? Using pivots, slicers, and pivot charts, you can create dynamic dashboard reports.

👤 Notes before taking the course

  • This course offers easy-to-follow, detailed instruction that anyone with basic Excel knowledge can follow. Functions are explained in detail, including formats and the requirements for each argument.
  • Practice environment
    A PC with Excel 2016 or later installed (Excel 2019 or later or 365 recommended)
  • Learning materials
    Excel practice files and completed files provided

Recommended for
these people

Who is this course right for?

  • New employees who need to learn practical Excel before joining the company for an internship

  • Office workers who know the basics of Excel but have difficulty applying it in practice

  • An office worker who is embarrassed to ask people around him about Excel

  • Office workers who want to get better at Excel and upgrade their skills

  • A job seeker who has Excel certification but doesn't know the practical skills

Hello
This is

6,336

Learners

622

Reviews

156

Answers

4.9

Rating

6

Courses

김경자 / 컴피플 대표, 연성대학교 겸임교수, 엑셀여신(http://blog.naver.com/onwings)

LG전자 LearningCenter에 근무하면서 IT교육과 인연을 맺어 현재는 삼성그룹, 기아그룹, 유데미, 금융감독원, 김앤장, 국가공무원인재개발원 등에서 강의하고 있습니다. IT/정보화 교육 전문회사인 컴피플 대표이며 연성대학교 겸임교수로 재직중입니다.

<저서>
- 회사에서 통하는 엑셀 데이터 활용 분석(한빛미디어, 2025)
- 회사에서 엑셀로 살아남기 (한빛미디어, 2023)
- 엑셀 실무 함수 + 수식 (한빛미디어, 2021)
- 엑셀 실무 매크로와 VBA (한빛미디어, 2020)
- 엑셀 실무 데이터 활용+분석 (한빛미디어, 2019)
- 엑셀 2016 기본+실무완성 (북스홀릭, 2018)
- 실무통 엑셀 함수 실무 강의 (한빛미디어, 2017)
- 회사 실무에 힘을 주는 엑셀 2016 매크로와 VBA (정보문화사, 2016)
- 회사에서 바로 통하는 엑셀 데이터 활용+분석 (한빛미디어, 2016)
- 엑셀 2013 기본 실무완성 (북스홀릭, 2014)
- 키노트 & 넘버스 무작정 따라하기 (길벗, 2014)
- 엑셀 2010 매크로와 VBA (영진닷컴, 2012)
- 엑셀 2010 기본 실무완성 (북스홀릭, 2011)
- 엑셀 2007 매크로 & VBA 기본+실무 (성안당, 2009)
- 엑셀 2007 기본 + 실무 (성안당, 2007)
- 실무에 강한 엑셀 매크로와 VBA (사이버출판사, 2005)

Curriculum

All

40 lectures ∙ (5hr 16min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

6 reviews

4.2

6 reviews

  • wjkyori2847님의 프로필 이미지
    wjkyori2847

    Reviews 15

    Average Rating 2.9

    4

    100% enrolled

    I like the clean and concise lectures. Thank you.

    • sh1005park6311님의 프로필 이미지
      sh1005park6311

      Reviews 9

      Average Rating 4.8

      4

      100% enrolled

      It was a really good lecture.

      • kkh19902642님의 프로필 이미지
        kkh19902642

        Reviews 3

        Average Rating 4.3

        4

        100% enrolled

        The class was taught calmly and the explanations were very focused. Thank you.^^

        • wonchoong님의 프로필 이미지
          wonchoong

          Reviews 2

          Average Rating 5.0

          5

          100% enrolled

          After Corona, I have been taking Excel lectures here and there. Among them, I can say that your lectures are by far the best. The lectures go straight into my ears and I understand them well. Thank you.

          • onwings
            Instructor

            Thank you~^^ I hope that learning Excel was helpful. If you encounter any problems while using Excel for work in the future, please ask questions even if they are not related to the lecture content. We will think about it together and help you.

        • jjh227611님의 프로필 이미지
          jjh227611

          Reviews 1

          Average Rating 4.0

          4

          30% enrolled

          $50.60

          onwings's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!