|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-excel-functions-macros-and-vba-training/
课程评论：没有评论
Coursera 上的“高级 Excel 函数、宏和 VBA 套件”课程是一门进阶课程，专为已经具备 Excel 中级知识的学习者设计。该课程分为两个部分，旨在帮助您通过高级函数、公式、宏和 VBA 来提升电子表格的处理能力。 **课程亮点：** * **函数与公式进阶：** * 学习使用公式过滤和排序数据集。 * 创建多级动态下拉列表。 * 掌握 2 向查找、复杂逻辑计算和文本字符串提取。 * 制作动态图表标题。 * 查找列表中值的最后出现位置。 * 运用 XLOOKUP 进行信息查找。 * 实现查找最接近值的功能。 * **宏与 VBA 自动化：** * 了解 Excel 宏的实际应用。 * 学习 VBA 的基础知识。 * 掌握录制宏（包括相对引用）的技巧。 * 学会录制复杂宏并将其分配给按钮。 * 设置和编辑 VBA 编辑器。 * 学习编写基础 VBA 代码。 * 掌握使用调试工具解决宏问题的技巧。 * 从头开始编写自己的宏。 * 创建自定义宏功能区并整合您的宏。 **课程特色：** * **动手实践：** 提供可下载的随堂练习文件，让您可以立即练习所学内容。 * **内容丰富：** 包含超过 4 小时的视频教程，共 27 个独立视频讲座。 * **专业指导：** 由经验丰富的导师授课，内容实用且易于理解。 * **认证证书：** 完成课程后可获得结业证书。 本课程适合那些希望更深入地探索 Excel 功能，从而提高数据清理、分析、数据收集表设置以及创建自动更新图表效率的学习者。 **先决条件：** 需要具备 Excel 中级知识。
**Includes downloadable follow-along files**In this two-course bundle, we take you through how to perform a number of tasks in Excel by utilizing advanced functions and formulas, before moving onto how to use Macros and VBA to automate and supercharge your spreadsheets!If you've used Excel a lot, but you know that you could be doing more with it, then this two-part course is for you. You'll learn skills that will help you clean data, perform analysis, set up spreadsheets to collect data, and create amazing-looking charts that auto-update.This course includes follow-along instructor files so you can immediately practice what you learn. This class is not for Excel beginners. You will need an intermediate knowledge of Excel to get the most from these videos.In the Advanced Functions and Formulas part of the course you will learn how to:Filter a dataset using a formulaSort a dataset using formulas and defined variablesCreate multi-dependent dynamic drop-down listsPerform a 2-way lookupMake decisions with complex logical calculationsExtract parts of a text stringCreate a dynamic chart titleFind the last occurrence of a value in a listLook up information with XLOOKUPFind the closest match to a valueIn the Macros and VBA part of the course you will learn:Examples of Excel MacrosWhat is VBA?How to record your first macroHow to record a macro using relative referencesHow to record a complex, multi-step macro and assign it to a buttonHow to set up the VBA EditorHow to edit Macros in the VBA EditorHow to get started with some basic VBA codeHow to fix issues with macros using debugging toolsHow to write your own macro from scratchHow to create a custom Macro ribbon and add all the Macros you've created4+ hours of video tutorials27 individual video lecturesInstructor files to practice as you learnCertificate of completionHere's what our students are saying…"So far, this is another phenomenal course that is practical and easy to follow along."- Cecil"It's a great course and I'm really starting to learn some really useful and valuable things Excel can do - thank you! Great tutor as well."- Kevin"Great content and comprehensive."- Wyatt
