|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-fundamentals-for-advanced-level-users/
课程评论：没有评论
**课程名称：** Microsoft Excel 中级到高级 - 分步讲解 **课程概述：** 本课程专为希望提升 Excel 技能、迈向高级用户水平的学习者设计。您将深入了解 Microsoft Excel 的高级功能，课程内容建立在“Microsoft Excel - Excel 入门介绍”的基础上。 **课程将涵盖：** * 高级函数：包括数学与统计函数、VLOOKUP 函数、嵌套函数、数据库函数、文本函数、日期函数与计算。 * 高级图表：学习创建和自定义各种高级图表。 * 选择性粘贴 (Paste Special)。 * 条件格式 (Conditional Formatting)。 * 锁定与保护：包括数据验证 (Data Validation) 和工作表/工作簿的锁定与保护。 * 方案 (Scenarios)。 * 公式审核与批注 (Formula Auditing and Comments)。 * 分类汇总 (Subtotalling)。 * 迷你图 (Sparklines)。 * 筛选与高级筛选 (Filtering and Advanced Filtering)。 * 数据透视表与数据透视图 (Pivot Tables and Pivot Charts)。 * 命名单元格与命名范围 (Named Cells and Named Ranges)。 * 混合单元格引用 (Mixed Cell Referencing)。 **课程特点：** * 由 Microsoft 认证培训师 Richard Walters 主讲，他拥有超过九年的 Microsoft Excel 培训经验。 * 课程时长合理，大部分讲座在 10-18 分钟之间，最长不超过 20 分钟。 * 课程内容全面，无论您是想快速了解 Excel 公式，还是希望大幅提升选择性粘贴的应用水平，这里都能满足您的需求。 * 在当今数据驱动的世界，Excel 使查看和分析数据变得轻松直观。 **讲师介绍：** Richard 是一位专业的培训师，拥有十多年的 IT 和商业技能培训经验，对所有 Microsoft Office 软件包（尤其是 Excel、Word、PowerPoint、Visio 和 Project）都有极其深入的理解。 **立即报名，踏上成为 Excel 大师的旅程！**
Are you looking to improve your Excel skills to become an advanced level user?This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security. Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.Microsoft Excel - Fundamentals of Advanced Level UsersPaste SpecialConditional FormattingLocking and ProtectionAdvanced ChartsData ValidationScenariosFormula Auditing and CommentsSubtotallingSparklinesFiltering and Advanced FilteringPivot Tables and Pivot ChartsNamed Cells and Named RangesMixed Cell ReferencingMathematical & Statistical FunctionsVlookup FunctionNested FunctionsDatabase FunctionsText FunctionsDate Functions and CalculationsWhether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place. In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master!See you there!-Richard Walters (Microsoft Excel Trainer)__________Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.
