統計分析マスタークラス
Masocampus
今経験よりもデータに基づいて答えるとき！統計知識で信頼性を数値化して根拠として提示するなら、皆さんの説得力は無限大UP！
초급
Statistics
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,026
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
sanggubyeon9661Reviews 1
∙
Average Rating 5.0
5
64% enrolled様々なExcel講座を受講してきましたが、これほど実務に役立つ講座はなかったように思います。
- masocampusInstructor
受講レビューを残していただき、ありがとうございます😊 一生懸命準備した甲斐がありますね。いつも最善を尽くすマソキャンパスになります！
- jdh3551629977
Reviews 1
∙
Average Rating 5.0
5
86% enrolled- masocampusInstructor
受講レビューをお寄せいただきありがとうございます😊 一生懸命準備した甲斐がありました。常に最善を尽くすMaso Campusになります！
- parkjh10065236
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!
![[エピソード] Excel + Python (基礎)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.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)
