|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2021-365-masterclass-excel-advanced-course/
课程评论：没有评论
**课程名称：Microsoft Excel 2021/365 精通：高级Excel课程** **课程概述：** 本课程为期十小时，由专家指导，旨在帮助您深入掌握Excel的高级功能，包括高阶数据整合、分析和财务数据报告。这是我们Excel 2021系列课程的第三部分，在您掌握了初级和中级课程的技能后，本课程将助您快速成为Excel的超级用户。 课程内容涵盖Microsoft的最新更新，例如LET和LAMBDA函数，让您能够创建自定义变量甚至Excel函数。您将学习最常用且与业务最相关的函数和公式，包括动态数组函数、预测函数、统计函数、数据透视表、数据透视图、Power Query、宏VBA等。 本课程旨在激发您以全新的方式解决问题，并鼓励您组合运用Excel的各种强大功能来完成实际任务。 **目标学员：** * 已对Excel有良好基础，希望提升技能水平的学生。 * 在旧版本Excel方面拥有丰富经验，希望了解和掌握新版本功能的用户。 **课程重点内容：** * 运用新的动态数组函数完成任务。 * 创建高级且灵活的查找公式。 * 使用统计函数进行数据排名，计算中位数和众数。 * 利用数学函数处理财务数据，得出准确结果。 * 通过LET和LAMBDA函数创建自定义变量和函数。 * 掌握高级数据透视表和数据透视图技巧，进行数据分析。 * 结合表单控件创建交互式报表和仪表板。 * 使用Power Query进行数据导入和清理。 * 利用预测函数和预测工作表预测未来数值。 * 录制和运行宏以自动化重复性任务。 * 理解并进行VBA代码的初步编辑。 * 组合运用函数创建实用的公式以完成特定任务。 **课程包含：** * 10小时的视频教程。 * 87个独立的视频讲座。 * 可供学习和练习的课程及练习文件。 * 课程结业证书。 **学生评价：** “到目前为止，这门课程非常适合我。一切都解释得很详细，而且很容易理解。” - Kirsten Morales
**This course includes downloadable course instructor files and exercise files to work with and follow along.**With this ten-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial data.This is the third part of our Excel 2021 course series, where you can build on the skills learned in the beginner and intermediate courses and fast-track your way to being an Excel power user.This course covers the latest updates from Microsoft, including the LET and LAMBDA functions, which allow you to create your own variables and even Excel functions.Excel 2021 Advanced will show you how to use the most business-relevant functions and formulas you might need, such as dynamic array functions, forecasting, statistical functions, PivotTables, PivotCharts, Power Query, Macro VBA, and so much more!This course is designed to inspire you to approach problem-solving differently and encourage you to combine Excel's myriad of functions to complete practical tasks.This Excel 2021 masterclass is for students who already have a good understanding of Excel and want to take their capabilities to the next level. It's also suitable for students with significant experience in an older version of the software.What we cover in this course:Using the NEW dynamic array functions to perform tasksCreating advanced and flexible lookup formulasUsing statistical functions to rank data and to calculate the MEDIAN and MODEProducing accurate results when working with financial data using math functionsCreating variables and functions with LET and LAMBDAAnalysing data with advanced PivotTable and PivotChart hacksCreating interactive reports and dashboards by incorporating form controlsImporting and cleaning data using Power QueryPredicting future values using forecast functions and forecast sheetsRecording and running macros to automate repetitive tasksUnderstanding and making minor edits to VBA codeCombining functions to create practical formulas to complete specific tasks.This course includes:10 hours of video tutorials87 individual video lecturesCourse and exercise files to follow alongCertificate of completionHere's what our students are saying.★★★★★ "So far, it is a good match for me. Everything is explained in better detail and is simple to understand." -Kirsten Morales
