|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excelnext_excel/
课程评论：没有评论
**课程名称：** Excel 高级技巧 - 从入门到精通 (包含图表) **课程概述：** 本课程旨在帮助学员系统地掌握 Microsoft Excel 的高级功能，将 Excel 应用技能提升至全新水平。课程共包含 12 个部分，提供超过 90 段教学视频，总时长约 13 小时。与其他同类课程不同的是，本课程深入探讨了许多常常被忽略的高级技巧，例如： * **函数综合运用：** VLOOKUP() 与 MATCH()、HLOOKUP() 与 MATCH()、INDEX() 的多数组及双 MATCH() 应用、TRANSPOSE() 公式、SUMIF() 与 SUMIFS()、SUM() 与 SUBTOTAL() 的区别（在筛选时）、IFERROR() 与 IF() + ISERROR() 的比较。 * **数据处理与分析：** Form Control 控件在仪表盘中的应用、文本分列技巧、INDIRECT() 和 OFFSET() 的实际应用、数据透视表（Pivot Table）的自动化求和、计数、百分比计算及分组数据标题生成、3-数据合并、"定位" (Go To - Special) 功能与 Ctrl+Enter 的结合使用、"查找和替换" 的通配符应用、基于公式的条件格式设置。 * **实用图表与技巧：** 制作温度计图、双坐标轴图、趋势线、轴值设置、在批注中插入图片等。 * **数据清洗：** 综合运用多种技巧进行数据清洗。 **讲师背景：** 本课程由资深 Excel 专家 CA. Rishabh Pugalia 主讲。他是一名特许会计师 (Chartered Accountant)，曾任职于 KPMG 和 J.P. Morgan。截至 2016 年 6 月，他已为超过 12,500 名专业人士提供过面授培训，并积累了丰富的 Excel 技巧和解决实际问题的经验。他深知不同部门和领域用户的需求，并将这些宝贵的洞察融入到课程设计中。 **课程优势：** * **内容全面深入：** 涵盖了许多其他高级 Excel 课程中未曾涉及的实用技巧。 * **专家授课：** 由经验丰富的行业专家亲自指导。 * **学习资源丰富：** 提供终身访问视频的权限，并附赠可供下载的 Excel 实战案例和图文并茂的指导手册 (PDF 格式)。 * **注重实践：** 课程设计旨在帮助学员将所学知识应用于实际工作场景。 **适合人群：** 希望显著提升 Excel 应用能力，成为 Excel 高手（Ninja level）的各类专业人士。
"Advanced Excel Ninja" is a comprehensive online training program on Microsoft Excel. It is divided in 12 sections and covers exhaustive list of topics. There are 90+ tutorial videos and the duration is 13 hrs. Topics often ignored in other advanced online programs have been included. Demo Preview Lecture 89 and 90 to find the difference. VLOOKUP() with MATCH() HLOOKUP() with MATCH() INDEX() with multiple arrays & two MATCH() Using TRANSPOSE() formula Form Control Buttons for Dashboard SUMIF() vs. SUMIFS() SUM() vs. SUBTOTAL() while using Filter Hidden Text-to-Columns tricks Using IFERROR() vs. IF() + ISERROR() Applications of INDIRECT() and OFFSET() Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings 3-Data Consolidation Power of "GO TO - Special" along with Ctrl+Enter Using "Find and Replace" with wildcard characters Combo techniques for Data cleaning Formula-based Conditional formatting Charts - Thermometer, 2 axis, Trendline, Axis value settings Inserting Picture in Comments.and the list of such tricks is very long So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who - Is a qualified Chartered Accountant Has worked with KPMG and J.P. Morgan Has trained 12,500+ professionals (Apr 2010 - June 2016) in face-to-face training programs Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction And by the way he has conducted more than 200 (two hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program. Instructor: CA. Rishabh Pugalia, Founder, Excel Next The participants will be provided lifetime access to videos plus downloadable Excel Case Studies and picture-based HandBook (PDF).
