Using Excel: Intermediate EXCEL (Inflearn Original)

This is a recorded video of the TDD online live meetup held in July 2025.

The renewal version of Life Coding's first web development course, <WEB 1 - HTML & Internet>, is being released exclusively on Inflearn!

The best introductory programming course that has already been taken and enjoyed by over 20,000 people. This introductory programming course was planned and prepared by Inflearn from the perspective of a non-major, and helps people who have never touched programming before to develop programming skills that can be used in real life.

Learn Figma, the most widely used collaboration tool in the world! Learn the basics of Figma, a design tool for UI design sketching, prototyping, and collaboration, and how to use it in practice.

This course is designed to cover the grammar of multi-threading, multi-processing, parallelism, and concurrency based on OS knowledge in preparation for technical interviews. You will learn basic knowledge about how to increase execution efficiency with multiple resources.

Leverage Python to create your own indicators and a convenient tool for securities analysis!

You can meet Excel as a data analysis tool that can add value to your work. This is a basic Excel course that teaches concepts in a broad and thorough manner from the basics.

In this lecture, we will look at service planning and design methodologies for planning services in the IT/tech field, as well as various soft skills that service planners must have. Finally, we will analyze the service using the example of an AI voice recognition service, a UX service introductory lecture for beginners.

From the basics of the Spring Framework to practical usage! Become a developer who can be deployed and actively engaged in the field right away through thorough and comprehensive explanations and examples.

This is a live video of Jung Heung-soo from Heung Button, which was broadcasted on January 23 as part of the <2025 Know Yourself Know Your Enemy Relay Live Campaign>.

Based on basic Python grammar knowledge, we will gradually increase the difficulty level from easy to difficult examples. During this process, you will learn how to study on your own, acquire solid grammar knowledge, and firmly establish your basics. In addition, we will learn frequently used patterns in Python programming.

This is an introductory web development course for those starting programming for the first time. By learning HTML, CSS, and JavaScript and creating an Instagram post card, you will learn the essential basics required for web page production.

The fact that you can analyze data more easily and effectively with Python Pandas instead of Excel! Learn the basic functions of the Pandas library and how to use it in practice through financial data analysis.

This course is designed to cover Python metaprogramming and in-depth grammar based on extensive Python development experience and online and offline teaching experience. Furthermore, we have prepared a curriculum that will be helpful for Python job seekers' interviews and technical interviews for experienced professionals. In addition, we will explain the process of directly distributing the library you created to PyPI (Python Package Index).

In an environment without a design team, product proposals, or a PM, how can we plan, deliver, and persuade? Kim Young-jun, former 29CM Product Design Lead, will share his self-product strategy focusing on Figma, along with practical case studies. Learn in detail everything from how to survive in a structureless environment to how to build structure with just Figma.

You've applied to be an Inflearn knowledge sharer, but you're feeling overwhelmed by the task of creating a lecture. How about listening to knowledge sharer Kang Young-hwa's lecture creation know-how?

[Inspiration Note] From ways to find inspiration in daily life with author Seunghee, to everything you're curious about regarding Seunghee as a brand marketer!

This is the edited live video from the LLM Application Experience Sharing Session with knowledge sharer Kang Byung-jin :)

How are product design and education changing in the AI era? Figma Official Community, FoF Seoul & Educators jointly hosted a meetup. Discover various cases and topics on AI-era product design and education, along with relevant sessions from global industry speakers who love Figma.

<This course is part of the 'Wrtn AI Literacy Voucher Program', a collaboration between Inflearn and Wrtn, and is available completely free for elementary, middle, and high school students who are in the AI vulnerable demographic.> From the fundamentals of artificial intelligence to generative AI that creates text, images, and videos! Artificial intelligence is already being used everywhere in our daily lives. This course is designed to help you easily understand what AI is, how it learns, and how it works. Without complicated formulas, just follow along like listening to a story and you'll naturally become friends with artificial intelligence!

You can meet Excel as a data analysis tool that can add value to your work. This is a basic Excel course that teaches concepts in a broad and thorough manner from the basics.

We will practice automating repetitive tasks using Power Automate Desktop, a free RPA tool from MS. Through this process, we will learn to understand automation and apply it to our actual work.

There are many things that are happening through non-face-to-face methods, such as non-face-to-face work, non-face-to-face services, and non-face-to-face meetings. In order to continue business, meetings must continue. If you have done seminars/broadcasts through Live Events, this lecture will now teach you how to conduct online video or audio conferences through Teams Meeting.

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

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

Through this course, students will master the core functions of NotebookLM step-by-step and learn how to delegate repetitive office tasks—such as report writing, meeting minute summaries, and data analysis—to an AI assistant. Moving beyond simple conceptual learning, the course provides actual work routines and checklists, equipping students with practical skills that can be applied to their jobs immediately after completion.

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

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

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.

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

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!

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 class on analyzing customer/sales data with Excel, even without R or Python!

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)

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.

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)

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided