Word/Excel/PPT/WPS/Photoshop商務辦公5合1

上冊目錄

第一篇Word應用篇   

第1章   文本類文檔制作                                                                   001

◎1.1    制作勞動合同..................................................................................................002

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

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

1.1.3     閱覽勞動合同......................................................................................007

1.1.4     打印勞動合同......................................................................................009

◎1.2    制作員工手冊..................................................................................................010

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

1.2.1     輸入內(nèi)容并設置格式..........................................................................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     編排正文內(nèi)容......................................................................................024

◎2.2    制作個人簡歷..................................................................................................028

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

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

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

◎2.3    同步訓練...........................................................................................................033

◎2.4    高手進階——圖形與表格處理技巧..........................................................034

第3章   商務文檔制作                                                                       036

◎3.1    制作企業(yè)文件模板.........................................................................................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    制作問卷調(diào)查表..............................................................................................050

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

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

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

◎3.4    同步訓練...........................................................................................................058

◎3.5    高手進階——文檔設置技巧.......................................................................059

第二篇Excel應用篇

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

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

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

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

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

4.1.4     為表格設置邊框和底紋......................................................................072

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

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

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

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

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

◎4.3    同步訓練...........................................................................................................080

◎4.4    高手進階——單元格設置技巧...................................................................081

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

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

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

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

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

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

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

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

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

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

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

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

◎5.4    同步訓練...........................................................................................................098

◎5.5    高手進階——函數(shù)應用實例.......................................................................099

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

◎6.1    排序考評成績表..............................................................................................102

6.1.1     按成績高低進行排序..........................................................................102

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

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

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

6.2.1     應用合并計算匯總銷售額..................................................................108

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

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

◎6.3    同步訓練...........................................................................................................116

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

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

◎7.1    創(chuàng)建生產(chǎn)統(tǒng)計圖表.........................................................................................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    同步訓練...........................................................................................................133

◎7.4    高手進階——圖表應用技巧.......................................................................134

第3篇PPT應用篇

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

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

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

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

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

◎8.2    為“升級改造方案”演示文稿設置動畫..................................................150

8.2.1    設置幻燈片動畫..................................................................................150

8.2.2    設置幻燈片切換動畫..........................................................................156

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

8.3.1    設置幻燈片放映類型..........................................................................158

8.3.2    設置排練計時......................................................................................159

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

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

◎8.4    同步訓練...........................................................................................................169

◎8.5    高手進階——PPT圖文混排有訣竅.........................................................171

下冊目錄

第4篇WPS應用篇

第9章   WPS文字應用                                                                    175

◎9.1     制作公司簡介..................................................................................................176

9.1.1     創(chuàng)建公司簡介文檔..............................................................................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    制作商品房購銷合同.....................................................................................190

9.2.1     制作文檔首頁......................................................................................190

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

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

◎9.3    同步訓練...........................................................................................................199

◎9.4    高手進階——WPS文字處理技巧............................................................200

第10章   WPS表格應用                                                                   202

◎10.1 制作會計科目表..............................................................................................203

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

10.1.2    設置表格格式....................................................................................204

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

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

10.2.1    移動與復制工作表............................................................................208

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

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

◎10.3 制作明細賬......................................................................................................215

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

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

10.3.3    設置不顯示零值................................................................................220

◎10.4 同步訓練...........................................................................................................221

◎10.5 高手進階——WPS表格處理技巧............................................................223

第11章   WPS演示應用                                                                   225

◎11.1 制作樓盤展示演示文稿.................................................................................226

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

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

11.1.3    設置幻燈片動畫................................................................................233

◎11.2  放映“樓盤展示”演示文稿........................................................................237

11.2.1    設置幻燈片切換效果........................................................................237

11.2.2    設置幻燈片放映類型........................................................................238

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

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

◎11.3 同步訓練...........................................................................................................243

◎11.4 高手進階——WPS演示實用技巧............................................................245

第5篇Photoshop應用篇

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

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

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

12.1.3    把風景照片制作成日式油畫效果....................................................256

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

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

12.2.1    快速處理曝光過度的照片................................................................262

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

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

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

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

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

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

13.1.2    制作磚墻霓虹燈海報........................................................................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è)廣告設計                                                                      313

◎14.1  宣傳單/海報設計........................................................................................314

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

14.1.2    制作牙膏宣傳海報............................................................................321

◎14.2   產(chǎn)品包裝設計...............................................................................................327

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

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

◎14.3 戶外廣告設計..................................................................................................336

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

14.3.2    制作公交車站臺廣告........................................................................341