회사에서 많이 쓰는 엑셀(excel) 함수와 수식
Learn Excel functions from beginner to advanced! Solve your Excel frustrations and master formulas. A-Z coverage for efficient data analysis.
Course Content
회사에서 많이 쓰는 엑셀(excel) 함수와 수식 is a beginner-level Udemy course taught by 마소캠퍼스 Masocampus. It runs 9h 2m, is taught in Korean, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 32 reviews, with 106 students enrolled. It is a paid course, first published March 2023.
Mastering Excel Functions & Formulas: Unlock Data Analysis Power
Transform your Excel skills and become a data analysis expert! This comprehensive course, built on 100 million hours of accumulated online and offline instruction since 2013, empowers you to go beyond basic spreadsheet tasks and leverage the full potential of Excel. Learn from industry experts and gain practical skills to excel in your professional life.
What You'll Learn:
- Cell References & Ranges: Master the fundamentals of referencing cells and ranges – from static and dynamic ranges to structured references and array formulas. A solid foundation is crucial for effectively using Excel functions.
- Microsoft's Top 10 Functions: Discover the most frequently used Excel functions, including:
- SUM: Aggregate data efficiently.
- IF & CHOOSE: Make decisions based on conditions.
- DATE & DAYS: Work with dates and durations.
- FIND: Locate specific text within cells.
- VLOOKUP, LOOKUP, INDEX, MATCH: Retrieve data from tables based on criteria.
- And many more essential functions!
- Array Formulas: Systematic Data Handling: Understand the difference between single and array calculations. Learn to utilize powerful array functions like SUMPRODUCT, use wildcards, and handle AND/OR conditions for complex calculations.
- Data Lookup Functions for Real-World Applications: Become proficient in using functions like VLOOKUP, INDEX, and MATCH to find and extract data. Learn how to navigate arrays, retrieve the last matching record with LOOKUP, and adapt formulas for complex, large datasets. Gain practical insights into formula variations and their applications.
Course Highlights:
- Beyond the Basics: This isn't a dry listing of 330+ Excel functions. We focus on the 30 most commonly used functions in the workplace.
- Practical Application: Learn how to construct formulas for common business scenarios, covering aggregation, transformation, and data retrieval.
- Comprehensive Understanding: Develop a holistic understanding of Excel functions and formulas, enabling you to confidently apply them to real-world problems.
Course Structure:
- Step 1: Unveiling Excel's Potential: Begin with the core principles of how Excel works, setting the stage for effective function utilization.
- Step 2: Demystifying Essential Functions: Deep dive into frequently used functions like SUM, IF, FIND, and VLOOKUP, uncovering their capabilities and practical applications.
- Step 3: Data Retrieval Mastery: Conquer complex data exploration with powerful functions like INDEX and MATCH, enabling you to extract precise information from even the most challenging datasets.
Instructor: 최 정 아
Director, Content Lab, 마소캠퍼스
A seasoned international remote education expert with an MA in Business Administration from Yonsei University. As a Webmaster for YKLP (Yonsei-Keio-Ritsumeikan-Pudong) program, she spearheaded its successful launch. Previously, she served as Editor-in-Chief of PlayForum, managing a community of 2.38 million monthly active users and producing content reaching up to 9 million views. A versatile digital marketing expert with degrees in linguistics, information science, and business administration, she excels at leveraging data for optimal digital platform performance. She is a published author of best-selling books on effective data marketing.
Ready to unlock the power of Excel? Enroll today!
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.