新手学Excel 2010

新手学Excel 2010

杰创文化, 编著

出版社:科学出版社

年代:2011

定价:28.0

书籍简介:

Excel2010是一款功能强大的表格制作软件,可以创建工作表和工作簿,实现数据的输入、编辑、分析和输出,插入图形、图表,制作动态报表等,被广泛应用于公司文秘、行政管理、财务审计、市场销售和办公管理等多个领域,是一门实用性很强的职业技能。本书兼顾实用和易学两个特性,在分析知识点时,采用了大量常见问题作为示例,读者可以灵活套用、应对实际工作;详细的步骤演示,确保读者能掌握操作技法。

书籍目录:

第1章 初识Excel 2010 ??????????????????????? 1

1.1  安装与卸载Office 2010 ········································ 2

1.1.1 安装Office 2010 ························································2

1.1.2 卸载Office 2010 ························································4

1.2  启动与退出Excel 2010 ········································· 5

1.2.1 启动Excel 2010 ·························································5

1.2.2 退出Excel 2010 ·························································6

1.3  认识Excel 2010的新增功能 ·································· 7

1.3.1 小而精巧的迷你图 ······················································7

1.3.2 直观形象的筛选器——切片器 ·····································7

1.3.3 随时随地筛选与排序数据············································8

1.3.4 增强的筛选搜索功能——搜索框 ··································8

1.3.5 交互性更强的动态数据透视图 ·····································8

1.3.6 增强的条件格式设置功能 ···········································9

1.3.7 随用随抓的“屏幕截图”功能 ······································9

1.3.8 新增图片处理与艺术效果功能 ·································· 10

1.3.9 粘贴预览功能 ·························································· 10

1.4  Excel 2010在用户界面上的大变动 ························11

1.4.1 “文件”菜单更清晰 ·················································· 11

1.4.2 自定义功能区 ·························································· 11

1.4.3 快速访问工具栏 ······················································· 13

1.5  Excel 2010的基本操作 ······································ 14

1.5.1 创建Excel 2010工作簿 ·············································· 14

1.5.2 保存Excel 2010工作簿 ············································· 14

1.5.3 打开Excel 2010工作簿 ············································· 15

1.5.4 保护Excel 2010工作簿 ············································· 16

1.5.5 共享工作簿 ······························································ 18

2章 输入与编辑数据 ????????????????????? 20

2.1  输入数据 ·························································· 21

2.1.1 输入普通数据 ··························································· 21

2.1.2 同时输入多个数据 ····················································22

2.1.3 输入特殊数据 ··························································· 23

2.2  数据输入的实用技巧 ·········································· 24

2.2.1 数据的换行 ······························································ 24

2.2.2 分数的输入技巧 ······················································· 25

2.2.3 指数的输入技巧 ·······················································26

2.3  复制与移动数据 ················································· 27

2.3.1 使用命令复制与移动数据 ········································· 27

2.3.2 使用拖动法复制与移动数据 ·····································30

2.3.3 将数据复制为图片对象 ············································· 31

2.4  自动填充数据 ··················································· 32

2.4.1 使用“填充”命令填充序列 ········································32

2.4.2 使用拖动法填充有规律的数据 ···································33

2.4.3 自定义填充序列 ······················································34

2.5  查找与替换数据 ················································· 36

2.5.1 查找普通字符 ··························································36

2.5.2

内容摘要:

Excel 2010是专业的电子表格制作软件,可以快捷地生成电子表格,高效地输入数
据,运用公式和函数进行计算,实现数据的管理、计算和分析,生成直观的图形、专业
的报表等,因此被广泛应用于文秘办公、财务管理、市场营销和行政管理等事务中。
本书兼顾实用和易学两个特点,采用了大量常见问题作为示例,读者可以灵活套用、
应对实际工作,详细的步骤演示,确保读者能掌握操作技法。
本书共分12章。第1章介绍Microsoft Of?ce 2010软件的安装与卸载、Excel 2010的新增
功能等。第2章介绍普通和有规律的数据的输入、数据的复制与移动等。第3章~第4章介绍
工作表的插入、删除、复制和隐藏,工作簿窗口的管理和查看,以及单元格的格式设置、
条件格式和表格样式的应用等。第5章介绍图形的绘制、SmartArt图形和图片的插入与格式
设置。第6章介绍公式的使用和审核,以及财务、统计等常用函数的应用。第7章~第8章介
绍了图表的创建与图表格式的设置,数据透视表、数据透视图的创建与美化,以及图表分
析和迷你图的应用等。第9章~第10章介绍数据的排序、筛选和分类汇总,还介绍了数据分
析工具的应用。第11章介绍了数据的输出,包括工作表页面设置、打印效果预览及打印设
置等。第12章介绍了Excel与外部数据的协作,包括如何在Excel中导入文本文件、网页数
据、Access数据,还介绍了如何将Excel数据导入Word、PowerPoint和Access程序中。
本书配1CD多媒体教学光盘,内容极其丰富,具有较高的学习价值和使用价值。光盘
中不仅收录了部分实例的原始文件和最终文件,还有播放时间长达230分钟的162个重点
操作的视频教学文件,并附赠了《Of?ce 2010从入门到精通》一书的多媒体视频教程。

书籍规格:

书籍详细信息
书名新手学Excel 2010站内查询相似图书
9787030305916
如需购买下载《新手学Excel 2010》pdf扫描版电子书或查询更多相关信息,请直接复制isbn,搜索即可全网搜索该ISBN
出版地北京出版单位科学出版社
版次2版印次1
定价(元)28.0语种简体中文
尺寸26 × 19装帧平装
页数 280 印数

书籍信息归属:

新手学Excel 2010是科学出版社于2011.4出版的中图分类号为 TP391.13 的主题关于 电子表格系统,Excel 2010 的书籍。