Quick. easy. 2 day Institute Excel form and data processing (2016 Edition) (Attached CD-ROM)(Chinese Edition)

YI XIAN WEN HUA ZHU

ISBN 10: 7113216951 / ISBN 13: 9787113216955

Published by 中国铁道出版社, 2016

About this Item

Language:Chinese.Paperback. Pub Date:2016-07-01 Publisher: Chinese Railway Press book system and comprehensively introduces the Excel2016 data table to create and edit. format setting. Excel formula and the use of function. data management and analysis. statistical charts and the PivotTable application content of Excel and VBA. acer. This is a.

Seller Inventory # DN053677

Bibliographic Details

• Title: Quick. easy. 2 day Institute Excel form and data processing (2016 Edition) (Attached CD-ROM)(Chinese Edition)
• Publisher: ???????
• Publication Date: 2016
• Language: Chinese
• ISBN 10: 7113216951
• ISBN 13: 9787113216955
• Binding: paperback
• Condition: New

About this title

Synopsis

本书系统并全面地介绍了Excel2016数据表格的创建与编辑、表格格式设置、Excel公式与函数的使用、数据的管理与分析处理、统计图表与透视表的使用、Excel宏与VBA的应用等内容。这是一本一看就懂、一学就会的Excel2016表格与数据处理自学速成图书，在编写过程中，突出知识的实用性、强调内容的易学性，采用“步骤讲述+图解标注”的方式进行编写，非常适合Excel新手学习。第1课Excel数据表格的创建与编辑1.1工作簿的基本操作..................21.1.1新建工作簿...................21.1.2保存工作簿...................31.1.3打开工作簿...................41.2单元格的选中......................51.2.1快速选中某个单元格...........51.2.2选中连续的多个单元格.........61.2.3选中不连续的多个单元格.......61.3输入表格数据......................71.3.1输入文本.....................71.3.2输入文本型数字...............81.3.3输入日期与时间...............81.3.4输入特殊符号.................91.4编辑表格数据.....................101.4.1快速填充数据................101.4.2修改单元格中的数据..........121.4.3移动和复制数据..............131.4.4查找与替换数据..............141.4.5设置录入数据的有效性........151.5工作表的管理.....................161.5.1重命名工作表................171.5.2插入与删除工作表............171.5.3移动与复制工作表............181.5.4隐藏工作表..................191.6工作簿的管理.....................191.6.1对工作簿进行加密............191.6.2恢复被损坏的工作簿..........201.6.3拆分工作簿窗口..............211.6.4冻结工作簿窗口..............211.7工作簿或工作表的打印.............211.7.1页面设置....................221.7.2选定打印区域................221.7.3取消打印....................22学习小结...........................30第2课Excel工作表的格式设置2.1单元格的基本操作.................322.1.1调整单元格行高与列宽........322.1.2插入单元格、行和列..........332.1.3删除单元格、行和列..........342.1.4合并与拆分单元格........