Excel2019教程-128节入门到精通，百度网盘(2.45G)

文件目录：Excel2019教程-128节入门到精通，文件大小：2.45G

{1}–课程 [2.45G]

{1}–Excel快速入门 [394.59M]

[1.1]–Excel2019工作界面(课程素材查看网易云私信).mp4 [60.90M]

[1.10]–应用实例1-制作工资条明细表.mp4 [27.29M]

[1.11]–Excel数字格式-常规、数值，货币，会计专用.mp4 [13.31M]

[1.12]–Excel数字格式-分数与百分数.mp4 [22.92M]

[1.13]–Excel数字格式-日期和时间.mp4 [12.17M]

[1.14]–Excel数字格式-科学计数，文本.mp4 [9.02M]

[1.15]–Excel数字格式-特殊.mp4 [7.08M]

[1.16]–设置Excel行高与列宽.mp4 [7.54M]

[1.18]–删除与隐藏行与列.mp4 [15.63M]

[1.19]–表格的插入与删除.mp4 [12.72M]

[1.2]–Excel2019保存与保护.mp4 [16.58M]

[1.20]–显示，冻结窗格.mp4 [13.25M]

[1.21]–Excel表格视图.mp4 [11.38M]

[1.22]–Excel输入公式计算.mp4 [8.55M]

[1.23]–Excel公式运算符与编辑公式.mp4 [11.80M]

[1.24]–Excel公式复制与删除.mp4 [6.51M]

[1.25]–公式与函数.mp4 [30.06M]

[1.26]–求和SUM函数应用.mp4 [9.12M]

[1.3]–制作销售业绩表-一些简单功能操作.mp4 [16.18M]

[1.4]–设置常用字体和设置边框、填充色..mp4 [16.89M]

[1.5]–快速录入数据-录入相同数据.mp4 [5.96M]

[1.6]–快速录入数据-序列填充.mp4 [14.52M]

[1.7]–数据录入-单元格剪切、移动与复制.mp4 [7.97M]

[1.8]–数据录入-单元格字体、对齐、换行与合并.mp4 [16.47M]

[1.9]–数据录入-设置下拉菜单按钮.mp4 [20.78M]

{2}–Excel工作表打印输出 [41.14M]

[2.1]–页面背景设置.mp4 [3.07M]

[2.2]–打印预览与表格分页.mp4 [7.52M]

[2.3]–纸张大小、页边距与页眉页脚.mp4 [16.89M]

[2.4]–打印区域与标题设置.mp4 [13.67M]

{3}–Excel常用函数 [497.82M]

[3.1]–求平均值AVERAGE与AVERAGEA（求平均温度）.mp4 [19.07M]

[3.10]–向下舍入到整数INT与数字截断TRUNC.mp4 [10.36M]

[3.11]–向上舍入ROUNDUP与向下舍入ROUNDDOWN（求快递费和积.mp4 [19.64M]

[3.12]–统计含有数字的单元格个数COUNT（员工考勤）.mp4 [12.62M]

[3.13]–统计非空白单元格个数COUNTA.mp4 [12.94M]

[3.14]–统计空白单元格COUNTBLANK.mp4 [16.40M]

[3.15]–根据条件统计单元格个数COUNTIF.mp4 [17.74M]

[3.16]–统计满足多个条件的单元格个数COUNTIFS.mp4 [12.94M]

[3.17]–求最大值MAX.mp4 [13.17M]

[3.18]–求最小值MIN.mp4 [9.46M]

[3.19]–返回行号ROW.mp4 [15.90M]

[3.2]–3.2条件求平均AVERAGEIF与AVERAGEIFS.mp4 [24.54M]

[3.20]–返回行数ROWS.mp4 [5.72M]

[3.21]–返回列标COLUMN.mp4 [5.65M]

[3.22]–返回列数COLUMNS.mp4 [3.96M]

[3.23]–垂直查找VLOOKUP，精确与模糊查找.mp4 [25.52M]

[3.24]–VLOOKUP精确查找学生信息.mp4 [29.93M]

[3.25]–VLOOKUP跨表查询.mp4 [18.66M]

[3.26]–VLOOKUP模糊查找代替IF函数嵌套成绩分级.mp4 [14.46M]

[3.3]–逻辑函数-AND,OR,NOT.mp4 [14.66M]

[3.4]–逻辑函数-IF.mp4 [36.49M]

[3.5]–实例应用2-分析成绩表.mp4 [56.57M]

[3.6]–根据条件求和SUMIF与多条件求和SUMIFS.mp4 [40.89M]

[3.7]–TRUE与FALSE配合函数灵活运用.mp4 [7.75M]

[3.8]–区域乘积求和SUMPRODUCT（求指定商品销售总销售额）.mp4 [40.68M]

[3.9]–四舍五入ROUND.mp4 [12.07M]

{4}–Excel数据处理，分析 [495.44M]

[4.1]–多表协同工作-绝对引用与相对引用.mp4 [10.94M]

[4.10]–设置多条件排序.mp4 [24.95M]

