《Excel 使用技巧集锦——163种技巧(史上最全的excel用法.pdf》由会员分享，可在线阅读，更多相关《Excel 使用技巧集锦——163种技巧(史上最全的excel用法.pdf（95页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、Excel 163 7 1.7 2.EXCEL 7 3.8 4.8 5.EXCEL 9 6./9 7.9 8.10 9.10 10.11 11.11 12.13 13.OFFICE 13 14.14 15.14 16.15 17.EXCEL 15 18.16 19.16 20.16 21.17 22.17 23.17 24.18 25.EXCEL 18 26.19 27.19 28.20 29.20 30.20 31.21 32.21 33.21 34.EXCEL OFFICE 22 35.22 36.23 37.23 38.23 39.24 40.25 41.26 42.26 43.27 4
2、4.27 28 1.28 2.28 3.F4 29 4.EXCEL 29 5.30 6.30 7.0 31 8.32 9.OFFICE 32 10.33 11.33 12.34 13.34 14.34 15.35 16.36 17.36 18.37 19.38 20.39 21.WPS/WORD EXCEL 39 22.40 23.40 24.41 25.41 26.41 27.EXCEL WORD 42 28.43 29.43 30.EXCEL 43 31.44 32.44 33.45 34.45 35.46 36.OFFICE 46 37.OFFICE 46 38.47 39./OFFIC
3、E 47 40.48 41.48 42.49 43.50 44.50 45.50 46.51 47.51 48.EXCEL 52 49.52 50.53 51.OFFICE 53 52.EXCEL 53 53.54 54.EXCEL 54 55.55 56.56 57.56 58.EXCEL 57 59.57 60.EXCEL 58 58 1.EXCEL 58 2.59 3.EXCEL WORD 60 4.WORD EXCEL 61 5.WORD EXCEL 61 6.62 7.62 8.63 9.63 10.64 11.65 12.65 13.66 14.66 15.67 16.67 17.
4、68 18.68 19.70 20.71 21.71 22.71 23.72 24.72 25.73 26.74 27.EXCEL 75 28.75 75 1.IF EXCEL 0 75 2.76 3.77 4.78 5.79 6.79 7.80 8.80 9.SUM 81 10.81 11.82 12.82 83 1.83 2.84 3.85 4.86 5.EXCEL 86 6.OFFICE 87 7.87 8.WEB 88 9.EXCEL 89 10.10 89 11.OFFICE 90 12.EXCEL 91 13.92 92 1.92 2.93 3.93 4.94 5.94 6.95
5、一、1.2.Excel Excel:1.Windows MenuPrograms;2.Excel Excel Excel Windows Excel Windows Excel:Excel:Excel 3.()()4.Excel D3:1.2.:255 5.Excel Excel:6./Ctrl 7.Shift:Shift 8.Delete:9.;Ctrl;10.Excel sheet1 sheet2 sheet3:1.2.11.:(*.xls)Shift Ctrl Excel 2002 C:WindowsApplication DataMicrosoftExcelXLSTART Excel
6、2002 Excel 2002(d:Excel)Excel 2002(Excel)Excel 2002 Shift Ctrl Excel 2002 12.9 9 13.Office Excel 14.*()15.Excel 2002()Excel 16.:regedit HKEY_CURRENT_USERSoftwareMicrosoft Office10.0CommonOpen FindPlacesUserDefinedPlaces)Excel 2002 17.Excel 18.19.Excel HTML Xlmain10.chm Office102052 Windows Excel Off
7、ice Windows Excel 20.:;21.Shift 22.Ctrl 23.24.:25.Excel-26.Excel:():27.():Tab 28.Shift 29.Shift;Ctrl;30.Shift Ctrl:1.2.3.4.31.Ctrl 32.33.()Shift()()Ctrl()34.Excel Office Excel Shift:Ctrl Shift 35.36.Office C:Prograrn FilesMicrosoft OfficeOffice10XLStart Excel 37.(A1)trl+.4 38.Excel:X X X X X 39.Exce
8、l Excel:()()Excel 4()40.:Excel(41.Enter 42.:1.;2.;3.43.()Excel 44.:一、45.:Ctrl 46.255 47.F4 Excel F4 F4 F4 48.Excel 1.Tab;2.Excel-3-3 Excel Tab -3 Excel 49.Excel:Alt+50.Excel():1 51.0 Excel Excel:52.Excel Excel:1.;2.;3.F2 Enter 53.Office Excel,:Tab :Tab;Tab Enter 54.:Enter 55.Enter Tab 9/5/96 Jun-96
9、12 a()p()9:00 pExcel AM()56.Alt()0128 4 Alt 57.:()()58.1 1 2:1 2 2 59.:2 4:1 2 2 4 2 2 4 8 2 4 6 60.:61.X:62.:1.2.Enter 3.D R 4.Ctrl 63.:Ctrl 64.Excel:65.WPS/Word Excel WPS Word Excel Excel:1.WPS Word WPS Word;2.Excel Excel:WPS Excel WPS97 WPS2000 WPS Office Word 66.:67.68.a b 69.:1.0 2.0 70.Excel:1
10、.;2.(Excel 71.Excel Word 1.Word;2.Word Excel ;3.Word;4.Excel 72.73.74.Excel Excel Excel Excel Excel 2002 Excel Html 75.Excel 1.URL E-mail 2.76.Enter;Esc 77.78.79.()Excel Enter 80.Office Excel 81.Office ):4 4 3 82.:B A C 83./Office Excel,:84.85.()():86.:87.88.89.90.:TODAY NOW 91.:92.Excel Excel:93.Ex
11、cel:()Excel 94.95.Office Excel A B B A 96.Excel Excel 97.Excel:98.Excel Excel F2:F2 Enter ESC:Excel Internet 99.Excel:+100.Excel:101.Excel 12/10/91 12/10/99 12/10/99 12/10/91 0/99 102.Excel Excel DATEDIF()A1 A2 type=DATEDIF(A1,TODAY(),y)Enter()A2 103.:Shift 104.Excel Excel Excel Excel Html 一、105.Exc
12、el Excel Web(PNG)PNG Excel GIF JPG Excel Excel Web Web Excel VB 106.Excel 2002:4 107.Excel Word Excel Shift 1 Word Excel;108.Word Excel Word Excel:Word Excel Shift Excel Excel 109.Word Excel Word Excel Shift Excel 110.111.Excel:112.():113.114.:115.:116.:117.118.Excel:119.C:WindowsApplicationDataMicr
13、osoft Excel xlusrgal.xls 120.:(Ctrl 121.122.Excel:Shift()123.Excel 124.125.4:F11 126.:127.Excel:()128.:Excel 5 Excel 129.6 130.8;131.Excel Excel F11 Excel 132.Excel Shift Shift 一、133.IF Excel 0 Excel IF IF:IF(logical_test,value_if_true,value_if_false)logical_test TRUE FALSE A1=100 A1 100 TRUE FALSE;
14、value_if_true logical_test;value_if_false logical_test IF(SUM(B1:C1):B1 C1 B1 C1 B1 C1 134.:135.B2 B5 B6:B6 B2 B5 B2 B5 B6 Enter B2 B5 B6 B2 D2 E2:(E2),C2 C5 D2 D5 E2 E5 C6 D6 E6 C6 D6 E6:B6 C6 E6 B6 C6 D6 E6 136.B2 C5 D4 E6:E6 B2 C5 D4 E6 B2 C5 D4 137.Excel 138.Excel Excel 2002:Enter 139.,140.:141.
15、SUM Excel SUM 30 SUM 50 A2 A4 A6 A8 A10 A12 A96 A98 A100 SUM(A2 A4 A6 A96 A98 A100)Excel SUM;SUM(A2 A4 A6 A96 A98 A100)SUM 142.Excel$B$1 B:F4 143.Excel:144.60 60 IF B3 C3 C3:if(b3 3 4:IF 7 一、145.Excel Office Excel Office Excel Excel 146.Excel 147.:1.Internet;2.;3.Internet(=)URL:=http:/www.J 148.Shee
16、t1 Sheet2 Sheet3 3 Sheet1 D8 40 Sheet2 B8 60 Sheet3 A8 Sheet3 A8:=Sheet1!D8 40 Sheet2!B8 60 149.Excel Excel(A Z)A Z 150.Office:Excel 151.Excel:-1 1000 152.Web Excel Web Excel Excel Web Web Excel 2002 Web Web:Web Excel Web Web Excel:Web gif 153.Excel:154.10 n 10 10 10 10 10 8 12 155.Office C1 C4 C5 D3 E11 25:25 Ctrl C1 C4 C5 D3 E11 25 156.Excel Excel Excel:Excel 157.一、158.159.Excel:Alt;160.C:Windows Application Data Microsoft Excel Excel10 xlb Excell0 xlb 161.162.Excel 2002 Excel 2002:163.Excel 1.;2.;3.