Excel 2013表格、公式、函数与图表应用傻瓜书

01Excel 2013轻松入门1.1 Excel 2013的工作界面··························21.2 Excel 2013工作簿的基础操作···············31.2.1 新建工作簿··············································31.2.2 保存工作簿··············································41.2.3 打开工作簿··············································51.2.4 关闭工作簿··············································61.2.5 隐藏工作簿··············································61.3 工作簿的多窗口显示······························71.3.1 创建新窗口··············································71.3.2 切换窗口··················································81.3.3 全部重排··················································91.3.4 视图缩放················································101.4 Excel 2013工作环境的设置················· 131.4.1 显示与隐藏网格线································131.4.2 显示与隐藏标尺····································141.4.3 设置自动保存时间间隔························141.4.4 设置文档的默认保存路径····················151.4.5 设置文档的默认保存类型····················161.4.6 隐藏与显示功能区································161.5 共享工作簿··········································· 171.5.1 创建共享工作簿····································171.5.2 修订共享工作簿····································181.5.3 接受/拒绝修订工作簿···························1902输入与编辑Excel表格数据2.1 Excel单元格数据编辑·························· 222.1.1 选择单元格············································222.1.2 插入单元格············································232.1.3 删除单元格············································242.1.4 清除单元格···········································252.1.5 命名单元格···········································262.1.6 移动单元格数据···································272.1.7 复制单元格数据···································282.1.8 合并多个单元格···································292.1.9 取消单元格合并···································302.2 手动输入数据·······································302.2.1 输入文本型数据···································302.2.2 将数字转化为文本·······························312.2.3 输入日期或时间···································312.2.4 输入货币型数据···································322.2.5 快速填充相同数据·······························332.3 填充数据···············································342.3.1 设置记忆式输入···································342.3.2 使用填充柄自动填充数据···················342.3.3 使用“填充”命令填充数据···············352.3.4 文本序列填充·······································352.3.5 自定义填充序列···································362.4 编辑数据···············································372.4.1 修改数据···············································372.4.2 选择性粘贴···········································382.4.3 撤销和恢复数据···································392.4.4 查找和替换数据···································3903工作表格式设置与美化3.1 设置单元格格式····································423.1.1 设置字体格式·······································423.1.2 设置数字格式·······································433.1.3 使用格式刷···········································433.2 设置对齐方式·······································443.2.1 设置水平和垂直对齐方式···················443.2.2 设置旋转文本·······································463.3 格式化单元格······································· 473.3.1 调整行高和列宽··································· 473.3.2 设置单元格边框··································· 493.3.3 设置单元格背景色和图案··················· 503.3.4 设置工作表的背景图··························· 513.4 文字拼音·············································· 523.4.1 添加拼音··············································· 523.4.2 显示和隐藏拼音··································· 533.4.3 编辑拼音字段······································· 533.4.4 设置拼音格式······································· 543.5 套用表格样式······································· 553.5.1 应用表样式··········································· 553.5.2 自定义表格样式··································· 563.6 使用单元格样式··································· 583.6.1 应用单元格样式··································· 583.6.2 创建新样式··········································· 583.6.3 修改样式··············································· 593.6.4 删除样式··············································· 603.7 使用条件格式······································· 613.7.1 设置三色条件格式······························· 613.7.2 使用数据条格式··································· 623.7.3 更改条件格式······································· 633.7.4 删除条件格式······································· 6404 使用公式快速计算4.1 关于公式·············································· 664.1.1 公式的结构··········································· 664.1.2 运算符··················································· 664.1.3 运算符优先级······································· 674.2 公式的基本操作··································· 684.2.1 在单元格中输入公式··························· 684.2.2 在编辑栏中输入公式··························· 694.2.3 结合键盘和鼠标输入公式··················· 704.2.4 在公式中使用括号······························· 714.3 编辑公式·············································· 724.3.1 显示公式··············································· 724.3.2 修改公式··············································· 724.3.3 复制公式··············································· 734.4 审核公式··············································744.4.1 检查错误··············································· 744.4.2 追踪引用单元格··································· 754.4.3 追踪从属单元格··································· 754.4.4 移去箭头··············································· 764.5 单元格的引用·······································774.5.1 相对引用··············································· 774.5.2 绝对引用··············································· 784.5.3 混合引用··············································· 7905 使用函数高效办公5.1 函数简介··············································825.1.1 认识函数··············································· 825.1.2 函数分类··············································· 825.2 函数的输入和编辑································835.2.1 输入函数··············································· 835.2.2 复制函数··············································· 845.3 统计函数··············································855.3.1 AVERAGE 函数··································· 855.3.2 MAX 函数············································ 865.3.3 COUNTA函数····································· 885.3.4 COUNT函数········································ 895.4 文本函数··············································905.4.1 EXACT函数········································ 905.4.2 LOWER 与UPPER 函数····················· 925.4.3 CONCATENATE 函数························· 955.4.4 REPT 函数············································ 975.4.5 SUBSTITUTE函数······························ 995.5 数学与三角函数··································1015.5.1 ABS 函数············································ 1015.5.2 INT 函数············································· 1025.5.3 ODD 与EVEN函数·························· 1045.5.4 SUM 函数··········································· 1065.5.5 DEGREES函数·································· 1095.6 逻辑函数············································ 1105.6.1 AND 函数············································1105.6.2 OR 函数···············································1115.6.3 NOT 函数·············································1125.6.4 IF 函数·················································1135.7 财务函数············································ 1145.7.1 折旧计算函数······································1145.7.2 本利计算函数······································1155.7.3 报酬计算函数······································11706 创建与编辑图表6.1 认识图表············································ 1206.1.1 图表结构··············································1206.1.2 图表类型··············································1216.2 创建图表············································ 1246.2.1 创建基本图表······································1246.2.2 使用快捷键创建图表··························1256.2.3 创建组合图表······································1256.2.4 移动图表的位置··································1276.2.5 转变图表类型······································1286.2.6 创建迷你图··········································1286.3 编辑图表数据····································· 1306.3.1 更改系列值··········································1316.3.2 删除系列··············································1316.3.3 添加系列··············································1326.3.4 重新选择图表数据区域······················1346.3.5 处理隐藏的单元格······························1356.3.6 改变数据系列的产生方式··················1356.4 更改图表布局····································· 1366.4.1 添加图表元素······································1366.4.2 添加数据标签······································1376.4.3 添加网格线··········································1386.4.4 添加坐标轴标题··································1396.4.5 将标题链接到单元格··························1396.4.6 更改图例的位置··································1416.4.7 应用快速布局样式······························1416.5 应用趋势线和误差线··························1426.5.1 添加趋势线·········································1426.5.2 添加误差线·········································1436.6 美化图表·············································1446.6.1 更改图表颜色·····································1446.6.2 更改图表样式·····································1456.6.3 通过格式窗格设置格式·····················1456.6.4 使用“格式”选项卡设置图表格式·············································1476.6.5 插入形状·············································1496.6.6 插入图片·············································1506.6.7 设置图片填充·····································15107 Excel数据管理与分析7.1 数据的排序·········································1547.1.1 排序规则·············································1547.1.2 简单排序·············································1557.1.3 多关键字排序·····································1557.1.4 更改排序依据·····································1567.1.5 自定义序列排序·································1577.2 数据的筛选·········································1587.2.1 按文本值筛选·····································1587.2.2 按数字筛选·········································1607.2.3 高级筛选·············································1617.3 数据的分类汇总··································1627.3.1 认识分类汇总·····································1627.3.2 简单分类汇总·····································1637.3.3 删除分类汇总·····································1657.3.4 嵌套分类汇总·····································1657.4 数据的合并计算··································1677.4.1 按位置合并计算·································1677.4.2 按分类合并计算·································1687.5 数据的有效性·····································1707.5.1 设置数据有效性·································1707.5.2 圈释错误信息·····································17208 数据透视表与数据透视图8.1 创建数据透视表································· 1748.1.1 在新工作表中创建数据透视表········· 1748.1.2 在当前工作表中创建数据透视表····· 1758.2 移动与删除数据透视表······················ 1768.2.1 移动透视表········································· 1768.2.2 删除数据透视表································· 1778.3 更改行标签和列标签·························· 1778.3.1 更改行标签层次结构························· 1788.3.2 添加列标签········································· 1788.4 筛选数据透视表数据·························· 1798.4.1 在透视表中筛选数据························· 1798.4.2 在“数据透视表字段”窗格中筛选数据············································· 1798.5 更改数据透视表的布局······················ 1808.5.1 显示/隐藏分类汇总···························· 1808.5.2 设置报表布局····································· 1818.5.3 更改数据透视表样式························· 1828.6 数据透视表排序································· 1828.6.1 简单排序············································· 1838.6.2 自定义排序条件································· 1838.7 字段设置············································ 1858.7.1 更改字段名称····································· 1858.7.2 更改值的汇总方式····························· 1868.7.3 以总计百分比显示数据····················· 1878.7.4 以百分比显示数据····························· 1878.8 使用切片器········································ 1888.8.1 创建切片器········································· 1888.8.2 筛选数据············································· 1898.8.3 删除切片器········································· 1908.8.4 更改切片器样式································· 1908.9 使用筛选器········································ 1928.9.1 添加筛选器········································· 1928.9.2 显示报表筛选页································· 1938.10 使用条件格式···································1948.10.1 突出显示单元格规则······················· 1948.10.2 使用项目选取规则··························· 1958.11 数据透视表的其他操作·····················1958.11.1 显示详细信息··································· 1968.11.2 复制数据··········································· 1968.12 使用数据透视图································1978.12.1 使用现有数据透视表创建数据透视图······································· 1978.12.2 创建全新数据透视图······················· 1988.12.3 使用数据透视图筛选数据··············· 1998.12.4 转换为标准图表······························· 20009 宏与VBA 应用9.1 宏与安全设置···································· 2029.1.1 认识宏················································· 2029.1.2 更改宏的安全设置····························· 2029.1.3 打开包含宏的工作簿························· 2039.2 宏的录制与执行································· 2039.2.1 显示“开发工具”选项卡················· 2049.2.2 创建宏················································· 2049.2.3 使用“宏”对话框执行宏················· 2059.2.4 使用快捷键执行宏····························· 2069.2.5 指定宏················································· 2069.3 宏的其他操作···································· 2079.3.1 保存宏文档········································· 2079.3.2 删除宏················································· 2089.3.3 更改执行宏的快捷键························· 2099.3.4 编辑宏················································· 2099.3.5 加载宏················································· 2099.4 认识VBA··········································· 2109.4.1 VBA 简介··········································· 2109.4.2 VBA 与VB 的关系·····························2119.5 熟悉VBA 开发环境····························2119.5.1 用户界面组成······································2119.5.2 工程资源管理器窗口··························2129.5.3 代码窗口··············································2129.5.4 监视窗口··············································2139.5.5 属性窗口··············································2139.5.6 立即窗口··············································2149.5.7 对象浏览器窗口··································2149.6 VBA 语法基础····································2159.6.1 数据类型··············································2159.6.2 常量与变量··········································2179.6.3 VBA 运算符与表达式························2199.6.4 程序结构··············································2229.6.5 数组······················································2279.6.6 SUB 过程·············································2289.6.7 Function 函数·······································2309.6.8 使用按钮控件······································2339.6.9 其他控件属性······································23410 创建链接与引用10.1 插入超链接·······································23810.1.1 创建指向现有文件的超链接············23810.1.2 创建指向特定网页的超链接············23910.1.3 创建指向工作表的超链接················24010.1.4 创建指向特定单元格的超链接········24010.1.5 选中超链接单元格····························24210.1.6 删除超链接········································24210.2 数据引用··········································24310.2.1 引用本工作表内的单元格················24310.2.2 引用其他工作表的单元格················24310.2.3 引用其他工作簿的单元格················24410.2.4 粘贴引用链接····································24510.3 嵌入与链接文件·······························24610.3.1 嵌入Word 文档·································24610.3.2 嵌入PowerPoint演示文稿···············24710.3.3 链接Excel 工作簿·····························24711 工作表打印与输出11.1 设置页面版式··································· 25011.1.1 设置页边距········································25011.1.2 设置纸张大小····································25111.1.3 设置打印区域····································25211.1.4 设置打印顺序····································25311.2 设置页眉和页脚······························· 25311.2.1 添加预定义页眉和页脚···················25311.2.2 自定义页眉和页脚····························25411.3 使用分页符······································ 25611.3.1 插入分页符········································25611.3.2 调整分页符········································25711.3.3 删除分页符········································25811.4 打印工作表······································ 25911.4.1 快速打印工作表································25911.4.2 设置打印参数····································26011.5 添加工作表水印效果························ 26011.5.1 制作图片水印····································26011.5.2 制作文字水印····································26212 Excel数据安全与保护12.1 使用隐藏的方式保护数据················ 26612.1.1 隐藏行或列·······································26612.1.2 显示隐藏的行或列···························26612.1.3 隐藏工作表·······································26712.1.4 取消隐藏工作表·······························26712.1.5 隐藏工作簿·······································26712.1.6 显示隐藏的工作簿···························26812.2 使用密码保护数据··························· 26912.2.1 保护特定单元格·······························26912.2.2 限定工作表可用的操作···················27112.2.3 设置工作簿打开密码·······················27212.2.4 保护工作簿结构·······························273

