|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-intermediate-2
课程评论：没有评论
课程名称：商业Excel技能：中级II 课程概述：电子表格软件已成为全球职场中最普遍使用的软件之一。自信地操作该软件意味着为您的就业能力增加一个极具价值的资产。在我们Excel专业的第三门课程中，您将更深入地探讨Excel最强大的几项功能。完成课程后，您将能够： - 检查和防止电子表格中的错误； - 在电子表格中创建强大的自动化； - 应用高级公式和条件逻辑，帮助做出明智的商业决策； - 创建帮助预测和建模数据的电子表格。 我们的教学团队将陪伴您完成每一步，Nicky、Prashan和我会每周指导您。在探索这些更高级的主题时，我们将跟随Excel顾问Alex，他经常被企业邀请来解决电子表格中出现的问题。 课程大纲： - 数据验证：本模块介绍数据验证和条件格式的创建与应用，以及在数据验证中使用公式的基础和高级知识。 - 条件逻辑：学习Excel中的逻辑函数，了解公式中的条件逻辑概念，进行逻辑测试，并使用条件操作，掌握嵌套IF函数以评估数据。 - 自动查找：学习如何查找来自工作簿不同部分的信息，介绍CHOOSE、VLOOKUP、INDEX、MATCH等动态查找函数。 - 公式审计与保护：学习如何检查错误、追踪前置和后依、解决循环引用，以及保护工作表和工作簿以防进一步损坏。 - 数据建模：基于输入、假设和结果对不同场景进行建模，了解如何使用“目标求解”、“数据表”和“场景管理器”等功能来增强模型的稳健性。 - 录制宏：学习自动化，识别宏的用途，以及如何创建、编辑和管理宏，提高工作效率。 - 最终评估：课程结束后的评估阶段。
Name:Data Validation
Description:We kick off this course with data validation and conditional formatting. This module takes you through creating and applying data validation, as well as working with formulas in data validation. This is followed by basic and advanced conditional formatting.
Name:Conditional Logic
Description:Excel has several logical functions and this module explores some of them. Start by learning the concept of conditional logic in formulas, followed by how to conduct logic tests and use conditional operations, to your benefit. We will also look at nested IF functions to evaluate data.
Name:Automating Lookups
Description:How do you find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.
Name:Formula Auditing and Protection
Description:If you are worried that errors have crept into your worksheet, this module will show you how to check for errors, trace precedents and dependents, resolve circular references, and finally, protect your worksheets and workbooks from further harm.
Name:Data Modelling
Description:This module is all about data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.
Name:Recording Macros
Description:We all love a bit of automation, and this module teaches you just that. By the time you have completed this module, you will be able to identify the uses of macros, as well as create, edit and manage them to increase your efficiency.
Name:Final Assessment
Description:
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer. When you have successfully completed the course you will be able to Check for and prevent errors in spreadsheets; Create powerful automation in spreadsheets; Apply advanced formulas and conditional logic to help make informed business decisions; and Create spreadsheets that help forecast and model data. Once again, we have brought together a great teaching team that will be with you every step of the way. Nicky, Prashan and myself will guide you through each week. As we are exploring these more advanced topics, we are following Alex who is an Excel consultant called in by businesses that experience issues with their spreadsheets.
