Chief Choi's Excel Pivot Table Master Class

A practical tip encyclopedia that collects Excel tips that are easy and delicious to use one by one

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.

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!

You use 'pivot tables' a lot for data analysis, right? However, Excel provides various analysis tasks that are suitable for the situation in addition to pivot tables. In this lecture, we will organize Excel analysis tasks in 10 ways (sorting, subtotals, pivot tables, pivot charts, target value search, data tables, scenario managers, integration, advanced filters, conditional formatting)

Let's implement a deep learning framework directly with Excel! Let's solve supervised learning/unsupervised learning/reinforcement learning with the implemented framework!

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

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.

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#

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

Forget boring theories! We're going straight into practice from the beginning of the lecture. Once you start, you'll be captivated by the charm of Excel Macro VBA that you won't be able to stop~!

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

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