최반장의 엑셀 피벗테이블 마스터 클래스

This course will teach you the functions and correct usage of the main functions that are mainly used in business. You can use the function alone or use multiple functions in a nested manner to increase the efficiency of your work.

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

Learn Excel most efficiently in a short period of time by creating an Excel report used at work in a project format.

This is an in-depth course on Microsoft Power BI that allows you to analyze and explore data more effectively by applying various visualization techniques. Through this course, you can learn how to connect various data sources, refresh data in the way you want, and learn various data preprocessing methods to edit data in a form suitable for analysis.

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.

Data-based decision-making ability, an essential competency in the era of digital transformation! As companies rush to find talent with digital capabilities, develop BA capabilities to successfully solve organizational problems through this course!

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.

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!

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.

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.

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#

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)

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

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.

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.

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)

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!

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