취업 준비를 위한 OA (Excel) 실무 2023 Part. 1

This course is designed to teach the entire process of 'AI Training Data Construction,' which is essential for successfully executing AI modeling projects. Learners will not simply remain at the theoretical knowledge level, but will experience step-by-step the data construction processes required in actual practice. Specifically, the course covers the entire process from AI training data planning → acquisition → storage → preprocessing → labeling → pseudonymization and transformation through hands-on practice, structured to develop practical skills that can be immediately applied in the field. Additionally, learners will systematically study the most important data management capabilities in AI projects, such as data quality management and security issues, personal information de-identification processing, and dataset optimization. Through this, learners can grow from simple data collectors into data specialists who can proactively plan and execute AI projects. 👉 Through this course, learners will understand how to construct high-quality training data that determines AI model performance and acquire practical capabilities to effectively apply this in real work environments.

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

This course will teach you how to create an EPUB format e-book using Sigil and learn various techniques required for creating e-books.

This course is designed to learn the JavaScript programming language along with the latest ES6 grammar.

This course is designed to learn the fundamental theories and practical processes necessary for applying AI modeling and service planning to real-world work environments. Learners can acquire essential foundational knowledge to skillfully perform AI modeling projects and experience various practical procedures used in actual business settings. The course is specifically structured to provide step-by-step learning of the entire workflow from AI service environment analysis → goal setting → requirements analysis → service model design → scenario planning → utilization planning → execution plan development → performance evaluation planning. Through this approach, learners can develop systematic thinking and practical application skills for how to introduce and utilize AI from business and service planning perspectives, rather than limiting themselves to purely technical learning. Upon completing this course, learners will understand the overall planning and execution process of AI projects and will be able to strengthen their capabilities as AI service planners, PMs, and data-driven strategists in actual corporate environments.

This course is a hands-on lecture that covers learning the basic usage of the Cursor AI artificial intelligence tool and applying it to actual website development. Learners will understand AI-based development environments and experience code writing and automation features using Cursor. The course is structured not just to learn the tool's functions, but to develop practical skills through actual website development projects. Additionally, the course covers basic elements frequently used in website development such as HTML, CSS, and JavaScript, along with efficient development methods utilizing AI assistance features, making it easy for beginners to follow along. Upon completing this course, learners will gain the ability to quickly implement ideas and complete websites using Cursor AI, which will serve as a great first step in adapting to modern development environments.

This course is an advanced program that provides in-depth coverage of C# multithreading and asynchronous programming, systematically designed to help you learn concurrency handling techniques frequently used in real-world applications. First, you'll understand the basic concepts of threads and practice creating and managing threads, learning to precisely control thread states and behaviors through various thread methods, ThreadState enumeration, and Flags properties. Next, you'll practice the differences and use cases between **Interrupt() and Abort()**, and learn how to reliably implement thread synchronization using **lock keywords and Monitor class (Enter, Exit, Wait, Pulse)**. Additionally, you'll cover asynchronous programming techniques essential in modern development environments, practicing parallel programming using Task and Task<TResult> classes, and the Parallel class. Finally, through async/await keywords, you'll understand the differences between synchronous and asynchronous code and gain experience applying more efficient asynchronous processing methods to projects. Through this course, learners will acquire the ability to develop high-performance applications using multithreading and asynchronous programming, and gain confidence in solving concurrency issues and implementing efficient programs in real-world scenarios.

Learn various know-hows that will help you get the most out of Excel in your real work.

This course focuses on learning the fundamental concepts of algorithms using the JAVA language, with an emphasis on simultaneously developing programming thinking skills and problem-solving abilities. Additionally, it systematically covers the large-scale application development procedures used in corporate environments, allowing students to learn the analysis and design processes required in practical work. Through this, learners can go beyond simple coding abilities to become familiar with the overall system analysis and design process and strengthen their practical application skills. By learning step-by-step from basics to practical procedures through this course, students can build a foundation for growing into developers, system engineers, and IT planners.

This course is designed to simultaneously develop both fundamental theory and practical application skills needed to proficiently execute AI modeling projects in real-world settings. Learners will understand the overall flow of AI projects and experience step-by-step processes through hands-on practice: problem definition → model design → data acquisition and preprocessing → feature extraction → model training and validation. Additionally, by learning how to select and manage optimal AI models in various situations, learners can build practical AI capabilities that can be applied to actual business environments. Through this course, learners can systematically understand the entire AI modeling project process and strengthen their data-driven problem-solving abilities based on this foundation.

