Business Automation with Python and Excel

This lecture examines the entire process of generating a photo mosaic from an algorithmic perspective. The input image is reduced to a set of representative colors matching the number of tiles through K-means clustering, then the Hungarian algorithm is applied to optimally match each color with a tile in a 1:1 correspondence. Through this, you will understand how image processing and combinatorial optimization algorithms combine to create a single visual output.

Let's visually learn the principles of deep learning using Excel.

Deeply understand deep learning basics by implementing in Excel!

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

Hot image generation model! Let's understand it by implementing it from the basics! Let's implement AUTO ENCODER / VAE / GAN / DIFFUSION together!

Why this course is special: Key Advantages • Intuitive Visualization: Directly observe algorithm operations in real-time with Pygame 2D simulations • Practical Implementation Experience: Go beyond theory and internalize autonomous driving algorithms by coding directly • Master Core Algorithms: Focused learning of essential algorithms such as Dijkstra, Pure Pursuit, ICP, etc. • Step-by-step Advanced Learning: Systematic difficulty progression from basics to SLAM • Lidar-based SLAM: Practical map building and localization in unknown environments

Deep learning is a technology that learns data through neural networks composed of combinations of complex functions. In this lecture, we will mathematically understand the core concepts of deep learning and analyze them from the perspective of matrix operations. In particular, utilizing Python's NumPy library, we will visually examine how parameters are updated by directly implementing the forward and backward propagation processes of deep learning. Even the seemingly complex neural network structure becomes clear when analyzed with matrix operations. This lecture focuses more on understanding concepts than coding and is suitable for students who wish to intuitively grasp the principles of deep learning mathematically.

Implementing deep learning basics with Excel to deeply understand their meaning! Learn how image data is processed!

Implement Deep Learning Basics in Excel for Deeper Understanding!

Pre-Trained Model (VGG16) / CAM / Grad-CAM / YOLO / STYLE TRANSFER / PIX2PIX / CYCLEGAN Implementing Stable Diffusion Directly

It would be efficient to automate IT security tasks using Python, wouldn't it? This course follows hands-on practice, applying Python and web Flask development to automate tasks, idea by idea.

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 course that covers how to conveniently handle work using the macro recorder without the burden of VBA coding! You can understand how to utilize macros in various ways through practice of simply converting data accumulated in the company into an Excel database and building a search system to find it.

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work settings to learn which functions to apply in each situation to perform tasks most quickly and efficiently.

Learn to implement Telegram, Slack, KakaoTalk, and Discord bots with Python, exploring each service's features via various examples.

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.

Automate Creating YouTube Shorts with AI!! Learn from scratch how to automatically create YouTube Shorts with n8n. Build a complete workflow that runs from text→image/music→video creation→upload all at once. Practice distinguishing between test mode/production mode and tips for saving costs. Complete 3 ready-to-use automation templates by the end of the course. Learn step-by-step from node placement so you can follow along even without coding knowledge. Let's automate AI YouTube Shorts production together!

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

This course aims to acquire Python-based web crawling technology to collect data from web pages and improve data collection and analysis capabilities at work based on this.

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)

No more lectures that start with boring grammar! Python practical application examples that jump straight into use

Let's begin developing with Copilot (copilot). With AI, even elementary school students can follow along!

"Level Up Your Python Alone!" Starting from Python basics, all the way to creating 2D games and an Ollama-based AI chatbot! This is a practice-focused introductory course where you learn core syntax like variables, conditional statements, and functions, and improve your skills by building things yourself.

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

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

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

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.

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.

A solopreneur is always short on time. They need to develop automation programs to delegate repetitive tasks to the programs and let people do the creative work.

From the basics of Python to applications, everything you can do with Python, including web, data analysis, crawling, business automation, GUI, and programming, is covered in one course.