[엑셀 2013] 비즈니스 엑셀 Basic

To build precise cost accounting knowledge and practical skills, this course covers core costing principles including calculation and reporting, structured with case studies for direct real-world use.

We'll cover the most fundamental core principles of using Excel as a business tool. We'll teach you various Excel elements from the principles of Excel calculations to functions, formulas, aggregation, and filter utilization. The content is structured around how to construct formulas, understanding functions at the center of formulas, and methods for utilizing aggregation and filter features.

We have systematically organized inventory/material management techniques, resolved data duplication and errors, and established a foundation for effective MRP system operation. Through this, you will acquire the know-how to respond to demand and supply volatility and develop capabilities for effective inventory management execution and operational strategies.

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.

To enable office workers to actively and effectively use AI in their work, we provide various techniques for reducing 'Hallucination' (i.e., nonsensical) answers and accurately eliciting desired responses.

It is structured around practical guidelines for HR and labor managers, covering human resources, labor, wage, industrial accident, retirement, and employment management. Additionally, it offers solutions to various HR and labor legal issues frequently encountered in businesses, integrating diverse cases and precedents.

The content has been structured to be applicable in practice by integrating the internal audit planning process and audit points for each department in the field with various case studies.

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.

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.

This course is designed to be easily understandable with various case studies covering quality strategy development, implementation, and goal monitoring techniques to achieve quality objectives under established quality policies. Additionally, it presents methods for recognizing and evaluating quality issues by converting them into monetary units, which are common management metrics, and is a process that can measure the accurate performance of current quality management systems through the introduction and operation of quality costs, while developing systematic and continuous quality cost management capabilities.

We will introduce the concept of Statistical Process Control (SPC) as a scientific approach for quality improvement and data literacy. Additionally, we have structured this content by integrating data-driven Quality Control (QC) techniques and application methods for reducing process variation with various case studies.

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.

You can understand the difference between adjusting entries and closing entries, verify the closing procedures for each account, and communicate accounting information through financial statements.

We have structured the content so that you can understand everything from the complex and confusing concepts of chart of accounts to their practical application all at once. For the convenience of managers and practitioners, we have created a table of contents that allows you to find chart of accounts based solely on transaction details, and we systematically include not only chart of accounts considering various industries but also journal entry methods, so any company can apply them to suit their own circumstances.

We have presented key credit analysis checklists related to business feasibility review by integrating them with various case studies. Additionally, we have explained the credit analysis methodologies that Credit Analysts use in practice to enhance their applicability in the field.

We'll cover the most fundamental core principles of using Excel as a business tool. We'll teach you various Excel elements from the principles of Excel calculations to functions, formulas, aggregation, and filter utilization. The content is structured around how to construct formulas, understanding functions at the center of formulas, and methods for utilizing aggregation and filter features.

Through Edupick lectures, students are expected to be able to build a solid foundation in Excel.

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

We will practice automating repetitive tasks using Power Automate Desktop, a free RPA tool from MS. Through this process, we will learn to understand automation and apply it to our actual work.

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

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

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

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

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. :)

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!

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

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)

AI Excel that automates perfectly for your work without company security concerns. From data preprocessing to visualization in just a few minutes, no coding knowledge required!

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.

In the [Beginner's] Data Visualization with Power BI course, you will learn how to edit data using the query editor, visualize data using various tools, and check and share the analyzed results.

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)

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided