Using Excel: Intermediate EXCEL (Inflearn Original)

Inflearn's official MCP! Through MCP, you can retrieve the content of the courses you own. Connect quickly and feel free to apply the knowledge from your courses.

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.

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.

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

It explains the basic concepts step-by-step and helps you build practical knowledge by creating various applications that run in real-world web environments. By completing this course, you will be ready to be deployed immediately as a professional programmer.

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.

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.

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.

This course focuses on teaching high-level grammar so that learners who have learned the basics of Python can apply Python to practical use. By understanding the unique features of Python and learning them quickly, you can become familiar with intermediate-level programming.

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

Learn the features of Sketch, a widely used UX/UI design tool, and learn about the overall application interface design process.

We will look at the overall features of Adobe XD, a UX/UI design tool from Adobe, and learn various ways to apply it to practical design work.

This is a basic UI design course for those who want to become a new UI/UX designer or learn about UI design. You will learn basic knowledge about UI design and design tips that are essential in practice.

Learn about the concept of UX (User Experience) and explore today's UX design processes and design trends, and learn about the concept of UX/UI in general.

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.

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

From design collaboration methods to career advice, Wanted Product Designer Sanghyo Lee shares stories you might be curious about.

Since 2017, I have made it a point to do a retrospective at the end of every year. I have also done one whenever I faced a particular concern. I would like to share what I have realized through these retrospectives over the past seven years.

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.

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

We will show you how to use ChatGPT prompts for task automation in the most frequently used areas in practice (files and folders, Excel, PowerPoint, Word, PDF, data analysis), through various practical examples.

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

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

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 first in Korea! This course teaches you how to automate Word documents for business using ChatGPT. You can easily create various questionnaires, business reports, meeting minutes, and contracts, and apply them directly to your work through hands-on practice.

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.

This covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn how to create Excel formulas needed for practical work, easily understand Excel functions, and even write macros and VBA coding using ChatGPT.

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

Coding Excel data with Python?! It's not that hard~ Becoming a cutting-edge professional is only a matter of time!

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.

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)

This is a practice-oriented course designed to increase work productivity by automating repetitive Outlook email tasks using Python. From composing emails and saving drafts to accessing the inbox, searching for emails, handling attachments, categorizing emails, and creating calendar events and contacts— you will learn how to automate frequently repeated Outlook tasks using Python and pywin32. Rather than just explaining simple functions, this course is structured to help you build your own reusable Outlook automation programs through automation code ready for immediate practical use and real-world project examples.

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.

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)

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.

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.

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