[4.11]–排序自定义序列和表格排序.mp4 [26.37M]

[4.12]–自动筛选.mp4 [13.24M]

[4.13]–文本筛选和颜色筛选.mp4 [13.90M]

[4.14]–日期筛选.mp4 [6.19M]

[4.15]–数字筛选.mp4 [5.60M]

[4.16]–高级筛选.mp4 [44.05M]

[4.17]–表格筛选-插入切片器.mp4 [20.95M]

[4.18]–设置切片器.mp4 [12.36M]

[4.19]–数据分类汇总.mp4 [104.56M]

[4.2]–多表协同工作-链接公式.mp4 [63.12M]

[4.20]–数据验证1-整数、小数、序列.mp4 [10.29M]

[4.21]–数据验证2-日期、时间、文本长度.mp4 [8.65M]

[4.3]–强大的表格功能-插入.mp4 [14.29M]

[4.4]–强大的表格功能-编辑.mp4 [18.74M]

[4.5]–强大的表格功能-清除数据与删.mp4 [5.49M]

[4.6]–表格实际应用.mp4 [22.49M]

[4.7]–公式[名称]定义与使用.mp4 [44.94M]

[4.8]–公式[名称]结合函数应用.mp4 [16.06M]

[4.9]–数据排序升序降序.mp4 [8.25M]

{5}–Excel数据透视表 [114.76M]

[5.1]–创建数据透视表.mp4 [21.92M]

[5.2]–数据透视表-设置行与列、移动与删除等.mp4 [7.04M]

[5.3]–数据透视表-清除、刷新、更改数据源等..mp4 [15.52M]

[5.4]–数据透视表-字段设置1.mp4 [21.69M]

[5.5]–数据透视表-字段设置2.mp4 [9.96M]

[5.6]–数据透视表-设计.mp4 [17.48M]

[5.7]–表格与数据透视表实际应用.mp4 [21.16M]

{6}–Excel图形图表进行数据展示 [554.41M]

(6.2)–Excel2019各图表介绍.pdf [320.61K]

[6.1]–数据快速分析及使用推荐图表.mp4 [35.68M]

[6.10]–图表标题和图例.mp4 [19.75M]

[6.11]–坐标轴和网格线.mp4 [29.28M]

[6.12]–数据标签和数据表.mp4 [13.28M]

[6.13]–柱状图与条形图-各季度销售业绩和学员成绩.mp4 [35.87M]

[6.14]–折线图-收入成本利润走势.mp4 [10.24M]

[6.15]–散点图-收入成本利润趋势.mp4 [12.17M]

[6.16]–饼图-展示产品百分比.mp4 [8.81M]

[6.17]–组合图.mp4 [6.82M]

[6.18]–面积图-展示利润积累.mp4 [6.14M]

[6.19]–漏斗图-展示客户转化率.mp4 [16.37M]

[6.20]–图表与数据透视表组合展示.mp4 [20.45M]

[6.21]–树状图-展示多层数据的比例关系.mp4 [9.31M]

[6.22]–旭日图-展示多层数据的比例关系.mp4 [8.82M]

[6.23]–直方图与箱形图-展示数据分布.mp4 [15.84M]

[6.24]–瀑布图与堆积柱形图-展示企业成本的构成、变化情况.mp4 [13.98M]

[6.25]–迷你图插入编辑与删除.mp4 [159.54M]

[6.3]–插入、选择合适图表.mp4 [26.88M]

[6.4]–修改图表的数据源.mp4 [18.97M]

[6.5]–图表移动及更改大小.mp4 [19.66M]

[6.6]–图表区设置.mp4 [20.40M]

[6.7]–绘图区设置.mp4 [11.86M]

[6.8]–图表布局设置.mp4 [14.51M]

[6.9]–图表样式设置.mp4 [19.47M]

{7}–Excel数据查询编辑与表格样式 [312.08M]

[7.1]–条件格式1.mp4 [42.15M]

[7.10]–Excel查找内容和格式.mp4 [28.17M]

[7.11]–查找范围和选项.mp4 [44.94M]

[7.2]–条件格式2.mp4 [21.10M]

[7.3]–条件格式3.mp4 [22.01M]

[7.4]–条件格式4.mp4 [41.63M]

[7.5]–单元格样式1.mp4 [17.48M]

[7.6]–单元格样式2.mp4 [33.13M]

[7.7]–Excel表格样式应用.mp4 [32.50M]

[7.8]–Excel编辑批注.mp4 [8.70M]

[7.9]–Excel选择性粘贴.mp4 [20.29M]

{8}–Excel工作应用小技巧 [100.30M]

[8.1]–单元格自定义功能妙用.mp4 [59.19M]

[8.2]–制作表格目录.mp4 [9.10M]

[8.4]–快速合并数据.mp4 [3.86M]

[8.5]–TXT转为表格.mp4 [3.61M]

[8.6]–快速制作工资条.mp4 [15.88M]

[8.7]–合并工作表.mp4 [8.65M]

DPL_PYJUN [17.75K]

播放列表.dpl [17.75K]

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