|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advance-microsoft-excel-formulas-and-functions/
课程评论：没有评论
**课程名称：** 高级 Microsoft Excel 公式与函数及数据透视表 **课程概述：** 本课程旨在帮助您掌握高级 Excel 公式、函数以及数据透视表的使用，将 Excel 从一个基础的电子表格工具转变为一个强大的动态分析工具。无论您是 Excel 新手还是希望成为 Excel 使用达人，本课程都将为您提供所需知识。 课程将清晰易懂地讲解每个公式和函数的作用及其多种应用方式。课程内容涵盖： * Excel 列表处理 * 列表函数 * 数据验证 * 处理大型 Excel 数据集 * Excel 条件函数 * Excel 查找函数 * Excel 文本函数 * Excel 工作表审计 * Excel 工作表与工作簿保护 * Excel 的“假设分析”工具 * Excel 数据透视表 讲师 Devyani Lakhyani 将以对话式、真实、简洁明了的教学风格，将复杂的概念以清晰易懂的框架呈现。 **目标学员：** 希望提升 Excel 技能，成为 Excel 高手，熟练运用高级公式、函数及数据透视表进行数据分析的用户。 **课程特色：** * 内容全面，涵盖高级 Excel 核心技能。 * 教学风格清晰易懂，化繁为简。 * 兼容多个 Excel 版本（2007 及以上，包括 Office 365）。 * 提供可下载资源、课程测验和终身访问权限。 * 30 天退款保证。
It's time to learn Advanced Excel Formulas and Functions With PivotTablesWhether you're starting from scratch or aspiring to become an absolute Excel power user, you've come to the right place.This course will give you understanding of the Advanced Excel Formulas and Functions With PivotTables that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.This Microsoft Excel - Advanced Excel Formulas & Functions With PivotTables Course will tell you simply what each formula does, how they can be applied in a number of ways.I have divided this course in different sections including:Working With Excel ListList FunctionsData ValidationWorking With Large Set Of Excel DataExcel Conditional FunctionsExcel Lookup FunctionsExcel Text Based FunctionsAuditing An Excel WorksheetProtecting Excel Worksheet and WorkbookWorking with Excel What If? ToolsExcel PivotTables And So On.My teaching style is conversational, authentic, easy and to the point, and I will always communicate complex/ difficult concepts in a framework that is clear and easy to understand.If you're looking for the course where you can learn Microsoft Excel - Advanced Excel Formulas & Functions With PivotTables that you need to know to become an absolute Excel Hero, you've found it.See you in the course!Devyani Lakhyani* NOTE: Full course includes downloadable resources, course quizzes and lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 & Office 365.
