|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/important-functions-with-microsoft-excel/
课程评论：没有评论
**课程名称：Microsoft Excel 重要函数解析** **课程概述：** 本课程旨在帮助学习者掌握Microsoft Excel中最常用、最强大的函数，从而极大地简化数据处理和计算工作。Excel作为一款功能强大的电子表格软件，在个人、学生和职场中都发挥着重要作用，而函数是其核心优势所在。无论是简单的单元格计算，还是处理大量数据的复杂任务，函数都能提供高效的解决方案。 **课程内容亮点：** 本课程将涵盖 Excel 中近 500 个内置函数中的一部分精选函数，包括但不限于： * **日期与时间函数：** NOW、TODAY、DAY、MONTH、YEAR、DATE、HOUR、MINUTE、SECOND、TIME、NETWORKDAYS、WORKDAY、WEEKDAY、WEEKNUM 等，用于处理和分析日期时间数据。 * **工程函数：** CONVERT，用于单位转换。 * **逻辑与信息函数：** ISBLANK、ISERROR、ISNUMBER、ISTEXT、ISFORMULA、ISODD、ISEVEN、AND、OR、NOT、IF、IFERROR 等，用于条件判断和错误处理。 * **查找与引用函数：** VLOOKUP、HLOOKUP、INDEX、MATCH、ROW、COLUMN、ROWS、COLUMNS、HYPERLINK、TRANSPOSE 等，用于高效的数据查找和引用。 * **统计函数：** COUNT、COUNTA、COUNTBLANK、COUNTIF、COUNTIFS、SUM、SUMIF、SUMIFS、MIN、MAX、LARGE、SMALL、MINIFS、MAXIFS、MODE、RANK 等，用于数据计数、汇总和统计分析。 * **数学函数：** RAND、RANDBETWEEN、ROUND、ROUNDUP、ROUNDDOWN、INT、MROUND、CEILING.MATH、FLOOR.MATH、MOD、SUBTOTAL、AGGREGATE 等，用于数值计算和四舍五入。 * **文本函数：** LEFT、RIGHT、MID、LEN、FIND、SEARCH、REPLACE、SUBSTITUTE、TRIM、CLEAN、CONCAT、TEXTJOIN、UPPER、LOWER、PROPER 等，用于文本处理和格式化。 **课程特色：** * **循序渐进的教学方式：** 每个函数都将进行详细的步骤讲解，并清晰阐述其所需条件。 * **实践性强：** 课程包含 9 个章节，共 38 个视频课程，时长通常在 4-10 分钟，确保学习效率。 * **覆盖全面：** 既包含热门且必学的函数，也介绍了一些鲜为人知但非常有用的函数。 * **适合人群：** 具备基本 Excel 知识的学习者均可轻松掌握。零基础学习者建议先学习“Microsoft Excel for Complete Beginners”课程。 * **证书激励：** 完成课程后将获得结业证书。 **总结：** 本课程是学习和掌握 Microsoft Excel 函数的理想途径。通过系统学习，您将能够更有效地处理数据，提高工作效率，充分发挥 Excel 的强大功能。
Microsoft Excel is one of the most powerful and widely used spreadsheet programs in the worldIt has the power to perform calculations and tasks to simplify our work. Whether you are using Excel personally, as a student or at work, the reason for using it is most probably to do some sort of calculation or perform a task of some sort.Functions are tools found in Microsoft Excel to make this process easier for us. If you were to individually add the values in 2 cells together, a simple formula telling Excel to add Cell A to Cell B (Cell A + Cell B) would work well.But what if you have to add the values of 100 or 1000 or more cells together??? Surely you can't individually type that into a formula, and therefore Excel has functions, in a case like this the SUM function, to make this a very simple operation.This is just one example of how functions are used in Microsoft Excel. Excel has nearly 500 built-in functions, and more are being added. That is many operations simplified, that might have taken quite some time to perform otherwise.Luckily, you don't need to know every function to be able to use Excel, so in this course I will teach you some of the most popular and powerful function which are just must know functions, but also some functions that are not well known, but you might be surprised at how they can help you...I will explain how to use each function step by step and explain each of the criteria required for each specific function.This course consist of 9 sections which include 38 video lessons which are mostly 4 - 10 min long, unless the function needs some more explaining.Course layout as follows:Section 1: IntroductionWelcomeIntroduction to functions in ExcelSection 2: Date & Time FunctionsNOW and TODAYDAY, MONTH, YEAR and DATEHOUR, MINUTE, SECOND and TIMENETWORKDAYS and WORKDAYWEEKDAY and WEEKNUMSection 3: Engineering FunctionsCONVERTSection 4: Logical and Information FunctionsISBLANK, ISERROR, ISNUMBER, ISTEXT, ISBLANK, ISFORMULA, ISODD, ISEVENAND, OR and NOTIF and IFSIFERRORSection 5: Lookup and Reference FunctionsVLOOKUP and HLOOKUPINDEX and MATCHROW, COLUMN, ROWS and COLUMNSHYPERLINKTRANSPOSESection 6: Statistical FunctionsCOUNT, COUNTA and COUNTBLANKCOUNTIF and COUNTIFSSUM, SUMIF and SUMIFSMIN, MAX, LARGE and SMALLMINIFS and MAXIFSMODERANKSection 7: Mathematical FunctionsRAND and RANDBETWEENROUND, ROUNDUP, ROUNDDOWN and INTMROUND, CEILING.MATH and FLOOR.MATHMODSUBTOTAL and AGGRETATESection 8: Text FunctionsLEFT, RIGHT, MID and LENFIND and SEARCHREPLACE and SUBSTITUTETRIM and CLEANCONCAT and TEXTJOINUPPER, LOWER and PROPERTEXTAnyone with basic Excel knowledge can easily learn all these functions by taking this course.If you have however never used Excel before, please make sure to look at my Microsoft Excel for Complete Beginners course, to learn the basics and get started.You will receive a certificate on completion of this course.Good luck, and please give me a rating and review if you enjoyed this course.
