Demystifying AI with Excel (AI with Excel)

Implement Deep Learning Basics in Excel for Deeper Understanding!

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)

[Lecture Summary: From Pixels to Practice, Building a Business Card Recognition System] * **Pre-processing:** We learned how to remove noise and extract the 'skeleton' of a business card using Gaussian Blur and Canny Edge detection. * **Hough Transform:** We went through an "audition" process to select the real 'borders' from tens of thousands of points using the $(\rho, \theta)$ voting system. * **Geometric Reasoning:** By solving complex linear equations through substitution and matrices, we precisely targeted the four corners $(x, y)$ of the business card. * **Data Sorting & Filtering:** We mastered data refinement techniques, such as removing overlapping lines and labeling the found points in the order of 'top-left, top-right, bottom-right, bottom-left.' * **The Magic of Transformation (Perspective):** We concluded with practical techniques for straightening tilted images or, conversely, compositing an image into a frame of your choice. 📢 "Does looking at formulas give you a headache? It was the same for me." When I first took on an image processing project in the field, what bothered me most were the screens full of $\sin$ and $\cos$ formulas. Textbooks were full of nothing but equations, and nowhere provided answers to practical problems like, **"Why can't this find the business card in my code?"** Through this lecture, I want to help you solve three chronic problems you will encounter: 1. **"The problem where math feels like an alien language"** → Solved through [The Power of Analogy]. Instead of simply memorizing linear equations, I help you understand them through **'lasers fired from the origin'** and **'shadow play.'** Once you understand the principles, the code follows naturally. I translate formulas into the 'easiest language' that I discovered after countless trials and errors. 2. **"The problem where you know the theory but can't apply it"** → Solved through [Data Auditions]. Why are there 10 borders on my business card? Why is the order of the corners scrambled? I have revealed all my debugging know-how on how to filter and sort the 'messy data' you inevitably encounter in practice. The audition logic for separating the wheat from the chaff will take your project to the next level. 3. **"The problem where the result is boring"** → Finished with [Interactive Composition]. This isn't a lecture that ends with just looking at black-and-white edges. The moment you tuck the business card you created into a 'Hall of Fame frame' that you clicked yourself with a mouse, you will experience **'the magic of manipulating space'** beyond simple coding. "Computer vision is not about math; it's the process of gaining a new set of eyes to see the world." I want to pass on to you that thrilling 'A-ha!' moment I realized in the field. You can close the complex theory books now. Let's paint images freely with the brush of code together!

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.

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!

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

Deeply understand the meaning of deep learning by implementing its basics in Excel!

Let's learn the principles of deep learning by visualizing them with Excel.

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

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

Let's learn the principles of deep learning by visualizing them with Excel.

We are now in the era of Generative AI! Go beyond simply using the latest technology—grasp the core principles and acquire the knowledge and experience to integrate Generative AI into your daily life!

Have you been getting stuck on linear algebra formulas every time you try to study AI? Instead of memorizing formulas, this lecture shows you visually how vectors and matrices actually move in space. By the end of the course, you will be able to interpret the mathematics behind neural networks, PCA, and SVD on your own.

Building a Full-Stack System Without Coding: Complete the entire pipeline from data collection to AI/ML analysis and web dashboards using only Korean prompts (Vibe Coding). Owning a 100% Automated Pipeline: Secure an independent stock analysis tool that sends S&P 500 screening and investment opinions via Telegram every morning. Acquiring a Practical Data-Based Investment Framework: Master institutional-level data analysis and risk management capabilities based on source code currently in actual operation.

In the era of AI and Big Data, are you utilizing your organization's data effectively? This course builds essential capabilities for reading and interpreting data, covering everything from the foundations of statistical thinking to the core principles of machine learning and deep learning. Grow into a practical leader capable of discovering patterns amidst volatility and making data-driven decisions.

Build your own powerful stock price analysis model that analyzes over 40 types of economic indicators and stock price data using AI to predict not only the S&P 500 and QQQ ETFs but also individual stocks!

Introducing AI entry-level study methods for undergraduates.

This course is designed to teach the entire process of 'AI Training Data Construction,' which is essential for successfully executing AI modeling projects. Learners will not simply remain at the theoretical knowledge level, but will experience step-by-step the data construction processes required in actual practice. Specifically, the course covers the entire process from AI training data planning → acquisition → storage → preprocessing → labeling → pseudonymization and transformation through hands-on practice, structured to develop practical skills that can be immediately applied in the field. Additionally, learners will systematically study the most important data management capabilities in AI projects, such as data quality management and security issues, personal information de-identification processing, and dataset optimization. Through this, learners can grow from simple data collectors into data specialists who can proactively plan and execute AI projects. 👉 Through this course, learners will understand how to construct high-quality training data that determines AI model performance and acquire practical capabilities to effectively apply this in real work environments.

