|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2024-beginner-to-advanced/
课程评论：没有评论
**Coursera 课程：《Excel 精通三小时：从新手到专家》内容摘要** 这门为期三小时的在线课程旨在帮助学习者在短时间内掌握 Microsoft Excel 的各项技能，从基础操作到高级应用，最终成为 Excel 专家。 **课程特色：** * **易于理解：** 以简单明了的方式讲解 Excel 功能。 * **细节丰富：** 全面深入地介绍 Excel 的工具和特性。 * **循序渐进：** 采用分步教学法，帮助学习者轻松掌握概念。 * **适合 all：** 无论初学者还是有一定基础的学习者均可参与。 * **实践导向：** 通过真实案例进行练习，增强学习的趣味性和实用性。 **课程内容涵盖：** * **基础数字函数** * **百分比计算** * **数据排序** (单级、多级、自定义列表、图标着色、取消排序) * **数据筛选** (基础筛选、高级筛选，包括正则表达式和 IF/OR 条件) * **数据验证** (创建列表、文本和日期验证，以及动态列表) * **单元格引用** (相对、绝对、混合引用) * **IF 函数系列** (SUMIF(S), COUNTIF(S), IF, 嵌套 IF 与 AND/OR) * **查找函数系列** (VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP) * **文本函数系列** (Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, Text) * **FlashFill** (正确使用 FlashFill) * **自定义数字格式** (使用自定义图标高效展示数据) * **数据透视表** (基础知识、条件格式) * **数据透视表切片器** (结合切片器创建仪表板) * **SUMIF(S) & COUNTIF(S) 增强** (使用自定义条件/正则表达式匹配) * **查找增强** (根据正则表达式或通配符提取数据) * **多标题下的 Index & Match** * **数组公式** (UNIQUE, FILTER, SORT 等) 本课程承诺通过实践操作，将学习者从 Excel 新手提升为高级用户，非常适合希望快速提升 Excel 技能以适应实际工作需求的学习者。课程强调实践、学习新方法以及将在新技能应用于现实场景的重要性。
Learn everything about Microsoft Excel, from the basics to the super advanced stuff, in this online course. After taking this class, you'll become an Excel expert!Here's how it works:We explain Excel in a simple way so it's easy to understand.We go through all the tools and features in Excel, paying close attention to details.We follow a step-by-step approach. So that it's easier for you to grasp all the concepts.This course is made for everyone, no matter how much or little you already know.We practice with real-life examples to make learning fun and useful.Topics covered in the course:Basic Number FunctionsHow to calculate percentagesSorting Data - Single Level, Multi Level, Custom List, Own List, Icons (Colors Coding), How to Unsort DataFilter - Basic Filter and Advanced Filter (including Regex's and IF/OR Conditions)Data Validation - How to create a list, text and date validations, and a Dynamic List with Excel Tables.Cell Reference - Relative, Absolute, and Mixed ReferencingIF Functions - SUMIF(S), COUNTIF(S), IF, Nesting IF with AND / OR FunctionLookup Functions - VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUPText Functions - Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, TextFlashfill - How to use FlashFill correctlyCustom Number Formatting - How to Format Numbers with your custom icons and present data efficientlyPivot Tables - Basics of Pivot Tables including Conditional FormattingPivot Tables - Slicers - Intro to creating Dashboards with Pivot Tables and SlicersSUMIF(S) & COUNTIF(S) - Using custom conditions/criteria. Eg. Regex MatchLookup - Extract data based on Regex Match, or Wildcard Lookup.Index & Match with Multiple Headers - Use Index & Match when you have more than 1 header in your datasetArray Formulas - Learn to use formulas like - UNIQUE, FILTER, and SORTEmbark on a journey into the world of Excel with our genuine passion for sharing knowledge. In this Udemy course, we cover everything from basics to advanced topics, offering hands-on practice with spreadsheets. We guarantee to turn you into an advanced Excel user. Suitable for people with all skill levels, we focus on practical learning, emphasizing the importance of practice, a readiness to learn new methods, and the application of skills to real-world scenarios. Take this course to get a head start on your path to becoming an Excel pro!
