Excel入门到全能高手，百度网盘(2.73G)

文件目录：Excel入门到全能高手，文件大小：2.73G

{1}–课程 [2.73G]

{1}–Excel基础 [1.17G]

[1.1]–认识键盘.mp4 [20.37M]

[1.10]–高级排序.mp4 [49.50M]

[1.11]–筛选数据.mp4 [130.18M]

[1.12]–拆分列和合并单元格.mp4 [38.27M]

[1.13]–拷贝剪切复制粘贴内容.mp4 [46.10M]

[1.14]–调整行高和列宽.mp4 [23.82M]

[1.15]–查找内容.mp4 [150.46M]

[1.16]–替换内容.mp4 [56.50M]

[1.17]–设置数字格式.mp4 [31.36M]

[1.18]–设置文字格式.mp4 [17.86M]

[1.19]–设置文字对齐方式.mp4 [33.72M]

[1.2]–新建工作薄.mp4 [24.01M]

[1.20]–边框背景色汉语拼音和格式刷.mp4 [41.25M]

[1.21]–套用预设定的样式.mp4 [25.11M]

[1.22]–隐藏工作表和工作薄.mp4 [11.30M]

[1.23]–拆分窗格.mp4 [22.59M]

[1.24]–插入数学公式.mp4 [27.47M]

[1.25]–插入特殊字符.mp4 [41.10M]

[1.26]–自动填充.mp4 [57.04M]

[1.27]–快速填充.mp4 [14.49M]

[1.28]–批注.mp4 [14.71M]

[1.29]–插件介绍-扩展Excel功能.mp4 [68.05M]

[1.3]–插入和删除工作表.mp4 [15.65M]

[1.30]–设置Excel默认选项.mp4 [24.42M]

[1.4]–移动或复制工作表内容.mp4 [32.20M]

[1.5]–选中内容.mp4 [20.35M]

[1.6]–插入删除行列以及单元格.mp4 [15.86M]

[1.7]–冻结窗格.mp4 [38.79M]

[1.8]–隐藏行或列.mp4 [28.80M]

[1.9]–排序.mp4 [78.23M]

{10}–规划求解-找到最优方案 [55.96M]

[10.1]–求最大利润.mp4 [55.96M]

{11}–Excel2019新功能 [34.96M]

[11.1]–着色地图图表.mp4 [18.83M]

[11.2]–漏斗图.mp4 [1.94M]

[11.3]–精准选择和文字上下标.mp4 [4.68M]

[11.4]–IFS函数.mp4 [9.50M]

{2}–公式和函数 [493.82M]

[2.1]–公式介绍.mp4 [34.09M]

[2.10]–计数函数COUNTIF.mp4 [13.16M]

[2.11]–公式中使用名称.mp4 [26.48M]

[2.12]–名称的高级使用.mp4 [29.27M]

[2.13]–根据所选内容创建名称.mp4 [60.04M]

[2.14]–查找内容VLOOKUP函数.mp4 [76.14M]

[2.2]–引用.mp4 [18.50M]

[2.3]–相对和绝对引用.mp4 [37.70M]

[2.4]–公式中的运算符.mp4 [50.48M]

[2.5]–函数介绍.mp4 [29.82M]

[2.6]–单条件求和SUMIF函数.mp4 [58.86M]

[2.7]–通配符.mp4 [37.57M]

[2.8]–多条件求和SUMIFS函数.mp4 [6.47M]

[2.9]–条件函数IF.mp4 [15.23M]

{3}–Excel表-会用表的人才会飞 [66.06M]

[3.1]–创建表.mp4 [32.30M]

[3.2]–清除表数据.mp4 [10.94M]

[3.3]–使用切片器筛选表数据.mp4 [22.81M]

{4}–数据透视表-傻瓜式数据分析利器 [232.77M]

[4.1]–简单数据透视表.mp4 [62.09M]

[4.2]–高级数据透视表.mp4 [83.02M]

[4.3]–数据透视表分组.mp4 [31.59M]

[4.4]–筛选数据透视表数据.mp4 [23.59M]

[4.5]–数据透视图.mp4 [32.48M]

{5}–图表-一图胜千言 [437.46M]

[5.1]–图表介绍.mp4 [50.52M]

[5.10]–树状图.mp4 [12.41M]

[5.11]–统计图.mp4 [8.70M]

[5.12]–雷达图.mp4 [20.00M]

[5.13]–组合图.mp4 [9.93M]

[5.14]–迷你图.mp4 [8.04M]

[5.2]–饼图.mp4 [27.52M]

[5.3]–高级饼图和圆环图.mp4 [38.35M]

[5.4]–修改饼图的数据源.mp4 [18.93M]

[5.5]–柱形图和条形图.mp4 [37.95M]

[5.6]–高级柱形图和条形图.mp4 [21.48M]

[5.7]–图表的美化.mp4 [44.49M]

[5.8]–折线图和面积图.mp4 [36.31M]

[5.9]–旭日图.mp4 [102.82M]

{6}–条件格式-我就是这么酷 [127.47M]

[6.1]–突出显示单元格规则.mp4 [26.96M]

[6.2]–项目选取规则.mp4 [10.78M]

[6.3]–数据条和色阶规则.mp4 [15.11M]

[6.4]–图标集规则.mp4 [11.06M]

[6.5]–公式规则.mp4 [12.13M]

[6.6]–自定义条件格式.mp4 [17.74M]

[6.7]–管理条件格式.mp4 [33.69M]

{7}–快速分析 [42.49M]

[7.1]–使用快速分析.mp4 [42.49M]

{8}–Excel的保护和安全 [45.12M]

[8.1]–保护excel文件.mp4 [19.39M]

[8.2]–保护excel工作薄结构.mp4 [7.53M]

[8.3]–保护excel工作表.mp4 [18.20M]

{9}–宏-让Excel自己工作 [59.30M]

[9.1]–宏原理.mp4 [28.70M]

[9.2]–宏实战.mp4 [30.59M]

DPL_PYJUN [9.33K]

播放列表.dpl [9.33K]

修复播放列表.bat [0.17K]