|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-from-medium-to-advanced/
课程评论：没有评论
## Coursera 课程总结：Microsoft Excel从中级到高级 本课程旨在帮助您**高效运用Microsoft Excel**，特别适合**中级和高级用户**。 在约3小时的课程中，您将深入学习以下核心内容： * **函数应用**：精通IF函数、嵌套IF函数、IF与逻辑函数（AND, OR, NOT）的综合运用。 * **查找与引用**：熟练掌握VLOOKUP、XLOOKUP（适用于Microsoft 365/Office 2021及以上版本）、INDEX和MATCH函数在复杂场景下的应用，包括多ID查找和跨多列检索数据。 * **数据透视表与图表**：进行深入的数据透视表分析和多样的图表创建。 * **错误处理与数据分析工具**：学习使用IFERROR和AGGREGATE处理错误，掌握GOAL SEEK（单变量求解）、SOLVER（规划求解）等高级分析工具。 * **数据管理与格式化**：学习高级筛选、创建条件格式自定义规则，以及实现数据验证中的嵌套列表功能。 课程设计**灵活便捷**，每节课时长在5至20分钟之间，支持您**随时随地、按个人节奏**学习。每节课都提供原始数据和完成后的示例文件，方便您跟着操作。 **为什么选择本课程？** * **提升技能**：全面构建您的Excel知识体系。 * **职业发展**：为跳槽或在同一公司内寻求职业晋升打下坚实基础。 **兼容性说明**：本课程兼容所有Microsoft Excel版本，但XLOOKUP、TEXTSPLIT、TEXTBEFORE、TEXTAFTER函数仅适用于Microsoft 365或Microsoft Office 2021及以上版本。
This training covers knowledge you need to work efficiently in Microsoft Excel.This is a training for intermediate and advanced level.In approximately 3 hours you will learn about Microsoft Excel IF function, nested IF functions, IF and logical functions, lookup functions VLOOKUP, XLOOKUP, INDEX and MATCH in more complex scenarios (multiple IDs, drag formula right for retrieving values from multiple column), pivot table in depth, charts in depth, error handling using IFERROR and AGGREGATE, GOAL SEEK, SOLVER, advanced filters, custom rules for conditional formatting, data validation with nested lists, etc.Each lesson in between 5 and 20 minutes, to be easily accessible from anywhere, anytime, at a pace you choose. In the lessons resources you will find the original source and the completed one, to be more accessible for you to follow along my examples.We all need a software for entering data, preparing and processing data, data analysis, creating reports. Because it is wide spread, Microsoft Excel is a very common solution.You can choose this training because:- you want to improve your knowledge- you want to change jobs- you want to change companiesThis training is compatible with all versions of Microsoft Excel, except XLOOKUP, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, that are available only in Microsoft 365 or from Microsoft Office 2021 version.
