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 there is an attachment in an email, save it to OneDrive! If someone uploads a file to the team site, get an email notification! If there is an email from a VIP customer, get a notification! Learn how to automatically do these repetitive tasks without you having to do them yourself.

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

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!

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.

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.

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

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

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!

Now you can use Python in Excel! A light lecture to try out the latest features!

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

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.

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

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

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

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