|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-microsoft-excel/
课程评论：没有评论
**课程名称：** 高级Microsoft Excel - 提升您的技能至新境界！ **课程概述：** 本课程旨在帮助您将Excel技能提升至全新水平，成为Excel大师。您将学习Excel中最强大的函数，如INDEX/MATCH、MIN/MAX等，掌握高级数据透视表工具，并通过VBA宏自动化您的工作。 **课程亮点：** * **独特学习体验：** 完成课程可赚取积分并解锁您的“精神动物”，拥有不枯燥的互动式教学。 * **内容充实：** 课程内容聚焦实用技术，无冗余信息，学完即可投入实际工作。 * **广泛适用性：** 无论您如何使用Excel，本课程都能为您带来实质性提升。 **学习内容：** * **高级公式：** 掌握INDEX/MATCH、MIN/MAX等强大函数。 * **高级数据透视表：** 提升数据分析能力。 * **命名范围：** 高效使用高级公式。 * **数据保护：** 学习数据验证等技术保护您的数据。 * **增强IF语句：** 结合AND/OR函数。 * **快捷键：** 掌握比Ctrl+S、Ctrl+C更高级的快捷键。 **课程目标：** 学完本课程后，您将成为Excel方面的专家，并能为后续的Microsoft Excel VBA（宏）课程打下坚实基础。 **重要提示：** * 如需CPE学分，请在课程官网上完成期末考试。 * 本课程适用于Excel 2010、Excel 2013和Excel 2016版本。
Take your Excel skills to a whole new level! Our Advanced Excel course will give you the Excel skills to become an Excel master. You'll learn Excel's most powerful functions including INDEX/MATCH, learn advanced PivotTable tools, automate your work using VBA Macros, and more!WHAT MAKES OUR EXCEL COURSE UNIQUE?Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleepG-rated humor and lighthearted lessonsZERO FLUFF!Real world application that you can start applying todayWHAT YOU'LL BE LEARNINGThis course will help you take your Excel skills to an advanced level. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:Powerful formulas such as INDEX/MATCH, MIN/MAX, and moreAdvanced PivotTable functions to better analyze your dataUtilize named ranges to efficiently work with advanced formulasProtecting your data using Data Validation and other techniquesEnhancing IF statements by incorporating AND/OR formulasKeyboard shortcuts beyond the simple Ctrl+S or Ctrl+CBy the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Microsoft Excel VBA (Macros) course which builds off of the Macros portion of this course.__________NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.
