|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-microsoft-excel-basics-blended-with-advanced/
课程评论：没有评论
**课程名称：** 精通 Microsoft Excel - 基础与高级融合 **课程概述：** 本课程以一种独特的方式，将 Excel 的基础与高级技能相结合，旨在帮助学员打下坚实的数据分析基础，为进一步学习商业智能（BI）应用做好准备。学员将跟随指导步骤，一步步完成设定的目标。每节课后都设有动手练习，帮助学员巩固所学知识和技能。 课程内容涵盖： * **基础功能：** 数据排序、数据筛选、公式审计。 * **数据分析：** 数据透视表、数据透视图、使用切片器和时间线创建交互式 Excel 仪表板。 * **函数：** 从常用 Excel 函数到高级 Excel 函数的全面讲解。 **学习建议：** * **视频教程：** 鼓励学员观看视频教程并跟随视频中的步骤进行操作。 * **附加任务：** 许多主题都附有额外任务，学员务必尝试完成。 * **深入钻研：** 在某些课程中，设有标记为“深入钻研”（Diving Deep）的挑战性任务。能够独立完成并正确解读“深入钻研”任务的学员，意味着已在该课程内容上达到精通水平。
Mastering Microsoft Excel in a unique way of combining different levels of skills. The course is a good foundation for data analysis en-route to skills for Business Intelligence applications. The students will have will guided by steps on how to accomplish a stated objective. At the end of the lecture, there will be some hand-on assignment that the student must attempt to cement the gained knowledge and skills. The training course starts by introducing you to common functionalities of spreadsheet processing which are data sorting, data filtering and then formula auditing. Thereafter, the course presents more data analytical lessons such as pivot tables and pivot charts, interactive excel dashboard with slicers and timelines for interactive data analysis. At the end the course brings the common excel functions and wind up with advanced excel functions. Where there is a video tutorial, the students are encouraged to watch and follow the steps demonstrated in the video. Other topics has bonus tasks, students must make sure they have attempted. In some lessons, there are some challenging tasks which are labelled as 'Diving Deep'. Once a student is able to do and interpret 'diving deep' assignments then definitely the student has reached mastery level for that lesson
