Excel表格应用技巧.doc

ExcelExcelExcelExcelExcelExcel2000150010001.20002.(15001000)3.1.Sheet2()2.A()BC3.Sheet1(C)()(D)=INDIRECT(C1)4.C(C4)D(D4)1.()2.()()()()3.()(.xls)4.1.?fuhao1?2.()3.214.(fuhao1)5.1.()()2.()3.()4.OK?1.(,)2.1.()()2.3.Excel?(1)?1.2.pcw(pcw)3.pcw?pcw?ExcelExcel1.Visual Basic(Alt+F11)Visual Basic2.13.Function V(a,b,h)V = h*(a+b)/2End Function4.?1.2.Ctrl()()3.()()?&(BCD)1.D(EF)D1=B1&C1&D12.D1DBCDE3.EFE()F4.BCDE12BCD3VBASheet1A1G64121.Sheet2A1=IF(MOD(ROW()3)=0IF(0MOD?ROW()3(=1sheet1AINDEX(sheet1$A$GINT(ROW()+4)/3)+1)COLUMN()2.A1B1G1A1G1A2G1853.A1G2(1)()4.A1G3A4G186ExcelExcel()(Sheet1)(Sheet2Sheet3)ExcelExcel 2002Excel 2002Excel!Excel4!Excel?ExcelExcelExcelExcel?Sheet1ShiftSheet3(Ctrl)Excel?ExcelExcelExcelExcelExcel 2002=UPPER()=LOWER()=PROPER()A1excel=UPPER(A1)EXCELA3mr.weiwei=PROPER(A3)Mr.WeiweiA4=RIGHT()A42=LEFT()A5=MID(A5,4,2)A5445th123stndrd1112133th=A2&IF(OR(VALUE(RIGHT(A2,2)=11,12,13),th,IF(OR(VALUE(RIGHT(A2)=1,2,3,CHOOSE(RIGHT(A2),st,nd,rd),th)111213th11st2nd3rd12th$ExcelREPT=REPT()A2#16=(A2&REPT(#,16-LEN(A2)A3#16=REPT(#,16-LEN(A3)&A3#A4=REPT(#,8-LEN(A4)/2)&A4&REPT(#)8-LEN(A4)/2)A5$=(TEXT(A5,$#,#0.00(&REPT(#,16-LEN(TEXT(A5,$#,#0.00)REPTEGDWingdingsNE3=IF(D30,REPT(n,ROUND(D3*100,0),)G14ExcelSUBSTITUTETRIMA1how many words?=IF(LEN(A1)=0,0,LEN(TRIM(A1)-LEN(SUBSTITUTE(TRIM(