Word/Excel/PPT/WPS/Photoshop商務(wù)辦公5合1

上冊(cè)目錄

第一篇Word應(yīng)用篇   

第1章   文本類文檔制作                                                                   001

◎1.1    制作勞動(dòng)合同..................................................................................................002

1.1.1     創(chuàng)建勞動(dòng)合同文檔..............................................................................002

1.1.2     編輯勞動(dòng)合同內(nèi)文..............................................................................003

1.1.3     閱覽勞動(dòng)合同......................................................................................007

1.1.4     打印勞動(dòng)合同......................................................................................009

◎1.2    制作員工手冊(cè)..................................................................................................010

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

1.2.1     輸入內(nèi)容并設(shè)置格式..........................................................................012

1.2.3     提取目錄..............................................................................................015

◎1.3    同步訓(xùn)練...........................................................................................................017

◎1.4    高手進(jìn)階——文本錄入技巧.......................................................................018

第2章   表格類文檔制作                                                                   019

◎2.1    制作旅游景點(diǎn)宣傳單.....................................................................................020

2.1.1     頁(yè)面設(shè)置..............................................................................................020

2.1.2     制作宣傳單頁(yè)頭..................................................................................021

2.1.3     編排正文內(nèi)容......................................................................................024

◎2.2    制作個(gè)人簡(jiǎn)歷..................................................................................................028

2.2.1     表格的插入與調(diào)整..............................................................................029

2.2.2     填寫(xiě)表格內(nèi)容......................................................................................031

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

◎2.3    同步訓(xùn)練...........................................................................................................033

◎2.4    高手進(jìn)階——圖形與表格處理技巧..........................................................034

第3章   商務(wù)文檔制作                                                                       036

◎3.1    制作企業(yè)文件模板.........................................................................................037

3.1.1     制作模板頁(yè)眉......................................................................................037

3.1.2     制作模板頁(yè)腳......................................................................................039

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

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

◎3.2    批量制作員工工作證.....................................................................................042

3.2.1     頁(yè)面設(shè)置..............................................................................................042

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

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

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

◎3.3    制作問(wèn)卷調(diào)查表..............................................................................................050

3.3.1     在調(diào)查表中應(yīng)用ActiveX控件........................................................050

3.3.2     添加宏代碼..........................................................................................055

3.3.3     完成制作并測(cè)試調(diào)查表程序..............................................................056

◎3.4    同步訓(xùn)練...........................................................................................................058

◎3.5    高手進(jìn)階——文檔設(shè)置技巧.......................................................................059

第二篇Excel應(yīng)用篇

第4章 數(shù)據(jù)的輸入和整理                                                                   061

◎4.1    員工檔案表......................................................................................................062

4.1.1     新建員工檔案表文件..........................................................................062

4.1.2     錄入員工基本信息..............................................................................065

4.1.3     編輯單元格和單元格區(qū)域..................................................................069

4.1.4     為表格設(shè)置邊框和底紋......................................................................072

◎4.2    制作供應(yīng)商列表..............................................................................................073

4.2.1     使用單元格樣式美化工作表..............................................................073

4.2.2     插入特殊符號(hào)......................................................................................076

4.2.3     使用圖片作為工作表背景..................................................................077

4.2.4     制定允許用戶編輯區(qū)域......................................................................078

◎4.3    同步訓(xùn)練...........................................................................................................080

◎4.4    高手進(jìn)階——單元格設(shè)置技巧...................................................................081

第5章  數(shù)據(jù)計(jì)算與統(tǒng)計(jì)                                                                      083

◎5.1    制作并打印員工工資表.................................................................................084

5.1.1     制作工資表..........................................................................................084

5.1.2     制作并打印工資條..............................................................................088

◎5.2    制作員工數(shù)據(jù)統(tǒng)計(jì)表.....................................................................................091

5.2.1     統(tǒng)計(jì)員工總?cè)藬?shù)..................................................................................091

5.2.2     統(tǒng)計(jì)員工性別比例..............................................................................092

5.2.3     統(tǒng)計(jì)本科及以上學(xué)歷的人數(shù)及比例..................................................094

◎5.3    制作員工出差登記表.....................................................................................095

5.3.1     用TODAY函數(shù)插入當(dāng)前日期.........................................................096

