excel操作技巧與實(shí)例(大全)

1、LeoSinoHRManageConsultingStudioIExcel操作技巧操作技巧SkillsAboutExcel版本：ARev.20120820（20128202012820初版）初版）Email：jungwongcn@LeoSinoHRManageConsultingStudioIII2.2自定義函數(shù)157個(gè)....................................................202.3VL

2、OOKUP..............................................................202.4OFFSET...............................................................202.5IS函數(shù)..............................................................202.6數(shù)組公

3、式特征........................................................212.7SQL語(yǔ)句在EXCEL中的典型用法.........................................223圖表圖表...........................................................................................

4、...............................................23233.1復(fù)合餅圖............................................................233.2圖表組合............................................................263.3甘特圖.........................

5、.....................................303.4帶滾動(dòng)條的圖表......................................................343.5動(dòng)態(tài)圖表的制作......................................................364數(shù)據(jù)分析數(shù)據(jù)分析........................................

6、..........................................................................................39394.1數(shù)據(jù)有效性..........................................................394.1.1防止重復(fù)錄入...............................................

7、...394.1.2只能輸入日期..................................................404.1.3輸入的內(nèi)容中必須包括某字符....................................414.1.4制作二級(jí)選項(xiàng)菜單：............................................414.2整合數(shù)據(jù)表............................

8、..............................414.3自定義數(shù)字格式的實(shí)用案例............................................464.4批量取消合并單元格并使用CTRLENTER填充數(shù)據(jù)...........................474.5隱藏小于3000的數(shù)值.................................................484.6將一

9、列數(shù)據(jù)轉(zhuǎn)化為多列數(shù)據(jù)............................................484.7將多列數(shù)據(jù)轉(zhuǎn)化為一列................................................484.8合并計(jì)算匯總多表數(shù)據(jù)................................................494.9利用合并計(jì)算核對(duì)數(shù)值型數(shù)據(jù)......................

10、....................505實(shí)例技巧實(shí)例技巧..................................................................................................................................51515.1各種各樣的排名匯總...........................................