|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-excel-2021-from-beginners-to-the-mastery-level/
课程评论：没有评论
课程名称：Microsoft Excel 2025：初学者+中级+高级综合课程 课程概述： 本课程采用渐进式实践学习（PPL）方法，旨在帮助学员全面掌握Excel的使用，适合随时随地学习。初学者部分包含四个模块：首先是Excel基础，讲解电子表格的基本概念及Excel的核心功能——公式。接着是基本技能模块，这是熟练使用Excel所必需的核心元素。然后更深入地探讨公式，包括语法、公式复制、相对和绝对引用、公式审核工具以及为单元格或单元格范围定义名称。此外，还介绍了文本连接等基本操作。 进阶格式化部分，从基础到高级，涵盖了Excel中的多种格式化选项，如自定义数字、日期和时间格式，并介绍了条件格式化等高级功能。工作表模块则强调工作表的基本操作及跨多个工作表的单元格引用，确保在协作时的工作表保护和打印定制。 函数部分使Excel更具强大计算能力，课程中讲解了统计、数学、文本、逻辑、条件、财务，以及日期和时间等类别的函数。此外，数据库部分探讨数据查找和引用功能，并介绍了新函数XLookup和XMatch。 图表模块提供了多种图表类型的深入讲解，使学员能通过图示化数据来增强信息的可读性。模板功能教会学员如何创建和管理常用的电子表格模板。数据库模块介绍了数据表的整理与筛选功能，以及数据有效性和数据的导入导出。 数据透视表功能用于从大型表中汇总信息，并涵盖了创建、重定义字段设置、过滤功能等。Power Pivot附加功能则能够将多个表连接为统一的数据模型，并根据公式创建额外字段以分析关键绩效指标。 “假设分析”模块指导学员使用Goal Seek、场景管理器、数据表和Solver等工具寻找最优值。宏功能使学员能记录重复性任务，将其转化为VBA代码，以便通过按钮或快捷键快速执行。 此外，课程还讲解了如何在工作表中插入和重新设定图形对象，包括图片、形状、图标和SmartArt，从而使学员能创造更具吸引力和表现力的电子表格。 此课程不仅适合初学者，也适合希望进一步提升Excel技能的中级和高级用户。通过系统的学习，学员将全面掌握Excel的各种功能和应用。
With the proven Progressive Practical Learning (PPL) methodology aiming to provide you with the mastery of Excel. Prepared for Learning On Go and Learning On Demand.Beginners cycle comprises almost 4 sections: Excel Foundations where you will learn about notions regarding the spreadsheet and the heart of Excel, formulas. Then follows Basic Skills which is essential for proficient use of Excel, since these are the central elements of Excel. More Basic Skills section approaches other matters for you to acquire a sound base for the rest of the course, for learning Excel in depth. Formulas in Depth partially can be considered as part of the beginners cycle.Formulas in Depth with a dedicated section, as the name suggests it's for you to dominate the heart of Excel: formulas and all related notions and features, such as syntax, formulas replication, relative and absolute referencing, formula auditing tools, and defining names for the cells or range of cells to be used in formulas instead of cell references. Also, a fifth operation is introduced: concatenation, for joining text. The power and square root operations are left to the functions section.Advanced Formatting, from basic to advanced formatting features, excel offers a wide set of predefined options especially regarding the numeric values and also full customization of numbers, dates, and time through codification which you are going to learn in detail, besides the usual formatting of the font, horizontal and vertical alignment, bordering tables and coloring the background, amongst others. Advanced formatting features, such as cells and tables styles, and conditional formatting deserve a full approach. This matter comprises 4 sections.Worksheets are the stage where the spreadsheets are developed, so understanding their basics and manipulation is a must together with the interconnecting spreadsheets across several worksheets through cell referencing, including the placement of a range of worksheets in a formula for operating the same range of cells. Printing worksheets can be customized and include headers and footers and other aspects. Protecting worksheets and their structure is important for collaborative work. For a series of worksheets, representing each one a segment of an organization, the consolidation in a single one can be done with the Worksheets Consolidation tool.Functions make Excel even more powerful since they embody calculations that otherwise would take several steps, some of them involving a complex process, but with this feature, you only need to provide the arguments and Excel delivers the result. You'll learn its syntax and the relevant functions from categories such as Statistical, Math, Text, Logical, Conditional, Financial, Date, and Time. Lookup & Reference functions are approached under the Database section.Charts are minded for providing a visual perspective of numeric values and Excel offers a vast catalog of types, sub-types, and variants covering all needs. Besides the predefined configuration, they can be customized in every single detail, through deep formatting tools. These matters are demonstrated through various types of charts such as Column, Bar, Line, Area, Pie, and Doughnut.Templates constitute a feature for saving models of spreadsheets you need often for instancing them and just for introducing elementary data. You'll learn how to create a model and manage it and also, use pre-packed templates that with some adjustments can solve your requirements, without the need to reinvent the wheel.Tables and Database: When a list of data is formally defined as such, extra features are added. Besides this aspect, tables can be sorted and filtered, columns and rows grouping can be done with automatic summarizing functions.For assuring the consistency of the data there is the feature Data Validation and since Excel is more and more a complement for other applications Importing and Exporting data is taught.There are specific functions for searching data, namely VLookUp, HLookup, Index, and Match. Two new functions are also approached: XLookup and XMatch. There are also functions for dynamic numeric calculations, such as Subtotal - with the option of ignoring hidden cells.DSUM, DAVERAGE, and DCOUNT with dynamic criteria.A Pivot Table aggregates data from a larger table and produces summary information. Besides the creation and recreation of a Pivot Table, other matters are approached such as redefining the settings of a field, creating calculated fields and items, grouping columns and rows, filtering features, and inserting charts.Power Pivot it's an add-in that brings to Excel the features of a database and one of the most important is to connect several tables through relationships and transform separate tables in a unified Data Model, and then create Pivot Tables out of it. Under the Power Pivot, extra fields based on formulas can be created and the Key Performance Indicators can be analyzed.What-If-Analysis is for reaching an optimum value, directly or indirectly and all the four tools are approached.Goal Seek, for finding out the value of a variable for reaching a goal.Scenarios Manager, for storing and retrieving, as the name suggests, scenarios.Data Table, for producing the results of the combination of the possible values of two variables.Solver, for finding an optimal solution for a problem with several variables and constraints.Macros it's a tool for recording repetitive tasks for executing them through a button on the ribbon or a shortcut key. Excel transforms the recorded tasks in VBA code and, you'll get acquainted with and do some editing for improving the macro by adding an InputBox and a Message Box. Planning is exemplified with a script and at placing Buttons in the Ribbon you'll learn how to reconfigure the tabs of the Ribbon.Graphical Objects, such as Pictures, Shapes, Icons, and SmartArt, can be inserted into the worksheets and restyled. SmartArt is a compound-type object which includes text features, so you can highlight some information, enriching your spreadsheets by making them more communicative and appealing. The content of a shape can be dynamic, in other words, it can be linked to a cell, a feature to be demonstrated through a SmartArt.
