[OA 아카이브] 손에 잡히는 비즈니스 엑셀

We will show you how to use ChatGPT prompts for task automation in the most frequently used areas in practice (files and folders, Excel, PowerPoint, Word, PDF, data analysis), through various practical examples.

We'll share the know-how techniques of successful leaders by combining them with various real-world cases.

This is a course designed for procurement cost management practitioners aimed at promoting procurement cost management strategies and rationalization, which are core functions of corporate procurement organizations. Through theoretical learning and practical case studies for procurement cost management, you can understand the specific characteristics and management techniques of procurement cost management, and acquire essential basic accounting knowledge for procurement cost management to understand the interconnected relationships.

You can understand change-driven leadership capabilities and acquire the change management skills needed for business activities by viewing the organization as a whole, enabling you to proactively drive change management activities and projects within the organization.

It is structured around issues frequently encountered in real estate practice, such as the establishment and changes of real rights, real estate registration, nominee title trust, liens, mortgages, and the Lease Protection Act, to provide practical legal insight not only for practitioners seeking to build a foundation in law but also for intermediate or higher-level practitioners.

We provide a practical guide for designing and operating core implementation tasks of MES systems to improve quality and productivity in manufacturing companies, as well as a guide for establishing key implementation strategies for successful MES system construction. Additionally, we explore data utilization technologies and development trends for operating the latest smart factories, including the Fourth Industrial Revolution, and provide data-based decision support measures to improve corporate productivity and quality. Through this, you can establish efficient operational plans for information management in successful smart factory MES systems.

To allow even beginners to easily approach SQL, everything from basic installation methods to fundamental knowledge, and even points beginners should especially note, has been presented clearly and simply for effortless access.

By inviting a top expert who has worked as a professional interviewer for many years, this content includes the interview process and methods, as well as the fundamental qualities and communication skills interviewers should possess.

The program is structured with content including real estate development project financing, PF case studies, and other materials for smooth funding of real estate development projects utilizing project financing techniques. Through this, you can understand the overall execution of real estate development projects and enhance your capabilities in PF financing design, risk management, and feasibility analysis.

Beyond simple compensation theory, you can more effectively improve payroll processes and compensation systems and apply them to your work based on a comprehensive understanding of wage systems, income tax systems from employment to retirement, and regulations related to the four major insurances.

The content has been structured to help improve job competency by covering the accounting knowledge necessary for work performance, from basic concepts up to the composition stages of financial statements. We have explained double-entry bookkeeping concepts and content related to financial position and business performance by incorporating various practical cases.

It is case-study based to acquire accurate prior knowledge and practical skills in corporate accounting. By acquiring basic accounting principles, from voucher creation to closing and financial statement prep, via core principles, accounting knowledge can be applied in real-world business.

This is a course designed to improve your ability to successfully communicate your arguments and ideas in various presentation situations such as proposals, reports, and briefings. We hope that through this course, you will become a more competitive presenter.

This patent guide is designed to legally protect the development achievements of universities, research institutes, and companies, and to secure exclusive technological competitiveness. Additionally, we provide efficient and competitive research and development directions through understanding intellectual property-based R&D trends and predicting technology gaps.

We provide comprehensive guidance on discovering, proposing, and transferring technology-based innovative products to business divisions, and inform you about the functions and roles of R&D, product development, marketing, and business divisions related to product development.

We provide strategic implementation plans that can offer direct assistance in performing duties, focusing on essential content that corporate education and training managers must know. We have also included methodologies and procedures for designing corporate human resource development systems, as well as content on recent applications of competency modeling and case analyses of educational systems through job analysis.

Based on comprehensive theories including job analysis procedures for job-centered human resource management, NCS job analysis, job analysis and performance management (KPI), and job-based pay systems, this content is structured in an easy-to-understand manner by combining various cases with issues that frequently occur in the field.

This is designed for practitioners in both public and private sectors who handle urban planning, development activities, maintenance projects, and licensing work to systematically understand the provisions of the National Land Planning Act and apply them in practice.

We aim to improve the Personal Skills and Work Skills of key talent. We provide solutions for growing into key talent, including fostering creativity and thinking skills, methods to enhance interpersonal relationship skills, and followership.

We provide you with comprehensive information on everything needed to manage partner companies. You can learn logical and rational selection and evaluation methods for partner companies, as well as various management techniques to ensure manufacturing quality from partner companies. Additionally, we help you improve your ability to systematically manage partner companies and maintain partnership relationships with them.

A class on analyzing customer/sales data with Excel, even without R or Python!

We aim to enhance business skills by using Excel, a core tool, to improve work efficiency and enable differentiated form creation. This goes beyond simple formula-based Excel use, teaching how to easily, professionally, and efficiently produce necessary business forms.

Are you wondering which tool to use for data analysis? Get started easily with Excel!

Now you can use Python in Excel! A light lecture to try out the latest features!

In just one hour a day for three days, you will learn the most important and frequently used parts that will allow you to fully master the basics of Excel.

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

Data-based decision-making ability, an essential competency in the era of digital transformation! As companies rush to find talent with digital capabilities, develop BA capabilities to successfully solve organizational problems through this course!

Forget boring theories! We're going straight into practice from the beginning of the lecture. Once you start, you'll be captivated by the charm of Excel Macro VBA that you won't be able to stop~!

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)