[Star Instructor Teacher Choi] The Standard for Passing Quickly｜ITQ Excel Master

Using the Hangul NEO program, you can learn everything from the basics of document writing to practical use and even obtain certification all at once! I can confidently say that those who lack the basics and want to write documents in the field can obtain certification and write documents through this course.

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.

Use AI to build your own Excel macro-based stock analysis program. You will practice step by step how to retrieve data from the internet based on a stock ticker and date range, then record and organize the JSON data in an Excel sheet. Along with price changes, moving averages, trading volume, and changes in financial performance, you will analyze period returns, volatility, and maximum drawdown, completing everything from an individual stock analysis screen to a comprehensive dashboard for comparing multiple stocks of interest.

When you need a technology solution that keeps your workforce connected and engaged, learn how Microsoft Stream can help you securely manage and conveniently share all of your company’s video content, giving every employee access to the information that matters to them.

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)

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

Your document writing skills will improve, allowing you to create a variety of documents and increase the efficiency of document-related work. In addition, you can obtain the ITQ Korean certification by investing about 4 hours!

Are you still using Google Sheets simply like Excel? If you use Google Sheets properly, you can significantly reduce the time spent on collecting data through copy-pasting, getting confused by the latest files, and fixing formula errors. Try automatically operating reports and dashboards that are always up-to-date based on real-time data connections.

Are you wondering which tool to use for data analysis? Get started easily with Excel!

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.

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

Data is piling up, but are you feeling lost about who to target? Find your key customers through data summarization and design the optimal targeting logic.

Efficiently tackle the typical office tasks that keep employees working late—such as recurring monthly report writing and large-scale data organization—with the AI assistant Claude. Learn practical techniques for freely designing and enhancing long-form text visualizations and slides while preserving the unique formatting and layout of your company’s templates. Through this process, you can perfectly complete the manual documents that accumulate over time within the allotted deadline.

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

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

Artificial Intelligence is transforming the way professionals work with data. Microsoft Copilot in Excel allows you to analyze, clean, format, automate, and optimize spreadsheets faster than ever before. But using Copilot effectively requires more than just typing prompts — it requires understanding Excel fundamentals, structured thinking, and prompt engineering. This course gives you exactly that. You will learn how to combine Excel expertise with AI-powered automation to dramatically improve productivity, accuracy, and workflow efficiency. What You Will Gain From This Course • Save hours every week using AI-driven Excel automation • Analyze large datasets in seconds using Copilot • Clean and fix messy data effortlessly • Write powerful formulas with AI assistance • Master prompt engineering for Excel Copilot • Build professional reports and dashboards faster • Improve decision-making with AI-powered insights • Optimize workflows for real-world business scenarios By the end of this course, you will not just “use” Copilot — you will control it. What This Course Covers Foundations What is Microsoft Copilot How to activate and use Copilot in Excel Introduction to Excel basics and navigation Data types and conversions Data entry and validation techniques Excel Core Skills Mathematical, logical, and time functions Nested functions for complex calculations Combining logical and LOOKUP functions Conditional statements and formatting Pivot tables and advanced formatting Data Analysis with Copilot Data general analysis and Q&A Sorting, filtering, and profiling data Handling and fixing missing data Identifying and correcting common data errors Transposing data for trend analysis Date-time formatting techniques AI-Powered Excel Automation Generating synthetic data Adding formula columns with Copilot Subtotals and advanced calculations Optimizing workflows using Copilot Enhancing data presentation Editing spreadsheets intelligently Prompt Engineering for Excel Copilot Writing effective prompts Advanced prompt engineering techniques Evaluating prompt performance Optimizing prompts for better results Customizing Copilot for improved outcomes Real-World Application Creating a travel budget using Copilot Practical exercises and activities Performance evaluation and improvement strategies Why This Course Is Different Most Excel courses teach formulas. Most AI courses teach theory. This course bridges both. You will learn Excel fundamentals and advanced skills alongside AI-powered Copilot usage. That combination makes you significantly more productive than someone who only knows Excel or only knows AI prompts. This course is structured for clarity, practical application, and real-world efficiency. Who This Course Is For • Business professionals who work with Excel daily • Data analysts and aspiring analysts • Managers who want faster reporting • Students preparing for corporate roles • Entrepreneurs handling business data • Anyone who wants to leverage AI inside Excel No prior AI experience is required. Excel basics are covered before advancing into automation and Copilot optimization. Why You Should Enroll Today Microsoft Copilot is becoming a core productivity tool across organizations. Professionals who understand how to use AI effectively inside Excel will have a measurable competitive advantage. Instead of spending hours writing formulas, cleaning data, or building reports manually, you will learn how to work smarter. If you want to future-proof your Excel skills and become significantly more efficient with data, this course is for you. Enroll now and master Microsoft Copilot in Excel with confidence.

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.

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

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

Is it enough to just search for past exam questions and pass the Google Analytics Individual Qualification (GAIQ)? A certification holds little meaning if you obtain it without knowing how GA4 is actually used in practice or how to query and utilize data. This course focuses on practical application, allowing you to directly examine reports and GA demo accounts, and even set up a demo shopping mall yourself. You will build the skills necessary for the field while solving the latest 2026 GAIQ exam questions.