资源描述：
《很全的Excel高级使用技巧.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Excel1.2.3.4.5.6.7.8.9.10.11.12.111°1/°5°°1/2°00°000011°°003°5°4/°Ctrl4°°15CtrlSheet1Sheet2......Ctrl6CtrlCtrl728Ctrl*Ctrl*Ctrl*9Delete,2BCCDD1°=B1&CD1BCD1""BCBCDBCD°AutoCADEXCEL°yExcelxAyB°ABCC1=A1&""&B1C1C1AB3-4CONCATENATE°=CONCATENATB1,C1B2B3B745°=CONCATENAT""B2""B3
2、""B7"/"±45/3If6060"IFA2A3A3=ifA2<60IFIF=ifA2<60ifA2<=90"=ifA2<60"ifA2<=70ifA2<90=ifSUMA1A5>0SUMA1A50A1A5000IF4ExcelExcel1Excel[][][][][][][]Excel[X]X15656(52@@@Excel3>>=<<==<>°°>3Excel23[>0][<0]°:"($#,##0.00);":"($#,##0.00);"";":"@°1$12.00-0.3$0.30°°thisisabookthisisab
3、ook°]":"($#,##0.00);[]":"($#,##0.00);[]"";":"@°[Blue];[Red];[Yellow];[Green6$50000°][>50000]$#,##0.00_);[][<0]($#,##0.00);$#,##0.00_)±°[>999999]#,##0,,_m"";[>999]##,_k_m"";#_k""±05EXCELy=
4、lg6+x^3
5、AA1"X="AA2A2A3""BB1y=
6、lg6+x^3
7、B2°=ABLOG106+A2^3B2B2B2""B°Y7°Y8EXCELEXCELx
8、^2=x^7+4xEXCEL6ExcelExcelVisualBasic°VisualBasiVisualBasicVBAobject-rrrFunctionrrr(tatol,rr)Ifrr=""Thenrrr=0.6*tatolElseIfrr=""Thenrrr=0.5*tatolElseIfrr=""Thenrrr=0.9*tatolEndIfEndFunction9rrr(FB)10107Excel1Excel{A1C3}A1C3ShiftCtrlEnterA={A1C3}B={E1:G3}Excel11MDETERMMI
9、NVERSEMMULTSUMPRODUCT112AB3¡Á3¡Á3¡Á°=B°=-B°=A*AB°=A/AB°=B°=-B°=MMULT(B)AB°=MMULT(MINVERSEB)ShiftCtrlEnter81...12122IME9ExcelCtrl+A131310ExcelDIV/0!00VALUE!VALUE!C4D4=C4D4VALUE!REF!N/A#N/A#N/A#N/ANAME?ExcelSUMC1C10NUM!-1¡Á10301¡Á1030NULL°=SUM(A1:A10C1:C10°=SUM(A1:A10,C1
10、:C1011EXCELEXCELVBA******EXCELWORDOffsetActiveCell.Offset(1,0).range("A1").select12Excel14------XYXYEXCELEXCEL14Excel2000(2009-12-2613:06)-01excel131AAB2B2="13"&A2313xxxxxxxxxxxxxB213B2=A2&°10203EXCEL°-1°-21112EXCEL04EXCELWORD...05ExcelWordEXCELExcel06ExcelExcel07Excel
11、Excel°sheetsheet2sheet3.......08EXCEL,EXCEL09Excel2000.......)officeExcelA410ExcelWindows°Excel11F5A2A1000F5A2A100012Ctr+BacksPae13F514°Ctr*Ctrl*Ctfl*1516CtrlEner17CtrAExcel2218ShiftShift19Excel202122ExcelExcelXlstartExcelXlstartEXcel\2312±VCExcel24Excel6°25262728Ex
12、celVisualBasicModuleVBAEnterExcelExedFunctionZm(a)Ifa60Thenim±ElseZm=±EndIfEndFunction29()ZmMYUDF.XLSZmMYUDF.XLS=MYUD
