|
所在平台: Coursera专项课程 |
课程主页: https://www.coursera.org/specializations/everyday-excel
课程评论：没有评论
课程名称：日常Excel 概述： 在这个专项课程中，您将学习到多种Excel工具、技巧和函数，并将其应用于实际的“开放式”项目。内容包括Excel导航、编辑工作表（包括插入/删除单元格、列和行）以及单元格格式化；表达式输入和常用Excel公式（包括逻辑函数、文本函数和财务函数）；数据管理（排序、筛选、合并、去重、数据验证和单向查找）。 您将获得的技能包括： - 电子表格 - Microsoft Excel - 问题解决 - 项目管理 - 计算 - 数据管理 - 实际应用项目 关于该专项课程： 本课程适合希望从初学者到专家级别学习Microsoft Excel的学习者。前两门课程通过大量的教学录屏和一系列测验与应用任务教授Excel基础知识。最后，在第三部分（项目）中，学习者将完成几个“现实世界”的开放式项目。在项目课程中，特别强调动态数组函数，这是Office 365中的新功能，革命性地改变了工作表计算方式。 应用学习项目： 在第三部分（项目）中，学习者可选择三个“热身”项目（从五个可选项目中选择）、三个中级项目（从六个可选项目中选择）和三个主要项目（从五个可选项目中选择）。因此，学习者可以通过选择项目来个性化他们的学习体验。每个项目都有提供提示和预览的录屏。 证书信息： 完成课程后可获得可分享证书。课程完全在线学习，您可以立即开始并按自己的节奏学习，灵活设定和维护截止日期。该课程面向初学者，学习大约需要4个月，建议学习时间为每周4小时。 提供语言： 英语，提供英文、阿拉伯文、法文、欧洲葡萄牙文、意大利文、越南文、德文、俄文和西班牙文字幕。 课程链接： - 日常Excel 第1部分：[课程链接](https://www.coursera.org/learn/everyday-excel-part-1) - 日常Excel 第2部分：[课程链接](https://www.coursera.org/learn/everyday-excel-part-2) - 日常Excel 第3部分（项目）：[课程链接](https://www.coursera.org/learn/everyday-excel-projects)
Course Link: https://www.coursera.org/learn/everyday-excel-part-1
Name:Everyday Excel, Part 1
Description:Offered by University of Colorado Boulder. "Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. ... Enroll for free.
Course Link: https://www.coursera.org/learn/everyday-excel-part-2
Name:Everyday Excel, Part 2
Description:Offered by University of Colorado Boulder. "Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on ... Enroll for free.
Course Link: https://www.coursera.org/learn/everyday-excel-projects
Name:Everyday Excel, Part 3 (Projects)
Description:Offered by University of Colorado Boulder. "Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is ... Enroll for free.
What you will learn
In this specialization, you'll learn a variety of Excel tools, techniques, and functions, which you'll apply to real-world, "open-ended" projects.
Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
Skills you will gain
Spreadsheet
Microsoft Excel
Problem Solving
Project
computing
Data Management
Real World
Real-world projects
About this Specialization
36,501
recent views
This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.
Applied Learning Project
In Part 3 (Projects), learners choose three "warm-up" projects (chosen from five potential projects), three intermediate projects (chosen from six potential projects), and three main projects (chosen from five potential projects). Thus, learners have liberty to tailor their experience through choice of projects. Screencasts are provided that show hints and previews for each project.
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Beginner Level
Beginner Level
While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.
Hours to complete
Approximately 4 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Beginner Level
Beginner Level
While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.
Hours to complete
Approximately 4 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English, Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, Spanish
