Learners will apply advanced Excel financial functions, analyze data using conditional logic, and execute dynamic lookup and sorting operations to solve real-world analytical challenges. This course equips professionals with the ability to calculate complex financial metrics, perform multi-criteria summations, build powerful Pivot Table summaries, and retrieve information efficiently using modern functions like SORT and VLOOKUP.

您将学到什么
Apply advanced Excel functions to calculate financial metrics and analyze data using conditional logic.
Use lookup, sorting, and multi-criteria functions to retrieve, organize, and summarize data efficiently.
Build Pivot Tables and dynamic analyses to support reporting, insights, and data-driven decisions.
您将获得的技能
要了解的详细信息

添加到您的领英档案
7 项作业
December 2025
了解顶级公司的员工如何掌握热门技能

积累特定领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 获得可共享的职业证书

该课程共有2个模块
This module introduces learners to foundational and advanced Excel functions used for financial analysis, conditional summations, and mathematical computations. Through hands-on demonstrations, learners gain the skills to calculate interest payments, perform net present value assessments, apply conditional summation logic, and execute advanced array-based mathematical operations essential for data-driven decision-making.
涵盖的内容
8个视频4个作业
This module equips learners with advanced tools for data organization, logical decision-making, and dynamic lookup operations in Excel. Learners explore Pivot Table aggregation, multi-condition logical testing, dataset sorting with dynamic arrays, and high-accuracy lookup methods—building strong analytical capabilities for modern data-driven tasks.
涵盖的内容
4个视频3个作业
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.








