Excel の活用方法: EXCEL 中級 (Inflearn Original)

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.

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.

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

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.

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.

It explains the basic concepts step by step and helps you gain practical knowledge by practicing creating various applications that actually run in a web environment. If you complete this course, you will be ready to work as a programmer.

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

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.

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 an introductory web development course for those who are starting programming for the first time. You will learn HTML, CSS, and Javascript and create an Instagram posting card to learn the basic content that is essential for creating a web page.

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.

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

This is a live video of Lee Jung-hwan, which was broadcast on January 16 as part of the <2025 Know Yourself Know Your Enemy Relay Live Campaign>.

Do you want to create a tool that can help you with your real-world investments using Python? In this course, you will learn how to create an interactive web dashboard for financial data analysis for intermediate Python users and learn about pair trading strategies for in-depth quantitative work. We hope that you will be able to create your own useful analysis tools to help you analyze financial data more powerfully and make wise investment decisions.

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 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 renewed version of 생활코딩's first web development lecture, <WEB 1 - HTML & Internet>, is exclusively available on Inflearn!

Learn about tasks that can be done using Excel VBA. Learn about the basic syntax of VBA and objects, collections, properties, methods, and events, and create and use Visual Basic functions, Excel functions, and user-defined functions.

Excel 2021 Practical Super-fast Master Class covers 6 key tips and features to help practitioners maximize their work efficiency and get off work early. Quickly acquire all the essential skills of Excel, from data processing, editing, formatting, calculation, analysis, and visual effects through this course.

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.

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.

If there is an attachment in an email, save it to OneDrive! If someone uploads a file to the team site, get an email notification! If there is an email from a VIP customer, get a notification! Learn how to automatically do these repetitive tasks without you having to do them yourself.

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

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 learn NotebookLM's core features step by step and discover how to delegate repetitive workplace tasks like report writing, meeting minutes organization, and data analysis to an AI assistant. Going beyond simple conceptual learning, the course provides actual work routines and checklists, enabling students to develop practical skills they can immediately apply to their work right after completing the course.

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.

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

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

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

You still haven't started studying data analysis...? Are you... what? 😦 Now, data analysis is not a choice but a necessity! Master data analysis with Masocampus lectures and live a new life!

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)

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

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)