microsoft-excel2010基礎操作培訓學習教程

1、培訓教程培訓教程Excel2010基礎操作基礎操作3.8文本格式設置................................................................................................283.9設置對齊方式...............................................................................

2、.................283.10工作表中的行和列操作..............................................................................293.10.1選定行和列........................................................................................293.10.2

3、調整行高和列寬................................................................................293.11設置邊框與底紋..........................................................................................313.12套用單元格樣式.................

4、.........................................................................334應用案例二：成績表的制作應用案例二：成績表的制作..................................344.1表頭制作.............................................................................

5、...........................344.2數(shù)字錄入........................................................................................................344.2.1文本型數(shù)字錄入..................................................................

6、................344.2.2限定成績范圍......................................................................................354.3插入行或列...............................................................................................

7、.....374.3.1插入行..................................................................................................374.3.2插入列.................................................................................................

8、.384.4刪除行或列....................................................................................................394.5對調單元格數(shù)據(jù)............................................................................................404.6

9、公式的簡單運算............................................................................................414.6.1公式的表示法......................................................................................414.6.2公式的輸入與編輯.......

10、.......................................................................414.6.3自動更新結果......................................................................................424.6.4自動填充公式.....................................

11、.................................................424.7“自動求和”快速輸入函數(shù).........................................................................434.8不輸入公式得知計算結果.................................................................

12、...........434.9數(shù)據(jù)排序........................................................................................................444.9.1簡單排序.....................................................................................

13、.........444.9.2多關鍵字排序......................................................................................454.10數(shù)據(jù)篩選......................................................................................................

14、464.11利用“條件格式”分析數(shù)據(jù)......................................................................484.11.1使用條件格式突出顯示數(shù)據(jù)項........................................................484.11.2刪除條件格式.........................................

15、...........................................494.12凍結窗口......................................................................................................514.13隱藏與顯示行和列...................................................

16、...................................524.13.1隱藏行與顯示行................................................................................524.13.2隱藏列與顯示列...........................................................................