{\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\u-25896?\u25928?\u25968?\u25454?\u20998?\u26512?\u20043?\u-28589?\u-29779?\u32451?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT009181\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/gkk/009181.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 Excel\u-25896?\u25928?\u25968?\u25454?\u20998?\u26512?\u20043?\u-28589?\u-29779?\u32451?\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?\f0\fs22\cf3 2021\u24180?12\u26376?31\u26085? \u21040? 2022\u24180?01\u26376?01\u26085? \u19978?\u28023? 5160\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2020\u24180?12\u26376?11\u26085? \u21040? 2020\u24180?12\u26376?12\u26085? \u19978?\u28023? 5160\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/gkk/009181.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?\u25968?\u25454?\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?\u20869?\u23481?\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19968?\u12289?Excel\u-30616?\u26684?\u30340?\u26631?\u20934?\u21270?\u-30268?\u-31997?\u21270?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u20026?\u20160?\u20040?\u-30335?\u20570?\u26631?\u20934?\u21270?\u19982?\u-30268?\u-31997?\u21270?\u24037?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?Excel\u-30616?\u26684?\u23481?\u26131?\u20986?\u29616?\u30340?\u-27367?\u-29713?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u24555?\u-28641?\u20462?\u25913?\u-26786?\u27861?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u27491?\u30830?\u22788?\u29702?\u26085?\u26399?\u21644?\u26102?\u-27148?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u20462?\u25913?\u-26786?\u27861?\u26085?\u26399?\u21644?\u-26786?\u27861?\u26102?\u-27148?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24120?\u29992?\u26085?\u26399?\u20989?\u25968?\u21450?\u20854?\u23454?\u-27067?\u24212?\u29992?\u-230?TODAY\u12289?EDATE\u12289?EOMONTH\u12289?DATEDIF\u12289?WEEKDAY\u31561?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29791?\u31639?\u21512?\u21516?\u21040?\u26399?\u26085?\u12289?\u-29791?\u31639?\u21512?\u21516?\u-28610?\u26399?\u22825?\u25968?\u12289?\u-29791?\u31639?\u24180?\u-24700?\u21644?\u24037?\u-24700?\u12289?\u-29791?\u31639?\u25240?\u26087?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29791?\u31639?\u-29385?\u27454?\u26399?\u-27056?\u12289?\u24555?\u-28641?\u-28820?\u25442?\u25991?\u26412?\u22411?\u25968?\u23383?\u12289?\u-29783?\u25991?\u26412?\u22411?\u25968?\u23383?\u-32515?\u22815?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31616?\u20415?\u23454?\u29992?\u30340?\u-28820?\u25442?\u26041?\u27861?\u12289?\u32479?\u19968?\u25968?\u25454?\u26684?\u24335?\u12289?\u23454?\u29992?\u30340?TEXT\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u20998?\u21015?\u25968?\u25454?\u-230?\u20351?\u29992?\u8220?\u20998?\u21015?\u8221?\u24037?\u20855?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20351?\u29992?\u25991?\u26412?\u20989?\u25968?\u-230?LENb\u12289?LEN\u12289?LEFT\u12289?RIGHT\u12289?MID\u12289?FIND\u31561?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u22635?\u20805?\u25968?\u25454?F5\u-27346?\u30340?\u24378?\u22823?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u22635?\u20805?\u30456?\u21516?\u25968?\u25454?\u12289?\u24555?\u-28641?\u25209?\u-28209?\u-28781?\u20837?\u20844?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20174?\u31995?\u32479?\u23548?\u20837?\u25968?\u25454?\u30340?\u23436?\u25972?\u24615?\u25972?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20854?\u20182?\u25968?\u25454?\u25972?\u29702?\u25216?\u24039?\u12289?\u24555?\u-28641?\u21024?\u-27036?/\u25554?\u20837?\u22823?\u-28209?\u31354?\u-30644?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u21024?\u-27036?\u24037?\u20316?\u-30616?\u20013?\u30340?\u22403?\u22334?\u25968?\u25454?\u21644?\u23545?\u-29599?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20108?\u12289?\u24555?\u-28641?\u25484?\u25569?Excel\u20844?\u24335?\u21644?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u22797?\u26434?\u24773?\u20917?\u19979?\u-28613?\u-28783?\u21028?\u26029?\u21450?\u20854?\u31616?\u21270?\u22788?\u29702?\u-248?\u23454?\u29992?\u30340?4\u20010?\u-28613?\u-28783?\u21028?\u26029?\u20989?\u25968?\u-230?IF\u12289?AND\u12289?OR\u12289?ISERROR\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u23558?\u32321?\u29712?\u30340?\u21152?\u20943?\u20844?\u24335?\u21464?\u24471?\u26356?\u20026?\u31616?\u27905?\u21644?\u-25896?\u25928?\u-248?\u23454?\u29992?\u30340?3\u20010?\u27714?\u21644?\u27719?\u24635?\u20989?\u25968?\u-230?SUM\u12289?SUMIF\u12289?SUMPRODUCT\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u24555?\u-28641?\u-25896?\u25928?\u24341?\u29992?\u25968?\u25454?\u-248?\u23454?\u29992?\u30340?4\u20010?\u26597?\u25214?\u20989?\u25968?\u-230?VLOOKUP\u12289?MATCH\u12289?INDEX\u12289?INDIRECT\u-229?\u22810?\u26465?\u20214?\u25968?\u25454?\u26597?\u-29726?\u-229?\u-28211?\u22797?\u25968?\u25454?\u26597?\u-29726?\u-229?\u26597?\u-29726?\u32467?\u26524?\u20026?\u-27367?\u-29713?\u30340?\u22788?\u29702?\u-229?\u26597?\u-29726?\u32467?\u26524?\u20026?\u-26890?\u30340?\u22788?\u29702?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u21019?\u24314?\u-25896?\u25928?\u-29791?\u31639?\u20844?\u24335?\u30340?\u25216?\u24039?\u21644?\u26041?\u27861?\u-248?\u20998?\u-30237?\u32508?\u21512?\u27861?\u-229?\u-28795?\u21161?\u21015?\u27861?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19977?\u12289?\u24555?\u-28641?\u27719?\u24635?\u22823?\u-28209?\u30340?\u24037?\u20316?\u-30616?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u24555?\u-28641?\u27719?\u24635?\u20010?\u25968?\u19981?\u23450?\u30340?\u22810?\u20010?\u24037?\u20316?\u-30616?\u-248?INDIRECT\u20989?\u25968?\u30340?\u32508?\u21512?\u24212?\u29992?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u24555?\u-28641?\u27719?\u24635?\u22810?\u20010?\u32467?\u26500?\u23436?\u20840?\u30456?\u21516?\u30340?\u24037?\u20316?\u-30616?\u-248?\u21512?\u24182?\u-29791?\u31639?\u24037?\u20855?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u24555?\u-28641?\u27719?\u24635?\u32467?\u26500?\u19981?\u21516?\u30340?\u22810?\u20010?\u24037?\u20316?\u-30616?\u-248?\u29305?\u27530?\u24773?\u20917?\u-244?\u22810?\u-28211?\u21512?\u24182?\u-29791?\u31639?\u25968?\u25454?\u21306?\u22495?\u30340?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u24555?\u-28641?\u27719?\u24635?\u32467?\u26500?\u19981?\u21516?\u30340?\u22810?\u20010?\u24037?\u20316?\u-30616?\u-248?\u19968?\u-32212?\u24773?\u20917?\u-244?\u23548?\u20837?\u25968?\u25454?+SQL\u-29715?\u21477?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u24555?\u-28641?\u27719?\u24635?\u22810?\u20010?\u26377?\u20851?\u-32684?\u30340?\u24037?\u20316?\u-30616?\u-248?\u24378?\u22823?\u30340?Microsoft Query\u24037?\u20855?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u22235?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u28789?\u27963?\u24212?\u29992?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u22522?\u26412?\u27010?\u24565?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u31867?\u22411?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u20960?\u20010?\u26415?\u-29715?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u32467?\u26500?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u24517?\u-30335?\u30340?\u20934?\u22791?\u24037?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?\u21019?\u24314?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u22522?\u26412?\u26041?\u27861?\u21644?\u27880?\u24847?\u20107?\u-26503?\u-248?\u25972?\u29702?\u-30268?\u-31997?\u25968?\u25454?\u21306?\u22495?\u-229?\u21046?\u20316?\u27491?\u30830?\u30340?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-229?\u21046?\u20316?\u22522?\u20110?\u21160?\u24577?\u25968?\u25454?\u28304?\u30340?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-229?OFFSET\u20989?\u25968?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u12289?\u-29762?\u32622?\u25968?\u25454?\u-28657?\u-30266?\u30340?\u26684?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8\u12289?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u24555?\u-28641?\u32534?\u21046?\u21508?\u31867?\u32479?\u-29791?\u20998?\u26512?\u25253?\u-30616?\u-248?\u-29762?\u32622?\u23383?\u27573?\u20998?\u31867?\u27719?\u24635?\u26041?\u24335?\u-229?\u-29762?\u32622?\u23383?\u27573?\u26174?\u31034?\u26041?\u24335?\u-229?\u32452?\u21512?\u27573?\u-229?\u-32278?\u23450?\u20041?\u-29791?\u31639?\u23383?\u27573?\u-229?\u-32278?\u23450?\u20041?\u-29791?\u31639?\u-26503?\u-229?\u27880?\u24847?\u30340?\u20960?\u20010?\u-27154?\u-26472?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20116?\u12289?\u29992?\u22270?\u-30616?\u-29708?\u-29731?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u22270?\u-30616?\u31867?\u22411?\u30340?\u-28663?\u29992?\u21407?\u21017?\u21644?\u24314?\u-29778?\u-248?\u-29783?\u22270?\u-30616?\u-29708?\u27491?\u30830?\u30340?\u-29731?\u-229?\u-29783?\u22270?\u-30616?\u-29708?\u31934?\u28860?\u30340?\u-29731?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u20351?\u29992?\u-32278?\u-28663?\u22270?\u24418?\u31361?\u20986?\u22270?\u-30616?\u20449?\u24687?\u30340?\u-28211?\u28857?\u-248?\u31616?\u21333?\u30340?\u22270?\u-30616?\u20462?\u-26256?\u-244?\u22270?\u-30616?\u30340?\u-28211?\u28857?\u20449?\u24687?\u31361?\u20986?\u-244?\u19968?\u30446?\u20102?\u28982?\u21457?\u29616?\u-27154?\u-26472?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u20351?\u29992?\u32452?\u21512?\u22270?\u-30616?\u-30616?\u-28738?\u26356?\u21152?\u22797?\u26434?\u30340?\u20449?\u24687?\u-248?\u21512?\u29702?\u32452?\u21512?\u22270?\u-30616?\u31867?\u22411?\u-229?\u21512?\u29702?\u-28709?\u-30644?\u22270?\u-30616?\u21464?\u24418?\u-247?\u21046?\u20316?\u21160?\u24577?\u20132?\u20114?\u22270?\u-30616?\u-244?\u-29783?\u19968?\u24352?\u22270?\u-30616?\u21453?\u26144?\u26356?\u22810?\u30340?\u20449?\u24687?\u-248?\u20102?\u-30237?\u25511?\u20214?\u30340?\u20351?\u29992?\u26041?\u27861?\u-229?OFFSET\u20989?\u25968?\u-229?\u23450?\u20041?\u21160?\u24577?\u21517?\u31216?\u-247?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-26647?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29372?\u28145?\u23454?\u25112?\u22411?Excel\u22521?\u-29779?\u-29774?\u24072?\u12289?\u-30237?\u20915?\u26041?\u26696?\u19987?\u23478?\u21644?\u31649?\u29702?\u31995?\u32479?\u24320?\u21457?\u-29762?\u-29791?\u24072?\u-244?\u23545?Excel\u21450?Excel VBA\u22312?\u20225?\u19994?\u31649?\u29702?\u20013?\u30340?\u24212?\u29992?\u26377?\u30528?\u-28797?\u28145?\u30340?\u30740?\u31350?\u21644?\u29420?\u29305?\u30340?\u-29788?\u-29754?\u-244?\u23545?Excel\u21450?VBA\u22312?\u31649?\u29702?\u20013?\u-25896?\u32423?\u24212?\u29992?\u22521?\u-29779?\u26377?\u30528?\u20016?\u23500?\u30340?\u23454?\u25112?\u32463?\u-25972?\u-244?\u20855?\u26377?\u20016?\u23500?\u30340?\u31649?\u29702?\u32463?\u-25972?\u21644?\u26497?\u24378?\u30340?Excel\u24212?\u29992?\u24320?\u21457?\u-32515?\u21147?\u-244?\u23588?\u20854?\u26159?Excel\u21450?VBA\u22312?\u20225?\u19994?\u-29406?\u21153?\u12289?\u20250?\u-29791?\u12289?\u-27392?\u21806?\u12289?\u20154?\u21147?\u-29372?\u28304?\u12289?\u-28207?\u-30835?\u-29406?\u21153?\u31561?\u31649?\u29702?\u20013?\u30340?\u24212?\u29992?\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}