中文Excel97操作手冊

第1章  中文Excel 97基礎(chǔ)                  
                   
 1.1  Excel 97簡介                  
 1.2  中文Excel 97運(yùn)行環(huán)境                  
 1.3  安裝中文Excel 97                  
 1.4  啟動(dòng)和退出中文Excel 97                  
 1.5  Excel 97新增和改進(jìn)功能概述                  
                   
 第2章  中文Excel 97環(huán)境及功能                  
                   
 2.1  中文Excel 97屏幕介紹                  
 2.2  菜單                  
 2.3  工具欄                  
                   
 第3章  簡單表格制作                  
                   
 3.1  打開表格                  
 3.2  輸入數(shù)據(jù)                  
 3.3  保存文件                  
 3.4  頁面設(shè)置                  
 3.5  打印預(yù)覽                  
 3.6  打印                  
                   
 第4章  屏幕視圖控制                  
                   
 4.1  屏幕元素的隱藏和顯示                  
 4.2  對(duì)窗口的操作                  
                   
 第5章  數(shù)據(jù)輸入和編輯                  
                   
 5.1  在工作簿中移動(dòng)                  
 5.2  數(shù)據(jù)類型和輸入                  
 5.3  快速輸入數(shù)據(jù)                  
 5.4  修改單元中的數(shù)據(jù)                  
 5.5  取消操作                  
 5.6  區(qū)域                  
 5.7  數(shù)據(jù)的拷貝                  
 5.8  數(shù)據(jù)的移動(dòng)                  
 5.9  刪除數(shù)據(jù)                  
 5.10  插入單元                  
 5.11  插入行和列                  
 5.12  刪除單元                  
 5.13  刪除行和列                  
 5.14  輸入公式                  
 5.15  編輯公式                  
 5.16  拷貝公式                  
 5.17  使用絕對(duì)和相對(duì)單元地址                  
 5.18  重新計(jì)算設(shè)置                  
 5.19  使用函數(shù)                  
                   
 第6章  數(shù)據(jù)格式設(shè)置                  
                   
 6.1  數(shù)據(jù)格式及數(shù)據(jù)對(duì)齊方式                  
 6.2  改變列寬和行高                  
 6.3  隱藏. 重顯列和行                  
 6.4  改變數(shù)據(jù)的字體                  
 6.5  給單元添加邊框和背景                  
 6.6  格式化技巧                  
 6.7  利用樣式進(jìn)行格式化                  
                   
 第7章  工作簿中的工作表操作                  
                   
 7.1  切換工作表                  
 7.2  更換工作表名稱                  
 7.3  插入和刪除工作表                  
 7.4  拷貝和移動(dòng)工作表                  
                   
 第8章  建立圖表                  
                   
 8.1  圖表組成和類型                  
 8.2  建立內(nèi)建圖表                  
 8.3  建立獨(dú)立的圖表                  
 8.4  改變圖表類型                  
 8.5  快建圖表                  
                   
 第9章  編輯圖表                  
                   
 9.1  選擇圖表元件                  
 9.2  編輯圖表文字                  
 9.3  編輯圖例. 坐標(biāo)軸與網(wǎng)格線                  
 9.4  圖表格式化                  
 9.5  自動(dòng)套用圖表格式                  
                   
 第10章  圖表和工作表添加圖形                  
                   
 10.1  插入圖形                  
 10.2  繪制自己的圖像                  
 10.3  圖層和圖組的操作                  
                   
 第11章  打印工作簿                  
                   
 11.1  打印基礎(chǔ)                  
 11.2  打印預(yù)覽                  
 11.3  頁面設(shè)置格式                  
 11.4  分頁操作                  
 11.5  打印圖表                  
                   
 第12章  將Excel 97用作數(shù)據(jù)庫                  
                   
 12.1  建立數(shù)據(jù)庫基礎(chǔ)                  
 12.2  增加. 編輯和刪除記錄                  
 12.3  查找數(shù)據(jù)                  
 12.4  數(shù)據(jù)排序                  
 12.5  數(shù)據(jù)篩選                  
                   
 第13章  數(shù)據(jù)管理                  
                   
 13.1  分類匯總報(bào)表                  
 13.2  數(shù)據(jù)透視表                  
 13.3  合并匯總計(jì)算                  
 13.4  單變量求解                  
 13.5  模擬運(yùn)算表                  
 13.6  方案管理器                  
                   
 第14章  使用宏                  
                   
 14.1  宏簡介                  
 14.2  建立宏                  
 14.3  修改宏                  
 14.4  運(yùn)行宏                  
                   
 第15章  定制中文Excel 97                  
                   
 15.1  定制菜單                  
 15.2  定制工具欄                  
                   
 第16章  中文Excel 97與Internet                  
                   
 16.1 將文件保存成為HTM L                  
 16.2  超級(jí)鏈接                  
 16.3 WEB工具欄                  
                   
 第17章  和其他程序交換數(shù)據(jù)                  
                   
 17.1 在Excel 97工作表中調(diào)入Word 97表格                  
 17.2  在Excel 97中調(diào)入PowerPoint 97演示文稿                  
 17.3  在Excel 97中調(diào)入Access 97記錄                  
 17.4  在Excel 97中添加Outlook清單名和地址                  
 17.5  在Excel 以前版本中使用Excel 97文件                  
 17.6  在Windows和Macintosh之間移動(dòng)文件                  
                   
 第18章  Excel 97新增功能總結(jié)                  
                   
 18.1  基本操作                  
 18.2  建立公式                  
 18.3  打印和格式化                  
 18.4  繪制圖表                  
 18.5  數(shù)據(jù)透視表                  
 18.6  用戶幫助                  
 18.7  Internet新功能                  
                   
 附錄 A Excel 97快捷鍵                  
                   
 A.1  Excel 97功能鍵                  
 A.2  數(shù)據(jù)輸入快捷鍵                  
 A.3  數(shù)據(jù)格式設(shè)置快捷鍵                  
 A.4  數(shù)據(jù)編輯快捷鍵                  
 A.5  數(shù)據(jù)編輯快捷鍵                  
 A.6  在工作表和工作簿中移動(dòng)或滾動(dòng)快捷鍵                  
 A.7  預(yù)覽和打印文檔快捷鍵                  
 A.8  處理數(shù)據(jù). 數(shù)據(jù)清單和數(shù)據(jù)透視表快捷鍵                  
 A.9  分級(jí)顯示數(shù)據(jù)快捷鍵                  
 A.10  菜單操作快捷鍵                  
 A.11  工具欄操作快捷鍵                  
 A.12  窗口操作快捷鍵                  
 A.13  對(duì)話框操作快捷鍵                  
 A.14  文本框操作快捷鍵                  
 A.15  “Office助手”快捷鍵                  
                   
 附錄 B 中文Excel 97函數(shù)                  
                   
 B.1  數(shù)據(jù)庫與數(shù)據(jù)清單管理函數(shù)                  
 B.2  日期與時(shí)間函數(shù)                  
 B.3  DDE與外部函數(shù)                  
 B.4  工程函數(shù)                  
 B.5  財(cái)務(wù)函數(shù)                  
 B.6  信息函數(shù)                  
 B.7  邏輯函數(shù)                  
 B.8 查詢和引用函數(shù)                  
 B.9  數(shù)學(xué)和三角函數(shù)                  
 B.10  統(tǒng)計(jì)函數(shù)                  
 B.11  文本函數(shù)