Excel 2016: From Beginner to Advanced

Name: Excel 2016: From Beginner to Advanced
ISBN: 9787115434043

Longma Gaoxin Education / 任可Posts & Telecom Press · ChinaApr 2017

3.4

Word count: 84K words
Chapters: 271
ISBN: 9787115434043

Report an error Find this book

Summary

Excel 2016入门与提高 uses carefully selected cases to guide readers through a systematic introduction to Excel 2016 knowledge and practical techniques. The book has 13 chapters. Chapter 1 introduces the basics of Excel 2016; chapters 2–6 cover basic use, including essential operations, entering and editing information, beautifying worksheets, illustrations, and charts; chapters 7–9 cover advanced applications, including formulas, functions, data analysis and management, and pivot tables and pivot charts; chapters 10–12 use hands-on cases to show Excel in financial management, human resources management, and marketing; chapter 13 presents practical Excel tips, including collaboration between Excel and other Office components, sharing and collaboration in Excel 2016, and mobile office work on phones and tablets. The accompanying DVD multimedia teaching disc contains instructional videos synchronized with the book and supporting material and result files for all cases. It also includes many instructional videos and expanded-learning e-books on related topics. The book is suitable not only for beginner and intermediate Excel 2016 users but also as a textbook or supplementary reader for students in related programs and trainees in computer training courses.

Editor's review

Planned by the Longma Gaoxin Education team, Excel 2016入门与提高 is a practical tutorial for Excel beginners. Its defining feature is a dual-track “knowledge point + case” teaching approach that integrates dry feature explanations into real office scenarios such as financial statement preparation, sales data analysis, and inventory management, enabling readers to understand and apply skills quickly. The book covers not only basic Excel 2016 operations—cell editing, formulas and functions, and chart creation—but also advanced topics such as pivot tables, what-if analysis, and macros and VBA programming, in a complete and well-layered knowledge system. As a representative computer title from Posts & Telecom Press, the book is clearly organized, richly illustrated, and detailed in steps, making it especially suitable for self-study. In terms of depth, it serves both as a quick-start tool for workplace newcomers and as a systematic review and upgrade for users with some foundation. Compared with similar books, it is more practical and its cases are closer to real work needs, making it a handy office-efficiency guide worth keeping within reach for reference.

Who it's for

A good fit for

Workplace newcomers or students who need to learn Excel 2016 systematically
Users with some foundation who want to improve data analysis and automation skills
Office staff in finance, administration, sales, and other roles who use Excel frequently
Self-learners who prefer to master software through hands-on cases

Not a good fit for

Experienced users who have already mastered advanced Excel features (such as complex VBA programming)
Minimalist users who only need to know the basic Excel interface and do not need functions or data analysis

Reading tips

Work through the chapters in order, solidifying basic operations before tackling advanced content such as pivot tables and macros
Practice along with the book’s cases and try to transfer the methods to your own work
For functions or VBA sections, reread as needed and deepen understanding with Excel’s built-in help

About the publisher

Posts & Telecom Press China · Founded in 1953

Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.

