Microsoft-Excel2010基础操作培训学习教程.docx

培训教程Excel 2010基础操作  培训教程 Excel 2010基础操作 目 录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc426130759 1基本操作 PAGEREF _Toc426130759 \h 5 HYPERLINK \l _Toc426130760 1.1启动Excel 2010 PAGEREF _Toc426130760 \h 5 HYPERLINK \l _Toc426130761 1.2认识 Excel 2010工作环境 PAGEREF _Toc426130761 \h 6 HYPERLINK \l _Toc426130762 1.2.1选项卡 PAGEREF _Toc426130762 \h 6 HYPERLINK \l _Toc426130763 1.2.2功能区 PAGEREF _Toc426130763 \h 7 HYPERLINK \l _Toc426130764 1.2.3快速访问工具栏 PAGEREF _Toc426130764 \h 9 HYPERLINK \l _Toc426130765 1.2.4单元格与单元格地址 PAGEREF _Toc426130765 \h 10 HYPERLINK \l _Toc426130766 1.2.5标签 PAGEREF _Toc426130766 \h 11 HYPERLINK \l _Toc426130767 1.2.6显示比例 PAGEREF _Toc426130767 \h 12 HYPERLINK \l _Toc426130768 1.3新建工作簿 PAGEREF _Toc426130768 \h 12 HYPERLINK \l _Toc426130769 1.4保存工作簿 PAGEREF _Toc426130769 \h 13 HYPERLINK \l _Toc426130770 1.5打开工作簿 PAGEREF _Toc426130770 \h 15 HYPERLINK \l _Toc426130771 1.6退出工作簿 PAGEREF _Toc426130771 \h 16 HYPERLINK \l _Toc426130772 2 Excel 2010工作表基本操作 PAGEREF _Toc426130772 \h 16 HYPERLINK \l _Toc426130773 2.1新建工作表 PAGEREF _Toc426130773 \h 16 HYPERLINK \l _Toc426130774 2.2重命名工作表 PAGEREF _Toc426130774 \h 18 HYPERLINK \l _Toc426130775 2.3删除工作表 PAGEREF _Toc426130775 \h 18 HYPERLINK \l _Toc426130776 3应用案例一：课程表的制作 PAGEREF _Toc426130776 \h 19 HYPERLINK \l _Toc426130777 3.1选择单元格 PAGEREF _Toc426130777 \h 19 HYPERLINK \l _Toc426130778 3.1.1选择单个单元格 PAGEREF _Toc426130778 \h 19 HYPERLINK \l _Toc426130779 3.1.2选择多个连续单元格 PAGEREF _Toc426130779 \h 20 HYPERLINK \l _Toc426130780 3.2合并单元格 PAGEREF _Toc426130780 \h 20 HYPERLINK \l _Toc426130781 3.3文本输入 PAGEREF _Toc426130781 \h 21 HYPERLINK \l _Toc426130782 3.4数据的高效录入 PAGEREF _Toc426130782 \h 22 HYPERLINK \l _Toc426130783 3.4.1序列文本的输入 PAGEREF _Toc426130783 \h 22 HYPERLINK \l _Toc426130784 3.4.2相同文本的录入 PAGEREF _Toc426130784 \h 23 HYPERLINK \l _Toc426130785 3.4.3规律数字的录入 PAGEREF _Toc426130785 \h 23 HYPERLINK \l _Toc426130786 3.5编辑工作表中的数据 PAGEREF _Toc426130786 \h 24 HYPERLINK \l _Toc4