【正文】 凍 結(jié) 窗 口 功能 .......................................................................................................................8 11 、 自 動 換 行 功能 .......................................................................................................................9 12 、 剪 切 ， 粘 貼 命 令 的 鼠 標(biāo) 操作 ...............................................................................................9 13 、 強(qiáng) 制 換 行 功能 .......................................................................................................................9 14 、 自 動 設(shè) 定 合 適 行 高 列寬 .......................................................................................................9 15 、 查 找 及 替 換 功能 ...................................................................................................................9 16 、 設(shè) 置 數(shù) 據(jù) 有 效性 .................................................................................................................10 17 、 排 序 功能 .............................................................................................................................10 18 、 合 并 單 元 格 中 的 數(shù)據(jù) .........................................................................................................11 19 、數(shù)據(jù)透視表 .........................................................................................................................12 二、 Excel 常 用 函數(shù) ..............................................................................................................12 1 、 數(shù) 學(xué) 函數(shù) ...............................................................................................................................12 1)Sum 函數(shù) ........................................................................................................................122)Sumif 函數(shù) .....................................................................................................................123)COUNTIF 函數(shù) .............................................................................................................134)DCOUNT 函數(shù) ..............................................................................................................135)INT函數(shù) ........................................................................................................................146)MOD 函數(shù) ......................................................................................................................147)MATCH 函數(shù) .................................................................................................................148)DATEDIF 函數(shù) ..............................................................................................................159)Average 函數(shù) .................................................................................................................1510)Max 函數(shù) ........................................................................................................................1511)Min 函數(shù) ........................................................................................................................1612)ABS 函數(shù) ........................................................................................................................1613)Hex2dec 函數(shù) .................................................................................................................1614)Dec2hex 函數(shù) .................................................................................................................1615)Subtotal 函數(shù) .................................................................................................................16 2 、 文 本 函數(shù) ...............................................................................................................................17 1)Lift 函數(shù) .........................................................................................................................172)Right 函數(shù) ......................................................................................................................183)Mid 函數(shù) ........................................................................................................................184)Substitute 函數(shù) ..............................................................................................................18 3 、 邏 輯 函數(shù) ...............................................................................................................................19 1)If 函數(shù) .............................................................................................................................192)And 函數(shù) ........................................................................................................................203)Or 函數(shù) ...........................................................................................................................20 4 、 查 找 函數(shù) ...............................................................................................................................20 1)Vlookup 函數(shù) .................................................................................................................20 三、 Excel 中 插 入 圖表 ..........................................................................................................21 四、 Excel 中 錄 制宏 ..............................................................................................................24 五、 Excel 常 用 快 捷鍵 ..........................................................................................................25 1 、 Ctrl+ 箭頭鍵 .........................................................................................................................25 2 、Ctrl+Home...............................................................