시간을 줄이고 업무가 풀리는 엑셀 2016
유밥(Ubob)
기본 기능부터 현업에서 사용하는 수준 높은 실무 문서, 엑셀 2016만의 새로운 기능까지! 엑셀 2016으로 문서에 날개를 달아보자!
입문
Excel, MS-Office
From beginner to practitioner! Creating Excel office automation documents
Even if you are an Excel beginner, we will upgrade your Excel skills to the level of a job seeker. You can also secure an Excel portfolio for employment.
Reviews from Early Learners
What you will gain after the course
The concept of macros and various techniques for utilizing macros
An efficient way to design complex structured Excel documents
How to write a functional formula by combining multiple functions
How to manage a list of frequently added and deleted data
How to dynamically extract the data you need and obtain statistics
How to automatically process data for long-term storage
How to create a dynamic document using form controls such as scroll bars and option buttons.
How to package related Excel documents for work to increase efficiency
How to download the Excel document you need from the Internet and use it in your documents
Basic concepts of VBA code and how to use it for automation
Excel beginners gather around!
I'll show you how to package and automate Excel documents. 🤖
"I have a general understanding of Excel's functions, but I'm not confident in practical applications."
"I don't know many functions, and writing functional formulas is especially difficult."
"I feel like I'm always hovering around the level of a beginner in Excel."
Excel's functions
Gather and gather 🛒
Many people use Excel like a word processor, using only a small portion of its features. This guide will help these novice users maximize Excel's capabilities to create automated, practical documents.
Unique features of this course ✨
- Even beginners who don't know all the Excel menus can create documents that can be used immediately in the field .
- Learn techniques for automating and packaging Excel documents, not just plain documents.
- It is easy to understand because the lecture is conducted interactively, as if you are entering information one by one.
- All lectures include a complete file, practice file, and explanation file (text file ).
- The documentation file provides links to the functions used in the document, and clicking on a link will take you to the instructor's blog to learn more about that function.
What you'll learn 💁🏻♂️
#1.
Creating a basic document
#2.
Sales Management Package 1
You'll learn how to create and package four practical documents required for sales management into a single file. You'll learn how to efficiently manage data modifications, additions, and deletions by establishing shared information among related documents. You'll also learn how to write complex functional formulas for automation. You'll also learn techniques for automatically managing data due daily, weekly, and monthly.
#3.
Sales Management Package 2
We'll automate the process of displaying simple statistics during the order entry process for the order book, accumulating and storing daily closing data separately, and dynamically creating charts and summary tables based on this accumulated data. This process uses simple VBA code and provides detailed guidance on its use.
#4.
Dynamic data extraction and
Get statistics
Learn how to quickly extract only the data you want from a large amount of data and obtain statistical values. You can set conditions for every item in the data, and you'll learn how to use the scroll bar to precisely specify numbers like dates. You'll also learn techniques for extracting data with complex conditions using multiple AND conditions.
#5.
HR and salary package
Learn how to package and create documents required for HR and payroll tasks. Based on the HR ledger, you'll learn how to share necessary data between documents, how to use option buttons to process bonuses, how to select images like photos using combo boxes, and how to write functions to calculate various taxes and annual leave allowances related to payroll.
Expected Questions Q&A 💬
Q. Which version of Excel should I use?
You can work with all versions of Excel starting from Excel 2007.
Q. I haven't learned Excel in a long time and don't know much. Will I be able to understand it?
If you can remember the IF function, that's possible. This lecture is geared towards those who are familiar with it.
Q. I'm preparing for employment and need practical experience.
The documents used in this course were written, distributed, and used by the instructor at the request of surrounding businesses while running his own business. By taking the course, you will gain hands-on experience in the field.
Introducing the Knowledge Sharer ✒️
Calm
- A programmer with a background in computer engineering
- I run a small business and teach classes, and I create the Excel sheets I need myself.
- Developed various sheets upon request from surrounding trading companies
- Computer-related lectures at numerous companies, including the Korea Federation of SMEs, Dong-A Cultural Center, and Samdo Trading.
- Published numerous books, including Practical Application of Excel Functions and Macros, C Language Coding and Algorithms, and First Steps to Python Coding.
- Possess Level 1 Information Processing Engineer, Level 1 Electronic Computing Organization Application Engineer, and Level 2 Certified Teacher
Recommended for
these people
Who is this course right for?
For those who are beginners and are not familiar with Excel menus and want to advance to intermediate level
People who want to get an office job
People who are in charge of Excel work but are having difficulties
Those who use Excel as if it were Word by obtaining various Excel formats
Need to know before starting?
It will be easy if you know something about Excel's IF function.
컴퓨터 공학을 전공한 프로그래머 출신으로 강의, 컴퓨터 잡지사 편집장, 소규모 사업체 운영 등 IT 관련 다양한 경험을 했습니다.
"담담"이라는 닉네임으로 네이버 블로거, 인플루언서로 활동하고 있으며 주로 엑셀 함수식과 파이썬이나 C와 같은 프로그래밍 언어에 대한 포스팅을 하고 있습니다.
컴퓨터와 일상을 같이 하고 있으나 낚시와 호젓한 숲길 산책을 즐기는 자연주의자이기도 합니다.
Curriculum
All
20 lectures ∙ (9hr 35min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
3 reviews
Similar courses
Explore other courses in the same field!
![[기초]코딩 무경험자도 가능! 90분에 뽀개는 구글 시트 업무 자동화강의 썸네일](https://cdn.inflearn.com/public/courses/331717/cover/a395d468-0688-4908-88c2-4d087f24d7b7/thumbnail.jpg?f=avif&w=420)
![[에피소드] 엑셀+파이썬(기초)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
