|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/everyday-excel-part-2
课程评论：没有评论
课程名称：每日Excel，第二部分 课程概述：“每日Excel，第二部分”是热门课程“每日Excel，第一部分”的延续。在这个课程中，您将继续扩展Excel应用的知识。该课程针对中级用户，但即使是高级用户也能掌握新的技能和工具。完成本课程后，您将具备参与项目为基础的“每日Excel，第三部分（项目）”的技能和工具。 本课程是一个三部分系列和专业化课程的第二部分，专注于教授从入门到高级的Excel技术和工具。在本课程中，您将学习：1) 高级数据管理技术；2) 在Excel中实现财务计算；3) 使用Excel中的高级工具（数据表、目标寻求和求解器）进行“假设”分析；4) 如何使用Excel中的回归工具来创建数学预测回归模型。 这门课程旨在让学习的过程变得有趣和引发思考。我们希望您在课程中的某些时刻会感叹：“哇，我从未考虑过这个！”鉴于学习者的经验和能力差异，课程目标是吸引广泛的受众。课程分为五周（模块）。 每个模块通过掌握测验和解决问题的作业来完成。该课程的独特之处在于每周作业是在您的计算机上使用Excel进行的，为您提供了宝贵的实践训练。 课程大纲： - 第1周：高级数据管理 学习Excel内的高级数据管理策略，包括双向查找、条件下拉列表、条件格式设置等。 - 第2周：财务应用Excel，第1部分 学习关于货币时间价值、简单和复利的Excel公式及贷款的创建与管理。 - 第3周：财务应用Excel，第2部分 学习折旧计算、现金流、净现值和内部收益率（IRR）等高级财务功能。 - 第4周：案例研究与“假设”分析 关注Excel在案例研究和“假设”分析中的应用，学习数据表和目标寻求工具的使用。 - 第5周：Excel中的模型构建 学习如何创建数学模型，包括线性回归和逻辑回归模型，并使用Excel的回归工具。 完成每个模块后，您将获得“完成代码”，可以用于提交作业以获得相应的学分。完成“每日Excel，第二部分”后，您可以为自己感到自豪！
Name:Advanced Data Management
Description:In Week 1 you will learn all about advanced data management strategies in Excel. These techniques include two-way look-ups, two-way conditional look-ups, how to find the maximum or minimum location in an array, conditional drop-down lists, advanced conditional formatting strategies, how to compare lists (for unique, duplicates, and absent items), advanced duplicate management, and how to work with expiry dates. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. For paid learners, the Week 2 Excel files will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
Name:Excel for Financial Applications, Part 1
Description:In Weeks 2 and 3 you will learn all about advanced financial functions and applications in Excel. In Week 2, you will first learn about the concepts of and how to implement Excel formulas for the time value of money, simple and compound interest, and various loans (amortized, interest-only, and line of credit loans). You will learn how to create amortization schedules in Excel for these loans. Week 2 concludes with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 2, you will be given a "completion code", which you can input into the Assignment 2 submission quiz to earn credit for the assignment. For paid learners, the Week 3 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!
Name:Excel for Financial Applications, Part 2
Description:In Week 3, you will continue learning about advanced financial features of Excel. First, you will learn about depreciation and how to calculate depreciation and implement depreciation schedules in Excel. Next, you will learn about cash flows and net present value, and how to implement Excel functions to analyze cash flows. Then, you will learn how to compare financial alternatives. Finally, you'll learn about internal rate of return (IRR) and how to implement the IRR function in Excel. The week concludes with Quiz 3 and Assignment 3. When you successfully complete Assignment 3, you will be given a "completion code", which you can input into the Assignment 3 submission quiz to earn credit for the assignment. For paid learners, the Week 4 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!
Name:Case Studies and "What-If" Analyses
Description:One of the most valuable aspects of Excel is that it can be used nicely for case studies and "what-if" analyses. In Week 4, you'll learn about case studies, one-way and two-way data tables, and how to use the Goal Seek and Solver tools for targeting calculations. You'll also learn to use the Solver tool for optimization problems and problems for which you have constraints. The week concludes with Quiz 4 and Assignment 4. When you successfully complete Assignment 4, you will be given a "completion code", which you can input into the Assignment 4 submission quiz to earn credit for the assignment. For paid learners, the Week 5 Excel files will be released when you have successfully passed Quiz 4 and Assignment 4. Good luck!
Name:Model Building in Excel
Description:Week 5 of the course is all about creating mathematical models for experimental data. In this week, you'll first learn about how to insert trendlines into Excel plots and how to linearly interpolate between data points. Next, you'll learn about simple linear regression, general linear regression, and multilinear regression models and how to use Excel's Regression tool to create these regression models. The week concludes with an introduction to the logistic regression model, which is a type of nonlinear regression model. The week concludes with Quiz 5 and Assignment 5. When you successfully complete Assignment 5, you will be given a "completion code", which you can input into the Assignment 5 submission quiz to earn credit for the assignment. Then, you can pat yourself on the back for completing "Everyday Excel, Part 2!"
"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)". This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) learn advanced data management techniques; 2) learn how to implement financial calculations in Excel; 3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses; 4) learn how to create mathematical predictive regression models using the Regression tool in Excel. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!" Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
