업무가 100배 빨라지는 엑셀 데이터 활용과 분석 노하우
엑셀여신
본 과정은 엑셀의 기능을 설명하는 교육이 아니라 실제 업무 현장에서 사용되는 엑셀 예제를 이용하여 각 상황별로 어떠한 기능을 접목해야 가장 빠르고 효율적으로 업무를 수행할 수 있는지를 학습하는 과정입니다.
초급
Excel, MS-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.
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
6,235
Learners
592
Reviews
138
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
wjkyoriReviews 14
∙
Average Rating 2.8
- 박성후
Reviews 9
∙
Average Rating 4.8
- 권기현
Reviews 3
∙
Average Rating 4.3
- choong youn won
Reviews 2
∙
Average Rating 5.0
5
100% enrolled코로나 이후에 이거저거 어설프게 엑셀 강의듣고 있었습니다. 그 중에서 강사님 강의가 단연 최고라고 말씀드릴 수 있겠네요. 귀에 강의가 쏙쏙 들어오고 이해도 잘 됩니다. 감사합니다.
- 엑셀여신Instructor
감사합니다~^^ 엑셀 학습이 도움이 되었으면 하는 바램입니다. 추후에도 업무에 엑셀 사용하시다가 부딪치는 문제가 있으면 강좌 내용과 관련 없더라도 질문 올려주십시오. 같이 고민해서 도움 드릴 수 있도록 하겠습니다.
- jjh22
Reviews 1
∙
Average Rating 4.0
$50.60
onwings's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
