|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/essentials-of-microsoft-excel-beginner-to-advanced/
课程评论：没有评论
**课程名称：** Microsoft Excel 从入门到精通及高级应用 **课程概述：** 本课程旨在将您从 Excel 初学者培养至精通级用户。课程采用短小精悍的讲座形式，帮助您保持专注和学习效率。每节讲座均配有练习文件，鼓励您边学边练，强化对复杂概念的理解。 **核心学习内容：** * **基础操作与导航：** 熟悉 Excel 工作簿、工作表、功能区、快速访问工具栏、状态栏的各项功能。 * **数据录入与编辑：** 掌握数据输入、编辑、移动、复制、剪切、缩进、对齐、缩放等基本操作。 * **格式化与美化：** 学习使用格式刷、设置绝对/相对引用、打印预览与共享设置。 * **数据工具：** 掌握排序、筛选、求和、高亮重复值、查找唯一值等数据处理工具。 * **图表与表格：** 学会创建各类图表、创建和格式化表格、创建模板。 * **日期格式化与文本处理：** 学习日期格式化、文本分列、Flash Fill (填充)、文本函数（如 OFFSET, CONCATENATE, IF, SEARCH, FIND, REPLACE, SUBSTITUTE, LEN, TRIM, FILTER, LOWER, UPPER, PROPER, REPT, RIGHT, LEFT）。 * **姓名管理与数据验证：** 学习使用命名常量、命名范围、动态命名范围以及数据验证。 * **条件函数：** 掌握 IF, SEARCH, CONCATENATE, IF, FIND DUPLICATES with IF, COUNTIF, SUMIF, SUMIFS, COUNTIF, COUNTIFS, COUNT, COUNTA, AVERAGEIF, AVERAGEIFS, SUBTOTAL 等条件函数。 * **高级函数：** 学习 MATCH, INDEX, HLOOKUP, VLOOKUP, XLOOKUP, XMATCH 等高级查找和引用函数。 * **数据库函数：** 了解 DSUM, DCOUNT, DCOUNTA, DAVERAGE 等数据库函数。 * **What-If 分析：** 掌握单变量求解、数据表格、方案管理器等“假设分析”工具。 * **Power Query：** 学习使用 Power Query 从文本/CSV 文件导入数据，并进行数据整理（格式化数据、自动填充、合并单元格、调整行/列、插入边框）。 * **工作表管理：** 学习冻结窗格、条件格式、插入形状和图像、链接工作表、保护工作表。 * **公式与审计：** 学习从选区创建公式、公式审计。 * **数据透视表与 Power Pivot：** 学习创建数据透视表、数据透视图、Power Pivot、KPI、切片器。 * **宏与自动化：** 了解如何创建宏。 * **其他实用技巧：** 探索更多 Excel 技巧。 **您将获得：** * **30天无风险退款保证** * **终身学习权限**，可随时复习课程内容 * **问答环节支持**，获得专家帮助 * **结业证书**，为您的职业生涯增添亮点 * **配套练习文件**，方便您随学随练，快速提升技能和信心。 **课程优势：** 本课程旨在帮助您快速掌握 Excel 核心功能，并将所学知识立即应用于实际工作、职业晋升或个人创业中。立即启程，开启您的 Excel 精通之旅！
This course takes you from beginner to advanced. The course consists of short and concise lectures to keep you focused and engaged. Each lecture has accompanied lecture files for you to practice along. You learn your best with practice and complex subjects will sink in.My objective is for you to grab the fundamental. You learn practical uses of Excel to apply immediately.You'll learn the following: Navigate around Excel workbook, worksheets, the ribbon, quick access tool bar, status barEnter and edit data, move, copy, cut, indent, align, zoomFormat painterAbsolute and relative referencingPrinting set up and sharingData tools for sorting, filtering, totaling, highlight duplicates, uniqueCreate chartsCreate tablesCreate templatesFormat as tableFormat datesShortcutsNamed constant, named rangeData validationText to columnsFlash fillGrouping, consolidateNamed rangeDynamic named rangeSortingWhat-If Analysis with goal seek, data tables, scenario managerUse Power Query to import from text/csv, get-dataFormat as table, auto fill, merge cells, adjust rows and columns, insert bordersFreeze pane, conditional format, Insert shapes and images, templatesLink worksheetProtect worksheetText functions: OFFSET, CONCATENATE, IF, SEARCH, FIND, REPLACE, SUBSTITUTE, REPLACE, LEN, TRIM, FILTERLOWER, UPPER, PROPER, REPT, RIGHT, LEFT,Conditional functions: IF, SEARCH, CONCATENATEIF, FIND DUPLICATES with IF COUNTIF, SUMIF, SUMIFS, COUNTIF,COUNTIFS, COUNT, COUNTA, AVERAGEIF, AVERAGEIFS, SUBTOTALAdvanced functions: MATCH, INDEX, HLOOKUP, VLOOKUP, XLOOKUP, XMATCHDatabase functions: DSUM, DCOUNT, DCOUNTA, DAVERAGECreate from selectionFormula auditingPivot table, Pivot chart, Power Pivot, KPI, slicersCreate sample practice files with ChatGPTMacrosAnd moreWhat you get for enrolling:Risk-free 30-day money-back guaranteeLifetime access that you can review any timeAccess Q & A to get helpCertificate of completion to add to your career pathPractice files are included with the lectures for you to practice while watching. You'll gain confidence and apply what you learn immediately. Excel can be useful for works and promotion or your own business. Start learning today!
