|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-excel-with-practical-real-world-scenarios/
课程评论：没有评论
Coursera 课程：通过实际案例精通 Excel 本课程（Master Excel with Practical real world scenarios）旨在通过贴近实际工作场景和案例，教授 Microsoft Excel 的使用技巧。学习者将掌握的技能可直接应用于工作和项目。 课程内容从 Excel 基础入手，共包含五个部分，适合 Excel 新手入门。之后，课程将深入探讨 Excel 的强大功能，通过大量真实案例展示其应用，并包含一些鲜为人知的实用技巧。 课程涵盖的主题包括但不限于： * 数据验证 (Data Validation) * 填充助手 (Flashfill) * 从零开始制作 Excel 甘特图 (Gantt Chart) * 制作家庭月度收支追踪表 (Monthly expense tracker) * 无需编码即可创建数据录入表单 (Data entry forms without coding) * Power Query 介绍及其在实际数据中的应用 (Power Query Intro and use on actual data) * NPV 函数与货币时间价值的应用 (NPV function to understand the time value of money) * 序列化 Vlookup 比较两份清单 (Using Vlookup in serial fashion to compare two lists) 此外，课程还涉及其他进阶概念，如数据透视表 (pivot tables)、NVp 等。 课程目标是帮助学习者达到中级 Excel 用户水平。强调通过实践来巩固所学知识，鼓励学习者“亲自动手”，将所学概念应用到实践中，以期掌握能终生受益的技能。
This Course will teach you Microsoft Excel using practical real world situations and scenarios. The skill set acquired here will be directly applicable in your job or projects. This is a beginner level course but has plenty of material for experienced people to learn including pivot tables, power query, Gantt charts, expense trackers, data entry forms, VLOOKUP, time value of money, NPV and many more concepts.The first five sections are for learning Excel Foundations. You will learn about working in Excel and following every lesson will prove extremely beneficial for you, if you are new to MS Excel.The 6th and the largest sections is filled with many case studies, where you will see MS Excel's power used in actual situations. This section also includes some much needed and less known tips as well. Some of the Topics are given below:Data ValidationFlashfillGantt Chart in Excel from scratchHow to make Monthly expense tracker for FamilyMaking data entry forms without codingPower Query Intro and use on actual dataUsing the NPV function to understand the time value of moneyUsing Vlookup in serial fashion to compare two listsThese lectures and real world cases are intended to bring you at par with an intermediate user of Excel. However, polishing any skill requires practice. You can call it "sharpening the saw" as Stephen covey puts it. The best way to learn Excel is to get your hands dirty and apply all these concepts by hand. Only then you will learn something that will stay with you for life.
