Star Instructor Teacher Choi's 3-Week ITQ Excel Course

This is a course for the 'Coding Ability Master Level 2' certification hosted by the Korea Information and Communications Association. It is highly recommended for those who want to learn coding without difficulty and obtain a certification! ^^

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.

I will show you how to use Excel effectively in your work and how to create data that is easy to analyze.

Anyone who needs Excel can learn, and it's a course covering everything from beginner to practical application. You can learn regardless of the Excel version.

For those who have difficulty with Excel, we deliver only the essentials that you need to know in the shortest time possible. And, the effect of killing two birds with one stone until obtaining a certificate. Take this opportunity to gain Excel practice and a certificate. Unlike other OA programs, Excel has many complicated parts in terms of functions and utilization. Based on the know-how accumulated through long lectures, we only cover the essentials of Excel. In relation to practical use, you can improve your Excel practical skills in a short period of time and obtain the ITQ Excel certificate, which is highly useful in practice, at the same time.

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.

We take a practical and easy approach to cost accounting and business analysis—topics that often feel difficult—by utilizing Excel. This course covers the following topics: - From Cost Accounting Basics to Practice: Step-by-step learning from cost concepts to standard costing, actual costing, and overhead allocation. - Understanding Financial Statements and Accounting Flows: From manufacturing cost flows to accounting treatments and the financial statement preparation process. - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product. - Analyzing Business Indicators with Excel: Hands-on practice with break-even point (BEP) analysis and financial ratio analysis. - Management Decision-Making Based on Managerial Accounting: Hands-on practice with short-term/long-term business planning and feasibility analysis.

We'll take a very practical and easy approach to cost accounting and management analysis using Excel, which you may have found difficult before. This course covers the following topics: - Cost Accounting from Basics to Practice: Step-by-step learning from cost concepts, standard costs, actual costs, to indirect cost allocation - Understanding Financial Statements and Accounting Flow: From manufacturing cost flow to accounting treatment and financial statement generation process - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product - Analyzing Management Indicators with Excel: Break-even point analysis and financial ratio analysis practice - Management Decision-Making Based on Management Accounting: Short-term/long-term business planning and business feasibility analysis 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. :)

This course is designed to help you learn various functions needed for presentation creation using the Han Show program, and develop practical skills applicable to both work and exams. It goes beyond simply acquiring design functions to cultivate logical thinking and problem-solving abilities, helping you create systematic and persuasive presentation materials. In particular, this course is designed with a curriculum optimized for the ITQ exam, making it effective for exam preparation. Learners can systematically study core presentation functions such as slide creation, utilizing shapes, images, tables, and charts, animations and transition effects, and develop practical skills by solving problems similar to actual exams. Through this, students will not only acquire ITQ certification but also simultaneously secure presentation creation abilities and application skills that can be immediately utilized in work environments.

Learn the core functions of SPSS in a short period to pass the Social Survey Analyst Level 2 practical exam. Master SPSS know-how along with problem-solving techniques—ranging from data entry to descriptive statistics, cross-tabulation, t-tests, ANOVA, and correlation/regression analysis—to perfectly prepare for the practical exam.

How did Assistant Manager Kim, who worked overtime every day, become a "leave-on-time pro" in just 1 hour? The secret to reclaiming your "clock-out time" Staying up all night because an Excel formula broke, or having an entire report ruined by a single typo—every office worker has experienced this at least once, right? This course was designed to put an end to that "recurring pain." You don't need to memorize complex coding syntax. We utilize Cursor AI, an AI-powered tool that writes code based on text commands, and Streamlit, which allows anyone to easily create websites. I have captured the entire process of solving the "pain points" I personally faced in the field—such as merging files by branch, automatically classifying items for repair, and generating infinite PDF certificates—all by "conversing" with AI without typing a single line of Python code yourself. By the end of this course, you will be reborn not as a mere office worker, but as a "Digital Transformation Expert" who revolutionizes your team's work efficiency.

Don't learn Excel the hard way. The questions that appear on the ITQ exam are already predetermined. With the 'guaranteed exam formulas' extracted from 25 years of teaching big data, we guide you on the fastest shortcut to achieving an A grade in just 2 weeks, even with no prior experience.

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)

Even complex data becomes clear at a glance with Tableau! From a single drag to a finished dashboard, master data visualization for real-world business.

Even if you don't know coding, you can read data—everything about no-code AI analysis that makes work sense explode! From marketing to HR and quality management—we'll make your work sense explode with AI.

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!

This is a practice-oriented course designed to increase work efficiency by automating repetitive Excel tasks with Python. You will learn how to automate the entire workflow—from opening files to data processing, inspection, consolidation, and saving—and will also be provided with practical automation code using pywin32.

Data-driven decision-making, an essential skill in the era of digital transformation! As companies are going all out to find talent with digital capabilities, develop your BA skills to successfully solve organizational problems through this course!

Data visualization is an essential skill for effectively communicating data and supporting decision-making. This course is designed for beginners learning Tableau for the first time, offering a practice-oriented curriculum that covers everything from basic data visualization concepts to creating various charts and data analysis techniques. Through this course, you will gain hands-on experience with frequently used practical features, including Tableau installation, data connection, creating various charts, calculated fields, trend lines, box plots, histograms, and highlight tables. In addition, you will learn core concepts necessary for data analysis, such as data literacy, data visualization strategies, correlation analysis, and outlier analysis. Even complex functions are explained step-by-step at a beginner's level, allowing those new to Tableau to follow along without any pressure.

We approach cost accounting and management analysis, which you may have found difficult, in a very practical and easy way using Excel. This course covers the following topics: - Cost Calculation from Basics to Practice: Step-by-step learning from cost concepts, standard costs, actual costs, to indirect cost allocation - Understanding Financial Statements and Accounting Flow: From manufacturing cost flow to accounting processing and financial statement creation process - Strategic Pricing Methods: Pricing strategies by market type and profitability analysis by product - Analyzing Management Indicators with Excel: Break-even point analysis and financial ratio analysis practice - Management Decision-Making Based on Management Accounting: Short-term/medium-to-long-term business planning and business feasibility analysis practice