|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-beginner-to-advanced-2020/
课程评论:没有评论
**课程总结:Microsoft Excel:从入门到高级 2020** **课程概述:** 本课程专为希望提升Excel技能,从而提高在工作、学习或个人项目中的效率的学习者设计。您将学习强大的Excel函数,以自动化工作流程,简化生活。同时,课程还将教授如何设置规范的电子表格,并利用Excel的功能更高效、更轻松地完成工作。 **您将学到:** * **Excel基础:** 数据输入、公式输入及Excel的各项基本功能。 * **高级函数:** 掌握Excel的高级函数应用。 * **数据可视化:** 学习规范的数据格式设置、图表和图形的创建。 * **数据分析:** 深入学习数据透视表、Excel的查找函数(Lookup Functions)。 * **动态查询:** 掌握创建动态查询的方法。 * **财务函数:** 学习使用Excel的财务函数。 * **自动化工具:** 学习创建宏(Macros),并通过密码加密文件。 * **“假设分析”工具:** 掌握Excel的“假设分析”(What-if Analysis)工具。 * **以及更多内容!** 课程中还将分享能给您的雇主或老师留下深刻印象的快捷方式和技巧。 **您需要准备:** * 一台电脑、笔记本电脑或平板电脑。 * 安装有Microsoft Excel软件。 * 学习的意愿。 **无忧学习:** 课程提供30天退款保证。如果您觉得课程不符合您的预期,我们将在30天内全额退款。您可以放心学习,收获满满。
Why this course is for youYou want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You want to learn how to setup clean spreadsheets and use Excel's functions to work much more efficiently and with less effort.The functions and formulas you will learn will teach you how to use Excel from beginner to an intermediate level. Along the way I will teach you shortcuts and tips that will impress any employer or teacher.What you will learn:The basics of excel: how to input numbers, how to input formulas, and the different functions of ExcelAdvanced functionsProper formattingGraphs and chartsPivot tablesExcel's lookup functionsHow to build dynamic queriesFinancial functionsHow to create macrosEncrypt file with a passwordExcel's what if toolsAnd much much more!What you will need:A computer, laptop, or tabletMicrosoft ExcelWillingness to learn 30-day money back guaranteeIn the rare case that you feel the course was not helpful or isn't for you Udemy will refund your money up to 30 days. You have nothing to lose and everything to gain.