OA (Excel) Practice for Job Preparation 2023 Part. 2

This is a series of video lectures for AWS beginners and college students enrolled in AWS Educate. We will briefly introduce the AWS registration process and free tier services.

Notion's powerful and convenient database features allow even beginners to easily build a DB. In this course, you will learn about database concepts and related terms (tables, rows, columns, etc.), as well as the basic usage of the Notion database.

Learn the latest features of InDesign CC.

This course teaches you how to write safe and reliable code in the software development process. Rather than simply stopping at feature implementation, you'll learn programming principles and techniques that can prevent security vulnerabilities and ensure stability. Through hands-on practice and case studies, you can understand security threats that may occur in real development environments and acquire safe coding techniques such as coding rules, input validation, exception handling, and memory management to prevent them. By taking this course, developers will enhance the completeness of their code while gaining practical capabilities to develop software with security and reliability.

This is a basic C++ course for those who are new to C++ programming. You will learn and practice how to utilize C++ along with an overview of programming and the basic grammar of C++.

This is a hands-on course where you'll build an AI-based autonomous driving car using Raspberry Pi and various sensors.

This course is an advanced program that delves deeply into C# multi-threading and asynchronous programming, structured to help you systematically learn concurrency handling techniques frequently used in practice. First, you will understand the basic concepts of threads and practice how to create and manage them. You will learn how to finely control thread states and behaviors through various thread methods, the ThreadState enumeration, and Flags attributes. Next, you will practice the differences and use cases of **Interrupt() and Abort()**, and learn how to reliably implement synchronization between threads using the **lock keyword and the Monitor class (Enter, Exit, Wait, Pulse)**. Furthermore, the course covers asynchronous programming techniques essential in modern development environments, including hands-on practice with parallel programming using the Task and Task<TResult> classes, as well as the Parallel class. Finally, through the async/await keywords, you will understand the differences between synchronous and asynchronous code and gain experience applying more efficient asynchronous processing methods to projects. Through this lecture, learners will acquire the ability to develop high-performance applications using multi-threading and asynchronous programming, gaining confidence in solving concurrency issues and implementing efficient programs in real-world scenarios.

This course is a practical-focused program that covers the comprehensive utilization of **Google Sheets, the most widely used spreadsheet program in the world**. Starting with basic functions such as fundamental input, formatting, and cell management that even first-time users can easily follow, the course progressively advances to professional features including advanced function utilization, data analysis and visualization, conditional formatting, and pivot tables through step-by-step learning. Additionally, by focusing intensively on Google Sheets' unique strengths of real-time collaboration tools and cloud-based sharing features, learners can experience an efficient work environment where multiple people can simultaneously create, edit, and review documents. Through this course, learners can go beyond simple spreadsheet usage to simultaneously strengthen their data-driven decision-making abilities and collaboration capabilities, significantly improving work productivity.

This is an introductory course on 3D graphics modeling using the 3D modeling software Autodesk Maya. The course consists of four parts, and in this section, we will start with tool installation and learn the basic functions of Maya.

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.

This is a course to learn in various languages how to call various open data provided by the public data portal from various programming languages and how to use JSON data provided as a result of the call.

This is a course to learn in various languages how to call various open data provided by the public data portal from various programming languages and how to use JSON data provided as a result of the call.

This is a basic machine learning course that briefly covers the basic machine learning theory for those who are new to machine learning.

This is an introductory 3D graphics modeling course using the 3D modeling software Autodesk Maya. The course consists of four parts in total, and this specific session focuses intensively on animation techniques using Maya.

This course is designed to help office workers and practitioners utilize office programs more proficiently. Rather than simply learning the functions, the learning process focuses on real-world business scenarios such as document creation, data management, and presentation production. Through this course, students will systematically learn everything from the basics to the practical application of office programs like Word, Excel, and PowerPoint, naturally acquiring the skills to apply various functions to their specific tasks. This will help increase the efficiency of simple repetitive tasks and further strengthen practical competencies such as report writing and data analysis. In short, this course is a practical learning program that provides productivity-enhancing skills that can be applied immediately in the field, not only for beginners new to office programs but also for professionals who already have experience using them.

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.

This tutorial will show you how to use Bootstrap to create responsive web pages that change layout depending on the device.

This course is designed to provide basic knowledge for those who are interested in mechanical drawing and design, those who are aiming to obtain qualifications in the field, those who wish to advance into a related field, or those who wish to improve their expertise.

When you want to try using Figma, a UI design authoring tool, or when you want to create something with Figma, you'll practice the most basic usage methods.

Through this lecture, you will be able to skillfully utilize Excel functions in real-life situations. You will learn how to use the office program (Excel) required by business practitioners and acquire the ability to process work appropriate to the work environment.

You can meet Excel as a data analysis tool that can add value to your work. This is a basic Excel course that teaches concepts in a broad and thorough manner from the basics.

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)

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.

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!

The HOT recruitment keyword in the era of digital transformation: "Digital Competency." That’s why Micro Campus has prepared this! A gem of a lecture that builds data-driven performance improvement skills using only Excel 🎁 (Become a core talent of your company after taking this course 😉)

This covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn how to create Excel formulas needed for practical work, easily understand Excel functions, and even write macros and VBA coding using ChatGPT.

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)

How did Assistant Manager Kim, who worked overtime every day, become a "leave-on-time pro" in just 1 hour? The secret to reclaiming your "clock-out time" Staying up all night because an Excel formula broke, or having an entire report ruined by a single typo—every office worker has experienced this at least once, right? This course was designed to put an end to that "recurring pain." You don't need to memorize complex coding syntax. We utilize Cursor AI, an AI-powered tool that writes code based on text commands, and Streamlit, which allows anyone to easily create websites. I have captured the entire process of solving the "pain points" I personally faced in the field—such as merging files by branch, automatically classifying items for repair, and generating infinite PDF certificates—all by "conversing" with AI without typing a single line of Python code yourself. By the end of this course, you will be reborn not as a mere office worker, but as a "Digital Transformation Expert" who revolutionizes your team's work efficiency.

Data-driven decision-making, an essential skill in the era of digital transformation! As companies are going all out to find talent with digital capabilities, develop your BA skills to successfully solve organizational problems through this course!

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

You still haven't started studying data analysis...? Do you... think you're something special? 😦 Data analysis is no longer an option, it's a must! Master data analysis with Microsoft Campus lectures and start living your best life!

AI Excel that automates perfectly for your tasks without any company security concerns. From data preprocessing to visualization, everything is OK in just a few minutes—without any coding knowledge!

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.

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!

Through this course, you can obtain information related to thin film deposition process technology and process development! For process technology and process development engineers, it's important to know not only about processes but also about equipment. In this course, I will share an introduction to equipment and my personal work experience. Make sure to actively utilize the content of this course by incorporating it into your cover letter & resume!!

This is a practice-oriented course designed to increase work efficiency by automating repetitive Excel tasks with Python. You will learn how to automate the entire workflow—from opening files to data processing, inspection, consolidation, and saving—and will also be provided with practical automation code using pywin32.

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