EXCEL 2000命令與實(shí)例

第1章  文件菜單操作                  
     1. 1  文件菜單全貌                  
     1. 2  新建                  
     實(shí)例一  新建空工作簿                  
     實(shí)例二  利用模板創(chuàng)建工作簿                  
     1. 3  打開                  
     實(shí)例一  打開已有的工作簿                  
     實(shí)例二  打開純文本類型的數(shù)據(jù)文件                  
     實(shí)例三  打開網(wǎng)頁文件                  
     實(shí)例四  以只讀方式打開工作簿                  
     1. 4   關(guān)閉                  
     實(shí)例一  關(guān)閉已命名文件                  
     實(shí)例二  關(guān)閉未命名文件                  
     1. 5  保存                  
     1. 6  另存為                  
     實(shí)例一  更名保存文件                  
     實(shí)例二  把工作簿文件轉(zhuǎn)換成文本格式的文件                  
     1. 7  另存為網(wǎng)頁                  
     實(shí)例一  把整個(gè)工作簿另存為網(wǎng)頁                  
     實(shí)例二  把其中一個(gè)工作表另存為網(wǎng)頁                  
     實(shí)例三  轉(zhuǎn)換時(shí)加入數(shù)據(jù)交互                  
     1. 8  保存工作區(qū)                  
     實(shí)例一  保存工作區(qū)                  
     實(shí)例二  打開工作區(qū)文件                  
     1. 9  網(wǎng)頁預(yù)覽                  
     1. 10  頁面設(shè)置                  
     實(shí)例一  預(yù)設(shè)“成績單”的打印頁面                  
     實(shí)例二  只打印工作表的一部分                  
     實(shí)例三  分頁打印設(shè)置                  
     1. 11  打印區(qū)域                  
     實(shí)例一  打印單元格區(qū)域B1：H10                  
     實(shí)例二  取消已經(jīng)設(shè)置的打印區(qū)域                  
     1. 12  打印預(yù)覽                  
     實(shí)例一  單頁打印預(yù)覽“三(1)班成績單”                  
     實(shí)例二  打印預(yù)覽多個(gè)工作表                  
     1. 13  打印                  
     實(shí)例  打印幾個(gè)工作表                  
     1. 14  屬性                  
     實(shí)例一  顯示工作簿“成績單”的文件屬性                  
     實(shí)例二  編輯文件的一般屬性                  
     實(shí)例三  創(chuàng)建自定義文件屬性                  
     實(shí)例四  創(chuàng)建與活動(dòng)工作簿內(nèi)容相鏈接的自定義文件屬性                  
     1. 15  退出                  
     1. 16  菜單上的文件                  
   第2章  編輯菜單操作                  
     2. 1  編輯菜單全貌                  
     2. 2  撤消                  
     實(shí)例一  撤消上一步操作                  
     實(shí)例二  撤消多步操作                  
     2. 3  重復(fù)                  
     實(shí)例一  重復(fù)上一次撤消的操作                  
     實(shí)例二  重復(fù)多步被撤消的操作                  
     2. 4  剪切                  
     實(shí)例  剪切一個(gè)選定區(qū)域的內(nèi)容                  
     2. 5  復(fù)制                  
     實(shí)例  復(fù)制一個(gè)區(qū)域的內(nèi)容到剪貼板                  
     2. 6  粘日占                  
     實(shí)例一  移動(dòng)一個(gè)選擇區(qū)域的內(nèi)容                  
     實(shí)例二  通過剪貼板粘貼不同的內(nèi)容                  
     2. 7  選擇性粘貼                  
     實(shí)例  選擇性粘貼Excel區(qū)域                  
     2. 8  填充                  
     實(shí)例一  向下填充                  
     實(shí)例二  自動(dòng)填充序列                  
     實(shí)例三  自定義填充序列                  
     2. 9  清除                  
     實(shí)例  清除格式                  
     2. 10  刪除                  
     實(shí)例  刪除一個(gè)區(qū)域                  
     2. 11  刪除工作表                  
     2. 12  移動(dòng)或復(fù)制工作表                  
     實(shí)例一  移動(dòng)工作表                  
     實(shí)例二  建立工作表副本                  
     實(shí)例三  更改工作表的排列次序                  
     2. 13  查找                  
     實(shí)例  查找“課程表”中的詞“數(shù)學(xué)”                  
     2. 14  替換                  
     實(shí)例  替換“數(shù)學(xué)”為“代數(shù)學(xué)”                  
     2. 15  定位                  
     實(shí)例一  定位在內(nèi)容為數(shù)值的單元格上                  
     實(shí)例二  使用單元格的行列號(hào)定位                  
   第3章  視圖菜單操作                  
     3. 1  視圖菜單全朗                  
     3. 2  普通                  
     3. 3  分頁預(yù)覽                  
     實(shí)例  分頁預(yù)覽工作表                  
     3. 4  工具欄                  
     實(shí)例一  移動(dòng)工具欄                  
     實(shí)例二  打開／關(guān)閉工具欄                  
     3. 5  編輯欄                  
     實(shí)例一  為單元格命名                  
     實(shí)例二  編輯公式                  
     3. 6  狀態(tài)欄                  
     實(shí)例  改變狀態(tài)欄的輸出信息                  
     3. 7  頁眉和頁腳                  
     3. 8  批注                  
     3. 9  視面管理器                  
     實(shí)例一  創(chuàng)建“全圖”視面                  
     實(shí)例二  顯示“全圖”視面                  
     3. 10  全屏顯示                  
     3. 11  顯示比例                  
     實(shí)例  不同顯示比例比較                  
   第4章  插入菜單操作                  
     4. 1  插入菜單全貌                  
     4. 2  單元格                  
     實(shí)例  插入一個(gè)單元格                  
     4. 3  行                  
     實(shí)例插入一行                  
     4. 4  列                  
     實(shí)例  插入一列                  
     4. 5  工作表                  
     實(shí)例  插入一個(gè)空工作表                  
     4. 6  圖表                  
     實(shí)例一  用向?qū)?chuàng)建收支平衡折線圖                  
     實(shí)例二  用向?qū)?chuàng)建人員組成餅狀圖                  
     4. 7  分頁符                  
     實(shí)例一  在表中插入分頁符                  
     實(shí)例二  刪除分頁符                  
     4. 8  函數(shù)                  
     實(shí)例  輸入函數(shù)                  
     4. 9  名稱                  
     實(shí)例一  用菜單命令命名單元格或選定區(qū)域                  
     實(shí)例二  自動(dòng)命名單元格                  
     實(shí)例三  建立名稱表                  
     實(shí)例四  刪除名稱                  
     實(shí)例五  利用名稱快速定位                  
     4. 10  批注                  
     實(shí)例一  為單元格插入批注                  
     實(shí)例二  編輯單元格的批注                  
     實(shí)例三  刪除單元格批注的幾種方法                  
     實(shí)例四  用“審閱”工具欄編輯批注                  
     4. 11  圖片                  
     實(shí)例一  插入流程圖                  
     實(shí)例二  插入一個(gè)公司的組織結(jié)構(gòu)圖                  
     4. 12  對(duì)象                  
     實(shí)例一  插入數(shù)學(xué)公式                  
     實(shí)例二  在工作表中播放電影剪輯                  
     4. 13  超級(jí)鏈接                  
     實(shí)例一  建立工作簿間的超級(jí)鏈接                  
     實(shí)例二  在同一工作表不同位置之間跳轉(zhuǎn)                  
   第5章  格式菜單操作                  
     5. 1  格式菜單全貌                  
     5. 2  單元格                  
     實(shí)例一  把數(shù)字改為中文大寫                  
     實(shí)例二  制作特別的單元格邊框                  
     實(shí)例三  把單元格設(shè)為“黃底色. 50％粉紅色圖案”                  
     5. 3  行和列                  
     實(shí)例一  精確設(shè)定行高                  
     實(shí)例二  使行高與字符高度相配                  
     實(shí)例三  隱藏第4行                  
     實(shí)例四  設(shè)置標(biāo)準(zhǔn)列寬為“22”磅                  
     5. 4  工作表                  
     實(shí)例一  重命名工作表                  
     實(shí)例二  隱藏和顯示工作表                  
     實(shí)例三  用云彩圖片作為工作表背景                  
     5. 5  自動(dòng)套用格式                  
     實(shí)例  套用“三維效果2”格式                  
     5. 6條件格式                  
     實(shí)例  根據(jù)數(shù)據(jù)準(zhǔn)確度確定格式                  
     5. 7  樣式                  
     實(shí)例一  套用千位分隔樣式                  
     實(shí)例二  自定義“黑框灰背景”樣式                  
     實(shí)例三  從其他工作簿中合并樣式                  
     5. 8  拼音信息                  
     實(shí)例一  為鑭系元素注音                  
     實(shí)例二  顯示鑭系元素的拼音                  
     實(shí)例三  更改拼音信息的顯示格式                  
   第6章  工具菜單操作                  
     6. 1  工具菜單全貌                  
     6. 2  拼寫                  
     實(shí)例  檢查工作表中的錯(cuò)誤單詞                  
     6. 3  自動(dòng)更正                  
     實(shí)例  增添自動(dòng)更正：更正“數(shù)碼相機(jī)”為“數(shù)碼相機(jī)”                  
     6. 4  共享工作簿                  
     實(shí)例一  有條件地共享工作簿                  
     實(shí)例二  取消工作簿共享狀態(tài)                  
     6. 5  修訂                  
     實(shí)例一  突出顯示其他用戶的修訂                  
     實(shí)例二  把所作的修訂保存成新工作表                  
     實(shí)例三  有選擇地接受他人的修改                  
     6. 6  合并工作簿                  
     實(shí)例  合并其他用戶修訂的備份                  
     6. 7  保護(hù)                  
     實(shí)例一  保護(hù)整個(gè)工作表                  
     實(shí)例二  保護(hù)一個(gè)工作表的部分區(qū)域                  
     實(shí)例三  取消工作表保護(hù)                  
     實(shí)例四  保護(hù)工作簿                  
     實(shí)例五  不讓他人取消工作簿共享                  
     6. 8  聯(lián)機(jī)協(xié)作                  
     實(shí)例  舉行聯(lián)機(jī)會(huì)議                  
     6. 9單變量求解                  
     實(shí)例  反推每年應(yīng)投資的金額                  
     6. 10  方案                  
     實(shí)例一  建立投資的3種方案                  
     實(shí)例二  在3種方案之間切換                  
     實(shí)例三  做“投資方案”總結(jié)報(bào)告                  
     實(shí)例四  創(chuàng)建方案數(shù)據(jù)透視表                  
     6. 11  審核                  
     實(shí)例一  追蹤“凈現(xiàn)值”引用的數(shù)值                  
     實(shí)例二  追蹤“投資支出”的從屬單元格                  
     實(shí)例三  定位在單元格D13所有級(jí)別的引用單元格上                  
     實(shí)例四  追蹤引起“#VLUE”錯(cuò)誤的根源                  
     實(shí)例五  圈出無效的數(shù)據(jù)                  
     6. 12  宏                  
     實(shí)例一  錄制新宏“星期”                  
     實(shí)例二  刪除宏“星期”                  
     實(shí)例三  執(zhí)行其他工作簿中的宏                  
     實(shí)例四  把宏“星期”的快捷鍵改為Ctrl十k                  
     實(shí)例五  把宏管理的安全級(jí)別設(shè)為高級(jí)                  
     實(shí)例六  用VisualBasic編輯器修改宏“合并”                  
     實(shí)例七  單步執(zhí)行宏“合并”                  
     6. 13  加載宏                  
     實(shí)例一  加載宏“分析工具庫”                  
     實(shí)例二  卸載已加載的宏“分析工具庫“                  
     6. 14  自定義                  
     實(shí)例一  隱藏幾個(gè)按鈕, 增加顯示幾個(gè)按鈕                  
     實(shí)例二  創(chuàng)建一個(gè)“實(shí)用”工具欄                  
     實(shí)例三  創(chuàng)建一個(gè)工具按鈕“自定義格式”                  
     實(shí)例四  保留多個(gè)工具欄配置                  
     6. 15  選項(xiàng)                  
     實(shí)例一  把默認(rèn)字體改為“隸書. 14號(hào)字”                  
     實(shí)例二  隱藏編輯欄. 狀態(tài)欄. 網(wǎng)格線. 滾動(dòng)條和行號(hào)列標(biāo)                  
     實(shí)例三  用迭代法求解方程, 要求精度達(dá)十萬分之一                  
     實(shí)例四  把生成的網(wǎng)頁文件存為Big5碼                  
   第7章  數(shù)據(jù)菜單操作                  
     7. 1  數(shù)據(jù)菜單全貌                  
     7. 2  排序                  
     實(shí)例一  對(duì)一列按升序排序                  
     實(shí)例二  按平均成績排名                  
     實(shí)例三  按物理成績排序                  
     7. 3  篩選                  
     實(shí)例一  篩選出損壞的公用物品                  
     實(shí)例二  篩選最昂貴的三件財(cái)物                  
     實(shí)例三  篩選98年前購買. 價(jià)格超過干元的物品                  
     實(shí)例四  篩選已損壞的. 超過于元的公用物品                  
     7. 4  記錄單                  
     實(shí)例一  添加新記錄                  
     實(shí)例二  在記錄單中修改和刪除記錄                  
     實(shí)例三  查找朋友中的女職員                  
     實(shí)例四  查找74年上半年之前出生的男性朋友                  
     7. 5  分類匯總                  
     實(shí)例  根據(jù)訂購人分類匯總                  
     7. 6  有效數(shù)據(jù)                  
     實(shí)例一  規(guī)定身高不能低于1米. 高于2. 5米                  
     實(shí)例二  “對(duì)不起, 您輸入的身高肯定有錯(cuò)!”                  
     實(shí)例三  通過計(jì)算判定數(shù)據(jù)有效性                  
     7. 7模擬運(yùn)算表                  
     實(shí)例一  不同利息下每月還款的數(shù)目                  
     實(shí)例二  為模擬運(yùn)算表再添加公式                  
     實(shí)例三  建立一個(gè)九九乘法表                  
     實(shí)例四  用雙變量模擬運(yùn)算表解決還款問題                  
     7. 8  分列                  
     實(shí)例  從記事本中導(dǎo)入數(shù)據(jù)                  
     7. 9  合并計(jì)算                  
     實(shí)例  從2個(gè)工作薄中統(tǒng)計(jì)職工的工資                  
     7. 10  組及分級(jí)顯示                  
     實(shí)例一  隱藏明細(xì)數(shù)據(jù)                  
     實(shí)例二  人工重新分組                  
     7. 11  數(shù)據(jù)透視表和圖表報(bào)告                  
     實(shí)例一  創(chuàng)建一個(gè)數(shù)據(jù)透視表                  
     實(shí)例二  顯示6月份的數(shù)據(jù)透視表                  
     實(shí)例三  直接修改數(shù)據(jù)透視表                  
     實(shí)例四  查看送交到歐洲貨物的明細(xì)數(shù)據(jù)                  
     實(shí)例五  更新數(shù)據(jù)透視表                  
     實(shí)例六  創(chuàng)建數(shù)據(jù)透視圖                  
   第8章  窗口菜單操作                  
     8. 1  窗口菜單全貌                  
     8. 2  新建窗口                  
     實(shí)例  新建工作簿窗口                  
     8.3  重排窗口                  
     實(shí)例  重排當(dāng)前活動(dòng)窗口的所有分窗口                  
     8. 4  隱藏和取消隱藏                  
     實(shí)例  取消隱藏“數(shù)據(jù)表. xls”窗口                  
     8. 5  拆分和凍結(jié)窗格                  
     實(shí)例一  把窗口拆分成四個(gè)窗格                  
     實(shí)例二  凍結(jié)窗格                  
   第9章  經(jīng)典實(shí)例                  
     實(shí)例一  建立成績單工作表                  
     實(shí)例二  現(xiàn)金流水帳目                  
     實(shí)例三  損益平衡分析表                  
     實(shí)例四  建立一個(gè)投資方案決策器                  
     實(shí)例五  實(shí)驗(yàn)數(shù)據(jù)擬合報(bào)告                  
   附  錄  操作技巧特輯