版权信息
内容提要
前言
第1章 Excel 2016快速入门
1.1 Excel的行业应用
1.2 Excel 2016的安装与卸载
1.2.1 计算机配置要求
1.2.2 安装Excel 2016
1.2.3 卸载Excel 2016
1.3 Excel 2016的启动与退出
1.3.1 启动Excel 2016
1.3.2 退出Excel 2016
1.4 Excel 2016的三大元素
1.4.1 工作簿
1.4.2 工作表
1.4.3 单元格
1.5 Excel 2016的操作界面
1.6 实战演练——使用Office助手Tell Me
高手私房菜
技巧1：双击无法打开.xlsx格式文件的解决方法
技巧2：将自定义的操作界面快速转移到其他计算机中
第2章 Excel的基本操作
2.1 工作簿的基本操作
2.1.1 创建工作簿
2.1.2 保存工作簿
2.2 工作表的基本操作
2.2.1 新建工作表
2.2.2 选择单个或多个工作表
2.2.3 重命名工作表
2.2.4 移动或复制工作表
2.2.5 显示和隐藏工作表
2.2.6 设置工作表标签颜色
2.2.7 保护工作表
2.3 单元格的基本操作
2.3.1 选择单元格
2.3.2 插入与删除单元格
2.3.3 合并与拆分单元格
2.3.4 选择行和列
2.3.5 插入/删除行和列
2.3.6 调整行高和列宽
2.4 复制与移动单元格区域
2.4.1 利用鼠标复制与移动单元格区域
2.4.2 利用剪贴板复制与移动单元格区域
2.4.3 用插入方式复制单元格区域
2.5 实战演练——修改员工信息表
高手私房菜
技巧1：删除最近使用过的工作簿记录
技巧2：仅显示包含内容的单元格区域
第3章输入和编辑表格信息
3.1 Excel的输入技巧
3.1.1 输入文本
3.1.2 输入数值
3.1.3 输入日期和时间
3.1.4 导入外部数据
3.2 设置单元格的数据类型
3.2.1 常规格式
3.2.2 数值格式
3.2.3 货币格式
3.2.4 会计专用格式
3.2.5 日期和时间格式
3.2.6 百分比格式
3.2.7 分数格式
3.2.8 文本格式
3.2.9 特殊格式
3.2.10 自定义格式
3.3 快速填充表格数据
3.3.1 使用填充柄
3.3.2 使用填充命令
3.3.3 数值序列填充
3.3.4 多个单元格的数据填充
3.3.5 同时填充多个工作表
3.4 查找与替换数据
3.5 撤销与恢复数据
3.6 实战演练——制作员工考勤表
高手私房菜
技巧1：输入以“0”开头的数字
技巧2：输入带有货币符号的金额
第4章美化工作表
4.1 设置字体
4.1.1 设置字体和字号
4.1.2 设置字体颜色
4.2 设置对齐方式
4.2.1 对齐方式
4.2.2 自动换行
4.3 设置边框和底纹
4.3.1 使用功能区设置边框
4.3.2 使用对话框设置边框
4.3.3 设置边框线型
4.3.4 删除边框
4.4 使用条件样式
4.4.1 设置条件样式
4.4.2 管理条件格式
4.4.3 清除条件格式
4.5 快速套用表格样式
4.6 设置单元格样式
4.7 使用主题
4.8 实战演练——美化员工工资表
高手私房菜
技巧1：新建单元格样式
技巧2：在Excel中绘制斜线表头
第5章使用插图
5.1 插入艺术字
5.1.1 添加艺术字
5.1.2 设置艺术字的格式
5.2 插入图片
5.2.1 插入本地图片
5.2.2 插入联机图片
5.2.3 编辑图片
5.3 插入自选图形
5.3.1 绘制自选图形
5.3.2 在形状中添加文字
5.3.3 组合图形对象
5.3.4 美化自选图形
5.4 使用SmartArt图形
5.4.1 创建SmartArt图形
5.4.2 改变SmartArt图形布局
5.4.3 应用颜色和主题
5.4.4 调整SmartArt图形的大小
5.5 实战演练——绘制网上零售订单处理流程图
高手私房菜
技巧1：用Shift键绘制标准图形
技巧2：在Excel工作表中插入Flash动画
第6章使用图表
6.1 图表及其特点
6.1.1 直观形象
6.1.2 种类丰富
6.1.3 双向联动
6.1.4 二维坐标
6.2 图表的组成元素
6.3 创建图表
6.3.1 使用快捷键创建图表
6.3.2 使用功能区创建图表
6.3.3 使用图表向导创建图表
6.4 不同图表的创建及使用方法
6.4.1 使用柱形图显示学生成绩差距
6.4.2 使用折线图显示销量变化
6.4.3 使用饼图显示公司费用支出情况
6.4.4 使用条形图显示销售业绩情况
6.4.5 使用面积图显示各区域在各季度的销售情况
6.4.6 使用XY散点图（气泡图）显示各区域销售完成情况
6.4.7 使用股价图显示股价的涨跌
6.4.8 使用曲面图显示成本分析情况
6.4.9 使用雷达图显示产品销售情况
6.4.10 使用树状图显示图书销售情况
6.4.11 使用旭日图分析不同季度、月份产品销售额所占比例
6.4.12 使用直方图显示考试成绩分数分布情况
6.4.13 使用箱形图显示销售情况的平均值和离群值
6.4.14 使用瀑布图反映投资收益情况
6.5 编辑图表
6.5.1 在图表中插入对象
6.5.2 创建组合图表
6.5.3 调整图表的大小
6.5.4 移动和复制图表
6.6 美化图表
6.6.1 使用图表样式
6.6.2 设置填充效果
6.6.3 使用图片填充图表
6.6.4 添加趋势线
6.7 插入迷你图
6.7.1 创建迷你图
6.7.2 编辑迷你图
6.7.3 清除迷你图
6.8 实战演练——制作销售情况统计表
高手私房菜
技巧1：打印工作表时，不打印图表
技巧2：在Excel中制作动态图表
第7章公式与函数
7.1 认识公式与函数
7.1.1 公式的概念
7.1.2 公式中的运算符
7.1.3 公式中的运算符优先级
7.1.4 函数的概念
7.1.5 函数的分类和组成
7.2 快速计算
7.2.1 自动显示计算结果
7.2.2 自动求和
7.3 公式的输入与编辑
7.3.1 输入公式
7.3.2 编辑公式
7.3.3 审核公式
7.4 单元格引用
7.4.1 单元格引用与引用样式
7.4.2 相对引用
7.4.3 绝对引用
7.4.4 混合引用
7.5 使用引用
7.5.1 输入引用地址
7.5.2 引用当前工作表中的单元格
7.5.3 引用当前工作簿中其他工作表中的单元格
7.5.4 引用其他工作簿中的单元格
7.5.5 引用交叉区域
7.6 函数
7.6.1 函数的输入与编辑
7.6.2 文本函数
7.6.3 逻辑函数
7.6.4 财务函数
7.6.5 时间与日期函数
7.6.6 查找与引用函数
7.6.7 数学与三角函数
7.6.8 其他函数
7.7 实战演练——制作销售奖金计算表
高手私房菜
技巧1：查看部分公式的运行结果
技巧2：逻辑函数间的混合运用
第8章数据的分析与管理
8.1 数据的筛选
8.1.1 自动筛选
8.1.2 高级筛选
8.1.3 取消筛选
8.2 数据的排序
8.2.1 单条件排序
8.2.2 多条件排序
8.2.3 按行排序
8.2.4 按列排序
8.2.5 自定义排序
8.3 设置数据验证
8.3.1 设置数据验证的条件
8.3.2 数据验证的应用
8.4 数据的分类汇总
8.4.1 简单分类汇总
8.4.2 多重分类汇总
8.5 数据的合并运算
8.6 实战演练——制作汇总销售记录表
高手私房菜
技巧1：对同时包含字母和数字的文本进行排序
技巧2：限制只能输入汉字
第9章数据透视表和数据透视图
9.1 认识数据透视表和数据透视图
9.1.1 数据透视表
9.1.2 数据透视图
9.1.3 数据透视图与标准图表之间的区别
9.2 创建和编辑数据透视表
9.2.1 数据透视表的有效数据源
9.2.2 创建数据透视表
9.2.3 编辑数据透视表
9.2.4 美化数据透视表
9.3 创建和编辑数据透视图
9.3.1 创建数据透视图
9.3.2 编辑数据透视图
9.4 实战演练——制作销售业绩透视表/图
高手私房菜
技巧1：将数据透视表转换为静态图片
技巧2：改变数据透视表的布局
第10章 Excel在财务管理中的应用
10.1 制作公司利润表
10.2 制作项目成本预算分析表
10.3 制作住房贷款速查表
第11章 Excel在人力资源管理中的应用
11.1 制作应聘人员基本情况登记表
11.2 制作员工年假表
11.3 制作员工年度考核表
第12章 Excel在市场营销中的应用
12.1 制作产品销售分析图表
12.2 汇总与统计销售额
12.3 用数据透视表分析员工销售业绩
第13章 Excel实战秘技
13.1 Excel与其他Office组件间的协作
13.1.1 在Word中创建Excel工作表
13.1.2 在PowerPoint中调用Excel工作表
13.1.3 在Excel中调用Word或PPT
13.2 Excel 2016的共享协作
13.2.1 使用OneDrive协同处理Excel
13.2.2 通过邮件共享Excel
13.3 使用手机/平板电脑玩转Excel
13.3.1 配置微软Office Excel
13.3.2 将计算机中的Excel文档发送到手机中
13.3.3 在手机中打开Excel文档
13.3.4 新建Excel工作簿
13.3.5 制作业绩管理及业绩评估分析表
13.3.6 将工作簿以邮件附件形式发送给他人
下载链接

