{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Arial;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;\red0\green0\blue255;\red128\green128\blue128;}{\stylesheet {\style\s0 \ql\fi0\li0\ri0\f1\fs24\cf0 Normal;}{\style\s3 \ql\fi0\li0\ri0\f1\fs26\b\cf0 heading 3;}{\style\s2 \ql\fi0\li0\ri0\f1\fs28\b\i\cf0 heading 2;}{\style\s1 \ql\fi0\li0\ri0\f1\fs32\b\cf0 heading 1;}}{\*\listtable}{\*\listoverridetable}{\*\generator iText 2.1.5 (by lowagie.com)}{\info}\paperw11907\paperh16840\margl720\margr720\margt720\margb720{\footer \pard\plain\s0\qc\fi0\li0\ri0\sl320\plain\f0\fs18 \u31532?\f0{\field{\*\fldinst PAGE}{\fldrslt  }}\f0\fs18 \u-26507?\par}{\header \pard\plain\s0\qr\fi0\li0\ri0\sl320\plain\f0\fs18 \u21517?\u24072?\u-29774?\u25480?\u183?\u20248?\u-29400?\u-29698?\u31243?\u8212?\u8212?\u21517?\u-29698?\u22530?\par}\pgwsxn11907\pghsxn16840\marglsxn720\margrsxn720\margtsxn720\margbsxn720\pard\plain\s0\qc\fi0\li0\ri0\sa140\plain\f0\fs36\b Excel\u25968?\u25454?\u22788?\u29702?\u22312?\u-29406?\u21153?\u20013?\u30340?\u24212?\u29992?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT051116\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u21517?\u31216?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/051116.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 Excel\u25968?\u25454?\u22788?\u29702?\u22312?\u-29406?\u21153?\u20013?\u30340?\u24212?\u29992?\ul0 }}\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u25152?\u23646?\u31867?\u21035?\u12305?\u-230?\u-32692?\u19994?\u25216?\u-32515?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u24320?\u-29698?\u26102?\u-27148?\u12305?\u-230?2025\u24180?08\u26376?01\u26085? \u21040? 2025\u24180?08\u26376?02\u26085? \u26477?\u24030? 3800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?12\u26376?20\u26085? \u21040? 2024\u24180?12\u26376?21\u26085? \u26477?\u24030? 3800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?08\u26376?16\u26085? \u21040? 2024\u24180?08\u26376?17\u26085? \u26477?\u24030? 3800\u20803?/\u20301?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u-29708?\u26126?\u12305?\u-230?\u26412?\u22521?\u-29779?\u-29698?\u31243?\u20840?\u24180?\u24490?\u29615?\u24320?\u-29698?\u-244?\u22914?\u26377?\u-26880?\u27714?\u-244?\u27426?\u-28722?\u26469?\u30005?\u21672?\u-29726?\u-255?\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u20854?\u20182?\u24320?\u-29698?\u22478?\u24066?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/051116.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u26477?\u24030?\ul0 }}\f0\fs22  \par\pard\plain\s0\fi0\li0\ri0\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?Excel\u25968?\u25454?\u22788?\u29702?\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u25910?\u30410?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25484?\u25569?\u25968?\u25454?\u23548?\u20837?\u31867?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u25484?\u25569?\u25968?\u25454?\u27719?\u24635?\u31867?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u25484?\u25569?\u21028?\u26029?\u31867?\u20989?\u25968?\u30340?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u25484?\u25569?\u25968?\u25454?\u20998?\u26512?\u30340?\u20351?\u29992?\u26041?\u27861?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u22823?\u32434?\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19968?\u12289?\u25968?\u25454?\u23548?\u20837?\u31867?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.Vlookup\u20989?\u25968?\u30340?\u-32268?\u21629?\u32570?\u-27017?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u22312?vlookup\u24773?\u20917?\u19979?\u-244?\u22914?\u20309?\u-30237?\u20915?\u22810?\u23545?\u22810?\u30340?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u22914?\u20309?\u20351?\u29992?\u-28646?\u-28339?\u31526?\u-30237?\u20915?\u23545?\u-29402?\u30340?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u-29208?\u-30616?\u24341?\u29992?\u30340?\u24120?\u-30271?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u21033?\u29992?Index+Match\u-30237?\u20915?\u26080?\u24207?\u22810?\u21015?\u21453?\u21521?\u27719?\u24635?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u21033?\u29992?index+Match\u-30237?\u20915?\u22810?\u32500?\u25968?\u25454?\u20043?\u-27148?\u30340?\u20114?\u30456?\u23548?\u20837?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.Match\u20989?\u25968?\u19982?\u-28646?\u-28339?\u31526?\u30340?\u20351?\u29992?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20108?\u12289?\u25968?\u25454?\u27719?\u24635?\u31867?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.Sum ifs\u30340?\u20351?\u29992?\u19982?\u24120?\u-30271?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.Sumifs\u30340?\u-28646?\u-28339?\u31526?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.countifs\u30340?\u20351?\u29992?\u19982?\u24120?\u-30271?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.Averageifs\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.sumproduct\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.Sumproduct\u19982?sumifs\u12289?countifs\u30340?\u21306?\u21035?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.Sumproduct\u19982?index\u12289?match\u30340?\u20114?\u25442?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.Sumproduct\u22312?\u22810?\u32500?\u-30616?\u20013?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19977?\u12289?\u26465?\u20214?\u21028?\u26029?\u31867?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.And\u12289?OR\u12289?Not\u20989?\u25968?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.IF\u20989?\u25968?\u30340?\u23884?\u22871?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.IF\u20989?\u25968?\u19982?Countifs\u23884?\u22871?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.IF\u20989?\u25968?\u19982?Vlookup\u12289?Text\u20989?\u25968?\u23884?\u22871?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u22235?\u12289?\u25991?\u26412?\u22788?\u29702?\u31867?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.Text\u20989?\u25968?\u22312?\u25991?\u26412?\u22788?\u29702?\u31867?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20116?\u12289?\u25968?\u25454?\u20998?\u26512?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1)\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u22522?\u30784?\u-248?\u25490?\u29256?\u20197?\u21450?\u22235?\u31181?\u24120?\u-30271?\u-27154?\u-26472?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2)\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u25968?\u25454?\u24314?\u27169?\u-248?\u20221?\u-26467?\u30334?\u20998?\u27604?\u-244?\u27719?\u24635?\u-26503?\u-244?\u24179?\u22343?\u20540?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3)\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20570?\u25968?\u25454?\u20998?\u27573?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4)\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u24314?\u31435?\u-31142?\u25311?\u22823?\u21306?\u21644?\u25968?\u25454?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5)\u22914?\u20309?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u22270?\u20570?\u21160?\u24577?\u22270?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6)\u27809?\u26377?\u30340?\u23383?\u27573?\u22914?\u20309?\u22312?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-28212?\u22686?\u21152?\u23383?\u27573?\u-244?\u20363?\u22914?\u29615?\u27604?\u21644?\u21516?\u27604?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7)\u22914?\u20309?\u-30237?\u20915?\u25968?\u-28657?\u20849?\u32531?\u23384?\u30340?\u-32268?\u21629?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8)\u21033?\u29992?\u20989?\u25968?\u-244?\u-30237?\u20915?\u25968?\u-28657?\u-28211?\u22797?\u25216?\u26415?\u30340?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20845?\u12289?\u25968?\u25454?\u22522?\u30784?\u21151?\u-32515?\u20197?\u21450?\u32508?\u21512?\u24212?\u29992?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25968?\u25454?\u24405?\u20837?\u26102?\u20505?\u30340?\u-30268?\u-31997?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u21033?\u29992?\u20998?\u21015?\u-28709?\u-30644?\u25968?\u25454?\u28165?\u27927?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u-28663?\u25321?\u24615?\u31896?\u-29388?\u30340?\u20116?\u22823?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u20998?\u21015?\u21644?\u-28663?\u25321?\u24615?\u31896?\u-29388?\u30340?\u32508?\u21512?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u20026?\u20160?\u20040?\u25105?\u30340?\u-30616?\u26684?\u19968?\u25171?\u24320?\u23601?\u26159?\u26085?\u26399?\u26684?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u21033?\u29992?\u25968?\u25454?\u26377?\u25928?\u24615?\u19982?sumproduct\u20570?\u21160?\u24577?\u22270?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u21033?\u29992?\u25968?\u25454?\u26377?\u25928?\u24615?\u19982?index\u12289?match\u20570?\u21160?\u24577?\u22270?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29323?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Microsoft\u-29372?\u28145?\u25480?\u26435?\u22521?\u-29779?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u-29372?\u21382?\u-32564?\u26223?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.Office\u22823?\u24072?\u32423?\u-29788?\u-29759?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u24494?\u-28817?\u21150?\u20844?\u-28817?\u20214?\u22269?\u-27067?\u-29788?\u-29759?\u30693?\u-29754?\u19987?\u23478?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.2012-16\u24180?\u26368?\u20339? Excel\u24212?\u29992?\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.2014-16\u24180?\u20840?\u22269?\u30334?\u24378?\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u25628?\u29392?\u12298?\u-32692?\u22330?\u19968?\u-30208?\u22530?\u12299?\u29305?\u-32680?\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u25628?\u29392?\u-26938?\u22242?\u25968?\u25454?\u20998?\u26512?\u-26498?\u-27154?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u19990?\u30028?\u-27402?\u-30644?OFFICE\u26041?\u21521?\u19987?\u23478?\u-26498?\u-27154?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.\u21271?\u20140?\u-32692?\u24037?\u25945?\u-32590?\u21327?\u20250?\u22996?\u21592?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u25480?\u-29698?\u-26418?\u26684?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25480?\u-29698?\u28145?\u20837?\u27973?\u20986?\u12289?\u26696?\u20363?\u20016?\u23500?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u-29715?\u-30208?\u29983?\u21160?\u12289?\u28608?\u24773?\u12289?\u24189?\u-24872?\u-244?\u26377?\u24863?\u26579?\u21147?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u-29698?\u22530?\u27668?\u27675?\u27963?\u-29245?\u-244?\u-28670?\u21512?\u23398?\u21592?\u30340?\u23398?\u20064?\u19982?\u30693?\u-29754?\u30340?\u21560?\u25910?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u25480?\u-29698?\u32463?\u-25972?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20013?\u25237?\u-244?\u19990?\u30028?\u-27402?\u-30644?\u-244?\u20013?\u-30644?\u-244?\u20892?\u-30644?\u-244?\u20013?\u20449?\u-244?\u19978?\u28023?\u20892?\u21830?\u-27402?\u-30644?\u-244?\u27743?\u-30337?\u-27402?\u-30644?\u-244?\u22269?\u20449?\u-29759?\u21048?\u-244?\u28006?\u21457?\u-244?\u26477?\u24030?\u-27402?\u-30644?\u-244?\u27993?\u21830?\u-27402?\u-30644?\u-244?\u24191?\u21457?\u-244?\u20013?\u22269?\u20449?\u20445?\u-244?\u22826?\u24179?\u27915?\u20445?\u-27031?\u-244?\u27665?\u29983?\u-244?\u24179?\u23433?\u-244?\u28044?\u-27417?\u25237?\u-29372?\u-244?\u32654?\u26725?\u25237?\u-29372?\u-244?\u-29406?\u-28646?\u-29759?\u21048?\u-244?\u21271?\u20140?\u32463?\u27982?\u25216?\u26415?\u25237?\u-29372?\u24320?\u21457?\u-244?\u30334?\u24230?\u-244?\u20013?\u-32214?\u20449?\u-244?\u29483?\u30524?\u-244?\u28165?\u21326?\u21516?\u26041?\u-244?\u24403?\u24403?\u-244?\u28023?\u-28791?\u-244?\u24555?\u-27471?\u25903?\u20184?\u-244?\u22825?\u-25027?\u-244?\u-24922?\u-32765?\u26519?\u-244?\u24247?\u21513?\u26862?\u-244?\u-24752?\u-32678?\u31185?\u25216?\u-244?\u-26000?\u27874?\u20449?\u24687?\u-244?\u21644?\u21033?\u26102?\u-244?\u21326?\u26222?\u-244?\u26032?\u19996?\u26041?\u22312?\u32447?\u31561?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par}