|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-essentials-x/
课程评论：没有评论
**Microsoft Excel 基础技能课程总结** 本课程为期约4小时，旨在帮助学员掌握Microsoft Excel的核心基础和进阶技能，使其能够高效处理数据。课程内容覆盖Excel界面介绍，常用函数（如SUM, MIN, MAX, AVERAGE），单元格格式化（基础格式化、条件格式、表格格式化），以及VLOOKUP，XLOOKUP，IF，COUNTIF，COUNTIFS，SUMIF，SUMIFS函数的应用和数据保护。此外，课程还将介绍数据透视表的基础知识。 **课程亮点：** * **内容全面：** 涵盖Excel日常工作所需的基础和常用功能。 * **循序渐进：** 课程长度适中（每节5-20分钟），方便随时随地学习，并可自由掌握学习节奏。 * **实践导向：** 提供原始文件和完成文件，方便学员对照练习。 * **适用性广：** 兼容所有Microsoft Excel版本，但XLOOKUP、TEXTSPLIT、TEXTBEFORE、TEXTAFTER功能仅限于Microsoft 365或Office 2021及以上版本。 * **职业发展助力：** 帮助学员提升技能，为求职、跳槽或公司内部岗位调整做好准备。 无论您是想提升现有技能，还是希望在新领域发展，本课程都将为您在数据录入、处理、分析和报告制作方面打下坚实基础。
This training covers basic knowledge you need to work efficiently in Microsoft Excel.This is a training for basic and intermediate level.In approximately 4 hours you will learn about Microsoft Excel interface, how to use the basic functions as SUM, MIN, MAX, AVERAGE, how to modify the cells format using basic formatting options, conditional formatting, format as table, as well as the most commonly used functions and functionalities from Microsoft Excel. We will also cover the basics for the lookup functions: VLOOKUP and XLOOKUP, simple IF functions, COUNTIF, COUNTIFS, SUMIF, SUMIFS and protections. We will cover the basics for pivot tables.Each lesson in between 5 and 20 minutes, to be easily accessible from anywhere, anytime, at a pace you choose. In the lessons resources you will find the original source and the completed one, to be more accessible for you to follow along my examples.We all need a software for entering data, preparing and processing data, data analysis, creating reports. Because it is wide spread, Microsoft Excel is a very common solution.You can choose this training because:- you want to improve your knowledge- you want to change jobs- you want to change companiesThis training is compatible with all versions of Microsoft Excel, except XLOOKUP, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, that are available only in Microsoft 365 or from Microsoft Office 2021 version.
