Rediscovering Excel: Encyclopedia of Practical Tips

The most accurate and systematic introductory standard lecture for ChatGPT. Hicrodos Original, ChatGPT Master Class! Based on official OpenAI materials, we systematically guide you through everything from the essential core usage you must know when starting out to practical applications in the workplace.

Through this course, even beginners can master Power BI from the basics to intermediate level!

This course is for those who are new to Excel or want to upgrade from basic to advanced level.

You can master advanced Excel Power Query skills that help process data efficiently and scientifically, and apply them to real-world tasks. (Power Query menus and M code, Advanced Course)

This is not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.

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

AI Excel that automates perfectly for your tasks without any company security concerns. From data preprocessing to visualization, everything is OK in just a few minutes—without any coding knowledge!

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.

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.

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.

Excel automation is possible without uploading company data? Revealing AI secrets that maintain security while reducing work hours!

This is a practical lecture designed for passing the ITQ Excel Grade A exam in a short period. You will master the four-step process—from data entry to pivot tables and charts—and learn time-saving skills to finish with 15 minutes remaining in the 60-minute exam. Rather than rote memorization, you will understand functions through intuitive pattern matching and complete your Excel skills to be immediately applicable in real-world tasks.

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

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

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.

Even if you don't know coding, you can read data - everything about no-code AI analysis that makes perfect sense! If you can use Excel, PPT, and Google Sheets, AI will now handle data analysis for you.

Visual design techniques that go beyond data visualization to instantly persuade others From visual cognitive design to future scenario analysis and AI workflows, all at once

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.

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)

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)