컴퓨터활용능력 1,2급 필기 - 스프레드시트 일반

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 is a hands-on course where you'll build an AI-based autonomous driving car using Raspberry Pi and various sensors.

Python with easy and intuitive grammar! Learn Python, a renowned introductory programming language, from the basics to practice! In this lecture, you will learn Python functions and lists.

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

Python with easy and intuitive grammar! Learn Python, a renowned introductory programming language, from the basics to practice! In this course, you will learn object-oriented programming.

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

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

"This is a course for learning the comprehensive 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 creating practical templates, 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 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 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 course covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

This is an intermediate course that teaches you about JavaScript and jQuery through theory and practice. It consists of content that can be applied to practical work based on basic concepts of HTML, CSS, and JS. Part. 1 covers the Document Object Model (DOM), basic concepts of jQuery, finding, creating, adding, deleting, and moving nodes.

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

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.

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.

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)

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. This course is designed to meet the examination criteria for obtaining a computer proficiency certificate. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate.

For those who have difficulty with PowerPoint, we will deliver only the essentials that you need to know in the shortest possible time. For those who want to practice PowerPoint or simply decorate documents using PowerPoint, we recommend Mr. Park's lecture. Based on the know-how accumulated through many years of lectures, we will cover only the essentials of PowerPoint.

Anyone who needs Excel can learn, and it's a course covering everything from beginner to practical application. You can learn regardless of the Excel version.

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

A lecture for those who don't know much about computers but want to learn Excel! We'll teach you 10 essential functions in an easy-to-understand manner.

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!

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

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.

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

This is a national technical qualification related to general computers and spreadsheets hosted by the Korea Chamber of Commerce and Industry.

In the basic course, you will learn how to use Power Automate Desktop and become familiar with it by following along. Now, in the essential course, you will learn about variables and frequently used grammar so that you can use it better and automate more.

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.

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

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

The 🔥 HOT recruitment keyword in the digital transformation era, "digital competency", is what Masocampus has prepared! A gem-like lecture that will help you develop data-based performance improvement capabilities using only Excel 🎁 (After taking the course, become a key talent for your company 😉)

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

You know the importance of 🔥Big Data🔥 in your business, but you gave up on data analysis tools with difficult names like Python, R, SQL... before you even started? Don't worry anymore 😉 A beginner's course that teaches anyone how to analyze data and discover valuable insights using Excel, which is highly accessible!🎁

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.