{\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 Office\u-28738?\u20154?\u8212?Excel\u-25896?\u25928?\u25805?\u20316?\u25216?\u24039?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT040952\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/040952.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 Office\u-28738?\u20154?\u8212?Excel\u-25896?\u25928?\u25805?\u20316?\u25216?\u24039?\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?03\u26376?14\u26085? \u21040? 2025\u24180?03\u26376?14\u26085? \u19978?\u28023? 1980\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?11\u26376?08\u26085? \u21040? 2024\u24180?11\u26376?08\u26085? \u19978?\u28023? 1980\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?10\u26376?17\u26085? \u21040? 2024\u24180?10\u26376?17\u26085? \u-32049?\u24030? 1980\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/040952.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-27265?\u27801?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk6/042933.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-32049?\u24030?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk5/038197.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?Excel\u25216?\u24039?\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 \u20316?\u20026?\u25968?\u25454?\u22788?\u29702?\u30340?\u-28646?\u29992?\u24037?\u20855?\u-244?Excel \u26089?\u23601?\u24471?\u21040?\u22269?\u20869?\u22806?\u20247?\u22810?\u-30644?\u19994?\u30340?\u24191?\u27867?\u-28720?\u29992?\u-244?\u21253?\u25324?\u25968?\u25454?\u20998?\u26512?\u12289?\u29983?\u20135?\u21046?\u-28640?\u12289?\u20379?\u24212?\u-27394?\u29289?\u27969?\u31649?\u29702?\u12289?\u-29406?\u21153?\u21450?\u-28207?\u-30835?\u31561?\u-26490?\u22495?\u12290?Excel \u-26938?\u25104?\u20102?\u26368?\u20248?\u31168?\u30340?\u25968?\u25454?\u22788?\u29702?\u21151?\u-32515?\u-244?\u31649?\u29702?\u-32763?\u23436?\u20840?\u21487?\u20197?\u25353?\u29031?\u-32278?\u24049?\u30340?\u24605?\u-29201?\u26469?\u21019?\u24314?\u25968?\u25454?\u27169?\u22411?\u-244?\u24182?\u22312? Excel \u30340?\u24110?\u21161?\u19979?\u20986?\u-32142?\u30340?\u23436?\u25104?\u22522?\u20110?\u25968?\u25454?\u30340?\u20998?\u26512?\u20915?\u31574?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29302?\u26469?\u-29302?\u22810?\u30340?\u20844?\u21496?\u23558? Excel \u20351?\u29992?\u-32515?\u21147?\u20316?\u20026?\u-30623?\u-28209?\u21592?\u24037?\u20215?\u20540?\u30340?\u26631?\u20934?\u20043?\u19968?\u-244?\u20855?\u26377?\u-25896?\u-29307?\u30340? Excel \u25216?\u-32515?\u25165?\u-32515?\u20351?\u24744?\u22312?\u28608?\u28872?\u30340?\u-32692?\u22330?\u31454?\u20105?\u20013?\u-32463?\u-26474?\u-32756?\u20986?\u-244?\u22914?\u-31154?\u28155?\u32764?\u-255?\u21442?\u21152? Excel \u23454?\u29992?\u25216?\u-32515?\u-29698?\u31243?\u-244?\u23558?\u20351?\u20320?\u30340?\u25968?\u25454?\u31649?\u29702?\u27700?\u24179?\u25552?\u21319?\u21040?\u19968?\u20010?\u26032?\u30340?\u-25896?\u24230?\u-244?\u25968?\u25454?\u21270?\u20915?\u31574?\u-29783?\u20320?\u30340?\u24037?\u20316?\u26356?\u20986?\u-32142?\u-255?\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 \u30693?\u26195? Excel \u-30616?\u26684?\u30340?\u-30268?\u-31997?\u21270?\u21450?\u22788?\u29702?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23398?\u20250?\u-28211?\u-30335?\u20989?\u25968?\u22914?COUNTIFS\u22810?\u26465?\u20214?\u-29791?\u25968?/SUMIFS\u22810?\u26465?\u20214?\u27714?\u21644?/IF\u22810?\u26465?\u20214?\u23884?\u22871?\u21028?\u26029?/VLOOKUP\u26597?\u20540?/\u20197?\u21450?DATE\u12289?EOMONTH\u31561?\u26085?\u26399?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-32515?\u22815?\u20351?\u29992?\u25968?\u25454?\u20998?\u26512?\u21033?\u22120?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-244?\u21046?\u20316?\u25353?\u24180?/\u23395?\u24230?/\u26376?\u26597?\u30475?\u30340?\u12289?\u20132?\u20114?\u24335?\u25253?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u30693?\u26195?\u21160?\u24577?\u22270?\u-30616?\u30340?\u21407?\u29702?\u-244?\u24182?\u25484?\u25569?\u23454?\u-27067?\u21046?\u20316?\u26041?\u27861?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u23545?\u-29599?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23545?\u23436?\u32654?\u12289?\u-25896?\u25928?\u22320?\u23436?\u25104?\u24037?\u20316?\u26377?\u31215?\u26497?\u-28675?\u27714?\u-244?\u-26880?\u-30335?\u32463?\u24120?\u20351?\u29992? Excel \u30340?\u21508?\u31867?\u20154?\u21592?\u-244?\u23588?\u20854?\u26159?\u20174?\u20107?\u-30644?\u25919?\u12289?\u20154?\u21147?\u-29372?\u28304?\u12289?\u-27392?\u21806?\u12289?\u24066?\u22330?\u-31707?\u-27392?\u12289?\u-29406?\u21153?\u31649?\u29702?\u21644?\u-26503?\u30446?\u31649?\u29702?\u30340?\u20154?\u22763?\u12290?\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?\u27169?\u22359?\u-230?\u-29762?\u-29791?\u-30268?\u-31997?\u30340?\u-30616?\u26684?\u26356?\u26131?\u20110?\u32479?\u-29791?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.Excel\u20013?\u20004?\u31181?\u-30616?\u26684?\u31867?\u22411?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u-30268?\u-31997?\u30340?\u25968?\u25454?\u24211?\u-29762?\u-29791?\u-30335?\u27714?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u25209?\u-28209?\u21462?\u28040?\u21512?\u24182?\u21333?\u20803?\u26684?\u24182?\u22635?\u20805?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u22797?\u21046?\u31896?\u-29388?\u20844?\u24335?\u26102?\u20445?\u30041?\u-28720?\u31639?\u32467?\u26524?\u-32756?\u-26786?\u20844?\u24335?\u26412?\u-29013?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u21435?\u-27036?\u21333?\u20803?\u26684?\u24038?\u19978?\u-30254?\u30340?\u32511?\u-32142?\u23567?\u19977?\u-30254?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u24555?\u-28641?\u20462?\u27491?\u-26786?\u27861?\u26684?\u24335?\u30340?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u25968?\u25454?\u25910?\u-26938?\u27169?\u26495?\u-27056?\u23450?\u21482?\u24405?\u20837?\u25968?\u20540?/\u26085?\u26399?\u31867?\u22411?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u20108?\u27169?\u22359?\u-230?\u25968?\u25454?\u32479?\u-29791?\u24037?\u20316?\u20013?\u24120?\u29992?\u30340?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u30456?\u23545?\u24341?\u29992?\u19982?\u32477?\u23545?\u24341?\u29992?\u-244?\u20960?\u31181?\u24341?\u29992?\u26041?\u24335?\u22914?\u20309?\u-28663?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u23545?\u19968?\u21015?\u25110?\u22810?\u21015?\u21435?\u-28211?\u-244?\u21482?\u20445?\u30041?\u21807?\u19968?\u20540?\u21015?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u22810?\u26465?\u20214?\u26469?\u-29791?\u25968?COUNTIFS\u-230?\u25353?\u23398?\u21382?\u25110?\u-32692?\u31216?\u32479?\u-29791?\u20154?\u25968?/\u21508?\u-27392?\u21806?\u21592?\u30340?\u-29790?\u21333?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u22810?\u26465?\u20214?\u27714?\u21644?SUMIFS\u-230?\u27719?\u24635?\u-28440?\u-27160?\u25253?\u-27392?\u-29383?\u29992?/\u24037?\u-29372?\u31561?\u21508?\u31181?\u-28207?\u-26467?\u30340?\u27719?\u24635?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u-28613?\u-28783?\u21028?\u26029?IF\u-230?\u20108?\u31181?\u21450?\u19977?\u31181?\u20197?\u19978?\u24773?\u20917?\u30340?\u21028?\u26029?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u26597?\u20540?\u24341?\u29992?VLOOKUP\u-230?\u31934?\u30830?\u21450?\u-28719?\u20284?\u21305?\u-28339?\u30340?\u29992?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u26085?\u26399?\u-29791?\u31639?DATE/EOMONTH\u-230?\u19968?\u24352?\u-30616?\u21363?\u21487?\u25353?\u24180?/\u25353?\u26376?\u26597?\u30475?\u25152?\u26377?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u19977?\u27169?\u22359?\u-230?\u21033?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u28789?\u27963?\u21046?\u20316?\u32479?\u-29791?\u25253?\u-30616?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u-28657?\u-30266?\u-30616?\u24067?\u23616?\u20171?\u32461?\u19982?\u21019?\u24314?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u26356?\u25913?\u23383?\u27573?\u-29791?\u31639?\u26041?\u24335?\u19982?\u25968?\u23383?\u26684?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u-29693?\u25972?\u-28657?\u-30266?\u-30616?\u26679?\u24335?\u19982?\u31616?\u27905?\u30340?\u25253?\u-30616?\u26684?\u24335?\u-29762?\u32622?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u23545?\u26085?\u26399?\u20998?\u32452?\u29983?\u25104?\u24180?\u24230?/\u23395?\u24230?/\u26376?\u24230?\u25253?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u25353?\u25968?\u20540?\u21306?\u-27148?\u20998?\u32452?\u27719?\u24635?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u25554?\u20837?\u-30616?\u26684?\u20197?\u-31817?\u21462?\u21160?\u24577?\u30340?\u25968?\u25454?\u28304?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7.\u21033?\u29992?\u20999?\u29255?\u22120?\u21046?\u20316?\u20132?\u20114?\u24335?\u25968?\u25454?\u25253?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u22235?\u27169?\u22359?\u-230?\u22270?\u-30616?\u23637?\u31034?\u19982?\u21160?\u24577?\u22270?\u-30616?\u21046?\u20316?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u26465?\u20214?\u26684?\u24335?\u31361?\u20986?\u25968?\u25454?\u21069?N\u21517?/\u21046?\u20316?\u26465?\u24418?\u22270?/\u25552?\u31034?\u25968?\u25454?\u24322?\u24120?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u21046?\u20316?\u26609?\u24418?-\u25240?\u32447?\u32452?\u21512?\u22270?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u22312?\u26609?\u24418?\u22270?\u20013?\u-32278?\u21160?\u32472?\u21046?\u24179?\u22343?\u32447?\u24182?\u26631?\u27880?\u26368?\u-25896?\u19982?\u26368?\u20302?\u28857?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u21160?\u24577?\u22270?\u-30616?\u21407?\u29702?\u19982?\u21046?\u20316?\u26041?\u27861?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u29579?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u24494?\u-28817?\u-29788?\u-29759?Office\u19987?\u23478?\u-229?\u20013?\u20851?\u26449?\u21019?\u26032?\u30740?\u20462?\u23398?\u-27038?\u29305?\u-32680?\u-29774?\u24072?\u-229?\u22269?\u23478?\u-32692?\u19994?\u-29372?\u26684?\u-29788?\u-29759?\u20225?\u19994?\u22521?\u22521?\u-29779?\u24072?\u-229?2013\u24180?\u-31901?\u-31817?\u25628?\u29392?\u8220?\u26368?\u20339?Excel \u23454?\u25112?\u-29774?\u24072?\u8221?\u-229?2016\u24180?\u-31901?\u-31817?\u32593?\u26131?\u8220?\u24180?\u24230?\u-26418?\u20113?\u30334?\u24378?\u-29774?\u24072?\u8221?\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}