엑셀을 활용한 VBA 업무 자동화

Using pandas, we will learn data processing patterns that frequently appear in real-world situations and analyze the processed data.

You can call, analyze, and visualize data from public data. You can learn how to collect transaction information on all green onions traded in the wholesale market from public data and perform data preprocessing, data analysis, and data visualization.

Learn about Python and how to automatically collect Naver news titles and stock data from Naver Finance using Python. The library I mainly use is BeautifulSoup.

Building and Refactoring Spring Framework with IntelliJ Gradle Building a Spring Framework development environment and applying the build!

Learn how to dramatically boost work productivity by automating the most frequently used MS Office tasks in your work using chatGPT.

From basic functions to high-level practical documents used in the field, to new features exclusive to Excel 2016! Give wings to your documents with Excel 2016!

Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work settings to learn which functions to apply in each situation to perform tasks most quickly and efficiently.

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.

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

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.

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

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Written - Spreadsheet General (2021 Revised))

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Practical - Spreadsheet Practice (2021 Revised))

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!

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!

First in Korea! A course on automating Word business documents with ChatGPT. Easily create various questionnaires, work reports, meeting minutes, and contracts, then immediately apply them to your work through hands-on 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.

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