|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-excel-2016-data-analytics-theory-bko-accredited/
课程评论：没有评论
课程名称：Microsoft Excel - Excel 数据分析专家（认证） 课程概述： 微软Excel 2024 - 数据分析专家课程旨在帮助学员掌握Microsoft Excel的基本和高级数据分析技巧。该课程不要求任何有关Microsoft Excel或数据分析的先前知识，适合各类教育背景的学员。课程注重实用性，内容与就业市场需求紧密相关，采用叙事方式进行教学，让学习更生动。 课程结构： 本课程可视为一个二合一的课程，既教授Microsoft Excel的基础知识，也涵盖数据分析的技巧。学员将学习以下内容： 1. **Excel基础知识**： - 绝对和相对引用 - 冻结窗格 - 图表制作 - 快捷键使用 - 工作表保护 - VLOOKUP 函数 - 筛选功能 - AND 函数 - (嵌套) IF 函数 - 数据透视图和数据透视表 - 仪表板功能及变量选择 - 下拉菜单 - 条件格式化 - 模式识别 2. **Excel数据分析**： - 情景分析 - 目标寻求 - 解算器 - 标准差 - 正态分布 - 几何均值 - 中位数与众数 - 描述性统计 - 相关性分析 - 单一OLS回归 - 非线性回归 - 多重OLS回归 课程亮点与附加内容： - 完成课程后可获得结业证书 - 30天退款保证 - 由合格的大学讲师教授的认证课程 注意：该课程已在测试小组上进行过测试，学员在使用不同版本的Excel（如2016、2019和Office 365）时均表现出良好的适应能力。
Microsoft Excel 2024 - Microsoft Excel Data Analysis ExpertThanks for considering our Microsoft Excel course. There are at least 100 Microsoft Excel courses out there. Why choose our Microsoft Excel course? Because of the following reasons:This course does not require any previous knowledge about Microsoft Excel or data analysis.This course is designed to be accessibele, regardless of your educational background. We keep this Microsoft Excel course practical. You learn what is required in the job market.We present the Microsoft Excel course based on story telling. .STRUCTUREThis Microsoft Excel course can be seen as a 2 in 1 course. We teach you data analysis techniques with Microsoft Excel, but we also teach you how to work with Microsoft Excel in general. So if you have not touched Microsoft Excel before, you have nothing to worry about. In concrete terms, you will learn: Microsoft Excel Essentials: Absolute and relative referencingMicrosoft Excel Essentials: Freeze panesMicrosoft Excel Essentials: GraphsMicrosoft Excel Essentials: Keyboard shortcutsMicrosoft Excel Essentials: Securing a sheetMicrosoft Excel Essentials: VLOOKUPMicrosoft Excel Essentials: Filter FunctionMicrosoft Excel Essentials: AND FunctionMicrosoft Excel Essentials: (Nested) IF FunctionMicrosoft Excel Essentials: Pivot Charts Microsoft Excel Essentials: Pivot TablesMicrosoft Excel Essentials: Dashboard functionMicrosoft Excel Essentials: Dashboard variable choiceMicrosoft Excel Essentials: Dashboard functionalityMicrosoft Excel Essentials: Drop Down MenuMicrosoft Excel Essentials: Conditional Formatting Microsoft Excel Essentials: Pattern RecognitionMicrosoft Excel Data Analysis: Scenario analysisMicrosoft Excel Data Analysis: Goal SeekMicrosoft Excel Data Analysis: SolverMicrosoft Excel Data Analysis: Standard DeviationMicrosoft Excel Data Analysis: Normal DistributionMicrosoft Excel Data Analysis: (Geometric) MeanMicrosoft Excel Data Analysis: Median And ModeMicrosoft Excel Data Analysis: Descriptive statisticsMicrosoft Excel Data Analysis: CorrelationMicrosoft Excel Data Analysis: Single OLS RegressionMicrosoft Excel Data Analysis: Non-linear RegressionMicrosoft Excel Data Analysis: Multiple OLS RegressionEXTRAS*Certificate of completion*30 day money back guarantee*Accredited course taught by qualified university lecturersNote: We have tested this course on a test audience and they had little to no problems keeping up with various versions of Microsoft Excel, such as Microsoft Excel 2016, Microsoft Excel 2019 and the MS Office 365 version.