This course is a step-by-step learning program that covers network programming from fundamentals to hands-on practice. First, we examine the origins and development of the Internet to understand how today's network environment was formed. Next, we learn the structure and operating principles of the TCP/IP protocol, which is the core of networking, to build a theoretical foundation. In the practical stage, we implement actual network communication using the Socket class, TcpListener, and TcpClient classes provided by C#, and experience client-server architecture. Through this, you can understand the actual data transmission and reception process and network connection procedures beyond simple theory. Finally, we visually implement network programs by creating user interfaces (UI) using WinForm. We practice enabling connection, message transmission, and reception through button clicks, developing the ability to create network application programs that can be utilized in real-world environments.

This course is a lecture that teaches C# Windows Forms (WinForm) application development step by step from basics to hands-on practice. First, you will understand how Windows Forms applications work and learn the structure and usage of WinForm classes and Application classes. Through this, you will become familiar with the execution flow of applications and build a foundation through actual code practice. In the following lessons, you will design forms using the form designer tool and implement **user interfaces (UI) utilizing various controls** such as buttons, text boxes, and labels. Rather than stopping at simple UI composition, you will develop the ability to create programs applicable in real work by adding event handling and interactive features. Additionally, you will practice asynchronous task processing methods in the WinForm environment and learn techniques to simultaneously improve application performance and user experience. Through this course, learners can solidly build the fundamentals of desktop application development in Windows environments and acquire WinForm programming capabilities applicable to real work.

Introduces the workflow integration between After Effects CC 2017 and CINEMA 4D and learn related features.

Django is a Python-based web application framework. In Part 1, you will learn about Django and create web applications.

This course is designed to learn how to efficiently manage and utilize file and directory information in C#. It focuses on file input/output processing, directory navigation, stream utilization, and understanding the Position property that are frequently required in practical development environments, and you will learn safe resource management methods through using statements through hands-on practice. Additionally, you will learn input/output methods for binary files and text files to handle various types of data, and by understanding the process of object serialization and deserialization, you will learn how to easily save or load C# objects to files. The goal is to develop the ability to immediately apply file input/output and serialization-related functions in actual development environments through practical projects as well as theoretical learning.

In this course, you will learn in-depth and practical use of 2D drawing in AutoCAD 2022.

This course will help those who have never worked with 3D graphics before to get started with basic 3D work concepts using Cinema 4D software. You will learn how to operate the basic interface, and the most basic concepts and overall workflow of modeling, rendering, and animation.

Learn the basic functions of Hancom Office Hangul (Hangul), which is most commonly used in practice.

This course is a learning process for database programming by integrating C# and MySQL. Learners will understand how to connect MySQL databases with C# applications and develop database utilization skills through actual projects. First, you'll learn the basic concepts and usage of **SQL commands (DDL, DML, DCL)** provided by MySQL, and practice data definition, manipulation, and control directly. Then, you'll learn step-by-step how to integrate with databases in the C# environment and apply functions frequently used in practical development. Additionally, through the process of implementing a membership registration project using WinForm, you'll directly experience core database integration functions such as data input, storage, and retrieval. Through this process, learners can systematically acquire practical skills for designing and implementing database-based application programs.

Learn the basics of using AutoCAD and the basic functions for 2D CAD work.

Learn how to use office programs (Excel) required by business practitioners and acquire work processing skills suitable for the work environment.

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)

"Computer Proficiency Level 2 Practical Test, Master Excel in One Month!" This course is designed to allow you to easily and systematically learn all the essential content for the Computer Proficiency Level 2 practical test, focusing on Excel. You can quickly acquire the skills to pass through key functions immediately applicable in practice and practical problem-solving processes. Key Features: From Basics to Core: Complete coverage from basic Excel usage to key functions tested in the practical exam Practical Problem Solving: Reflects the latest test trends, learn by selecting high-frequency problems Maximizing Efficiency: Learn only essential functions intensively to save time Kind Description: Structure makes it easy for even beginners unfamiliar with computers to follow Do you want to finish preparing for the Computer Proficiency Level 2 practical test within a month? With this course, passing is definitely not difficult! 😊

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~!

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)

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

If you are a job seeker who needs to study for the Level 2 Computer Skills Practical Test and want to obtain the practical qualification as quickly as possible, I will help you pass the Level 2 Computer Skills Practical Test in just 5 days!

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

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.

You still haven't started studying data analysis...? Are you... what? 😦 Now, data analysis is not a choice but a necessity! Master data analysis with Masocampus lectures and live a new life!

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

This is not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.

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

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

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