|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-beginner-to-advance/
课程评论：没有评论
**Coursera 课程：“Microsoft Excel - 从入门到精通” 内容摘要** 本课程旨在帮助您在最短的时间内，从零基础掌握 Microsoft Excel 的各项技能，直至达到高级水平。课程设计循序渐进，内容易于理解，涵盖了 Excel 的所有重要方面。 **课程内容概览：** * **基础入门 (Section One to Five):** * Excel 的启动与界面介绍，包括文本朗读功能的启用。 * 掌握不同的复制粘贴技巧、插入批注、创建自定义填充序列和闪电填充。 * 深入学习 Excel 中的格式设置，并结合模板制作发票，同时全面了解打印设置。 * **函数与公式：** * 学习 SUM, AVERAGE, MIN, MAX 等基本函数和公式。 * 详尽讲解各类单元格引用，并通过实例加深理解。 * 学习逻辑函数，包括如何嵌套函数以获得期望结果。 * 深入掌握数据验证的高级技巧，全面学习数据验证所需知识。 * 学习 industry-standard functions such as VLOOKUP, INDEX & MATCH, SUMIFS，以及其他超过50个关键函数。 * **数据处理与分析：** * 学习排序与筛选，包括高级筛选，使用通配符进行筛选，命名范围，以及文本分列等。 * 全面学习条件格式，并结合使用更高级的函数。 * 学习 Excel 表格 (Tables)、数据透视表 (Pivot Tables)，并初步了解 Power Pivot 以建立多表关联。 * **数据可视化与项目实践：** * 学习如何使用 Excel 图表来可视化数据，包括图表元素和格式设置。 * 完成三个实践项目： * 项目一：基础图表制作。 * 项目二：利用 Power Query 从外部网站获取信息并制作图表。 * 项目三：整合所学知识，创建数据仪表盘 (Dashboard)。 本课程内容充实，旨在全面提升您的 Excel 技能，帮助您在商业发展或职业生涯中运用这项宝贵技能。立即加入，一同开启精通 Excel 的精彩旅程！
In this course, you will learn Microsoft Excel from beginners' level to advance level in the shortest time possible.I have designed this course very carefully to teach you all the important aspects of MS Excel in a step by step and an easy to understand approach.Upon completion of this course, your Excel skill will surely shoot up to a whole different level. And You can implement this valuable skill to develop your business or in pursuing your career.From section one to five, you will learn the fundamentals of MS Excel. We will start from the very beginning, that is, we will start from how to open excel. And then we will learn about excel's startup screen, excel's interface, how to enable text speech and much more.We will also, learn about different types of copying and pasting, and then we will see how to insert comments, how to create custom fill series, flash fills and etc.Then we will take a deep dive about formatting in Excel.And in end of section two we will create an invoice using one of Microsoft's template. We will also thoroughly cover about print setting.And then we will learn about the basic functions and formulas, like, SUM, AVERAGE, MIN, MAX, and many more. We will also cover in detail about all types of cell references with comprehensive examples. When learning about logical functions, we will see how to nest functions, in other words we will see how to combine two or more functions to get the desired results.Then we will also cover some advance techniques in data validation and in fact we will cover everything you need to know about data validationAfterwards, we will learn some of the most popular functions in the industry like, VLOOKUP, INDEX & MATCH, SUMIFS and we will cover more than 50 vital functions in this courseWe will also learn about, sorting and filtering, advance filtering, filtering using wildcard characters, named ranges, text to column and so on.Then, we will cover everything you need to know about conditional formatting. While doing so, we will also see some more advance functions. Then we will learn about tables, pivot tables and we will touch base on power pivot in order to create relationship between multiple tables.In the final section, we will learn how to visualize data using excel charts. We will learn about chart elements, how to format charts and then finally we will be creating three projects. In the second project, we will see how to get information from external websites and create charts from them, which is a part of power query. And then in the project three, we will put everything we learned to create a dashboard.This is gonna be a comprehensive course. I have just given a glimpse of what you will learn in this course. For more information, please check the course outline. I am pretty sure, you will enjoy this journey of mastering Excel with me.So, do join this course now to take your Excel skill to the next level.
