|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-microsoft-excel-formulas/
课程评论：没有评论
**课程名称：** Microsoft Excel: 掌握 Excel 函数与公式 **讲师：** Ahmed Oyelowo (5 次微软 MVP，2018 年起成为微软认证讲师，Microsoft Office 专家 - Excel 专家) **课程概述：** 本课程旨在通过大量实际案例，帮助学习者熟练掌握超过 50 个日常使用的 Excel 函数，并学会如何编写以及组合多个函数来构建复杂的 Excel 公式。课程还将深入讲解单元格引用的逻辑，这是编写精确公式、方便跨单元格复制公式的核心。 **学习内容：** * **常用函数：** * **聚合函数：** SUM, AVERAGE, COUNT, COUNTA, LARGE, SMALL, MIN, MAX * **文本函数：** LEFT, RIGHT, MID, FIND, SEARCH, LEN, UPPER, LOWER, CONCATENATE, CONCAT, TEXTJOIN * **日期函数：** DATE, DAY, MONTH, YEAR, EDATE, EOMONTH, NETWORKDAYS, NETWORKDAYS.INTL, WEEKNUM, WEEKDAY, DATEDIF * **数据分析函数：** COUNTIF, SUMIF, COUNTIFS, AVERAGEIF, SUMIFS * **逻辑函数：** IF, AND, OR * **查找函数：** VLOOKUP, XLOOKUP, MATCH, INDEX * **函数组合：** 学习将多个 Excel 函数轻松地嵌套在一个公式中。 * **单元格引用：** 理解单元格引用的基本原理，并运用到公式的编写和复制中。 **学习资源：** * 课程提供两套 Excel 工作簿文件： * 一套由讲师使用的文件，供学习者跟随课程进行操作。 * 另一套供学习者自行练习，并包含自动评分功能，完成练习后可获得反馈。
Microsoft Excel: Mastering Excel Functions and Formulas:This excel course is taught by Ahmed Oyelowo, who is a 5-time Microsoft MVP, Microsoft Certified Trainer since 2018 and also a Microsoft Office Specialist (Excel Expert).In this course, you will learn, with practical examples, how to use over 50 everyday Excel functions to write Formulas in ExcelYou will also be learning an easy way of combining multiple Excel functions inside a single Excel formula.The course comes with 2 sets of Excel Workbook files.One used by the instructor which you should use to follow along in the lessons andThe other one for your own practice. The practice file will automatically mark you once you have completed the exercises in there.You will also learn the logic of Cell Referencing, which is the back bone of writing accurate formulas when you need to replicate formulas across multiple cells in Excel.What functions will you learn in this course?Aggregate functions in ExcelSUMAVERAGECOUNTCOUNTALARGESMALLMINMAXText functions in ExcelLEFTRIGHTMIDFINDSEARCHLENUPPERLOWERCONCATENATECONCATTEXTJOINDate functions in ExcelDATEDAYMONTHYEAREDATEEOMONTHNETWORKDAYSNETWORKDAYS.INTLWEEKNUMWEEKDAYDATEDIFData Analysis Function in ExcelCOUNTIFSUMIFCOUNTIFSAVERAGEIFSUMIFSLOGICAL Functions in ExcelIFANDORLookup functions in ExcelVLOOKUPXLOOKUPMATCHINDEX