5.3.2     使用IF函數(shù)判斷員工是否按時(shí)返回...............................................096

5.3.3     使用條件格式突出顯示單元格..........................................................097

◎5.4    同步訓(xùn)練...........................................................................................................098

◎5.5    高手進(jìn)階——函數(shù)應(yīng)用實(shí)例.......................................................................099

第6章   簡(jiǎn)單數(shù)據(jù)分析                                                                         101

◎6.1    排序考評(píng)成績(jī)表..............................................................................................102

6.1.1     按成績(jī)高低進(jìn)行排序..........................................................................102

6.1.2     使用自動(dòng)篩選功能篩選成績(jī)表數(shù)據(jù)..................................................104

6.1.3     使用高級(jí)篩選功能篩選數(shù)據(jù)..............................................................106

◎6.2    制作銷售業(yè)績(jī)分析表.....................................................................................107

6.2.1     應(yīng)用合并計(jì)算匯總銷售額..................................................................108

6.2.2     使用分類匯總功能匯總數(shù)據(jù)..............................................................110

6.2.3     篩選數(shù)據(jù)..............................................................................................114

◎6.3    同步訓(xùn)練...........................................................................................................116

◎6.4    高手進(jìn)階——數(shù)據(jù)分析技巧.......................................................................117

第7章   數(shù)據(jù)直觀化處理                                                                   119

◎7.1    創(chuàng)建生產(chǎn)統(tǒng)計(jì)圖表.........................................................................................120

7.1.1     創(chuàng)建圖表..............................................................................................120

7.1.2     調(diào)整圖表布局......................................................................................122

7.1.3     美化圖表..............................................................................................124

◎7.2    使用數(shù)據(jù)透視圖表分析產(chǎn)品銷售情況.......................................................126

7.2.1     使用數(shù)據(jù)透視表分析數(shù)據(jù)..................................................................126

7.2.2     插入切片器分析數(shù)據(jù)..........................................................................129

7.2.3     使用數(shù)據(jù)透視圖分析數(shù)據(jù)..................................................................131

◎7.3    同步訓(xùn)練...........................................................................................................133

◎7.4    高手進(jìn)階——圖表應(yīng)用技巧.......................................................................134

第3篇PPT應(yīng)用篇

第8章   幻燈片的編輯與放映                                                          137

◎8.1   制作企業(yè)宣傳演示文稿................................................................................138

8.1.1    創(chuàng)建演示文稿文件..............................................................................138

8.1.2    編輯幻燈片..........................................................................................142

8.1.3    美化幻燈片..........................................................................................148

◎8.2    為“升級(jí)改造方案”演示文稿設(shè)置動(dòng)畫(huà)..................................................150

8.2.1    設(shè)置幻燈片動(dòng)畫(huà)..................................................................................150

8.2.2    設(shè)置幻燈片切換動(dòng)畫(huà)..........................................................................156

◎8.3    放映“企業(yè)宣傳”演示文稿........................................................................158

8.3.1    設(shè)置幻燈片放映類型..........................................................................158

8.3.2    設(shè)置排練計(jì)時(shí)......................................................................................159

8.3.3    放映幻燈片..........................................................................................160

8.3.4    演示文稿的輸出和打包......................................................................165

◎8.4    同步訓(xùn)練...........................................................................................................169

◎8.5    高手進(jìn)階——PPT圖文混排有訣竅.........................................................171

下冊(cè)目錄

第4篇WPS應(yīng)用篇

第9章   WPS文字應(yīng)用                                                                    175

◎9.1     制作公司簡(jiǎn)介..................................................................................................176

9.1.1     創(chuàng)建公司簡(jiǎn)介文檔..............................................................................176

9.1.2     編輯文本內(nèi)容......................................................................................177

9.1.3     插入圖片內(nèi)容......................................................................................182

9.1.4     繪制組織結(jié)構(gòu)圖..................................................................................183

9.1.5     插入表格..............................................................................................187

◎9.2    制作商品房購(gòu)銷合同.....................................................................................190

9.2.1     制作文檔首頁(yè)......................................................................................190

9.2.2     編輯內(nèi)容頁(yè)..........................................................................................192

9.2.3     提取目錄..............................................................................................197