Through a systematic curriculum of 40 lectures, you will learn everything from the basic theories of AI to the applied AI technologies of each algorithm. Through mathematical intuition and R coding algorithm learning and practice, you will develop immediately applicable AI model development capabilities, covering everything from designing algorithm models for data analysis, machine learning, and their application tools to selecting and utilizing them.

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

This course is designed to learn the fundamental theories and practical processes necessary for applying AI modeling and service planning to real-world work environments. Learners can acquire essential foundational knowledge to skillfully perform AI modeling projects and experience various practical procedures used in actual business settings. The course is specifically structured to provide step-by-step learning of the entire workflow from AI service environment analysis → goal setting → requirements analysis → service model design → scenario planning → utilization planning → execution plan development → performance evaluation planning. Through this approach, learners can develop systematic thinking and practical application skills for how to introduce and utilize AI from business and service planning perspectives, rather than limiting themselves to purely technical learning. Upon completing this course, learners will understand the overall planning and execution process of AI projects and will be able to strengthen their capabilities as AI service planners, PMs, and data-driven strategists in actual corporate environments.

This course is an introductory program designed so that learners who are new to AI technology can easily understand and follow along. Through the lectures, you will learn the basic concepts and usage methods of AI platforms, and conduct hands-on practice directly generating images using various AI tools. Upon completing this course, you will become much closer to AI and acquire the capability to create AI images that can visually implement creative ideas.

This introductory course for AI engineers is designed to provide a brief hands-on experience of the entire process, from data processing and model development to cloud, MLOps, and ethical considerations. It focuses on building practical skills by helping students understand the process of connecting models to actual services, rather than just creating them. The course includes hands-on exercises and examples so that even those learning AI for the first time can easily follow along.

This course covers the entire process of evolving ChatGPT from a simple conversational AI into an intelligent AI Agent that performs real-world tasks. By utilizing the three core frameworks—LangChain, LangGraph, and LangSmith—you will build AI Agents that can be used immediately in practice.

"Throw away the cliché AI theories and chatbot examples scattered all over YouTube. This is Korea's one and only '7 Major Industry Integrated Manufacturing AI Bible' that understands the language of manufacturing and pierces through the essence of the process." Hello, I am Byte Detective, your knowledge sharer. Currently, countless companies and practitioners are calling for 'Manufacturing DX (Digital Transformation)' and 'AI Adoption.' However, the majority of courses on the market are limited to vague theories from IT developers or consultants who have no understanding of the harsh practical realities of the manufacturing field. This course is not a lecture for the sake of theory. By organically combining the actual domain knowledge of Korea's top 7 representative manufacturing industries with the latest AI frameworks, it provides a 'Practical Manufacturing DX Scenario Architecture' that can be applied to the field starting tomorrow.

This course covers everything from the basics to hands-on practice of AI platforms, and is a program where you can learn AI image generation technology. Learners can understand the fundamental concepts of AI and develop the ability to generate AI images using various tools and technologies. Through this course, you can enhance your understanding of the AI field and learn how to directly generate AI images in real-world applications.

This lecture is designed for job seekers preparing for Evaluation and Analysis roles in Samsung Electronics' DS Division (Memory, S.LSI, Foundry, TSP, AVP) and PE, AE, and Solution PE roles at SK hynix, who are struggling with the differences between business units and job functions. You will learn how to categorize job titles by company based on the actual workflow of Product Evaluation roles and how to translate your major-related experiences into professional terminology suitable for resumes and interviews. We will help you establish an application strategy by connecting experiences in Analog circuit design, Verilog/FPGA, process experiments, and data analysis with key industry terms such as Yield, Wafer Map, Shmoo Plot, and Failure Analysis.

In the era of smart factories and autonomous driving, is our production line truly safe? The remarkable advancement of Artificial Intelligence (AI) has brought innovative productivity and efficiency to the automotive manufacturing industry, but it is simultaneously creating unprecedented security threats to the Operational Technology (OT) environment within factories. This lecture breaks down "OT Security"—which can often feel vague and difficult—in a clear and easy-to-understand manner through vivid, real-world examples from the automotive industry.

"Smart Factory—it sounds cool, but can't quite picture it in your head?" The news talks about the 4th Industrial Revolution and AI factories every day, but when you actually look for information, it's full of "alien languages" like PLC, MES, ERP, and Edge Computing. What non-majors need isn't a complex circuit diagram, but a 'map' that shows how the whole system works. This course strips away difficult engineering jargon and explains everything about smart factories through intuitive illustrations and analogies that anyone can understand.

This course provides a solid foundation in the essential linear algebra required for AI learning and research. It covers core concepts frequently encountered when preparing for AI graduate school admissions, reading research papers, and conducting research, as well as fundamental numerical linear algebra techniques.