零点起步 循序渐进：真正为初学者量身定做的入门书，步步为营系统全面 超值实用：囊括初学者需要掌握的必备知识，丰富全面全程图解 快速上手：全程采用图解互动讲解的新模式，直观易学注重方法 高效学习：电脑教育专家多年的总结与心得，重在方法版式新颖 赏心悦目：采用精美双栏新版式与单色印刷，超大容量视频光盘 即学即会：提供全程教学精彩视频素材文件，超值方便——————————————————————————精选丰富实用案例，现场视频演示额外免费赠送《外行学电脑傻瓜书》《Photoshop图像处理傻瓜书》视频教程一书多用，超大容量，物超所值本书以零基础讲解为宗旨，用实例引导读者学习，深入浅出地介绍了Excel 2013表格制作、公式、函数与图表应用的方法与技巧。本书知识系统全面、实例教学丰富、步骤详尽清晰、视频演示直观，使读者学起来轻松，做起来有趣，在实践操作中不断提高自身水平，完成从新手到高手的飞跃。本书共分为12章，其中包括Excel 2013轻松入门、输入与编辑Excel表格数据、工作表格式设置与美化、使用公式快速计算、使用函数高效办公、创建与编辑图表、Excel数据管理与分析、数据透视表与数据透视图、宏与VBA应用、创建链接与引用、工作表打印与输出、Excel数据安全与保护等。本书讲解详细，注重实用，适用于各级别的Excel使用者阅读，同时也可作为大中专院校以及社会各类培训班的首选教材，对有一定经验的Excel使用者来说也有很高的参考价值。

零点起步 循序渐进：真正为初学者量身定做的入门书，步步为营　　系统全面 超值实用：囊括初学者需要掌握的必备知识，丰富全面　　全程图解 快速上手：全程采用图解互动讲解的新模式，直观易学　　注重方法 高效学习：电脑教育专家多年的总结与心得，重在方法　　版式新颖 赏心悦目：采用精美双栏新版式与单色印刷，超大容量　　视频光盘 即学即会：提供全程教学精彩视频素材文件，超值方便　　精选丰富实用案例，现场视频演示　　额外免费赠送《外行学电脑傻瓜书》《Photoshop图像处理傻瓜书》视频教程　　一书多用，超大容量，物超所值