|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-excel-2021-beyond-the-basics-an-intermediate-course/
课程评论：没有评论
**课程名称：** Microsoft Excel 2021/365: 中级培训 **课程概览：** 本课程是 Excel 2021 系列的第二部分，旨在帮助学员在初级课程的基础上，进一步拓展 Excel 技能，熟练掌握中级应用。课程提供练习和演示文件。 **课程内容：** * **公式与函数：** 创建中级公式，运用逻辑函数做出更优的商业决策，构建功能性和灵活性的查找公式，掌握日期和时间函数，以及利用文本函数提取数据。 * **数据管理与分析：** 使用 Excel 表格结构化数据并方便更新，提取列表中的唯一值，运用高级功能和新款公式进行数据排序和筛选，导入和清理数据以备分析。 * **数据可视化与交互：** 使用数据透视表 (PivotTables) 分析数据，通过数据透视图 (PivotCharts) 直观展示数据，为数据透视表和数据透视图添加交互性，创建交互式仪表板展示关键指标。 * **新功能探索：** 重点介绍 Excel 2021 的新功能和函数，特别是动态数组函数，如 XLOOKUP、XMATCH、FILTER 等。 * **数据验证与分析工具：** 学习使用验证规则控制数据输入，利用 What-If 分析工具观察输入变化对结果的影响。 * **表格设计与错误排查：** 探索电子表格设计的原则，以及公式审计和常见 Excel 错误故障排除。 **适合人群：** * 具备 Excel 初级知识，希望进阶学习 Excel 高级功能的学员。 * 使用过旧版本 Excel，具备初级到中级技能，并希望学习 Excel 2021 新功能的学员。 **先修课程：** * Excel 初级知识。 * 拥有 Excel 2021 工作版本。 **课程包含：** * 9 小时以上视频教程。 * 84 个独立视频讲座。 * 课程和练习文件（供学员跟随学习）。 * 结业证书（完成课程后）。
***Exercise and demo files included***In this second installment of our Excel 2021 course series, you can expand your Excel foundation beyond what you've learned in the beginners' course and take your skills up another notch.During this course, you will create intermediate-level formulas, prepare data for analysis using PivotTables and PivotCharts, make use of WhatIf analysis tools, learn how to use validation rules to control data input, and explore the fundamentals of spreadsheet design.And we are just getting started!You will also get to discover all the new features and functions available in Excel 2021, the latest standalone version of Microsoft Excel.Explore the exciting world of dynamic array functions and learn how to use XLOOKUP, XMATCH, FILTER, and so much more.This Excel 2021 Intermediate course is designed for those with beginner-level knowledge of Excel who are looking to take advantage of the application's more advanced features. It's also suitable for individuals who have beginner to intermediate skills using an older version of Excel.The only prerequisites for this course are beginner-level knowledge of Excel and a working copy of Excel 2021.This course covers:Designing better spreadsheets and controlling user inputHow to use logical functions to make better business decisionsConstructing functional and flexible lookup formulasHow to use Excel tables to structure data and make it easy to updateExtracting unique values from a listSorting and filtering data using advanced features and new Excel formulasWorking with date and time functionsExtracting data using text functionsImporting data and cleaning it up before analysisAnalyzing data using PivotTablesRepresenting data visually with PivotChartsAdding interactions to PivotTables and PivotChartsCreating an interactive dashboard to present high-level metricsAuditing formulas and troubleshooting common Excel errorsHow to control user input with data validationUsing WhatIf analysis tools to see how changing inputs affect outcomes.This course includes:9+ hours of video tutorials84 individual video lecturesCourse and exercise files to follow alongCertificate of completion
