Automating VBA tasks using Excel

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.

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

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!

If you have completed the basic and essential lectures to understand Power Automate Desktop, now you will learn the most frequently used Excel automation flow in your work through hands-on practice so that you can automate more in your actual work.

This course is for those who want to create charts more effectively. It introduces how to use various functions and form controls on the chart object to utilize charts more effectively.

Python + xlwings Work Automation Course Summary 1. Basic Section: Excel Control Fundamentals Cell Handling / Format Application / Image & Chart Insertion 2. Application Section: Automation Scenarios Automatic Email Sending / Report Summary Automation (LLM) / Image Classification Tasks (Teachable Machine)

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.

Stop messy and complicated data! 💥 Now organize your data clearly in Excel and become a professional worker 😉

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)

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

Are you wondering which tool to use for data analysis? Get started easily with 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, 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.

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

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.

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

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.

Even if you don't know coding, you can read data - everything about no-code AI analysis that makes perfect sense! If you can use Excel, PPT, and Google Sheets, AI will now handle data analysis for you.