Excel 2002中文版直通車

第一章 Excel 2002基礎(chǔ)                  
                   
 1.1 Excel 2002概述                  
 1.1.1 在Excel早期版本中使用Excel 2002文件                  
 1.1.2 在Excel 2002中使用舊宏                  
 1.1.3 Excel 2000升級(jí)為Excel 2002的常見問題                  
 1.2 Excel 2002的新增功能                  
 1.2.1 導(dǎo)入數(shù)據(jù)功能的增強(qiáng)                  
 1.2.2 公式和函數(shù)功能的增強(qiáng)                  
 1.2.3 格式設(shè)置功能的改善                  
 1.2.4 常現(xiàn)任務(wù)方面功能的增強(qiáng)                  
 1.2.5 語(yǔ)言相關(guān)功能的增強(qiáng)                  
 1.3 Excel 2002的基本工作界面                  
                   
 第二章 數(shù)據(jù)輸入與編輯                  
                   
 2.1 輸入數(shù)據(jù)                  
 2.1.1 輸入普通數(shù)據(jù)                  
 2.1.2 輸入特殊字符                  
 2.2 快速輸入數(shù)據(jù)                  
 2.2.1 同時(shí)輸入多處數(shù)據(jù)                  
 2.2.2 自動(dòng)填寫重復(fù)項(xiàng)目                  
 2.2.3 快速填充數(shù)據(jù)                  
 2.2.4 設(shè)置填充序列                  
 2.3 導(dǎo)入數(shù)據(jù)                  
 2.3.1 導(dǎo)入數(shù)據(jù)                  
 2.3.2 刷新導(dǎo)入的數(shù)據(jù)                  
 2.3.3 設(shè)置刷新選項(xiàng)                  
 2.4 選擇數(shù)據(jù)                  
 2.4.1 在工作表中移動(dòng)                  
 2.4.2 選擇單元格                  
 2.4.3 選擇工作表                  
 2.5 編輯操作                  
 2.5.1 編輯內(nèi)容                  
 2.5.2 插入和刪除                  
 2.5.3 撤消或恢復(fù)                  
 2.5.4 復(fù)制和移動(dòng)                  
 2.5.5 插入移動(dòng)和插入復(fù)制                  
 2.6 查找和替換數(shù)據(jù)                  
 2.6.1 查找數(shù)據(jù)                  
 2.6.2 替換數(shù)據(jù)                  
                   
 第三章 文件管理                  
                   
 3.1 基本文件管理                  
 3.1.1 打開文件                  
 3.1.2 復(fù)制和移動(dòng)文件                  
 3.1.3 刪除文件                  
 3.1.4 重命名文件                  
 3.1.5 “收藏”文件                  
 3.2 查找文件                  
 3.2.1 搜索文件概述                  
 3.2.2 基本搜索                  
 3.2.3 高級(jí)搜索                  
 3.2.4 處理搜索結(jié)果                  
 3.2.5 快速搜索                  
 3.3 設(shè)置文件屬性                  
 3.3.1 文檔屬性的類型                  
 3.3.2 查看文檔屬性                  
 3.3.3 創(chuàng)建自定義的屬性                  
 3.3.4 設(shè)置文件只讀狀態(tài)                  
 3.3.5 更改文檔庫(kù)的文件屬性                  
 3.4 打印文件                  
 3.4.1 設(shè)置打印選項(xiàng)                  
 3.4.2 定義打印工作表區(qū)域                  
 3.4.3 設(shè)置頁(yè)眉和頁(yè)腳                  
 3.4.4 打印預(yù)覽                  
 3.4.5 打印工作表和工作簿                  
 3.4.6 管理打印作業(yè)                  
 3.5 Excel文件格式轉(zhuǎn)換                  
 3.5.1 Excel文件格式轉(zhuǎn)換                  
 3.5.2 Windows和Macintosh格式轉(zhuǎn)換                  
                   
 第四章 管理工作簿和工作表                  
                   
 4.1 創(chuàng)建工作簿                  
 4.1.1 創(chuàng)建空白工作簿                  
 4.1.2 按模板新建工作簿                  
 4.2 管理工作表                  
 4.2.1 插入和刪除工作表                  
 4.2.2 移動(dòng)或復(fù)制工作表                  
 4.2.3 重命名工作表                  
 4.3 設(shè)置查看方式                  
 4.3.1 工作簿的顯示與隱藏                  
 4.3.2 工作表的顯示和隱藏                  
 4.3.3 行和列的顯示與隱藏                  
 4.3.4 工作表標(biāo)簽的顯示與隱藏                  
 4.3.5 切換工作表                  
 4.3.6 顯示多個(gè)窗口                  
 4.3.7 拆分和凍結(jié)操作                  
 4.3.8 設(shè)置顯示比例                  
 4.3.9 自定義視圖                  
 4.4 保護(hù)工作簿和工作表                  
 4.4.1 保護(hù)工作簿                  
 4.4.2 保護(hù)工作簿元素                  
 4.4.3 保護(hù)工作表                  
 4.4.4 保護(hù)工作表元素                  
 4.4.5 保護(hù)單元格區(qū)域                  
                   
 第五章 設(shè)置格式                  
                   
 5.1 設(shè)置邊框. 底紋和顏色                  
 5.1.1 設(shè)置工作表背景                  
 5.1.2 設(shè)置頁(yè)面邊框                  
 5.1.3 設(shè)置單元格邊框                  
 5.1.4 設(shè)置單元格底紋                  
 5.1.5 設(shè)置網(wǎng)格線顏色                  
 5.1.6 設(shè)置工作表標(biāo)簽的顏色                  
 5.2 設(shè)置文本格式                  
 5.2.1 設(shè)置字體和字號(hào)                  
 5.2.2 設(shè)置文本顏色                  
 5.2.3 設(shè)置文本對(duì)齊                  
 5.3 設(shè)置單元格格式                  
 5.3.1 更改列寬和行高                  
 5.3.2 定義默認(rèn)的列寬                  
 5.4 條件格式                  
 5.4.1 添加條件格式                  
 5.4.2 復(fù)制條件格式                  
 5.4.3 更改條件格式                  
 5.4.4 查找條件格式                  
 5.5 數(shù)字格式                  
 5.5.1 數(shù)字格式概述                  
 5.5.2 設(shè)置貨幣符號(hào)                  
 5.5.3 設(shè)置小數(shù)位數(shù)                  
 5.5.4 設(shè)置負(fù)號(hào)                  
 5.5.5 設(shè)置數(shù)字顯示                  
 5.5.6 自定義數(shù)字格式                  
 5.5.7 數(shù)字格式代碼                  
 5.6 自動(dòng)套用格式                  
 5.7 樣式應(yīng)用                  
 5.7.1 添加樣式                  
 5.7.2 應(yīng)用樣式                  
 5.8 復(fù)制格式                  
                   
 第六章 數(shù)據(jù)計(jì)算                  
                   
 6.1 運(yùn)算符                  
 6.1.1 運(yùn)算符類型                  
 6.1.2 運(yùn)算次序                  
 6.2 引用的概念                  
 6.2.1 引用樣式                  
 6.2.2 絕對(duì)引用與相對(duì)引用                  
 6.3 公式的組成                  
 6.3.1 名稱                  
 6.3.2 常量                  
 6.3.3 函數(shù)                  
 6.4 公式操作                  
 6.4.1 創(chuàng)建公式                  
 6.4.2 移動(dòng)或復(fù)制公式                  
 6.4.3 數(shù)組公式                  
 6.5 鏈接與嵌入                  
 6.5.1 鏈接與嵌入的作用                  
 6.5.2 選用鏈接和嵌入對(duì)象                  
 6.5.3 鏈接和嵌入對(duì)象                  
 6.5.4 更新鏈接                  
 6.5.5 編輯對(duì)象                  
 6.5.6 查找鏈接                  
 6.5.7 更改鏈接源                  
 6.5.8 斷開鏈接                  
 6.6 更正公式                  
 6.6.1 監(jiān)視公式                  
 6.6.2 修正公式錯(cuò)誤                  
 6.6.3 更改公式                  
 6.7 嵌套公式求值                  
                   
 第七章 數(shù)據(jù)清單                  
                   
 7.1 建立數(shù)據(jù)清單                  
 7.1.1 創(chuàng)建數(shù)據(jù)清單的準(zhǔn)則                  
 7.1.2 創(chuàng)建數(shù)據(jù)清單                  
 7.2 篩選數(shù)據(jù)                  
 7.2.1 自動(dòng)篩選                  
 7.2.2 自定義篩選                  
 7.2.3 高級(jí)篩選                  
 7.3 數(shù)據(jù)排序                  
 7.3.1 按升序或降序?qū)π羞M(jìn)行排序                  
 7.3.2 按2或3個(gè)數(shù)據(jù)列對(duì)行進(jìn)行排序                  
 7.3.3 按多個(gè)數(shù)據(jù)列進(jìn)行排序                  
 7.3.4 按月或星期對(duì)行排序                  
 7.3.5 將自定義序列作為排序的次序                  
 7.3.6 按行對(duì)列進(jìn)行排序                  
 7.4 分類匯總                  
 7.4.1 分類匯總的計(jì)算方法                  
 7.4.2 嵌套分類匯總                  
 7.4.3 匯總報(bào)表和圖表                  
 7.4.4 建立分類匯總                  
 7.4.5 明細(xì)數(shù)據(jù)的分組和分級(jí)顯示                  
 7.4.6 刪除分類匯總                  
                   
 第八章 數(shù)據(jù)透視表和數(shù)據(jù)透視圖                  
                   
 8.1 數(shù)據(jù)透視表                  
 8.1.1 基本概念                  
 8.1.2 創(chuàng)建數(shù)據(jù)透視表                  
 8.1.3 更改數(shù)據(jù)透視表                  
 8.2 數(shù)據(jù)透視圖                  
 8.2.1 基本概念                  
 8.2.2 創(chuàng)建數(shù)據(jù)透視圖                  
 8.2.3 更改數(shù)據(jù)透視圖                  
 8.3 匯總與公式                  
 8.3.1 顯示或隱藏匯總                  
 8.3.2 更改匯總方式                  
 8.3.3 匯總函數(shù)                  
 8.3.4 添加計(jì)算字段                  
 8.4 打印                  
 8.4.1 頁(yè)面設(shè)置                  
 8.4.2 打印預(yù)覽                  
 8.4.3 打印過(guò)程                  
                   
 第九章 數(shù)據(jù)分析與管理                  
                   
 9.1 外部數(shù)據(jù)                  
 9.1.1 導(dǎo)入數(shù)據(jù)                  
 9.1.2 刷新導(dǎo)入數(shù)據(jù)                  
 9.1.3 自定義字段名                  
 9.2 創(chuàng)建和運(yùn)行查詢                  
 9.2.1 自定義參數(shù)查詢                  
 9.2.2 更改外部數(shù)據(jù)區(qū)域的查詢                  
 9.3 驗(yàn)證數(shù)據(jù)有效性                  
 9.3.1 復(fù)制與更改數(shù)據(jù)有效性設(shè)置                  
 9.3.2 顯示或隱藏?zé)o效數(shù)據(jù)周圍的錯(cuò)誤標(biāo)識(shí)                  
 9.3.3 查找具有數(shù)據(jù)有效性設(shè)置的單元格                  
 9.4 模擬運(yùn)算表                  
 9.4.1 創(chuàng)建單變量模擬運(yùn)算表                  
 9.4.2 創(chuàng)建雙變量模擬運(yùn)算表                  
 9.4.3 清除模擬運(yùn)算表                  
 9.4.4 為模擬運(yùn)算添加公式                  
 9.5 方案管理                  
 9.5.1 創(chuàng)建方案                  
 9.5.2 合并方案                  
 9.5.3 隱藏和保護(hù)方案                  
 9.6 單變量求解                  
 9.6.1 應(yīng)用單變量求解                  
 9.6.2 對(duì)圖表數(shù)據(jù)應(yīng)用單變量求解                  
 9.6.3 單變量求解的常見錯(cuò)誤                  
 9.7 報(bào)告管理                  
 9.7.1 應(yīng)用報(bào)告管理器                  
 9.7.2 打印報(bào)告                  
 9.7.3 編輯報(bào)告                  
 9.7.4 刪除報(bào)告                  
                   
 第十章 圖形處理                  
                   
 10.1 圖形概述                  
 10.1.1 圖形應(yīng)用概述                  
 10.1.2 圖形類型                  
 10.2 剪輯管理                  
 10.2.1 搜索剪輯                  
 10.2.2 剪輯管理器                  
 10.2.3 預(yù)覽剪輯和查找剪輯屬性                  
 10.2.4 插入剪輯                  
 10.3 插入圖片文件                  
 10.3.1 插入圖片文件                  
 10.3.2 插入來(lái)自掃描儀或數(shù)碼相機(jī)的圖片                  
 10.4 設(shè)置圖片格式                  
 10.4.1 “圖片”工具欄                  
 10.4.2 調(diào)整顏色. 亮度和對(duì)比度                  
 10.4.3 縮放圖片                  
 10.4.4 剪裁圖片                  
 10.4.5 旋轉(zhuǎn)圖片                  
 10.4.6 設(shè)置背景填充色                  
 10.4.7 添加圖片邊框                  
 10.5 繪制圖形                  
 10.5.1 “繪圖”工具欄                  
 10.5.2 繪制圖形                  
 10.5.3 添加文字                  
 10.6 編輯圖形對(duì)象                  
 10.6.1 選定圖形對(duì)象                  
 10.6.2 改變多邊形的形狀                  
 10.6.3 調(diào)整位置                  
 10.6.4 調(diào)整大小                  
 10.6.5 旋轉(zhuǎn)或翻轉(zhuǎn)圖形                  
 10.6.6 設(shè)置填充色                  
 10.6.7 設(shè)置邊框線條顏色                  
 10.6.8 設(shè)置線型                  
 10.6.9 設(shè)置虛線線型                  
 10.6.10 設(shè)置箭頭樣式                  
 10.7 設(shè)置圖形特效                  
 10.7.1 設(shè)置陰影效果                  
 10.7.2 設(shè)置三維效果                  
 10.8 管理圖形對(duì)象                  
 10.8.1 調(diào)整疊加次序                  
 10.8.2 組合圖形對(duì)象                  
 10.9 插入藝術(shù)字                  
 10.9.1 插入藝術(shù)字                  
 10.9.2 設(shè)置藝術(shù)字屬性                  
                   
 第十一章 圖表                  
                   
 11.1 創(chuàng)建圖表                  
 11.1.1 圖表的基本構(gòu)成                  
 11.1.2 圖表類型                  
 11.1.3 繪制圖表                  
 11.2 調(diào)整圖表                  
 11.2.1 更改圖表類型                  
 11.2.2 調(diào)整圖表坐標(biāo)軸                  
 11.2.3 更改三維圖表視圖                  
 11.2.4 設(shè)置趨勢(shì)線                  
                   
 第十二章 宏. 加載宏和安全性保護(hù)                  
                   
 12.1 宏概述                  
 12.2 創(chuàng)建和管理宏                  
 12.2.1 錄制新定                  
 12.2.2 編輯宏                  
 12.2.3 復(fù)制宏                  
 12.2.4 刪除宏                  
 12.2.5 宏的保存位置                  
 12.3 運(yùn)行宏                  
 12.3.1 直接運(yùn)行宏                  
 12.3.2 通過(guò)快捷鍵啟動(dòng)宏                  
 12.3.3 通過(guò)窗體按鈕啟動(dòng)宏                  
 12.3.4 通過(guò)區(qū)域或熱點(diǎn)啟動(dòng)宏                  
 12.3.5 通過(guò)工具欄按鈕啟動(dòng)宏                  
 12.3.6 停止運(yùn)行宏                  
 12.4 加載宏程序                  
 12.4.1 Excel加載宏                  
 12.4.2 COM加載宏                  
 12.4.3 自動(dòng)化加載宏                  
                   
 第十三章 Web網(wǎng)絡(luò)應(yīng)用                  
                   
 13.1 發(fā)布Excel數(shù)據(jù)                  
 13.1.1 共享Excel數(shù)據(jù)概述                  
 13.1.2 發(fā)布數(shù)據(jù)                  
 13.1.3 數(shù)字儀表板應(yīng)用                  
 13.1.4 更改和保存Web數(shù)據(jù)                  
 13.1.5 優(yōu)化Web頁(yè)                  
 13.1.6 預(yù)覽Web頁(yè)                  
 13.1.7 加快Web頁(yè)下載速度                  
 13.2 查詢Web數(shù)據(jù)                  
 13.2.1 建立Web查詢                  
 13.2.2 更改Web查詢                  
 13.2.3 復(fù)制Web頁(yè)數(shù)據(jù)                  
 13.2.4 保存Web查詢                  
 13.3 XML應(yīng)用                  
 13.4 Web腳本                  
 13.4.1 創(chuàng)建Web腳本                  
 13.4.2 設(shè)置Web頁(yè)的語(yǔ)言編碼                  
 13.4.3 更改默認(rèn)腳本語(yǔ)言                  
 13.4.4 復(fù)制或移動(dòng)Web腳本                  
 13.4.5 編輯Web腳本                  
 13.4.6 刪除Web腳本                  
                   
 第十四章 自定義Excel 2002                  
                   
 14.1 顯示和隱藏基本組成                  
 14.1.1 狀態(tài)欄和滾動(dòng)條                  
 14.1.2 單元格網(wǎng)格線                  
 14.1.3 工具欄                  
 14.1.4 菜單命令                  
 14.1.5 字體顯示                  
 14.2 定制菜單和工具欄                  
 14.2.1 添加和刪除按鈕或命令                  
 14.2.2 創(chuàng)建工具欄                  
 14.2.3 定制菜單顯示方式                  
 14.2.4 定制工具欄按鈕外觀                  
 14.2.5 分組. 移動(dòng)和復(fù)制命令和按鈕                  
 14.2.6 重命名按鈕. 菜單命令和工具欄                  
 14.2.7 分配超鏈接                  
 14.2.8 還原初始設(shè)置                  
 14.2.9 更改鍵盤加速鍵                  
 14.3 定制調(diào)色板                  
 14.4 控制啟動(dòng)Excel的操作                  
 14.4.1 定制啟動(dòng)方式                  
 14.4.2 保存工作簿設(shè)置                  
                   
 附錄 Excel 2002規(guī)范