|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/adventures-in-excel/
课程评论：没有评论
《Excel奇幻冒险》课程的中文内容摘要： 本课程旨在介绍Microsoft Excel中最实用、最常被使用的函数和功能。课程内容涵盖： * **基础功能**: SUM, AVERAGE, MAX, MIN, PRODUCT, SQRT, POWER 等简单易用的强大函数。 * **关键日期函数**: 利用 EOMONTH, EDATE, DAYS 计算到期日期和逾期天数。 * **随机数与随机日期**: 使用 RAND, RANDBETWEEN 生成随机数和随机日期，并介绍新的 RANDARRAY 函数。 * **IFS 系列函数**: 学习 AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, SUMIFS 等（Office 365 新增功能）。 * **文本函数**: TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, FIND, TEXTJOIN 等文本处理函数。 * **逻辑与 IS 函数**: AND, OR, NOT, ISBLANK, ISTEXT, ISNUMBER, ISERROR 等常用的逻辑判断函数。 * **下拉列表制作**。 * **XLOOKUP 函数**: 学习新的 XLOOKUP 函数及其与 VLOOKUP 的对比。 * **数据透视表**: 如何创建和使用数据透视表进行数据分析。 课程专注于强大且易于使用的函数，剔除了宏和Visual Basic。讲师分享了他认为能满足90%日常工作需求的Excel技巧，帮助学习者快速掌握Excel的核心应用。
Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best - that is the ones I find most useful. In "Adventures in Excel", I cover the simple-to-use but powerful functions that I use most often:· Basic features including SUM, AVERAGE, MAX, MIN, PRODUCT, SQRT and POWER· Key date functions including the calculation of due dates and days past due using EOMONTH, EDATE and DAYS· Generating random numbers and random dates with RAND and RANDBETWEEN, and introducing the new RANDARRAY function· The new IFS functions (new to Office365) - AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS and SUMIFS· Text functions including TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, FIND, and TEXTJOIN· The most useful logical functions and IS functions - AND, OR, NOT, ISBLANK, ISTEXT, ISNUMBER and ISERROR· How to create a drop-down list· The new XLOOKUP function and how it compares with the popular VLOOKUP function· Pivot tables - how to create one and how to use one to analyse dataThere is so much in Microsoft Excel that I can't cover it all in one course - that might need 100 courses. Instead, in this course - Adventures in Excel - I start with some simple calculations and move onto some of the features and functions that I use most often. There's no visual basic or macros in here just powerful but simple to use functions. These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you'll use 90% of the time.I hope you find the course helpful.
