inflearn logo
Challenge
Ended

The Core of Excel Practice! Must-Know Functions Complete Mastery Challenge Season 2

🙋‍♀️ Have you ever thought this? "Functions! I understand when I hear about them, but I can't think of them when I actually try to use them..." "Wouldn't it be great if they just came to mind at the right moment?" Excel functions are the most powerful tool for improving work efficiency. But it's true that they can feel unfamiliar and complicated. That's why we've prepared this! 📌 Course Introduction We've carefully selected only the essential functions needed for practical Excel work and explain them easily with examples. ✔ Basic essential functions like IF / VLOOKUP / SUMIF / COUNT / RANK.EQ ✔ Financial functions like FV / PMT, statistical functions like AVERAGEIF / COUNTIFS ✔ Example-focused structure that you can use immediately in practical work It's not just about throwing function explanations at you and calling it done— we've structured it so you can follow along directly while looking at example files. Don't worry if you're an Excel beginner! We'll teach you slowly and step by step.

158명이 수강한

강의로 진행되는 챌린지!

Excel
MS-Office
functions

News

3 articles

  • dmsgml1030님의 프로필 이미지

    Hello, I'm Teacher Eunhee 😊

    [Function Mastery] It's already been 2 weeks since the challenge started.
    Are you keeping up well?

    At first, it may feel unfamiliar and confusing, but as you work through things one by one, there will definitely come a moment when you realize, 'Ah, this is how it's used!' That sense of achievement is truly the greatest joy of learning Excel

    It's okay if you haven't made much progress yet.
    The most important thing in a challenge is not to do it perfectly and quickly, but to consistently see it through to the end.
    If you follow the missions and lectures I've prepared step by step during the remaining time, functions will become your reliable weapon.

    This week, make sure to set a time and make a promise to yourself.
    Starting with a small goal like "I will complete at least ○ lectures this week!" is enough.

    And you can submit your challenge mission at any time

    This course has a total of 5 missions prepared: logical functions, mathematical trigonometric functions, text functions, statistical functions, and lookup reference functions
    You can watch the lectures, complete the challenge missions, and submit them at any time
    Completing missions allows you to check your skills and improve them while receiving feedback
    Please make sure to complete all 5 missions
    Teacher Eunhee will provide sincere and detailed feedback

    I support you in completing this journey to the end!
    With me by your side, you can definitely conquer functions 💪

    Shall we run together?

    0
  • dmsgml1030님의 프로필 이미지

    The long-awaited Excel Functions Complete Mastery Challenge Season 2 has finally begun!
    This 5-week course consists of a total of 26 lessons, 5 missions, and 2 live classes
    It's a practical program designed to help you completely master the essential functions you must know for Excel work

    📅 5-Week Curriculum at a Glance

    1⃣[Week 1] Understanding Date/Time Functions + Logical Functions
    → Build the foundation for calculating work schedules, working hours, and conditions.

    2⃣[Week 2] Complete Understanding of Math Functions
    → Master essential practical calculations including calculation automation, rounding, remainders, trigonometric functions, and more.

    3⃣[Week 3] Creating Clean Reports with Text Functions
    → Master text data manipulation including names, codes, and sentence formatting.

    4⃣[Week 4] Building Data Analysis Foundations with Statistical Functions
    → Developing practical analysis skills through averages, rankings, and conditional statistics.

    5⃣[Week 5] Completing with Lookup·Reference Functions + Information Functions
    → Connect data with VLOOKUP, INDEX, MATCH,
    and automatically check data flow with information functions.

    🧩 Challenge Structure

    📘26 Lectures – Focused on essential functions with practical, hands-on content
    🎯5 Missions – Apply learned functions through direct practice
    💬2 Live Classes – Complete understanding through real-time Q&A & feedback
    🏆Certificate Issued – Automatically issued upon 80% or higher completion

    📢In 5 weeks, Excel will transform from a 'tool' to a 'weapon'.
    Through this challenge, your work speed will increase, data errors will decrease,
    and most importantly, you'll gain the 'confidence to handle Excel easily'.

    Fighting~

    0
  • dmsgml1030님의 프로필 이미지

    📘 The Core of Excel Practical Skills!

    Essential Functions Mastery Challenge Now Open 🎉

    Excel, we use it every day, but what's always difficult is 'functions'.
    "I understand IF, but how is it different from SUMIF?"
    "VLOOKUP keeps giving me errors..."
    "It's faster to just do it by hand 😅"

    Have you ever had this kind of concern, perhaps even once?

    In fact, Excel functions are core business tools that make work 2x faster and reduce errors by 10x.
    However, if you don't learn them properly, they always feel difficult and complicated.

    So I've prepared this for you.
    Introducing the 5-Week Complete! Master Excel's Core Functions Challenge 💪

    💼 "Functions, I'm Not Afraid Anymore" — 5-Week Practical-Focused Curriculum

    This challenge is not simply a lecture that lists functions for you to learn.
    It's participatory learning structured around real-world situations that every working professional encounters.

    "What function should I use in this situation?" You'll think about this question,
    and learn by practicing directly with files.

    Weekly practice missions
    Practical example files provided
    Mission feedback provided
    Certificate issuance (upon 80% or more completion)

    📊 This is how it changes

    📌Week 1 – The basics of work! Date and logical functions for handling conditions (WEEKDAY, DATE, IF, IFERROR...)
    📌Week 2 – Math and trigonometric functions powerful for number calculations (SUMIF, SUMPRODUCT...)
    📌Week 3 – The core of data organization! Text functions (LEFT, RIGHT, MID...)
    📌Week 4 – Error-free analysis! Ranking and statistical functions (RANK.EQ, AVERAGE, MAX, MIN, COUNTIF...)
    📌Week 5 – The art of finding information! Lookup functions (VLOOKUP, INDEX, MATCH...)

    🏆 Recommended for these people

    • Office workers who deal with Excel daily but are still unfamiliar with functions

    • People who want to automate simple repetitive tasks

    • Someone who knows the concept of functions but doesn't know how to use them in practice

    🚀 In 5 weeks, your Excel will be different

    Through this challenge, you will experience functions that you once found difficult transforming into 'everyday tools'.
    You will no longer hesitate in front of complex formulas and will grow into an Excel expert who increases work efficiency.


    💚 Start right now!


    👉The Core of Excel Practice! Must-Know Functions Complete Mastery Challenge

    People who are good at Excel are not 'people who do more work' but 'people who work smarter'.
    After 5 weeks, your leaving time will be different 🌙

    0

$29.70