|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-365-beginner-to-advanced/
课程评论：没有评论
**课程名称:** Microsoft Excel 365 捆绑课程：从入门到精通 **课程概述:** 本课程 bundle 旨在帮助学习者成为 Microsoft Excel 365 的高级用户，涵盖从基础到高级的全方位技能。通过实践练习、可下载文件和终身访问权限，您将学习数据录入、公式运用、图表制作、数据整理、分析以及自动化任务等内容。课程分为三个部分： * **Excel 365 入门:** * 熟悉 Excel 365 界面及在线门户。 * 理解运算顺序（BODMAS）。 * 掌握绝对与相对引用。 * 学习数字和单元格格式化。 * 使用 VLOOKUP 和 XLOOKUP 进行查找。 * 冻结和解冻窗格。 * 保护工作簿和工作表。 * 在 Excel Online 和 Teams 中协作。 * **Excel 365 进阶:** * 设计专业易读的电子表格。 * 应用数据验证进行输入控制。 * 使用逻辑函数（AND, OR, IF）进行决策。 * 通过 VLOOKUP 和 INDEX/MATCH 进行高级查找。 * 高效排序和筛选数据。 * 处理重复数据。 * 掌握各类数学函数进行数值处理。 * 学习统计函数（平均值、中位数、众数）。 * 使用数据透视表和数据透视图进行数据分析。 * 进行“假设分析”（如 PMT, Goal Seek, Data Tables）。 * **Excel 365 高级:** * 使用动态数组函数进行唯一值提取和计数。 * 区分唯一值和去重值。 * 掌握 SORT 和 SORTBY 函数进行数据排序。 * 应用 FILTER 函数进行精确数据筛选。 * 使用 RANDARRAY 和 RANDBETWEEN 生成随机数。 * 通过 XLOOKUP 和 XMATCH 进行复杂查找。 * 学习 LET 和 LAMBDA 函数创建自定义公式。 * 使用 Power Pivot 构建数据模型和表间关系。 * 利用 Power Query 清洗和处理数据。 * 通过宏和 VBA 自动化任务。 **课程价值:** * 超过 25 小时的视频教程。 * 超过 270 个独立的视频讲座。 * 提供课程和练习文件。 * 完成课程可获得结业证书。 * 提供终身访问权限。 **目标受众:** 对数据处理、组织和图表制作感兴趣的初学者到高级用户。 **无教学大纲 (Syllabus)**
**This bundle includes practice exercises, downloadable files, and LIFETIME access**Learn all the tools needed to become a Microsoft Excel 365 power user with this great-value 3-course training bundle from Simon Sez IT for beginners to advanced users. This Excel bundle is perfect for anyone interested in number-crunching, data organizing, and chart-making.Start by learning the basics, such as navigating Excel's interface, entering data, and using basic formulas. Then, move on to creating impressive charts, sorting and filtering data, and collaborating with others.As you advance, master complex calculations, design professional spreadsheets, and analyze data with PivotTables and charts. Finally, explore powerful tools like Power Pivot, Power Query, and macros to automate tasks and handle large datasets effortlessly.If you already have a good understanding of Excel, you can skip to the intermediate and advanced sections, where our expert instructor will help you take your spreadsheet skills to the next level.What's included?Excel 365 BeginnersAccess the Microsoft 365 online portal.Understand the order of operations and the BODMAS rule.Know the difference between absolute and relative referencing.Apply number formatting, format cells, rows, and columns.Perform lookups with VLOOKUP and XLOOKUP.Freeze and unfreeze panes.Protect cells, worksheets, and workbooks from editing.Work with files in Excel Online.Add an Excel workbook to a Teams channel and share in a Teams meeting.Excel 365 IntermediateDesign spreadsheets for improved readability using cell styles.Implement data validation for accurate input control.Utilize logical functions like AND, OR, and IF for decision-making.Perform lookup operations using VLOOKUP and INDEX/MATCH.Sort and filter data efficiently using built-in Excel functions.Identify and handle duplicates in data using conditional formatting and formulas.Round values and perform special rounding using Excel's math functions.Apply statistical functions such as mean, median, and mode.Analyze data using PivotTables and Pivot Charts for insights.Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.Excel 365 AdvancedExtract and count unique entries using Dynamic Array Functions.Differentiate between unique and distinct values in Excel spreadsheets.Utilize SORT and SORTBY functions for data organization and analysis.Employ FILTER functions with logical operators for precise data filtration.Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.Perform complex lookups efficiently using XLOOKUP and XMATCH functions.Develop custom formulas with LET and LAMBDA functions for tailored analysis.Create and manage data models with Power Pivot, including table relationships.Clean and manipulate data effectively using Power Query functionalities.Automate repetitive tasks and customize Excel with macros and VBA.This course bundle includes:25+ hours of video tutorials270+ individual video lecturesCourse and exercise files to follow alongCertificate of completion
