{\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 \u24039?\u29992?Excel\u23454?\u29616?\u-25896?\u25928?\u-29406?\u21153?\u20998?\u26512?\u19982?\u26085?\u24120?\u31649?\u29702?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT036822\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/gkk5/036822.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u24039?\u29992?Excel\u23454?\u29616?\u-25896?\u25928?\u-29406?\u21153?\u20998?\u26512?\u19982?\u26085?\u24120?\u31649?\u29702?\ul0 }}\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u25152?\u23646?\u31867?\u21035?\u12305?\u-230?\u-29406?\u21153?\u31649?\u29702?\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?07\u26376?16\u26085? \u21040? 2025\u24180?07\u26376?16\u26085? \u19978?\u28023? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?08\u26376?29\u26085? \u21040? 2024\u24180?08\u26376?29\u26085? \u21271?\u20140? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?07\u26376?31\u26085? \u21040? 2024\u24180?07\u26376?31\u26085? \u19978?\u28023? 2800\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/gkk5/036825.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u21271?\u20140?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk5/036822.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u19978?\u28023?\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?\u-29406?\u21153?\u20998?\u26512?\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\f0\fs24\b \u-29698?\u31243?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21517?\u-29698?\u22530?\u-29693?\u30740?\u26174?\u31034?\u-244?70%\u30340?\u20225?\u19994?\u-29406?\u21153?\u20154?\u21592?\u-244?\u20351?\u29992?Excel\u-28709?\u-30644?\u24037?\u20316?\u30340?\u21344?\u27604?\u22312?60%\u20197?\u19978?\u-244?\u27599?\u21608?\u29978?\u-32269?\u27599?\u22825?\u-28419?\u-26880?\u-30335?\u23545?\u22823?\u-28209?\u25968?\u25454?\u-28709?\u-30644?\u25490?\u24207?\u12289?\u27719?\u24635?\u12289?\u-29791?\u31639?\u12289?\u20998?\u26512?\u12289?\u21046?\u20316?\u22270?\u-30616?\u12290?\u20316?\u20026?\u19968?\u20010?\u20248?\u31168?\u30340?\u-29406?\u21153?\u31649?\u29702?\u20449?\u24687?\u21270?\u24179?\u21488?\u-244?Excel\u24378?\u22823?\u30340?\u25968?\u25454?\u22788?\u29702?\u21151?\u-32515?\u27595?\u24248?\u32622?\u30097?\u-244?\u-28509?\u20040?\u-244?\u24744?\u26159?\u21542?\u22256?\u24785?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u22914?\u20309?\u-25896?\u25928?\u20351?\u29992?Excel\u26469?\u25552?\u-25896?\u25968?\u25454?\u22788?\u29702?\u21644?\u20998?\u26512?\u30340?\u25928?\u29575?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u23398?\u20064?\u20102?\u19968?\u20123?Excel\u25216?\u24039?\u-244?\u20294?\u23454?\u-27067?\u24212?\u29992?\u20013?\u20173?\u24863?\u21040?\u22256?\u-26946?\u-28211?\u-28211?\u-244?\u22914?\u20309?\u24212?\u29992?\u21040?\u24037?\u20316?\u20013?\u21435?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u22914?\u20309?\u-29783?\u20998?\u26512?\u25253?\u21578?\u26356?\u26377?\u-29708?\u26381?\u21147?\u12289?\u-32767?\u26495?\u26356?\u28385?\u24847?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u27425?\u-29698?\u31243?\u20174?\u-29406?\u21153?\u31649?\u29702?\u30340?\u-25896?\u24230?\u20837?\u25163?\u-244?\u20197?\u32456?\u20026?\u22987?\u-244?\u23618?\u23618?\u20998?\u-30237?\u-244?\u24110?\u24744?\u25484?\u25569?\u-29406?\u21153?\u24037?\u20316?\u20013?\u30340?Excel\u-28720?\u29992?\u25216?\u-32515?\u-244?\u23454?\u29616?\u-25896?\u-29400?\u-28209?\u12289?\u-25896?\u25928?\u29575?\u12289?\u-29783?\u-32767?\u26495?\u28385?\u24847?\u30340?\u-29406?\u21153?\u20998?\u26512?\u12290?\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 \u-28646?\u-28729?\u26412?\u27425?\u-29698?\u31243?\u-244?\u24744?\u23558?\u-31817?\u24471?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22810?\u20010?\u-29406?\u21153?\u20998?\u26512?\u27169?\u26495?\u21450?\u25968?\u25454?\u27169?\u22411?\u-244?\u21270?\u32321?\u20026?\u31616?\u25552?\u-25896?\u24037?\u20316?\u25928?\u29575?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 20\u24180?+\u26631?\u26438?\u20225?\u19994?\u23454?\u-29195?\u32463?\u-25972?\u20998?\u20139?\u-244?\u20102?\u-30237?\u-32767?\u26495?\u24819?\u-30335?\u30340?\u-29406?\u21153?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25484?\u25569?\u25968?\u25454?\u27169?\u22411?\u30340?\u24314?\u31435?\u-28613?\u-28783?\u-244?\u23398?\u20064?\u24314?\u27169?\u24605?\u-29201?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u27969?\u31243?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 08:30 \u20837?\u22330?\u21450?\u31614?\u21040?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 09:00 \u-29698?\u31243?\u24320?\u22987?\u-244?\u20027?\u25345?\u20154?\u-32268?\u-28770?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Part 1 \u-28729?\u20851?\u26025?\u23558?\u8544?\u-230?\u-29406?\u21153?\u20154?\u21592?\u-26880?\u-30335?\u25484?\u25569?\u30340?Excel\u25216?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u-29406?\u21153?\u20154?\u21592?\u26085?\u24120?\u-26880?\u-30335?\u20351?\u29992?\u30340?\u22522?\u26412?\u25216?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u-29762?\u-29791?\u22909?\u26631?\u20934?\u-30268?\u-31997?\u30340?\u22522?\u30784?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Part 2 \u-28729?\u20851?\u26025?\u23558?\u8545?\u-230?\u-29406?\u21153?\u20154?\u21592?\u-26880?\u-30335?\u25484?\u25569?\u30340?\u20989?\u25968?\u25216?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u-29406?\u21153?\u20154?\u21592?\u32463?\u24120?\u20351?\u29992?\u30340?5\u20010?\u-29791?\u31639?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26465?\u20214?\u21028?\u26029?\u12289?\u25991?\u26412?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - COUNTIF\\SUMIF\\Sumproduct\\Vlookup\\Hlookup\\Index\\offset\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Part 3 \u25968?\u25454?\u32452?\u-30523?\u-230?\u-28720?\u29992?Excel\u25216?\u-32515?\u20570?\u20986?\u-32767?\u26495?\u24819?\u30475?\u30340?\u-29406?\u21153?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u25104?\u26412?\u20998?\u26512?\u-230?\u20351?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u24555?\u-28641?\u30340?\u20570?\u25104?\u26412?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u-27392?\u21806?\u20998?\u26512?\u-230?\u26681?\u25454?\u19981?\u21516?\u-30335?\u27714?\u-28709?\u-30644?\u-27392?\u21806?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u21033?\u28070?\u20998?\u26512?\u-230?\u25353?\u29031?\u19981?\u21516?\u24615?\u-29400?\u12289?\u19981?\u21516?\u21306?\u22495?\u-28709?\u-30644?\u21033?\u28070?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26085?\u26399?\u20998?\u26512?\u-230?\u23558?\u21407?\u22987?\u30340?\u26085?\u26399?\u25490?\u21015?\u30340?\u-28709?\u-30644?\u26376?\u24230?\u12289?\u23395?\u24230?\u12289?\u24180?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u22810?\u-28211?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-230?\u23398?\u20064?\u22810?\u-28211?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u26680?\u23545?\u31038?\u20445?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u-30616?\u21333?\u25511?\u20214?\u-230?\u-29406?\u21153?\u27169?\u22411?\u24517?\u-26501?\u25484?\u25569?\u30340?\u25511?\u20214?\u24037?\u20855?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u21160?\u24577?\u25253?\u-30616?\u-230?\u-29406?\u21153?\u20998?\u26512?\u24517?\u-26501?\u25484?\u25569?\u30340?\u21160?\u24577?\u25253?\u-30616?\u21046?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u23450?\u20041?\u21517?\u31216?\u-230?\u-29406?\u21153?\u27169?\u22411?\u24517?\u-26501?\u20351?\u29992?\u30340?\u22522?\u26412?\u25805?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12:00 \u21320?\u-26352?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13:10 \u-29698?\u31243?\u24320?\u22987?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Part 4 \u27169?\u26495?\u21046?\u20316?\u-230?\u-28720?\u29992?Excel\u25216?\u-32515?\u23454?\u29616?\u-25896?\u25928?\u-29406?\u21153?\u31649?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26696?\u20363?1\u-230?\u22914?\u20309?\u32452?\u24314?\u19968?\u20010?\u-28440?\u-27160?\u28165?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26696?\u20363?2\u-230?\u22810?\u31181?\u-30616?\u26684?\u26680?\u23545?\u26041?\u26696?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - 7\u31181?\u19981?\u21516?\u30340?\u26041?\u27861?\u-28709?\u-30644?\u24046?\u24322?\u25968?\u25454?\u26680?\u23545?\u-248?Vlookup\u26041?\u27861?\u-27036?\u22806?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26696?\u20363?3\u-230?\u22810?\u-28211?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u24555?\u-28641?\u26680?\u23545?\u31038?\u20445?\u24046?\u24322?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u26696?\u20363?4\u-230?\u24212?\u25910?\u-29402?\u27454?\u-29402?\u-24700?\u20998?\u26512?\u27169?\u26495?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 - \u22914?\u20309?\u32534?\u21046?\u21160?\u24577?\u25240?\u26087?\u-30616?\u-225?\u-248?\u-28670?\u21512?\u20110?\u-26492?\u31639?\u32534?\u21046?\u21644?\u-29406?\u21153?\u26376?\u24230?\u-26492?\u27979?\u20351?\u29992?\u30340?\u-29406?\u21153?\u27169?\u22411?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 17:00 \u-29698?\u31243?\u32467?\u26463?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-30591?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-30591?\u-32767?\u24072?\u26159?\u-29406?\u21153?\u31649?\u29702?\u21672?\u-29726?\u-29372?\u28145?\u-29774?\u24072?\u-244?\u19978?\u28023?\u-29406?\u22823?\u-25896?\u32423?\u22269?\u-27067?\u-29406?\u21153?\u31649?\u29702?\u24072?\u-244?\u20013?\u23567?\u20225?\u19994?\u21697?\u29260?\u20419?\u-28709?\u20013?\u24515?\u8212?\u8212?\u20250?\u-29791?\u22312?\u32447?\u-29409?\u-29405?\u20154?\u-244?\u22810?\u24180?\u25285?\u20219?\u22806?\u20225?\u-29406?\u21153?\u24635?\u30417?\u-244?\u20027?\u-30335?\u30740?\u31350?\u26041?\u21521?\u26377?\u20225?\u19994?\u-29406?\u21153?\u31649?\u29702?\u12289? \u-29406?\u21153?\u25104?\u26412?\u25511?\u21046?\u31561?\u12290?\u22312?\u25945?\u23398?\u20013?\u-244?\u21892?\u20110?\u26681?\u25454?\u20225?\u19994?\u-26880?\u27714?\u-244?\u-28720?\u29992?\u20016?\u23500?\u30340?\u23454?\u-29195?\u24037?\u20316?\u32463?\u-25972?\u-244?\u29702?\u-29766?\u32467?\u21512?\u23454?\u-27067?\u-244?\u-29388?\u-28719?\u23398?\u21592?\u-26880?\u27714?\u-244?\u20197?\u26377?\u25928?\u24555?\u-28641?\u25552?\u21319?\u20844?\u21496?\u-29406?\u21153?\u31649?\u29702?\u20026?\u21407?\u21017?\u-244?\u-28720?\u29992?\u22810?\u31181?\u22269?\u20869?\u22806?\u20808?\u-28709?\u30340?\u25945?\u23398?\u24037?\u20855?\u21644?\u26041?\u27861?\u-244?\u23507?\u25945?\u20110?\u20048?\u-244?\u-29783?\u23398?\u21592?\u22312?\u23398?\u20064?\u21518?\u-32515?\u26377?\u25928?\u-28720?\u29992?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25797?\u-27265?\u-29731?\u-26472?\u-230?\u-29406?\u21153?\u32463?\u29702?\u20154?\u30340?\u23450?\u20301?\u12289?\u20840?\u-26782?\u-26492?\u31639?\u31649?\u29702?\u19982?\u25511?\u21046?\u12289?\u20869?\u-28440?\u25511?\u21046?\u21644?\u20225?\u19994?\u-26418?\u-27031?\u31649?\u29702?\u12289?EXCEL\u22312?\u-29406?\u21153?\u31649?\u29702?\u20013?\u30340?\u24212?\u29992?\u12289?EXCEL\u-29406?\u21153?\u27169?\u22411?\u12289?\u20379?\u24212?\u-27394?\u25104?\u26412?\u31649?\u29702?\u31561?\u12290?\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}