AI로 피그마에 날개 달기
Masocampus
디자이너들에게 가장 각광받는 툴, Figma! AI로 쉽게 만들어서 각광받는 UX/UI 디자이너 되기!
입문
Figma, 카카오공채-디자인
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!
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.
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
7,708
Learners
1,003
Reviews
97
Answers
4.7
Rating
88
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
4 reviews
5.0
4 reviews
sm222.leeReviews 1
∙
Average Rating 5.0
- sanggu.byeon
Reviews 1
∙
Average Rating 5.0
5
64% enrolled여러 엑셀 강의를 들어 보았지만 이렇게 실무에 도움이 되는 강의는 없었 던 것 같습니다.
- MasocampusInstructor
수강평 남겨주셔서 감사합니다😊 열심히 준비한 보람이 있네요. 항상 최선을 다하는 마소캠퍼스가 되겠습니다!
- jdh355162
Reviews 1
∙
Average Rating 5.0
- parkjh1006
Reviews 1
∙
Average Rating 5.0
$38.50
Masocampus's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[초급] 기본 튼튼 워드 정복하기 강좌강의 썸네일](https://cdn.inflearn.com/public/courses/329990/cover/ed18b59c-c8d7-46be-979e-ebcbe140ccf0/329990.png?f=avif&w=420)
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
