正版包邮 华研Word Excel PPT WPS Photoshop商务办公软件教程书籍 电脑计算机应用零基础函数表格制作教材自学入门到精通.

第一篇Word应用篇   

 

第1章   文本类文档制作                                                                   001

 

◎1.1    制作劳动合同..................................................................................................002

1.1.1     创建劳动合同文档..............................................................................002

1.1.2     编辑劳动合同内文..............................................................................003

1.1.3     阅览劳动合同......................................................................................007

1.1.4     打印劳动合同......................................................................................009

◎1.2    制作员工手册..................................................................................................010

1.2.1     制作封面..............................................................................................011

1.2.1     输入内容并设置格式..........................................................................012

1.2.3     提取目录..............................................................................................015

◎1.3    同步训练...........................................................................................................017

◎1.4    高手进阶——文本录入技巧.......................................................................018

第2章   表格类文档制作                                                                   019

◎2.1    制作旅游景点宣传单.....................................................................................020

2.1.1     页面设置..............................................................................................020

2.1.2     制作宣传单页头..................................................................................021

2.1.3     编排正文内容......................................................................................024

◎2.2    制作个人简历..................................................................................................028

2.2.1     表格的插入与调整..............................................................................029

2.2.2     填写表格内容......................................................................................031

2.2.3     美化表格..............................................................................................032

◎2.3    同步训练...........................................................................................................033

◎2.4    高手进阶——图形与表格处理技巧..........................................................034

第3章   商务文档制作                                                                       036

◎3.1    制作企业文件模板.........................................................................................037

3.1.1     制作模板页眉......................................................................................037

3.1.2     制作模板页脚......................................................................................039

3.1.3     添加水印图片......................................................................................040

3.1.4     保存为模板文件..................................................................................041

◎3.2    批量制作员工工作证.....................................................................................042

3.2.1     页面设置..............................................................................................042

3.2.2     制作工作证正面..................................................................................044

3.2.3     制作工作证背面..................................................................................046

3.2.4      批量制作工作证.................................................................................047

◎3.3    制作问卷调查表..............................................................................................050

3.3.1     在调查表中应用ActiveX控件........................................................050

3.3.2     添加宏代码..........................................................................................055

3.3.3     完成制作并测试调查表程序..............................................................056

◎3.4    同步训练...........................................................................................................058

◎3.5    高手进阶——文档设置技巧.......................................................................059

第二篇Excel应用篇

第4章 数据的输入和整理                                                                   061

◎4.1    员工档案表......................................................................................................062

4.1.1     新建员工档案表文件..........................................................................062

4.1.2     录入员工基本信息..............................................................................065

4.1.3     编辑单格和单格区域..................................................................069

4.1.4     为表格设置边框和底纹......................................................................072

◎4.2    制作供应商列表..............................................................................................073

4.2.1     使用单格样式美化工作表..............................................................073

4.2.2     插入特殊符号......................................................................................076

4.2.3     使用图片作为工作表背景..................................................................077

4.2.4     制定允许用户编辑区域......................................................................078

◎4.3    同步训练...........................................................................................................080

◎4.4    高手进阶——单格设置技巧...................................................................081

第5章  数据计算与统计                                                                      083

◎5.1    制作并打印员工工资表.................................................................................084

5.1.1     制作工资表..........................................................................................084

5.1.2     制作并打印工资条..............................................................................088

◎5.2    制作员工数据统计表.....................................................................................091

5.2.1     统计员工总人数..................................................................................091

5.2.2     统计员工性别比例..............................................................................092

5.2.3     统计本科及以上学历的人数及比例..................................................094

◎5.3    制作员工出差登记表.....................................................................................095

5.3.1     用TODAY函数插入当前日期.........................................................096

5.3.2     使用IF函数判断员工是否按时返回...............................................096

5.3.3     使用条件格式突出显示单格..........................................................097

◎5.4    同步训练...........................................................................................................098

◎5.5    高手进阶——函数应用实例.......................................................................099

第6章   简单数据分析                                                                         101

◎6.1    排序考评成绩表..............................................................................................102

6.1.1     按成绩高低进行排序..........................................................................102

6.1.2     使用自动筛选功能筛选成绩表数据..................................................104

6.1.3     使用高级筛选功能筛选数据..............................................................106

◎6.2    制作销售业绩分析表.....................................................................................107

6.2.1     应用合并计算汇总销售额..................................................................108

6.2.2     使用分类汇总功能汇总数据..............................................................110

6.2.3     筛选数据..............................................................................................114

◎6.3    同步训练...........................................................................................................116

◎6.4    高手进阶——数据分析技巧.......................................................................117