课程信息

195,134 次近期查看
可分享的证书
完成后获得证书
100% 在线
立即开始,按照自己的计划学习。
可灵活调整截止日期
根据您的日程表重置截止日期。
中级
完成时间大约为15 小时
英语(English)
字幕:英语(English)

您将学到的内容有

  • Use Excel tools and functions to clean and prepare data for analysis.

  • Use Named Ranges and Tables to automate your analysis.

  • Understand the different types of data in Excel and use appropriate functions to work with them.

  • Use logical and lookup functions to transform, link and categorise data.

您将获得的技能

Data AnalysisMicrosoft ExcelData Cleansing
可分享的证书
完成后获得证书
100% 在线
立即开始,按照自己的计划学习。
可灵活调整截止日期
根据您的日程表重置截止日期。
中级
完成时间大约为15 小时
英语(English)
字幕:英语(English)

提供方

麦考瑞大学 徽标

麦考瑞大学

教学大纲 - 您将从这门课程中学到什么

1

1

完成时间为 1 小时

Welcome and critical information

完成时间为 1 小时
1 个视频 (总计 3 分钟), 3 个阅读材料
1 个视频
3 个阅读材料
Welcome to Excel Fundamentals for Data Analysis15分钟
Course goals and weekly learning objectives10分钟
Important information about versions and regions10分钟
完成时间为 3 小时

Cleaning and manipulating text

完成时间为 3 小时
6 个视频 (总计 30 分钟), 4 个阅读材料, 6 个测验
6 个视频
Excel functions for combining text values6分钟
Functions that split text data3分钟
Combining text functions6分钟
Cleaning data and changing case4分钟
Removing and replacing text characters4分钟
4 个阅读材料
Read me before you start: Quizzes and Navigation10分钟
Download the Week 1 workbooks5分钟
Week 1 Practice Challenge20分钟
Week 1 Toolbox10分钟
6 个练习
Excel functions for combining text values10分钟
Functions that split text data10分钟
Combining text functions10分钟
Cleaning data and changing case10分钟
Removing and replacing text characters10分钟
Cleaning and manipulating text: Test your skills30分钟
2

2

完成时间为 3 小时

Working with numbers and dates

完成时间为 3 小时
6 个视频 (总计 37 分钟), 3 个阅读材料, 6 个测验
6 个视频
Converting Data with VALUE and TEXT6分钟
Understanding dates and basic date functions7分钟
Generating Valid Dates using the DATE function6分钟
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY8分钟
More sophisticated date calculations with EOMONTH and EDATE5分钟
3 个阅读材料
Download the Week 2 workbooks10分钟
Week 2 Practice Challenge20分钟
Week 2 Toolbox10分钟
6 个练习
Converting Data with VALUE and TEXT10分钟
Understanding dates and basic date functions10分钟
Generating Valid Dates using the DATE function10分钟
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY10分钟
More sophisticated date calculations with EOMONTH and EDATE10分钟
Working with numbers and dates: Test your skills30分钟
3

3

完成时间为 3 小时

Defined Names for working more effectively with data

完成时间为 3 小时
6 个视频 (总计 36 分钟), 3 个阅读材料, 6 个测验
6 个视频
Cell Referencing and Naming6分钟
Defined Names and Create from Selection4分钟
Managing Names5分钟
Calculations with Named Ranges6分钟
Automating Data Validation with Named Ranges6分钟
3 个阅读材料
Download the Week 3 workbooks10分钟
Week 3 Practice Challenge20分钟
Week 3 Toolbox10分钟
6 个练习
Cell Referencing and Naming10分钟
Defined Names and Create from Selection10分钟
Managing Names10分钟
Calculations with Named Ranges10分钟
Automating Data Validation with Named Ranges10分钟
Defined Names for working more effectively with data: Test your skills30分钟
4

4

完成时间为 3 小时

Tables for automating data manipulation

完成时间为 3 小时
6 个视频 (总计 42 分钟), 3 个阅读材料, 6 个测验
6 个视频
Introduction to Tables6分钟
Customising Tables 5分钟
Sorting and Filtering Tables8分钟
Table Calculations and Structured References9分钟
Automation with Tables7分钟
3 个阅读材料
Download the Week 4 workbooks10分钟
Week 4 Practice Challenge20分钟
Week 4 Toolbox10分钟
6 个练习
Introduction to Tables10分钟
Customising Tables10分钟
Sorting and Filtering Tables10分钟
Table Calculations and Structured References10分钟
Automation with Tables10分钟
Tables for automating data manipulation: Test your skills30分钟

审阅

来自EXCEL FUNDAMENTALS FOR DATA ANALYSIS的热门评论

查看所有评论

常见问题

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You’ll be prompted to complete an application and will be notified if you are approved. Learn more.

还有其他问题吗?请访问 学生帮助中心