|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/perfectxl-microsoft-excel-course
课程评论：没有评论
课程名称：Excel建模专业人士：最佳实践与陷阱 课程概述：本Excel课程的独特之处在于，我们不专注于快速解决方案或特定的小技巧。该课程面向已具备Excel基础的学习者，旨在提升Excel模型的质量，提高其清晰度、长久性和可转移性，减少错误，并鼓励企业在使用Excel时保持一致性。 通过本课程，学习者将获得评估何时使用Excel解决问题的工具。他们将学习如何正确设置输入数据、进行格式化以及良好文档的重要性。学习者还将掌握区分不同函数的能力，理解常用函数的优缺点，并将正确的函数应用于其Excel模型。此外，学习者将理解逻辑电子表格结构、图形和报告，保护和隐藏信息的概念，以及如何将这些知识应用于自己的模型。最后，学习者将获取有关模型最终定型的实用技巧和步骤，包括自动检查、手动审查以及确保Excel模型准确和完整的常规测试。 课程大纲： 1. 模块名称：打造更好的电子表格基础 描述：在本模块中，您将了解课程目标并获得判断是否存在比Excel更好解决方案的工具。您将学习如何根据最佳实践组织输入数据，区分优劣格式，并获得改善自己格式的实用技巧。最后，您将定义Excel中的文档，并学习如何将良好的文档应用于自己的Excel模型。 2. 模块名称：公式和函数的良好使用 描述：本周将聚焦Excel的核心：函数和公式。您将学习如何负责任地将函数和公式应用于Excel模型，如何在特定场景中选择最合适的函数，并理解和解释不同Excel函数的优缺点。 3. 模块名称：电子表格结构与逻辑流程 描述：在本模块中，您将学习如何构建具有逻辑结构和流程的电子表格，获得简化模型的优质技巧，了解Excel中受保护和隐藏信息的危险性和有效性。您将获得使同事/客户更加理解和安全的电子表格的工具。 4. 模块名称：最后润色 描述：在最后一个模块中，您将学习电子表格的最后调整。您将发现完全优化的电子表格的样子，了解可用于确保正确结果的检查，培养在模型中进行最后检查的技能，以确保最终结果的正确性。检查和测试过程至关重要。利用本模块了解更多有关此过程的内容并将其应用于您的Excel工作中。
Name:A Foundation for Better Spreadsheets
Description:In this module you will learn about this course and course aims. You will be given tools to determine whether or not there are better solutions for a certain task than Excel. You will learn how to organize your input data according to best practices. You will learn how to differentiate between good and bad formatting in Excel, and you will receive some practical tips on how to improve your own formatting. Finally you will be able to define documentation in Excel, and learn how to apply good documentation to your own Excel models.
Name:Good Use of Formulas and Functions
Description:This week is about the lifeblood of Excel: the functions and formulas. You will learn how you can apply functions and formulas to your Excel models responsibly, how you can discern between functions to choose the ones that work best for you in a particular scenario, and how you can understand and explain the strengths and weaknesses of different Excel functions.
Name:Spreadsheet Structure and Logical Flow
Description:In this module you will learn how to build up a spreadsheet with a logical structure and flow, you will get some great tips on keeping your models simple, and you will learn about the dangers and effectiveness of protected and hidden information in Excel. Essentially you will gain the tools to make your spreadsheets safer and more understandable for your colleagues/clients.
Name:Finishing Touches
Description:In this final module you will learn about the final things to do in a spreadsheet. You will discover what the result of a fully optimized spreadsheet looks like, which checks you can build in to ensure correct results, and you will gain the skills for last minute checks in your model to ensure the final result is correct. The checking and testing process is incredibly important. Use this module to learn more about that process and apply it to your own work in Excel.
What sets this Excel course apart is that we don’t focus on quick fixes or specific tips and tricks. This course is for those who already understand Excel. The aim of the course is to elevate Excel models, to improve clarity, longevity, and transferability of these models, and to reduce mistakes and to encourage consistency in businesses as they work with Excel. Through this Excel course learners will gain the tools to decide whether or not to use Excel to solve their problem. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their Excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models. Finally users will get practical tips and steps for the finalization of a model, the automated checks, the manual run through, and general testing that one should do to ensure that their Excel model is accurate and complete.
