圖書信息
我的第一本系列
啟賦書坊 編著
ISBN 978-7-121-13996-3
2011年8月出版
定 價：35.00元（含光碟1張）
24開
252頁
內 容 簡 介
Excel 2010是專業的電子表格製作軟體，可以快捷地生成電子表格，高效地輸入數據，運用公式和函式進行計算，實現數據的管理、計算和分析，生成直觀的圖形、專業的報表等，因此被廣泛套用於文秘辦公、財務管理、市場行銷和行政管理等事務中。本書兼顧實用和易學兩個特點。在分析知識點時，採用了大量常見問題作為示例，讀者可以靈活套用、應對實際工作；在講解方法時，採用了詳細的步驟圖解演示，確保讀者能掌握操作技法。
本書適合Excel 2010軟體的初學者快速提高軟體操作、數據分析及表格製作能力；也適合公司文秘、行政管理、財務審計和市場行銷等從業人員使用；還可作為各類電腦培訓學校、大中專院校的教學輔導用書。
前 言
Excel 2010是一款專業的電子表格製作軟體，它能快捷地生成電子表格，高效地輸入數據，運用公式和函式進行計算，實現數據的管理、計算和分析，生成直觀的圖形、專業的報表等，因此被廣泛套用於文秘辦公、財務管理、市場行銷和行政管理等事務中。那么要如何下手才能掌握這款軟體，將學到的知識運用到工作中呢？為了幫助讀者系統地掌握Excel的操作方法，以及製作表格、分析數據等方面的技巧，我們編寫了這本《我的第一本Excel書》。
本書兼顧實用和易學兩個特點。在介紹Excel表格的創建、數據統計和分析等知識點時，採用了大量模擬真實工作套用的示例，便於讀者靈活套用、拓展到實際工作中去；在講解操作方法和技巧時，採用了詳細的步驟圖解演示，確保讀者能按圖索驥、自己一步一步做出效果、增強信心、體會要領。
目錄
導讀
1 學習路線圖…………………………………2
2 如何閱讀本書………………………………4
3 學完本書您能做什麼…………………………………6
Chapter 01 進入Excel的世界 ······················9
1.1 安裝與啟動Excel 2010 ········10
1.1.1 安裝 Excel 2010 ·······················10
1.1.2 啟動Excel 2010 ························12
1.2 隨心整改Excel操作界面 ·····13
1.2.1 自定義功能區 ···························13
1.2.2 自定義快速訪問工具列按鈕 ······15
1.3 必備的工作簿的基本操作 ···16
1.3.1 創建工作簿 ·······························16
1.3.2 保存工作簿 ·······························17
1.3.3 關閉工作簿 ·······························18
1.3.4 打開工作簿 ·······························19
Chapter 02 快速、準確地錄入與編輯數據 ···· 30
2.1 輸入普通數據 ····················31
2.1.1 輸入文本與數字 ························31
2.1.2 輸入日期和時間 ························32
2.1.3 輸入分數 ··································33
2.2 輸入有規律的數據·············34
2.2.1 利用控制柄填充數據 ················34
2.2.2 利用對話框填充數據 ················35
2.2.3 自定義數據序列填充 ················36
2.3 有效避免數據錄入的錯誤 ····39
2.3.1 數據有效性設定 ························39
2.3.2 圈釋出無效數據 ························43
2.4 查找與替換數據 ················44
2.4.1 查找數據 ··································44
2.4.2 替換數據與格式 ························45
2.5 清除數據 ····························49
2.5.1 清除內容 ··································49
2.5.2 清除格式 ··································50
2.5.3 清除全部內容 ···························51
Chapter 03 快捷、方便地美化表格 ············· 53
3.1 設定單元格格式·················54
3.1.1 合併單元格 ·······························54
3.1.2 設定字型格式 ···························56
3.1.3 設定對齊方式 ···························58
3.1.4 設定數字格式 ···························61
3.1.5 設定框線與底紋樣式 ················62
3.2 套用單元格樣式 ················66
3.2.1 快速套用內置單元格樣式 ·········66
3.2.2 修改樣式 ··································67
3.2.3 自定義單元格樣式 ····················68
3.3 套用表格樣式 ····················70
3.3.1 套用預定義表樣式 ····················70
3.3.2 刪除重複項 ·······························72
3.3.3 將表格轉換為普通區域 ·············73
Chapter 04 用圖形、藝術字豐富表格 ·········· 74
4.1 使用圖片 ····························75
4.1.1 插入圖片 ··································75
4.1.2 簡單處理圖片 ···························77
4.1.3 為圖片添加特殊效果 ················82
4.2 使用形狀 ····························84
4.2.1 插入形狀 ··································84
4.2.2 設定形狀樣式 ···························86
4.2.3 排列多個形狀 ···························88
4.2.4 組合形狀 ··································89
4.3 使用藝術字 ························90
4.3.1 插入藝術字 ·······························91
4.3.2 設定藝術字樣式 ························91
4.4 使用SmartArt 圖形 ··············93
4.4.1 插入SmartArt圖形 ····················94
4.4.2 設計SmartArt圖形 ····················95
4.4.3 套用SmartArt樣式 ····················96
4.4.4 更改SmartArt布局 ····················97
Chapter 05 用加密和共享控制用戶的訪問 ···· 98
5.1 導入數據 ····························99
5.1.1 導入文本數據 ···························99
5.1.2 導入網站數據 ·························101
5.1.3 導入Access數據 ·····················102
5.2 使用超連結 ······················104
5.2.1 創建超連結 ·····························104
5.2.2 更改超連結外觀 ······················106
5.3 數據的加密 ······················108
5.3.1 保護工作表 ·····························108
5.3.2 限制用戶編輯區域 ··················109
5.3.3 加密工作簿 ·····························112
5.4 數據共享 ··························113
5.4.1 共享工作簿 ·····························114
5.4.2 以郵件共享工作簿 ··················116
5.4.3 將數據列印出來傳閱 ··············117
6.1 公式的套用 ······················123
6.1.1 公式的簡介 ·····························123
6.1.2 公式的輸入 ·····························123
6.1.3 編輯公式 ································125
6.2 單元格的引用 ··················127
6.2.1 相對引用 ································128
6.2.2 絕對引用 ································129
6.2.3 按行或列引用 ·························130
6.3 名稱的套用 ······················131
6.3.1 定義名稱 ································131
6.3.2 套用名稱 ································134
6.4 函式的使用方法 ··············137
6.4.1 插入函式 ································137
6.4.2 使用嵌套函式 ·························139
6.5 常用函式的套用 ··············140
6.5.1 統計函式的套用 ······················141
6.5.2 財務函式的套用 ······················144
Chapter 06 用簡潔、精確的公式函式計算數據 ··· 122
Chapter 07 用簡單、實用的查找與匯總整理數據 ··· 147
7.1 數據的排序 ·······················148
7.1.1 簡單排序 ································148
7.1.2 複雜排序 ································149
7.1.3 自定義排序 ·····························150
7.2 數據的篩選·······················152
7.2.1 自動篩選 ································152
7.2.2 自定義篩選 ·····························154
7.2.3 高級篩選 ································155
7.3 數據的分類匯總 ···············157
7.3.1 創建分類匯總 ·························157
7.3.2 分類匯總的嵌套 ······················159
7.4 按位置或分類合併計算數據 ···161
7.4.1 按位置合併計算數據 ··············161
7.4.2 按分類合併計算數據 ··············163
Chapter 08 用形象、直觀的圖形可視化數據 ···· 166
8.1 利用條件格式顯示
特定的數據 ························167
8.1.1 利用條件格式突顯滿足
條件的數據 ·····························167
8.1.2 利用數據條表現數據大小 ·······169
8.1.3 使用色階來突出極值 ··············174
8.1.4 使用圖示集劃分數據 ··············176
8.2 利用迷你圖表現
數據變化 ··························178
8.2.1 創建迷你圖 ·····························178
8.2.2 格式化迷你圖 ·························179
Chapter 09 用精美、視覺衝擊力強的圖表形象化數據··· 182
9.1 圖表簡介 ··························183
9.1.1 圖表的組成 ·····························183
9.1.2 圖表的種類 ·····························183
9.2 創建圖表 ··························186
9.2.1 快速組命令創建圖表 ··············186
9.2.2 通過模板創建圖表 ··················187
9.3 編輯圖表 ··························189
9.3.1 更改圖表源數據 ······················189
9.3.2 追加數據系列 ·························190
9.3.3 更改數據系列圖表類型 ···········191
9.3.4 快速調整圖表元素布局 ···········193
9.3.5 調整坐標軸刻度 ······················195
9.4 設定圖表格式 ··················196
9.4.1 套用圖表樣式 ·························197
9.4.2 設定圖表元素格式 ··················198
9.5 圖表分析 ··························200
9.5.1 添加趨勢線 ·····························200
9.5.2 添加折線 ································201
9.5.3 添加誤差線 ·····························203
9.5.4 添加漲/跌柱線 ························204
Chapter 10 用互動式的數據透視表和圖動態分析數據···207
10.1 創建數據透視表 ·············208
10.2 數據透視表結構調整 ·····209
10.2.1 數據透視表欄位區域調整 ·····209
10.2.2 以表格形式布局數據透視表 ···210
10.3 數據透視表布局的整理 ···212
10.3.1 整理複合字段 ·······················212
10.3.2 更改分類匯總顯示位置 ·········214
10.3.3 在每項後插入空行 ················215
10.4 數據的可視化篩選 ·········215
10.4.1 插入切片器進行篩選 ············216
10.4.2 設定切片器的外觀樣式 ·········217
10.5 利用數據透視圖動態
呈現數據關係 ················219
10.5.1 創建數據透視圖 ····················219
10.5.2 設計數據透視圖 ····················220
10.5.3 動態呈現數據關係 ················222
Chapter 11 用簡單、實用分析工具簡化數據分析和處理···· 224
11.1 將一列數據按內容
分為多列 ························225
11.2 快速刪除表格中的重複項 ···227
11.3 數據的模擬分析·············228
11.3.1 單變數模擬運算 ····················228
11.3.2 雙變數模擬運算 ····················230
11.4 創建方案分析數據 ·········231
11.4.1 創建方案 ······························231
11.4.2 生成方案總結報告 ················234
11.5 利用規劃求解找到最佳方案 ···235
11.5.1 建立規劃求解模型 ················235
11.5.2 規劃求解數據 ·······················236
11.5.3 生成規劃求解結果報告 ·········239
