In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis. Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel.


您将学到什么
Create data in Microsoft Excel and prepare it for data analysis.
Make use of common formulas and functions in a worksheet.
Prepare Excel data for analysis in Power BI using functions.
您将获得的技能
要了解的详细信息

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

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

该课程共有4个模块
This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.
涵盖的内容
11个视频19篇阅读材料7个作业2个讨论话题
This module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.
涵盖的内容
6个视频9篇阅读材料5个作业1个讨论话题
The module introduces common functions that help prepare Excel data for analysis in tools such as Power BI.
涵盖的内容
6个视频13篇阅读材料7个作业1个讨论话题
In this module, you will be assessed on the key skills covered in the Course.
涵盖的内容
2个视频4篇阅读材料2个作业1个讨论话题
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
从 Data Analysis 浏览更多内容
- 状态:免费试用
- 状态:免费试用
- 状态:免费试用
- 状态:免费试用
Corporate Finance Institute
人们为什么选择 Coursera 来帮助自己实现职业发展




学生评论
64 条评论
- 5 stars
79.68%
- 4 stars
17.18%
- 3 stars
0%
- 2 stars
1.56%
- 1 star
1.56%
显示 3/64 个
已于 Feb 5, 2025审阅
Great course. Easy to understand step-by-step instructions. Engaging activities.
已于 May 22, 2025审阅
Analysis with Microsoft excel, is great and understandable.
常见问题
This program is for you:
● If you want to switch or start a career in the field of data analytics.
● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.
You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.
It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.
更多问题
提供助学金,