('网络营销Excel数据分析必备技能教程',),全套视频教程学习资料通过百度云网盘下载

admin

资源详情


网络营销Excel数据分析必备技能教程视频-豆豆资源论坛
〖课程大纲目录〗
1、5个方面Excel知识
2、8种数据分析套路
3、5个角度分析方法
4、2套数据分析思维
1.0Excel数据分析课程简介及基础操作
ue6141.1Excel数据分析课程介绍[00:18:35]
ue6141.2Excel常用快捷键设置及操作[00:11:38]
ue6141.3Excel分析基础：相对绝对引用[00:10:31]
ue6141.4Excel分析实用技能：数据查找与替换[00:07:46]
2.1函数篇
ue6142.1.1日期函数-数据分析必学[00:17:01]
ue6142.1.2逻辑函数-数据分析必学[00:12:40]
ue6142.1.3零件函数-常用函数[00:17:09]
ue6142.1.4VLOOKUP函数-必会函数[00:14:05]
ue6142.1.5SUMIFS函数-必会函数[00:13:26]
ue6142.1.6COUNTIFS函数-必会函数[00:11:08]
ue6142.1.7COUNTIFS函数的另外一种用法[00:06:57]
ue6142.1.8LOOKUP函数-Excel函数番外篇[00:15:06]
2.2透视表篇
ue6142.2.1套用表格-数据透视表[00:08:32]
ue6142.2.2数据透视表原始数据要求[00:18:02]
ue6142.2.3数据透视表的简单介绍[00:18:08]
ue6142.2.4数据透视表计算字段[00:14:35]
ue6142.2.5数据透视表值显示方式介绍[00:12:33]
ue6142.2.6Excel交互利器-切片器[00:15:25]
ue6142.2.7Excel数据透视表字段分组[00:06:52]
ue6142.2.8数据透视表及切片器设计[00:17:01]
2.3PowerQuery数据动态合并基础篇
ue6142.3.1PowerQuery合并搜索词报告案例详解[00:11:43]
ue6142.3.2PowerQuery简单数据处理及追加合并功能[00:15:07]
ue6142.3.3PowerQuery批量合并Excel文件详解[00:10:01]
ue6142.3.4PowerQuery数据源整理-多维数据转一维[00:09:14]
ue6142.3.5PowerQuery去重汇总大法-分组依据的使用[00:10:28]
ue6142.3.6PowerQuery多表合并之超级VLOOKUP用法[00:16:32]
ue6142.3.7如何用PowerQuery快速处理【非常规】数据合并[00:12:12]
2.4函数实战及案例篇
ue6142.4.1三种方法提取关键词计划单元参数[00:14:17]
ue6142.4.2用PowerQuery高效拓展关键词前后缀[00:09:30]
ue6142.4.3剔除关键词词根[00:05:05]
ue6142.4.4函数实战-快速将通配符里关键词替换为单元关键词[00:11:12]
ue6142.4.5关键词URL生成练习及常用函数的基本应用[00:15:21]
ue6142.4.6使用Sumifs函数练习YTD，MTD[00:10:31]
ue6142.4.7创意模板制作[00:12:18]
3.1关键词精细化管理套路-关键词篇
ue6143.1.1关键词类聚分析的维度介绍[00:06:33]
ue6143.1.2关键词关键词精细化管理套路[00:05:29]
ue6143.1.3关键词精细化管理套路实操演示[00:06:55]
3.2URL贯通消费与咨询签约端的数据分析部署
ue6143.2.1URL标记跟踪的真相[00:11:17]
ue6143.2.2快速通过PowerQuery完成URL跟踪标记的方法[00:18:25]
ue6143.2.3使用VBA自定义模块对URL跟踪进行编码解码[00:12:45]
ue6143.2.4竞价通配符URL的使用详解[00:08:26]
4.1竞价Excel数据分析介绍
ue6144.1.1竞价数据分析常用指标介绍[00:13:36]
ue6144.1.2竞价数据分析常用的4种方法[00:12:43]
ue6144.1.3竞价数据分析的思路拓展[00:09:09]
4.2快速洞察咨询数据中的SEM价值
ue6144.2.1如何快速分析咨询数据中SEM价值简介[00:16:27]
ue6144.2.2咨询数据清洗整理-手动处理篇[00:13:32]
ue6144.2.3咨询数据清洗整理-透视表及PowerQuery篇[00:21:28]
ue6144.2.4咨询数据清洗整理-PowerQuery完善篇[00:15:08]
ue6144.2.5用PowerPivot透视表快速挖掘分析咨询数据[00:14:03]
4.3常用Excel数据分析思路
ue6144.3.1Excel数据多表关联的常用方法[00:13:42]
ue6144.3.2如何使用【三表思维】快速完成时段分析[00:11:57]
ue6144.3.3如何完善签约报表快速关联前、后端数据[00:23:39]
4.4数据建模分析思维及实操
ue6144.4.1数据建模的简单思维[00:19:13]
ue6144.4.2地域建模分析详解[00:36:40]
ue6144.4.3揭秘数据建模中时间表的神秘面纱[00:16:02]
ue6144.4.4如何用PowerPivot轻松处理千万级别的大数据[00:15:52]
ue6144.4.5PowerPivot快速链接数据源的方法[00:13:39]
ue6144.4.6PowerPivot上下文数据处理介绍[00:10:44]
ue6144.4.7PowerPivot关系函数使用方法[00:12:37]
ue6144.4.8PowerPivot常用的聚合函数[00:12:44]
ue6144.4.9Calculate函数的使用介绍[00:21:0]
ue6144.4.10时间智能函数篇之【累计至今】函数[00:17:01]
ue6144.4.11时间智能函数篇之【同比环比】函数[00:24:57]
ue6144.4.12如何快速建立KPI指标[00:04:31]
5.1PowerBI简单介绍及注册【免费学习】
ue6145.1.2PowerBI软件域名绑定及账号批量注册[00:10:55]
ue6145.1.1PowerBI注册及简单介绍[00:19:35]
5.2PowerBI可视化操作实践篇
ue6145.2.1可视化图表的选择[00:12:28]
ue6145.2.2自定义图标库如何导入到PowerBI[00:14:48]
ue6145.2.3PowerBI散点图及气泡图制作[00:25:12]
ue6145.2.4PowerBI趋势分析及占比分析常用图表[00:16:30]
ue6145.2.5PowerBI地图可视化的效果[00:06:38]
ue6145.2.6PowerBI重点指标展现[00:11:22]
ue6145.2.7PowerBI编辑交互设计[00:09:40]

游客，如果您要查看本帖隐藏内容请回复