|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-data-analysis/
课程评论：没有评论
Coursera 上的这门课程“Microsoft Excel 数据分析：公式与数据透视表”旨在帮助您在约 2 小时内，将 Excel 技能从初级提升到中级。课程将涵盖一系列重要的 Excel 功能，包括： * **数据透视表**：强大的数据汇总和分析工具。 * **排序和筛选**：高效地组织和查找数据。 * **键盘快捷键**：提升操作效率。 * **命名区域**：简化公式编写和管理。 * **日期处理**：专业地应用和管理日期数据。 * **错误处理**：识别和解决 Excel 中的常见错误。 * **中间函数**：如 VLOOKUP, COUNTIF, INDEX & MATCH, 嵌套 IF 语句等等（课程使用 Excel 2016 PC 版本）。 课程提供样本数据集供学员同步学习。学员评价普遍积极，认为课程深入讲解了数据分析师常用的基础工具，对于提升电子表格技能非常有帮助，即使是初学者也能通过课程内容受益良多。 **课程亮点包括**： * 包含可下载资源和 Excel 项目文件。 * 设有课程作业和测验。 * 提供终身访问权限。 * 享有 30 天退款保证。 **兼容性**：课程内容兼容 Excel 2007-2016 版本。
This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You'll learn a wide variety of important Excel features, including:Pivot TablesSorting and filteringKeyboard shortcutsCreating Named RangesUsing dates in Excel like a proHandling errorsIntermediate functions like VLOOKUP, COUNTIF, INDEX & MATCH, Nested IF statements, and many more (2016 PC Version used in course).Sample data sets provided for you to follow along and learn as you watch!See why people love this course on Udemy:"This course in particular gave me an indept knowledge of simple tools that can be used by a typical data analyst. It is a really good course to improve your skills and usage of spreadsheets."-Oladipupo J."This is a great course! I have learned alot of information so far. It is taking me longer to pick up, as I am a beginner, but since we are able to reverse, I am still learning so much!"-Katrina C."It was a great experience, being a first-timer. First, i thought the course would be a tough one. But the way the course is designed and explained is amazing! Worth it!"-Subhajit S.NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Lectures should be compatible with Excel 2007- 2016.
