新手学Excel 2010

第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从入门到精通》一书的多媒体视频教程。