Excel使用技巧大全_超全_

Excel16371.72.EXCEL73.84.85.EXCEL96./97.98.109.1010.1111.1112.1313.OFFICE1314.1415.1416.1517.EXCEL1518.1619.1620.1621.1722.1723.1724.1825.EXCEL1826.1927.1928.2029.2030.2031.2132.2133.2134.EXCELOFFICE2235.2236.2337.2338.2339.2440.2541.2642.2643.2744.27281.282.283.F4294.EXCEL295.306.307.0318.329.OFFICE3210.3311.3312.3413.3414.3415.3516.3617.3618.3719.3820.3921.WPS/WORDEXCEL3922.4023.4024.4125.4126.4127.EXCELWORD4228.4329.4330.EXCEL4331.4432.4433.4534.4535.4636.OFFICE4637.OFFICE4638.4739./OFFICE4740.4841.4842.4943.5044.5045.5046.5147.5148.EXCEL5249.5250.5351.OFFICE5352.EXCEL5353.5454.EXCEL5455.5556.5657.5658.EXCEL5759.5760.EXCEL58581.EXCEL582.593.EXCELWORD604.WORDEXCEL615.WORDEXCEL616.627.628.639.6310.6411.6512.6513.6614.6615.6716.6717.6818.6819.7020.7121.7122.7123.7224.7225.7326.7427.EXCEL7528.75751.IFEXCEL0752.763.774.785.796.797.808.809.SUM8110.8111.8212.82831.832.843.854.865.EXCEL866.OFFICE877.878.WEB889.EXCEL8910.108911.OFFICE9012.EXCEL9113.92921.922.933.934.945.946.951.2.ExcelExcel:1.Windows°StartMenu\Programs\;2.ExcelExcelExcelWindowsExcelWindowsExcel::Excel:Excel3.()()4.ExcelD3:1.2.:2555.ExcelExcel°Ctrl+Shift+*:6./Ctrl7.Shift:Shift8.Delete:9.;;Ctrl;;10.Excelsheet1sheet2sheet3:1.2.°Sheet11.:(*.xls)ShiftCtrlExcel2002C:\Windows\ApplicationData\Microsoft\Excel\XLSTARTExcel2002Excel2002(d:\Excel)Excel2002(Excel)Excel2002ShiftCtrlExcel200212.9913.OfficeExcel14.****()15.Excel2002()Excel16.:regeditHKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\OpenFind\Places\UserDefinedPlaces°mydo°Nam°Pat±)°d\mypath±)Excel2002°d\mypath17.Excel°Ctrl+Ta18.°ShifF119.ExcelHTMLXlmain10.chm\Office10\2052WindowsExcelOfficeWindowsExcel20.:;;;21.Shift22.°Shift+FCtrl23.24.:25.Excel°Ctrl+-26.Excel:():27.():Tab28.Shift29.Shift;Ctrl;30.ShiftCtrl:1.2.3.4.31.Ctrl32.:33.()Shift()()Ctrl()34.ExcelOfficeExcelShift:CtrlShift35.36.OfficeC:\PrograrnFiles\MicrosoftOffice\Office10\XLStartExcel37.°Ctri+Hom(A1)°Ctrl+En°trl+.438.Excel:XXXXX39.ExcelExcel:()()Excel4()40.Excel:Excel(°Alt±41.Enter°Ctrl+Ente42.:1.;2.;3.43.()Excel44.:45.:Ctrl46.25547.F4ExcelF4F4F448.Excel1.WindowsTab;2.Excel-31±;3-32ExcelTab±;4-33Excel49.Excel:Alt+°Alt50.Excel():151.0Excel°0°4.0°°Excel:°0°4.0°0°4.052.ExcelExcel:1.;2.;3.±;4F2Enter53.OfficeExcel,:Tab°Shift+Ta:Tab;TabEnter54.:Enter55.EnterTab9/5/96Jun-9612a()p()9:00pExcelAM()56.Alt()01284Alt57.:()()58.1212:12259.:248:1224224816246860.:61.X:°62.°Ctrl+°Ctrl+°Ctrl+:1.2.Enter3.°CtrDR°Ctrl+°Ctrl+4.Ctrl°Ctrl+Ente63.::Ctrl°64.Excel°:'65.WPS/WordExcelWPSWordExcelExcel:1.WPSWordWPSWord;2.ExcelExcel:WPSExcelWPS97WPS2000WPSOfficeWord66.:67.68.Ì°Marletab69.:1.02.070.Excel:1.;2.()Excel71.ExcelWord1.Word;2.WordExcel;3.Word;4.Excel72.73.74.ExcelExcelExcelExcelExcel2002ExcelHtml75.Excel1.URLE-mail2.76.Enter;Esc77.±78.79.()ExcelEnter80.OfficeExcel81.Office°;;¡±):44382.:BAC83./OfficeExcel,,,,::°Ctrl+:°Ctrl+:°Ctrl+Shift+ò:°Ctrl+Shift+ò84.85.()():86.:87.88.°Ctrl+Ente89.°Ctrl+Ente90.°Ctrl+°Ctrl+Shift+°Ctrl+°Ctrl+Shift+:TODAYNOW91.:°Ctrl+Shift+92.ExcelExcel:93.Excel:()Excel94.°Ctrl+95.OfficeExcelABBA96.ExcelExcel°Ctrl+97.Excel:98.ExcelExcelF2:F2EnterESC:ExcelInternet99.Excel:+100.Excel:101.Excel12/10/9112/10/9912/10/9912/10/9112/10/92¡­120/99102.ExcelExcelDATEDIF()A1A2type=DATEDIF(A1,TODAY(),y)Enter()A2103.:Shift104.ExcelExcelExcelExcelHtml105.ExcelExcelWeb°We(PNG)PNGExcelGIFJPGfiles°dog.htExcel°dog/fileExcel°image01.jp°image02.jpWebWebExcelVB106.Excel2002:4107.ExcelWordExcelShift1WordExcel;108.WordExcelWordExcel:WordExcelShiftExcelExcel109.WordExcelWordExcelShiftExcel110.111.Excel:112.():113.114.:::::115.:116.:117.118.Excel:119.C:\Windows\ApplicationData\MicrosoftExcelxlusrgal.xls120.::(±Ctrl121.122.Excel::::Shift()123.Excel124.°Al125.4:F11126.:127.Excel:()128.:Excel5Excel129.6130.8;131.ExcelExcelF11Excel°Alt+F132.ExcelShiftShift133.IFExcel0Excel°°IFIF:IF(logical_test,value_if_true,value_if_false)logical_testTRUEFALSEA1=100A1100TRUEFALSE;value_if_truelogical_test;value_if_falselogical_testIF(SUM(B1:C1)SUM(B1:C1),¡:B1C1B1C1B1C1134.:m¡Á135.B2B5B6:B6°ÆB2B5B2B5B6°=sum(B2:B5EnterB2B5B6B2D2E2:(E2),C2C5D2D5E2E5C6D6E6C6D6E6:B6C6E6B6C6D6E6136.B2C5D4E6:E6°ÆB2C5D4E6°=suB2C5D4137.Excel138.ExcelExcel2002:Enter139.,,140.:141.SUMExcelSUM30SUM50A2A4A6A8A10A12A96A98A100SUM(A2A4A6A96A98A100)ExcelSUM;SUM((A2A4A6A96A98A100))SUM142.Excel$$B$1B:F4143.Excel:°Ctrl+°°144.60±60IFB3C3C3:=if(b3=60,±±=if(b3=60,if(b3=90,±)3=if(b3=60,if(b3=70,if(b390,±)))4:IF7145.ExcelOfficeExcelOfficeExcelExcel146.URLExcel147.:1.Internet;2.;3.Internet(=)URL:=[filel.xls]148.Sheet1Sheet2Sheet33Sheet1D840Sheet2B860Sheet3A8Sheet3A8:=Sheet1!D840Sheet2!B860149.ExcelExcel(AZ)AZ150.Office:Excel151.Excel:-1-11000152.WebExcelWebExcelExcelWebWebExcel2002WebWeb:WebExcelWebWebExcel::Webgif153.Excel:154.10n1010101010812155.OfficeC1C4C5D3E1125:25CtrlC1C4C5D3E1125156.ExcelExcelExcel:Excel!±157.°We158.159.Excel:Alt;160.C:WindowsApplicationDataMicrosoftExcelExcel10xlbExcell0xlb161.162.Excel2002Excel2002:163.Excel1.;2.;3.ThisdocumentwascreatedwithWin2PDFavailableat