在日常辦公中，單個Excel函式的功能有限，往往需要組合運用各種函式才能真正解決問題。本書以經典範例的形式講解Excel函式的組合套用技巧。全書共分為7章，第1章從Excel函式與公式的基礎知識入手，讓讀者快速了解函式的用法；2-6章通過83個實例介紹了組合函式在數據分析處理、日期與時間、數據檢索、字元串操作等方面的套用技巧；第7章為綜合實例，以此鞏固並實踐前面各章學到的組合函式套用技巧。 本書以實例+圖解的形式展示了組合函式的強大功能，非常實用，又簡單易學。同時，在隨書光碟中提供了書中實例的素材檔案與最終檔案，方便讀者進行實操演練。
基本介紹
- 書名：Excel 函式×函式組合套用範例
- 出版社：科學出版社
- 頁數：396頁
- 開本：16
- 作者：Jacky Davis
- 出版日期：2013年11月1日
- 語種：簡體中文
- ISBN：9787030383327
內容簡介,作者簡介,圖書目錄,
內容簡介
這書的基礎是一本台灣引進的日本書，在台灣排在網路銷售的前列，找到這本書時，大約排在第12位。本書主要針對有一定的Excel操作基礎，同時需要利用多個函式解決實際工作問題的讀者，可以作為常備的參考工具書
作者簡介
《Office 2010圖解套用大全》張玉良，中國人民大學新聞學院畢業，具有豐富的出版經驗，工作期間也一直在提供各種Excel技術諮詢服務和培訓，並在各大論壇為網友解答辦公軟體困惑。2010年下半年創辦知行時代（北京）文化傳播有限公司，從事圖書的策劃與編寫。近期出版圖書：《Office辦公秘技360招》、《這么玩Excel最給力》、《Office 2010圖解套用大全》均有不錯的銷量
圖書目錄
目 錄
第 1 章 基本操作
1.1 創建與修改公式··············································································2
1.1.1 創建公式················································································ 2
1.1.2 修改公式················································································3
1.2 複製與隱藏公式··············································································4
1.2.1 複製公式················································································ 4
1.2.2 隱藏公式················································································ 6
1.3 單元格的引用···············································································7
1.3.1 相對引用················································································ 7
1.3.2 絕對引用················································································ 8
1.3.3 混合引用················································································ 9
1.4 套用單個函式···············································································11
1.4.1 初識函式················································································11
1.4.2 插入函式················································································12
1.5 套用多個函式···············································································15
1.5.1 嵌套函式················································································15
1.5.2 組合套用函式··············································································18
1.6 公式錯誤的解析··············································································19
1.6.1 錯誤值的含義··············································································19
1.6.2 套用錯誤檢查選項············································································20
1.6.3 公式審核················································································21
第 2 章 輸入與條件格式
001 限定輸入指定範圍的日期·······································································24
套用 限定輸入今年元旦至今日的日期 （TODAY + 數據有效性）
002 限定輸入文本長度且以特定字元開頭···················································27
套用 限定產品編號以“D”開頭且共4位 （LEFT + LEN + AND + 數據有效性）
003 避免一列中輸入重複數據·······································································30
套用 在員工信息表中輸入重複工號時彈出警告 （COUNTIF + 數據有效性）
004 生成動態下拉列表進行輸入···································································33
套用 輸入部門名稱時通過下拉列表選擇部門 （INDIRECT + 數據有效性）
005 提示輸入內容且輸入正確時自動計算···················································36
套用 提示輸入數量並自動計算總額 （IF + AND + ISNONTEXT）
006 給奇數、偶數行設定不同的格式···························································39
套用 讓表格內容藍白相間顯示 （MOD + ROW + 條件格式）
007 設定工作表中非空單元格格式·······························································42
套用 製作成本表後僅顯示表格區域 （條件公式 + 條件格式）
008 禁止錯誤值················································································45
套用 將錯誤值顯示為空白 （ISERROR + 條件格式）
009 比較兩個工作表檢查輸入錯誤·······························································48
套用 檢查在兩個工作表中輸入的公司名稱是否相同 （EXACT + IF）
拓展 常用同類函式···············································································51
第 3 章 統計分析
010 計算多個匯總值的總和···································································
第 1 章 基本操作
1.1 創建與修改公式··············································································2
1.1.1 創建公式················································································ 2
1.1.2 修改公式················································································3
1.2 複製與隱藏公式··············································································4
1.2.1 複製公式················································································ 4
1.2.2 隱藏公式················································································ 6
1.3 單元格的引用···············································································7
1.3.1 相對引用················································································ 7
1.3.2 絕對引用················································································ 8
1.3.3 混合引用················································································ 9
1.4 套用單個函式···············································································11
1.4.1 初識函式················································································11
1.4.2 插入函式················································································12
1.5 套用多個函式···············································································15
1.5.1 嵌套函式················································································15
1.5.2 組合套用函式··············································································18
1.6 公式錯誤的解析··············································································19
1.6.1 錯誤值的含義··············································································19
1.6.2 套用錯誤檢查選項············································································20
1.6.3 公式審核················································································21
第 2 章 輸入與條件格式
001 限定輸入指定範圍的日期·······································································24
套用 限定輸入今年元旦至今日的日期 （TODAY + 數據有效性）
002 限定輸入文本長度且以特定字元開頭···················································27
套用 限定產品編號以“D”開頭且共4位 （LEFT + LEN + AND + 數據有效性）
003 避免一列中輸入重複數據·······································································30
套用 在員工信息表中輸入重複工號時彈出警告 （COUNTIF + 數據有效性）
004 生成動態下拉列表進行輸入···································································33
套用 輸入部門名稱時通過下拉列表選擇部門 （INDIRECT + 數據有效性）
005 提示輸入內容且輸入正確時自動計算···················································36
套用 提示輸入數量並自動計算總額 （IF + AND + ISNONTEXT）
006 給奇數、偶數行設定不同的格式···························································39
套用 讓表格內容藍白相間顯示 （MOD + ROW + 條件格式）
007 設定工作表中非空單元格格式·······························································42
套用 製作成本表後僅顯示表格區域 （條件公式 + 條件格式）
008 禁止錯誤值················································································45
套用 將錯誤值顯示為空白 （ISERROR + 條件格式）
009 比較兩個工作表檢查輸入錯誤·······························································48
套用 檢查在兩個工作表中輸入的公司名稱是否相同 （EXACT + IF）
拓展 常用同類函式···············································································51
第 3 章 統計分析
010 計算多個匯總值的總和···································································
