{\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;}{\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 \u23558?Excel\u29609?\u20986?\u-25896?\u31934?\u23574?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b NX26439\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/nxk/26439.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u23558?Excel\u29609?\u20986?\u-25896?\u31934?\u23574?\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\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?Excel\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u21672?\u-29726?\b0\par\pard\plain\s0\fi400\li0\ri0\sa60\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\sa60\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\f0\fs24\b \u-28670?\u29992?\u20154?\u32676?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 VlookupIFLeft/Right/MidSumifs/CountifsDatedif/Today\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31934?\u-28646?\u31934?\u-28646?\u31934?\u-28646?\u31934?\u-28646?\u29087?\u24713?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u30456?\u23545?\u24341?\u29992?(A2)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u32477?\u23545?\u24341?\u29992?($A$2)\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21019?\u24314?\u20998?\u21015?\u-28663?\u25321?\u24615?\u31896?\u-29388?\u22522?\u30784?\u22270?\u-30616?\u21019?\u24314?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31934?\u-28646?\u31934?\u-28646?\u31934?\u-28646?\u31934?\u-28646?\u31934?\u-28646?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31934?\u-28646?\u-230?\u20351?\u29992?\u24050?\u32463?\u26080?\u-26980?\u30861?\u-244?\u22522?\u26412?\u21407?\u29702?\u-29715?\u27861?\u20102?\u28982?\u20110?\u-32520?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u29087?\u24713?\u-230?\u22823?\u27010?\u20102?\u-30237?\u20351?\u29992?\u22522?\u26412?\u-29715?\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 \u31532?\u19968?\u-28440?\u20998? \u-26786?\u20989?\u25968?\u31687?\u31456?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u21512?\u24182?\u21333?\u20803?\u26684?\u19979?\u22914?\u20309?\u31561?\u-27265?\u25554?\u20837?\u-30616?\u22836?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u26465?\u20214?\u26684?\u24335?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u25968?\u25454?\u26377?\u25928?\u24615?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u20999?\u29255?\u22120?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u-29791?\u31639?\u23383?\u27573?\u31639?\u29615?\u27604?\u12289?\u21516?\u27604?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u19982?\u25968?\u25454?\u-28657?\u-30266?\u22270?\u21521?\u23548?\u-30237?\u20915?\u20849?\u32531?\u23384?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u23450?\u20301?\u26465?\u20214?\u20197?\u21450?\u23450?\u20301?\u26465?\u20214?\u30340?\u-25896?\u32423?\u29992?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u20108?\u-28440?\u20998? \u20989?\u25968?\u31687?\u31456?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u28151?\u21512?\u24341?\u29992?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.Text\u20989?\u25968?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u21033?\u29992?text\u20989?\u25968?\u24555?\u-28641?\u25235?\u21462?\u20840?\u24180?\u21608?\u20845?\u26085?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.Vlookup\u19982?Column\u32467?\u21512?\u19968?\u27425?\u24615?\u24341?\u29992?\u22810?\u21015?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.Vlookup\u30340?\u27169?\u31946?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.Hlookup\u19982?Row\u20989?\u25968?\u30340?\u-26988?\u-30644?\u25235?\u21462?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.Hlookup\u30340?\u27169?\u31946?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8.Index+Match\u30340?\u21453?\u21521?\u26080?\u-30268?\u21017?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9.Index+Match\u30340?\u21452?\u26465?\u20214?\u26597?\u-29726?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10.Index+match\u30340?\u27169?\u31946?\u21305?\u-28339?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11.\u-28613?\u-28783?\u20989?\u25968?\u30340?\u-25896?\u32423?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12.\u-28613?\u-28783?\u20989?\u25968?\u19982?IS\u31995?\u21015?\u20989?\u25968?\u30340?\u-25896?\u32423?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13.Len\u20989?\u25968?\u19982?\u25130?\u21462?\u20989?\u25968?\u30340?\u19981?\u31561?\u-27265?\u25130?\u21462?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 14.Find/search\u20989?\u25968?\u19982?\u25130?\u21462?\u20989?\u25968?\u30340?\u29305?\u24449?\u20540?\u25130?\u21462?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 15.Indirect\u20989?\u25968?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 16.\u21033?\u29992?Indirect+index+mtach\u20989?\u25968?\u30340?\u-29208?\u-30616?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 17.\u21033?\u29992?Indirect+sumifs\u20989?\u25968?\u30340?\u-29208?\u-30616?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 18.\u21033?\u29992?indirect+match+Countifs\u30340?\u-27148?\u-26988?\u25235?\u21462?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 19.Sumproduct\u20989?\u25968?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 20.Sumproduct\u8220?\u19982?\u8221?\u30340?\u20851?\u31995?\u21644?\u8220?\u25110?\u8221?\u30340?\u20851?\u31995?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u19977?\u-28440?\u20998? \u20989?\u25968?\u19982?\u20854?\u20182?\u21151?\u-32515?\u32467?\u21512?\u31687?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u26465?\u20214?\u26684?\u24335?\u19982?\u20989?\u25968?\u32467?\u21512?\u-244?\u-30237?\u20915?\u21171?\u21160?\u21512?\u21516?\u-32278?\u21160?\u21040?\u26399?\u25552?\u-28270?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u26465?\u20214?\u26684?\u24335?\u19982?\u20989?\u25968?\u32467?\u21512?\u-244?\u-30237?\u20915?\u28385?\u-29261?\u25317?\u26377?\u27604?\u23545?\u25968?\u25454?\u21464?\u-32142?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u25968?\u25454?\u26377?\u25928?\u24615?\u19982?\u20989?\u25968?\u32467?\u21512?\u-244?\u-30237?\u20915?\u20108?\u32423?\u24207?\u21015?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u25968?\u25454?\u26377?\u25928?\u24615?\u19982?\u20989?\u25968?\u32467?\u21512?\u-244?\u-27086?\u27490?\u24405?\u20837?\u-28211?\u22797?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u25968?\u25454?\u26377?\u25928?\u24615?\u19982?\u20989?\u25968?\u32467?\u21512?\u-244?\u20570?\u21160?\u24577?\u22270?\u-30616?\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 \u20010?\u20154?\u-32564?\u26223?---\u24182?\u19981?\u26159?\u27599?\u20301?\u-32767?\u24072?\u-28419?\u21483?\u22823?\u24072?\u32423?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 OFFICE\u22823?\u24072?\u32423?(Master)\u26159?\u30001?\u24494?\u-28817?\u-26495?\u21457?\u30340?Office\u31995?\u26368?\u-25896?\u32423?\u21035?\u-29759?\u20070?\u-244?\u24517?\u-26501?\u-28646?\u-28729?3\u-27160?\u19987?\u23478?\u32423?\u-248?Expert\u-247?\u20197?\u21450?1\u-27160?\u19987?\u19994?\u32423?\u-248?Professional\u-247?\u-32765?\u-29739?\u-244?\u-26946?\u24230?\u21487?\u24819?\u-32756?\u30693?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u23601?\u-32692?\u20110?\u25705?\u25176?\u32599?\u25289?\u-244?\u25628?\u29392?\u-244?\u19990?\u30028?\u-27402?\u-30644?\u31561?\u30693?\u21517?\u20225?\u19994?\u-244?\u23545?\u25253?\u-30616?\u-30268?\u-31997?\u-244?\u25968?\u25454?\u20915?\u31574?\u19982?\u20998?\u26512?\u-244?PPT\u-28688?\u-32692?\u27719?\u25253?\u19982?\u23637?\u31034?\u-28419?\u26377?\u28145?\u20837?\u20102?\u-30237?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u29616?\u-32680?\u-29705?\u20026? \u25628?\u29392?\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u-26498?\u-27154?\u-244?\u-29409?\u-29405?\u-30237?\u20915?\u-29406?\u21153?\u26041?\u21521?\u30340?\u25968?\u25454?\u-27154?\u-26472?\u-229?\u19990?\u30028?\u-27402?\u-30644?OFFICE\u26041?\u21521?\u19987?\u23478?\u-26498?\u-27154?\u-244?\u-30237?\u20915?\u30456?\u20851?\u-26490?\u22495?\u25152?\u26377?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u-29762?\u-29791?\u30340?\u29702?\u24565?---\u19981?\u20877?\u26159?\u31616?\u31616?\u21333?\u21333?\u30340?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u32463?\u-28729?\u22810?\u24180?\u25945?\u23398?\u32463?\u-25972?\u-244?\u21457?\u29616?\u23398?\u29983?\u32570?\u20047?\u30340?\u19981?\u26159?\u23545?\u21151?\u-32515?\u30340?\u20102?\u-30237?\u-244?\u22240?\u20026?\u20960?\u20046?\u25152?\u26377?\u30340?\u21151?\u-32515?\u-28419?\u21487?\u20197?\u-28646?\u-28729?\u20070?\u31821?\u25110?\u-32763?\u25628?\u32034?\u24341?\u25806?\u25214?\u21040?\u12290?\u23398?\u29983?\u32570?\u20047?\u30340?\u26159?\u21151?\u-32515?\u30340?\u28145?\u24230?\u29702?\u-30237?\u21644?\u32508?\u21512?\u-28720?\u29992?\u12290?\u22240?\u27492?\u-29698?\u31243?\u-29762?\u-29791?\u30340?\u26041?\u21521?\u26159?\u20197?\u26696?\u20363?\u20026?\u20027?\u-244?\u19981?\u20877?\u31616?\u31616?\u21333?\u21333?\u30340?\u26159?\u26576?\u20010?\u21151?\u-32515?\u-244?\u24182?\u19988?\u26696?\u20363?\u20840?\u-28440?\u26469?\u-32278?\u24037?\u20316?\u24403?\u20013?\u-244?\u-28711?\u26679?\u23398?\u29983?\u23398?\u20064?\u21518?\u21487?\u20197?\u31435?\u21051?\u-28712?\u21407?\u21040?\u24037?\u20316?\u24773?\u22659?\u20013?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u8220?\u25480?\u20043?\u20197?\u-25476?\u19981?\u22914?\u25480?\u20043?\u20197?\u28180?\u8221?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25945?\u23398?\u-29762?\u-29791?\u30340?\u29702?\u24565?---\u28608?\u21457?\u23398?\u29983?\u30340?\u-32278?\u25105?\u23398?\u20064?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22521?\u-29779?\u30340?\u26102?\u-27148?\u26159?\u26377?\u-27056?\u30340?\u-244?\u19981?\u21487?\u-32515?\u22312?\u19968?\u27425?\u30340?\u-29698?\u31243?\u24403?\u20013?\u25945?\u23436?\u25152?\u26377?\u30340?\u30693?\u-29754?\u28857?\u-244?\u-28509?\u20040?\u23398?\u29983?\u24456?\u21487?\u-32515?\u21482?\u23398?\u20250?\u-29698?\u19978?\u30340?\u30693?\u-29754?\u-244?\u-32756?\u20854?\u20313?\u-28712?\u26159?\u19981?\u20250?\u12290?\u22240?\u27492?\u-28217?\u29992?\u30340?\u26159?\u24341?\u23548?\u30340?\u25945?\u23398?\u26041?\u24335?\u-230?\u20063?\u23601?\u26159?\u25105?\u21482?\u25945?\u31532?\u19968?\u27493?\u-244?\u30001?\u23398?\u29983?\u23436?\u25104?\u31532?\u20108?\u-32269?\u31532?\u19977?\u27493?\u12290?\u24182?\u-29783?\u23398?\u29983?\u-32278?\u24049?\u21435?\u21457?\u29616?\u-27154?\u-26472?\u-244?\u-30237?\u20915?\u-27154?\u-26472?\u12290?\u-28711?\u26679?\u-29776?\u24471?\u29282?\u-244?\u-32756?\u19988?\u30001?\u23398?\u29983?\u-32278?\u24049?\u21457?\u29616?\u-27154?\u-26472?\u-244?\u-30237?\u20915?\u-27154?\u-26472?\u20250?\u-29783?\u23398?\u29983?\u26356?\u26377?\u20449?\u24515?\u-244?\u28608?\u21457?\u23398?\u29983?\u30340?\u25361?\u25112?\u27442?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u21518?\u-28675?\u-29142?\u30340?\u29702?\u24565?---\u26368?\u23567?\u30340?\u20184?\u20986?\u26368?\u22823?\u30340?\u25552?\u21319?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20026?\u20102?\u-29783?\u23398?\u29983?\u26356?\u22909?\u30340?\u22797?\u20064?\u21644?\u25104?\u-27265?\u-244?\u-29698?\u21518?\u21487?\u20197?\u-28646?\u-28729?\u-32767?\u24072?\u30340?\u20070?\u31821?\u12289?\u-30266?\u-26479?\u12289?\u24494?\u20449?\u20844?\u20247?\u20197?\u21450?\u23398?\u20064?\u26696?\u20363?\u-244?\u22235?\u32467?\u21512?\u30340?\u26041?\u24335?\u-28709?\u-30644?\u20877?\u28436?\u32451?\u-244?\u-30237?\u20915?\u-29698?\u21518?\u-28585?\u24536?\u30340?\u-27154?\u-26472?\u-244?\u24182?\u-31817?\u24471?\u26356?\u22810?\u30340?\u30693?\u-29754?\u20197?\u21450?\u26368?\u22823?\u30340?\u25552?\u21319?\u12290?\u24182?\u21487?\u21033?\u29992?\u20844?\u20247?\u-29402?\u21495?\u-244?\u19982?\u-32767?\u24072?\u30452?\u25509?\u20132?\u27969?\u-244?\u-30237?\u20915?\u26085?\u21518?\u20986?\u29616?Office\u-27154?\u-26472?\u-244?\u26080?\u20154?\u21487?\u25214?\u30340?\u23604?\u23596?\u23616?\u-26782?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u21672?\u-29726?\b0\par\pard\plain\s0\fi400\li0\ri0\sa60\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\sa60\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par}