|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-bootcamp/
课程评论：没有评论
**课程名称：** Microsoft Excel Bootcamp - 3小时精通Excel！ **课程概述：** 本课程旨在助您成为Excel高手！您将学习高效使用Excel的各项技巧，包括但不限于： * **键盘快捷键：** 掌握比Ctrl+S和Ctrl+C更高级的快捷键，提升操作效率。 * **常用函数：** 精通VLOOKUP、IF、嵌套IF、SUMIFS、COUNTIFS等关键函数。 * **文本函数：** 学习LEFT、RIGHT、TRIM等处理文本的函数。 * **日期函数：** 掌握EOMONTH、EDATE等日期相关的函数。 * **数据分析工具：** 学习使用PivotTables（数据透视表）和Slicers（切片器）进行数据分析。 * **数据处理技巧：** 掌握条件格式、删除重复项、文本分列等实用功能。 **授课特色：** * **互动式学习：** 完成课程可获得积分并解锁您的“灵魂动物”。 * **幽默风趣的讲师：** 避免枯燥乏味的讲解，轻松学习。 * **无废话教学：** 直击核心，传授实用技能。 * **实际应用：** 学习内容可立即应用于实际工作中。 **课程目标：** 学完本课程后，您将能够熟练运用Excel，为进一步学习更高级的Excel课程（如“高级Microsoft Excel”和“Microsoft Excel VBA (宏)”）打下坚实基础。 **兼容性：** 课程内容兼容Excel 2010、Excel 2013 和 Excel 2016。 **重要提示：** 如需获取CPE学分，请务必在我们的网站上完成期末考试。
This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, 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 master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+CVLOOKUP, IF, and Nested IF statementsSUMIFS and COUNTIFSText formulas including LEFT, RIGHT, and TRIMDate formulas including EOMONTH and EDATEPivotTables and SlicersConditional Formatting, Remove Duplicates, and Text-to-ColumnsBy 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 Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) 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.