FAQ

Is this book suitable for complete beginners?

Very suitable. It starts with an introduction to the software interface and gradually guides readers through basic operations, with cases designed from easy to advanced, so beginners can follow along.

Does the book cover new features in Excel 2019 or later versions?

The book focuses on Excel 2016. Its core features are common to later versions, but it does not cover new functions or interface changes unique to Excel 2019 and later.

Are practice files or materials provided?

The cases usually provide operation steps and sample data, and readers can build their own practice environment from the descriptions. Some editions may include online learning resources.

Related on WeRead

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

Longma Gaoxin Education Author

Founded in 1998, Longma Gaoxin Education is an educational publishing organization specializing in the planning and writing of computer-related books. It is affiliated with Longma Studio and has long cooperated with multiple universities, industry associations, and websites. Its works cover areas such as software learning, general computing, and architecture, focusing on commonly used software including Office, Word, Excel, and AutoCAD. It has developed series such as "From Beginner to Master," "Complete Self-Study Manual," and "Programming Treasure," with 68 titles in the library. Its writing emphasizes progressive difficulty, clear steps, and close alignment with practical operation, making it easy for beginners and self-learners to follow. The organization has won the National Excellent Bestseller Award multiple times and has a certain influence in the field of popular computer reading materials. Due to limited public information, its staffing and detailed development history are not elaborated here.

任可 Author

Ren Ke is the author of books on software learning in Chinese. Public information about the author is currently limited: Ren Ke is known only for one work, Excel 2016: From Beginner to Advanced, which is classified under software learning. Judging from the title and category, the book is intended for readers who want to gain a systematic command of Excel 2016, covering basic functions such as creating spreadsheets, organizing data, using formulas and functions, and presenting charts, while also explaining more advanced techniques. It thus addresses both beginners and readers seeking to improve their skills. The author's approach is presumably to provide clear steps and concrete examples, so that readers can learn by doing and turn software functions into practical working ability. Books on software tools prove their value in lowering the learning threshold and saving time. Although Ren Ke has only this one work in the collection, it can be seen as a practical attempt in the field of office software instruction, suitable for beginners and for professionals who need to consolidate their foundations.