{\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 \u-29406?\u21153?\u24517?\u30693?\u24517?\u20250?\u30340?18\u20010?Excel\u20989?\u25968?\u19982?\u25968?\u25454?\u20998?\u26512?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT058615\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/gkk9/058615.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-29406?\u21153?\u24517?\u30693?\u24517?\u20250?\u30340?18\u20010?Excel\u20989?\u25968?\u19982?\u25968?\u25454?\u20998?\u26512?\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? \u124? \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?04\u26085? \u21040? 2025\u24180?07\u26376?04\u26085? \u21271?\u20140? 2800\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?07\u26376?19\u26085? \u21040? 2024\u24180?07\u26376?19\u26085? \u21271?\u20140? 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/gkk9/058615.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u21271?\u20140?\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\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?\u-29722?\u24773?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20316?\u20026?\u-32692?\u22330?\u21150?\u20844?\u30340?\u19981?\u21487?\u25110?\u32570?\u30340?Excel\u24037?\u20855?\u-244?\u24456?\u22810?\u20154?\u20165?\u20165?\u30053?\u30693?\u30382?\u27611?\u-32756?\u24050?\u-244?\u26356?\u-29688?\u19981?\u19978?\u-25896?\u25928?\u29575?\u22788?\u29702?\u25968?\u25454?\u-244?\u24314?\u31435?\u-32278?\u21160?\u21270?\u25968?\u25454?\u20998?\u26512?\u27169?\u29256?\u12290?Excel\u26368?\u26680?\u24515?\u30340?\u25216?\u-32515?\u20043?\u19968?\u26159?\u20989?\u25968?\u20844?\u24335?\u-244?\u20294?\u20320?\u26159?\u21542?\u30495?\u27491?\u20102?\u-30237?\u24182?\u-32515?\u28789?\u27963?\u-28720?\u29992?Excel\u21508?\u31181?\u20989?\u25968?\u24555?\u-28641?\u21019?\u24314?\u-25896?\u25928?\u-29791?\u31639?\u20844?\u24335?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-29698?\u31243?\u23558?\u24102?\u20320?\u-29722?\u32454?\u23398?\u20064?\u-29406?\u21153?\u24517?\u30693?\u24517?\u20250?\u30340?18\u20010?Excel\u-25896?\u32423?\u20989?\u25968?\u21450?\u20854?\u24212?\u29992?\u-244?\u23398?\u20064?\u22914?\u20309?\u20351?\u29992?\u20989?\u25968?\u26500?\u24314?\u-25896?\u25928?\u25968?\u25454?\u20998?\u26512?\u25253?\u21578?\u12290?\u-29779?\u32451?\u-28613?\u-28783?\u24605?\u32500?\u-244?\u26159?\u26412?\u-29698?\u31243?\u30340?\u26680?\u24515?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u28201?\u-26200?\u25552?\u31034?\u-230?\u26412?\u-29698?\u31243?\u-30335?\u27714?\u23433?\u-30523?Office 2019\u20197?\u19978?\u29256?\u26412?\u25110?\u-32763?Office 365\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. \u20840?\u-26782?\u23398?\u20064?\u-29406?\u21153?\u24517?\u30693?\u24517?\u20250?\u30340?18\u20010?Excel\u-25896?\u32423?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u32467?\u21512?\u22823?\u-28209?\u23454?\u-27067?\u26696?\u20363?\u-244?\u23398?\u20064?\u26500?\u24314?\u-32278?\u21160?\u21270?\u25968?\u25454?\u20998?\u26512?\u27169?\u22411?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3. \u-28646?\u-28729?\u26696?\u20363?\u21078?\u26512?\u-244?\u22521?\u20859?\u-30237?\u20915?\u-27154?\u-26472?\u30340?\u-28613?\u-28783?\u24605?\u32500?\u21644?\u29420?\u31435?\u24605?\u-32765?\u-32515?\u21147?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4. 30\u20010?\u22823?\u26696?\u20363?\u-244?64\u20010?\u23567?\u26696?\u20363?\u-244?\u28145?\u20837?\u27973?\u20986?\u20171?\u32461?\u20989?\u25968?\u20844?\u24335?\u30340?\u24212?\u29992?\u-28613?\u-28783?\u19982?\u25216?\u-32515?\u25216?\u24039?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u32434?\u22823?\u32434?\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19968?\u-230?\u25968?\u25454?\u-28613?\u-28783?\u21028?\u26029?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24517?\u-26501?\u25484?\u25569?\u30340?\u26465?\u20214?\u-30616?\u-28738?\u24335?\u25216?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u26803?\u29702?\u-27154?\u-26472?\u21644?\u-30616?\u26684?\u-244?\u25214?\u20986?\u-30237?\u20915?\u-27154?\u-26472?\u30340?\u-28613?\u-28783?\u24605?\u32500?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u24555?\u-28641?\u-28781?\u20837?\u23884?\u22871?IF\u20989?\u25968?\u20844?\u24335?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26500?\u24314?\u-32278?\u21160?\u21270?\u25968?\u25454?\u20998?\u26512?\u27169?\u29256?\u26102?\u-244?\u22914?\u20309?\u22788?\u29702?\u20844?\u24335?\u-27367?\u-29713?\u20540?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20108?\u-230?\u22788?\u29702?\u25991?\u26412?\u25968?\u25454?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24555?\u-28641?\u20174?\u23383?\u31526?\u20018?\u25130?\u21462?\u23383?\u31526?\u30340?\u24517?\u22791?\u20989?\u25968?\u19977?\u21073?\u23458?\u-230?LEFT\u-244?RIGHT\u21644?MID\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21033?\u29992?FIND\u26597?\u25214?\u23383?\u31526?\u20301?\u32622?\u-244?\u30830?\u23450?\u25130?\u21462?\u23383?\u31526?\u20301?\u32622?\u21450?\u20010?\u25968?\u-244?\u20197?\u21450?\u20851?\u-27346?\u-29747?\u21305?\u-28339?\u27719?\u24635?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24378?\u22823?\u30340?\u26684?\u24335?\u-28820?\u25442?\u20989?\u25968?TEXT\u-244?\u20197?\u21407?\u22987?\u25968?\u25454?\u30452?\u25509?\u26500?\u24314?\u19968?\u-27346?\u21047?\u26032?\u30340?\u25968?\u25454?\u20998?\u26512?\u25253?\u21578?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19977?\u-230?\u25968?\u25454?\u20998?\u31867?\u27719?\u24635?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u29702?\u-30237?\u24182?\u27491?\u30830?\u-28720?\u29992?SUMIF\u20989?\u25968?\u21644?SUMIFS\u20989?\u25968?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u20351?\u29992?SUMPRODUCT\u20989?\u25968?\u30452?\u25509?\u20197?\u31995?\u32479?\u23548?\u20986?\u30340?\u22522?\u30784?\u25968?\u25454?\u-28709?\u-30644?\u-32278?\u21160?\u27719?\u24635?\u20998?\u26512?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u22235?\u-230?\u25968?\u25454?\u26597?\u25214?\u19982?\u24341?\u29992?\u27719?\u24635?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20320?\u26159?\u21542?\u30495?\u27491?\u20102?\u-30237?VLOOKUP\u20989?\u25968?\u30340?\u22522?\u26412?\u21407?\u29702?\u21450?\u21508?\u31181?\u28789?\u27963?\u24212?\u29992?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26356?\u21152?\u24378?\u22823?\u30340?XLOOKUP\u20989?\u25968?\u-244?\u-29783?\u25968?\u25454?\u26597?\u25214?\u26356?\u21152?\u31616?\u21333?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22810?\u26465?\u20214?\u26597?\u25214?\u25968?\u25454?\u31163?\u19981?\u24320?\u30340?\u20004?\u20804?\u24351?MATCH\u20989?\u25968?\u21644?INDEX\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22914?\u20309?\u20351?\u29992?INDIRECT\u20989?\u25968?\u26500?\u24314?\u-32278?\u21160?\u21270?\u28378?\u21160?\u27719?\u24635?\u25253?\u-30616?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21160?\u24577?\u24341?\u29992?\u21306?\u22495?\u31163?\u19981?\u24320?\u30340?OFFSET\u20989?\u25968?\u-244?\u20320?\u20250?\u29992?\u20102?\u21527?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25511?\u20214?+\u20989?\u25968?\u-244?\u21046?\u20316?\u21160?\u24577?\u22270?\u-30616?\u30340?\u26680?\u24515?\u25216?\u-32515?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20116?\u-230?\u25968?\u25454?\u-32278?\u21160?\u21270?\u25490?\u24207?\u19982?\u31579?\u-28663?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 SORT\u20989?\u25968?\u-29783?\u25968?\u25454?\u25490?\u24207?\u21464?\u24471?\u26356?\u21152?\u28789?\u27963?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 FILTER\u20989?\u25968?\u24555?\u-28641?\u21046?\u20316?\u-32278?\u21160?\u21270?\u26126?\u32454?\u-30616?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31579?\u-28663?\u19982?\u25490?\u24207?\u-32684?\u21512?\u20351?\u29992?\u30340?\u-32278?\u21160?\u21270?\u25968?\u25454?\u20998?\u26512?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 16:30 \u-29774?\u-30237?\u32467?\u26463?\u-244?\u20114?\u21160?\u-27154?\u31572?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 17:00 \u-29698?\u31243?\u32467?\u26463?\u8195?\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-31657?\u21517?\u-29372?\u28145?\u23454?\u25112?\u22411?Excel\u22521?\u-29779?\u-29774?\u24072? \u25968?\u25454?\u31649?\u29702?\u19982?\u25968?\u25454?\u20998?\u26512?\u24212?\u29992?\u26041?\u26696?\u19987?\u23478? \u20013?\u22269?Excel\u22823?\u30334?\u31185?\u20840?\u20070?\u20316?\u-32763?\u-244?\u20986?\u29256?50\u20313?\u-28440?\u20851?\u20110?Excel\u22312?\u20225?\u19994?\u31649?\u29702?\u24212?\u29992?\u20070?\u31821?\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}