As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data.
课程信息
对员工进行热门技能培训能否为您的公司带来益处?
体验 Coursera 企业版您将学到的内容有
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 Analysis
- Microsoft Excel
- Data Cleansing
对员工进行热门技能培训能否为您的公司带来益处?
体验 Coursera 企业版提供方
立即开始攻读硕士学位
通过 MasterTrack 证书,硕士课程的部分内容已被分成若干在线单元,因此您可以以想不到的价格,通过灵活、互动性强的方式获得优秀大学颁发的职业证书。如果您注册该计划,您的课程学习将计入您的 MasterTrack 证书。
授课大纲 - 您将从这门课程中学到什么
Welcome and critical information
Cleaning and manipulating text
Working with numbers and dates
Defined Names for working more effectively with data
Tables for automating data manipulation
审阅
- 5 stars81.95%
- 4 stars15.77%
- 3 stars1.50%
- 2 stars0.23%
- 1 star0.53%
来自EXCEL FUNDAMENTALS FOR DATA ANALYSIS的热门评论
Super fun and and intellectual course. Real need of hour to excel in Excel :) . This course helped a lot, in improving skills in excel analytics.
special thanks to both the instructors !!!!!!!
A very well structured course with easy to follow examples. I would give it a 4.5 because there is some error in the workbook and quizzes but apparently, it hasn't been changed despite to complaints
Thank you for this course! It was a lot of fun and easy to follow. I loved the assignements when not only that weeks knowledge was tested but also something randomly from previous weeks.
This Course has really giving me a better insight to the things i can do with Excel and even more. i am building on the knowledge gained for my work in other areas
Yaw Agyakwa Adu
关于 Excel Skills for Data Analytics and Visualization 专项课程

常见问题
我什么时候能够访问课程视频和作业?
我订阅此专项课程后会得到什么?
有助学金吗?
还有其他问题吗?请访问 学生帮助中心。