◎9.3    同步訓(xùn)練...........................................................................................................199

◎9.4    高手進(jìn)階——WPS文字處理技巧............................................................200

第10章   WPS表格應(yīng)用                                                                   202

◎10.1 制作會(huì)計(jì)科目表..............................................................................................203

10.1.1    輸入表格內(nèi)容....................................................................................203

10.1.2    設(shè)置表格格式....................................................................................204

10.1.3    凍結(jié)工作表........................................................................................206

◎10.2 制作現(xiàn)金日記賬..............................................................................................207

10.2.1    移動(dòng)與復(fù)制工作表............................................................................208

10.2.2    篩選現(xiàn)金收入與支出記錄................................................................209

10.2.3    利用公式和函數(shù)快速創(chuàng)建表格........................................................211

◎10.3 制作明細(xì)賬......................................................................................................215

10.3.1    創(chuàng)建基本框架....................................................................................215

10.3.2    使用公式和函數(shù)................................................................................217

10.3.3    設(shè)置不顯示零值................................................................................220

◎10.4 同步訓(xùn)練...........................................................................................................221

◎10.5 高手進(jìn)階——WPS表格處理技巧............................................................223

第11章   WPS演示應(yīng)用                                                                   225

◎11.1 制作樓盤(pán)展示演示文稿.................................................................................226

11.1.1    演示文稿基本操作............................................................................226

11.1.2    為幻燈片添加內(nèi)容............................................................................229

11.1.3    設(shè)置幻燈片動(dòng)畫(huà)................................................................................233

◎11.2  放映“樓盤(pán)展示”演示文稿........................................................................237

11.2.1    設(shè)置幻燈片切換效果........................................................................237

11.2.2    設(shè)置幻燈片放映類型........................................................................238

11.2.3    放映幻燈片........................................................................................238

11.2.4  打包演示文稿.....................................................................................242

◎11.3 同步訓(xùn)練...........................................................................................................243

◎11.4 高手進(jìn)階——WPS演示實(shí)用技巧............................................................245

第5篇Photoshop應(yīng)用篇

◎12.1  合成特效照片..................................................................................................250

12.1.1    把人物照片轉(zhuǎn)換成古典工筆畫(huà)........................................................250

12.1.2    將人物照片創(chuàng)建成涂鴉墻效果........................................................253

12.1.3    把風(fēng)景照片制作成日式油畫(huà)效果....................................................256

12.1.4    合成人物素描效果............................................................................259

◎12.2  照片調(diào)色..........................................................................................................262

12.2.1    快速處理曝光過(guò)度的照片................................................................262

12.2.2    調(diào)出亮麗色彩的婚紗照....................................................................265

12.2.4    調(diào)制漂亮炫彩風(fēng)景照........................................................................267

12.2.5    快速調(diào)出秋天色調(diào)............................................................................270

第13章   圖像合成與創(chuàng)意                                                                  273

◎13.1  圖像合成..........................................................................................................274

13.1.1    合成水晶人像金幣............................................................................274

13.1.2    制作磚墻霓虹燈海報(bào)........................................................................280

13.1.3    地產(chǎn)宣傳廣告....................................................................................286

13.1.4    制作飛出屏幕的特效........................................................................294

◎13.2  創(chuàng)意圖像制作..................................................................................................296

13.2.1    制作水珠按鈕....................................................................................296

13.2.2    繪制通透的美玉手鐲........................................................................302

13.2.4    制作艷麗的金屬邊框字....................................................................309

第14章   商業(yè)廣告設(shè)計(jì)                                                                      313

◎14.1  宣傳單/海報(bào)設(shè)計(jì)........................................................................................314

14.1.1    制作快餐店宣傳單............................................................................314

14.1.2    制作牙膏宣傳海報(bào)............................................................................321

◎14.2   產(chǎn)品包裝設(shè)計(jì)...............................................................................................327

14.2.1    月餅包裝盒平面圖............................................................................327

14.2.2    月餅包裝盒效果圖............................................................................333

◎14.3 戶外廣告設(shè)計(jì)..................................................................................................336

14.3.1    制作戶外燈箱廣告............................................................................337

14.3.2    制作公交車站臺(tái)廣告........................................................................341