Excel 2019: Learn through Practice

This course is designed to provide step-by-step learning from the basic concepts of database systems to the utilization of Relational Database Management Systems (RDBMS) and SQL. Learners will understand the principles of databases and be able to create systematic data structures through data modeling and design methods. Additionally, they will experience actual data processing by practicing data manipulation and management techniques using SQL. Through this course, students can go beyond simple theoretical learning to build a foundation that can be utilized for both practical work and certification exam preparation by acquiring efficient data management and application skills.

This course is designed to help you learn fundamental algorithm concepts through JAVA programming. Rather than stopping at theoretical explanations, it is structured to allow natural understanding by directly implementing various algorithms in code. Students will learn progressively from basic sorting and search algorithms to more challenging algorithms, developing both problem-solving abilities and programming thinking skills. Additionally, by integrating JAVA language syntax and usage methods through hands-on practice, you can master both algorithm theory and actual implementation simultaneously. Through this course, learners will not only establish an understanding of algorithms but also acquire algorithm implementation capabilities using JAVA, securing practical programming skills that can be utilized in academics, employment, and professional work.

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 a course for learning the overall usage of Notion, an all-in-one productivity tool that enables efficient management of work and life in a Mac environment. You can learn step-by-step from Notion's basic functions to databases, automation, AI utilization, and practical template creation, acquiring work and self-management methods optimized for Mac users. Through a hands-on curriculum, you can increase productivity in both daily life and work."

This course is a video tutorial on creating a TodoList app using only questions with the Cursor AI artificial intelligence tool.

This course is an introductory program where you can systematically learn web standard coding methods. Learners will acquire fundamental knowledge necessary for web development and build a foundation for developing actual web programs based on this knowledge. Additionally, through coding methods that comply with web standards, you can aim to obtain certifications. It provides an opportunity to solidly prepare from the basics of web development to practical application.

This course provides foundational knowledge for learning and utilizing web standard coding. Learners can understand the basic principles of web coding and build the foundation necessary for learning web programming based on this understanding. Additionally, the course is structured to enable certification acquisition through web standard coding.

This course is a hands-on program where you learn the core syntax and applications of frontend web programming and apply them to actual portfolio creation. Learners will progressively master everything from basic syntax of HTML, CSS, and JavaScript to the latest frontend technologies, directly experiencing the process of implementing web interfaces and handling dynamic functionality. Additionally, through various examples frequently used in practice, you can naturally acquire efficient coding techniques and real development workflows. Through this course, learners can go beyond simple syntax memorization to understand the connected workflow from web page planning–design–implementation, and based on this, complete their own portfolio. Furthermore, this course will serve as a solid stepping stone for growing into a frontend developer, providing great help as an introductory course for learners new to web development and as a practical supplementary course for those wanting to build hands-on experience.

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

Through this course, you can study short answer and descriptive questions from past practical exams for the Information Security Engineer.

This is a Photoshop course for beginners that will teach you the most basic and important functions of the graphic editing tool Photoshop.

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

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

This course covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

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

In this course, you will learn how to use basic commands for 3D modeling in Inventor. Learn which modeling methods are used in various cases through hands-on practice!

In this course, you will learn how to use basic commands for 2D drawings in AutoCAD 2022.

1. Learn the main functions of Excel so you can create documents easily and quickly. 2. Learn tips commonly used in practice.

There are many things that are happening through non-face-to-face methods, such as non-face-to-face work, non-face-to-face services, and non-face-to-face meetings. In order to continue business, meetings must continue. If you have done seminars/broadcasts through Live Events, this lecture will now teach you how to conduct online video or audio conferences through Teams Meeting.

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

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

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

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.

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.

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 the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

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)

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.

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.

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

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

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!