강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Office

Excel functions and formulas frequently used in companies

Have you ever felt itchy and stuffy whenever you created a function in Excel? If so, solve it with this course that covers everything from A to Z about functions!

(5.0) 3 reviews

44 learners

  • Masocampus
실습 중심
엑셀함수
Excel
vlookup
MS-Office

What you will learn!

  • Ability to use Excel beyond its basic usage

  • Understand how to use essential Excel functions for work

  • Key features to improve work efficiency

  • Ability to use Excel functions according to situation

Excel, the office worker's best friend
Master essential business functions! 📊

👀 Please check before taking the class!

  • Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture and hands-on screens.
  • Since the training will be conducted based on Windows OS, we recommend taking the course in a Windows environment.
  • Lecture notes and practice files are available in the <0. Textbook Download Center> section.

Excel work processing
New Paradigm 💡

#1 Using cell references and static/dynamic ranges

#2 Microsoft's Top 10 Functions

#3 Even more systematically with array formulas !

#4 Functions for finding data that can be used immediately in practice!

Excel Bible for Office Workers 📖

Functions and formulas are the most fundamental part of Excel, forming the foundation for all its features . Regardless of what other functions you learn, if you don't understand basic functions like SUM, IF, COUNT, and VLOOKUP, you'll struggle to fully utilize Excel. The key lies in a lack of fundamental understanding of Excel functions and formulas. Memorizing a few formulas without fully understanding how each function works can hinder your ability to find unique problem-solving methods and hinder your ability to apply them effectively.

This course is designed for professionals who use Excel but are unsure how to effectively use its functions and formulas. It systematically explains the fundamentals of Excel, including functions and their operating principles. With the convenient and powerful Excel functions, you can work faster and more accurately than ever before.

  • Understanding Excel's operating principles to effectively utilize functions
  • Process complex data using various functions and use it in the desired format.
  • The ability to use functions appropriately without having to memorize them
  • The ability to examine data from various angles and derive insights

👉 Master this course and become a professional worker!

You can learn it in this lecture! 😎

[STEP 1] A Different Look at Excel, Used by Everyone
To help modern workers effectively utilize Excel functions, we'll explain how they work, step by step. Listen carefully and you'll be captivated by the diverse capabilities of Excel functions.

[STEP 2] Mastering Excel functions that you've heard of but find confusing when actually using them.
SUM, IF, FIND, VLOOKUP… Most of you have probably seen these functions somewhere, but few know what they do. Let's take a look at these frequently used functions and delve into their functions!

[STEP 3] Until the day you can retrieve the data you want from complex data with a single function!
Trying to actually use data exploration functions can be overwhelming. Learn how to use functions to find the data you want, even in complex data sets.

Structural reference of the table
Aggregation using functions and wildcards
Period calculations and unit conversions
Cell references and data tables

Expected Questions Q&A 💬

Q. Is prior knowledge of Excel required?

No, you don't need any prior knowledge of Excel functions. We'll walk you through every single button click from beginning to end, so you don't have to worry about your Excel skills.

Q. Are there any requirements or prerequisites for taking the course?

Since this is a hands-on course , we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens . Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.

Introducing the knowledge sharer ✔️

Recommended for
these people

Who is this course right for?

  • For those who want to speed up their work by using Excel

  • For those who want to easily handle simple Excel tasks with functions

  • For those who want to use complex functions where necessary

  • For those who need a course on Excel functions that can be applied directly to work

Hello
This is

7,027

Learners

857

Reviews

96

Answers

4.7

Rating

85

Courses

"어제보다 성장하겠습니다. 그리고, 어제보다 성장하려는 사람을 돕겠습니다."

 

마소캠퍼스의 진심과 소망을 담은 Actionable Content로,

2013년부터 온오프라인으로 함께해 온 누적 강의 1억시간!

이 소중한 경험과 시간은 언제나 마소캠퍼스와 수강생 모두의 성장의 원천입니다.

 

마소캠퍼스 팀은 우리의 모두의 성장을 위해 두 가지 원칙을 반드시 지킵니다.

 

1. 배우면 반드시 쓸 수 있는 Actionable Content

2. 참여자의 시간과 수고를 존중하는 Time-Saving Curriculum

 

마소캠퍼스의 Actionable and Time-Saving Curriculum으로 성장의 길을 함께 걸어나가길 기원합니다.

Curriculum

All

22 lectures ∙ (8hr 53min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

5.0

3 reviews

  • sanggubyeon9661님의 프로필 이미지
    sanggubyeon9661

    Reviews 1

    Average Rating 5.0

    5

    64% enrolled

    I've taken many Excel courses, but none have been this practical.

    • masocampus
      Instructor

      Thank you for leaving a course review😊 It makes all the hard work in preparation worthwhile. We will always do our best to be the best Maso Campus!

  • jdh3551629977님의 프로필 이미지
    jdh3551629977

    Reviews 1

    Average Rating 5.0

    5

    86% enrolled

    • masocampus
      Instructor

      Thank you for leaving a review.😊 It's rewarding to know my hard work paid off. Maso Campus will always do its best!

  • parkjh10065236님의 프로필 이미지
    parkjh10065236

    Reviews 1

    Average Rating 5.0

    5

    86% enrolled

    • masocampus
      Instructor

      Thank you for leaving a review😊 Maso Campus will always do its best!

$38.50

Masocampus's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!