本書封面
內容簡介
在日常辦公中，單個Excel函數的功能有限，往往需要組合運用各種函數才能真正解決問題。本書以經典范例的形式講解Excel函數的組合應用技巧。全書共分為7章，第1章從Excel函數與公式的基礎知識入手，讓讀者快速了解函數的用法；2-6章通過83個實例介紹了組合函數在數據分析處理、日期與時間、數據檢索、字符串操作等方面的應用技巧；第7章為綜合實例，以此鞏固并實踐前面各章學到的組合函數應用技巧。 本書以實例+圖解的形式展示了組合函數的強大功能，非常實用，又簡單易學。同時，在隨書光盤中提供了書中實例的素材文件與最終文件，方便讀者進行實操演練
本書目錄
目 錄
第 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 計算多個匯總值的總和···································································
免責聲明
本站收集資源，均來自網絡僅用于內部交流之用，如有需要，請支持正版（在某東，天貓或當當網上搜索并購買圖書，希望對大家有用）
