|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-365-bootcamp/
课程评论：没有评论
课程名称：Microsoft Excel 365 入门营 课程概述：Microsoft Excel 365 入门营是一门旨在帮助学生精通 Excel 365 的课程，让学员了解到 Excel 365 的各种细微差别。课程从基础知识开始，逐步深入到更高级的概念、工具和技术，适合希望学习 Excel 多样化应用的学生。完成课程后，学员不仅能够掌握 Excel 的应用，还能够在各种场合运用 Excel。未来的业务分析师、商业智能分析师和数据分析师可以利用 Excel 进行数据可视化、生成数据透视图和数据透视表、进行统计分析、求解方程。本课程的设计旨在传授上述技能。课程采用实践学习的方式，所有讲座均在 Excel 中进行，采用动手实践的方法。通过实际案例阐释概念，并利用真实数据演示各种 Excel 工具。课程结束时，学员将具备利用 Excel 提供商业解决方案的能力。 课程内容包括： 1. Excel 介绍 2. 数据导入 3. Excel 基本操作 4. 统计函数及应用 5. Excel 中的逻辑运算符和条件语句 6. 数据可视化 7. 在 Excel 中求解方程 8. 情景分析 9. 查找和匹配函数 10. 数据透视表和图表 11. Excel 中的统计数据分析
Microsoft Excel 365 Bootcamp is a course that has been designed to allow students to master Excel 365 and learn all the nuances of Excel 365. In this course I begin with the very basics, and then advance step by step to more advanced concepts , tools and techniques that can be used in Excel. The course is designed for those who want to learn the diverse range of applications that Excel is capable of. This course will allow students to not only master Excel applications, but also to use Excel in a wide variety of situations upon completion of the course. Budding business analysts, business intelligence analysts, data analysts can use Excel to visualise data, generate pivot plots and tables, conduct statistical analysis, solve equations, and this course is designed to impart the aforementioned skills to students. The course uses a learning by doing format, which means that all the lectures are taught in Excel with a hands on approach. Real world examples are used to demonstrate concepts, and practical data is used to demonstrate various Excel tools. At the end of the course, students will be well equipped to use Excel for providing business solutions. The course teaches the following topics:1. Introduction to Excel2. Importing Data3. Basic Operations in Excel4. Statistical functions and applications.5. Logical Operators and Conditional Statements in Excel6. Data Visualisation.7. Solving Equations in Excel8. What if analysis9. Look up and match functions.10. Pivot tables and charts11. Statistical Data Analysis in Excel
