{\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 \u-29406?\u21153?Excel\u30340?\u27494?\u21151?\u31192?\u31821? \u8212?\u8212?\u25171?\u-28646?\u20320?\u25104?\u20026?Excel\u-25896?\u25163?\u30340?\u20219?\u30563?\u20108?\u-32503?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b NX15506\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 //m.apparel77.com/nxk/15506.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-29406?\u21153?Excel\u30340?\u27494?\u21151?\u31192?\u31821? \u8212?\u8212?\u25171?\u-28646?\u20320?\u25104?\u20026?Excel\u-25896?\u25163?\u30340?\u20219?\u30563?\u20108?\u-32503?\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\sl300\plain\f0\fs22 \u12304?\u-29698?\u31243?\u20851?\u-27346?\u23383?\u12305?\u-230?Excel\u-25896?\u25163?\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\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u-32564?\u26223?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u32463?\u24120?\u26377?\u23398?\u21592?\u26379?\u21451?\u-27154?\u25105?\u-244?\u-32767?\u24072?\u-244?\u-29705?\u-27154?Excel\u31350?\u31455?\u-32515?\u24110?\u25105?\u20204?\u20570?\u20160?\u20040?\u-225?\u20026?\u20160?\u20040?\u-28711?\u20040?\u22810?\u24180?\u26469?\u-244?\u24744?\u-28711?\u20040?\u30196?\u-28681?\u20110?\u23398?\u20064?\u12289?\u30740?\u31350?Excel\u21602?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22312?\u25105?\u30475?\u26469?\u-244?Microsoft Excel\u26159?\u19968?\u20301?\u20255?\u22823?\u30340?\u-30616?\u26684?\u25112?\u22763?\u-244?Excel\u24120?\u24120?\u24110?\u21161?\u20154?\u20204?\u-29328?\u20986?\u25968?\u23383?\u27877?\u28525?\u-244?\u25688?\u21462?\u26234?\u24935?\u30340?\u26524?\u23454?\u12290?\u-28711?\u20301?\u8220?\u-30616?\u26684?\u25112?\u22763?\u8221?\u32451?\u23601?\u20102?\u19968?\u-29013?\u26412?\u-26490?\u-244?\u19987?\u-27160?\u23545?\u20184?\u19981?\u21548?\u-29731?\u30340?\u25968?\u25454?\u-244?\u-29783?\u20182?\u20204?\u-30268?\u-30268?\u30697?\u30697?\u30340?\u21574?\u30528?\u-244?\u24182?\u19988?\u20054?\u20054?\u30340?\u20379?\u20986?\u-32278?\u24049?\u30340?\u31192?\u23494?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20316?\u20026?\u21313?\u20960?\u24180?\u-29406?\u31246?\u24037?\u20316?\u-32763?\u30340?\u25105?\u-244?\u27599?\u22825?\u-28419?\u-30335?\u-26782?\u23545?\u22823?\u-28209?\u25968?\u25454?\u30340?\u22788?\u29702?\u-244?\u24403?\u24180?\u20063?\u22240?\u20026?\u29992?\u8220?\u31528?\u21150?\u27861?\u8221?\u22788?\u29702?\u-30616?\u26684?\u-244?\u32463?\u24120?\u21152?\u29677?\u21040?\u24456?\u26202?\u-244?\u-28509?\u26102?\u23601?\u19979?\u20915?\u24515?\u-30335?\u25104?\u20026?\u19968?\u20010?Excel\u30340?\u8220?\u-25896?\u25163?\u8221?\u12290?\u24403?\u25105?\u28145?\u20837?\u23398?\u20064?Excel\u20043?\u21518?\u-244?\u21457?\u29616?\u21407?\u26469?Excel\u-28711?\u20040?\u31070?\u22855?\u-244?\u20182?\u30495?\u30340?\u25317?\u26377?\u19968?\u-29013?\u8220?\u19978?\u20056?\u27494?\u21151?\u8221?\u-244?\u20182?\u21487?\u20197?\u-26782?\u23545?\u20960?\u19975?\u-30644?\u25968?\u25454?\u21435?\u22788?\u29702?\u-32756?\u-26782?\u19981?\u25913?\u-32142?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20170?\u22825?\u-244?\u25105?\u20316?\u20026?\u19968?\u20010?Excel\u19987?\u19994?\u-29774?\u24072?,\u32467?\u21512?\u25105?\u22810?\u24180?\u-29406?\u31246?\u24037?\u20316?\u30340?\u32463?\u21382?\u-244?\u24320?\u21457?\u20102?\u26412?\u22871?\u-29698?\u31243?\u12290?\u26412?\u-29698?\u31243?\u28085?\u30422?Excel\u30340?\u25805?\u20316?\u25216?\u24039?\u12289?\u20989?\u25968?\u19982?\u20844?\u24335?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u30456?\u20851?\u20869?\u23481?\u-244?\u-28646?\u-28729?\u22823?\u-28209?\u30340?\u23454?\u-27067?\u26696?\u20363?\u-29774?\u-30237?\u-244?\u24110?\u21161?\u24744?\u23569?\u-29328?\u24367?\u-29201?\u-244?\u23398?\u20250?\u29992?Excel\u-30237?\u20915?\u24037?\u20316?\u20013?\u-28601?\u21040?\u30340?\u21508?\u31181?\u-26946?\u-26472?\u-244?\u25171?\u-28646?\u20320?\u25104?\u20026?Excel\u-25896?\u25163?\u30340?\u8220?\u20219?\u30563?\u20108?\u-32503?\u8221?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u25910?\u30410?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-29698?\u31243?\u-32268?\u21147?\u20110?\u-29783?\u21508?\u20301?Excel\u29992?\u25143?\u-244?\u-28646?\u-28729?Excel\u30340?\u25805?\u20316?\u25216?\u24039?\u12289?\u20989?\u25968?\u19982?\u20844?\u24335?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u31561?\u21508?\u20010?\u27169?\u22359?\u30340?\u23398?\u20064?\u-244?\u-28720?\u29992?\u22823?\u-28209?\u30340?\u23454?\u-27067?\u26696?\u20363?\u-28709?\u-30644?\u-29774?\u-30237?\u-244?\u23398?\u21592?\u19981?\u20294?\u21487?\u20197?\u25484?\u25569?\u21040?\u24778?\u-32141?\u30340?\u21508?\u31181?\u25805?\u20316?\u25216?\u24039?\u12289?\u-29307?\u-28729?30\u20010?Excel\u30340?\u-25896?\u-26479?\u20989?\u25968?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u21021?\u-25896?\u-27082?\u-28720?\u29992?\u-244?\u-28712?\u21487?\u20197?\u20102?\u-30237?\u21040?\u-29774?\u24072?\u-30237?\u20915?Excel\u-26946?\u-26472?\u30340?\u24605?\u-29201?\u12290?\u-29783?\u24744?\u20174?Excel\u8220?\u23567?\u30333?\u8221?\u-244?\u-28646?\u-28729?\u31995?\u32479?\u30340?\u23398?\u20064?\u-244?\u23398?\u20250?\u-25896?\u25928?\u30340?\u29992?Excel\u-30237?\u20915?\u24037?\u20316?\u20013?\u-28601?\u21040?\u30340?\u21508?\u31181?\u-26946?\u-26472?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u23545?\u-29599?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-29698?\u31243?\u26696?\u20363?\u20559?\u21521?\u-29406?\u21153?\u20154?\u21592?\u-244?\u20294?\u21516?\u26102?\u20063?\u-28670?\u29992?\u20110?\u20854?\u20182?\u21033?\u29992?Excel\u24037?\u20316?\u30340?\u24037?\u20316?\u23703?\u20301?\u-244?\u20363?\u22914?\u-230?\u-30644?\u25919?\u20154?\u20107?\u12289?\u25968?\u25454?\u20998?\u26512?\u31561?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u26041?\u24335?\u-230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29774?\u24072?\u-29774?\u25480?+\u26696?\u20363?\u20998?\u26512?+\u23454?\u25805?\u28436?\u32451?+\u29616?\u22330?\u31572?\u30097?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u22823?\u32434?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u19968?\u-28440?\u20998? \u22522?\u30784?\u31687?\u-230?\u-29406?\u21153?\u25968?\u25454?\u30340?Excel\u22522?\u30784?\u25805?\u20316?\u19982?\u22788?\u29702?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u-29406?\u21153?\u25968?\u25454?\u-25896?\u25928?\u12289?\u-30268?\u-31997?\u24405?\u20837?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u25209?\u-28209?\u24405?\u20837?\u30456?\u21516?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u27491?\u30830?\u-28781?\u20837?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u-29406?\u21153?\u-30616?\u26684?\u26085?\u26399?\u30340?\u21508?\u31181?\u21576?\u29616?\u26041?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u27491?\u30830?\u-28781?\u20837?\u20998?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u27491?\u30830?\u24405?\u20837?\u21592?\u24037?\u-29013?\u20221?\u-29759?\u21495?\u30721?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u-247?\u24555?\u-28641?\u-28781?\u20837?\u23545?\u21495?\u19982?\u-27367?\u21495?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u-247?\u24555?\u-28641?\u-28781?\u20837?\u24179?\u26041?\u19982?\u31435?\u26041?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8 ) \u22312?2016\u29256?\u26412?\u20013?\u23454?\u29616?\u20840?\u23631?\u25171?\u21360?\u-26492?\u-30264?\u25928?\u26524?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9\u-247?\u24120?\u29992?\u30340?\u24555?\u25463?\u-27346?\u8212?\u8212?\u21033?\u29992?\u-24800?\u26631?\u-27346?\u30424?\u23436?\u25104?\u21333?\u20803?\u26684?\u30340?\u24555?\u-28641?\u-29197?\u-28820?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u-29406?\u21153?EXCEL\u-30616?\u26684?\u30340?\u8220?\u20094?\u22372?\u22823?\u25386?\u31227?\u8221?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u25554?\u20837?\u31354?\u30333?\u21333?\u20803?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u25554?\u20837?\u22810?\u-30644?\u22810?\u21015?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u-28820?\u25442?\u-30644?\u21015?\u27425?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u21453?\u-28820?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u22914?\u20309?\u23558?\u20108?\u32500?\u-30616?\u-28820?\u25442?\u20026?\u19968?\u32500?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u-29406?\u21153?\u25968?\u25454?\u-25896?\u25928?\u30340?\u26597?\u25214?\u19982?\u26367?\u25442?\u30340?4\u22823?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u32473?\u20104?\u27169?\u31946?\u26597?\u25214?\u30340?\u8220?Excel\u26597?\u25214?\u19982?\u26367?\u25442?\u8221?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u21033?\u29992?\u26597?\u25214?\u19982?\u26367?\u25442?\u20462?\u27491?\u-27367?\u-29713?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u24039?\u29992?\u26597?\u25214?\u19982?\u26367?\u25442?\u23436?\u25104?\u25286?\u20998?\u-29402?\u25143?\u21517?\u31216?\u21644?\u-28207?\u-26467?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u-29406?\u21153?\u20154?\u30340?\u21508?\u31181?\u20998?\u21015?\u21450?\u22635?\u20805?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u26631?\u20934?\u20998?\u21015?\u21151?\u-32515?\u30340?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u21033?\u29992?\u20998?\u21015?\u21151?\u-32515?\u24555?\u-28641?\u26657?\u27491?\u21508?\u31181?\u19981?\u-30268?\u-31997?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u21033?\u29992?\u20998?\u21015?\u23436?\u25104?\u25968?\u25454?\u26684?\u24335?\u30340?\u24378?\u21046?\u-28820?\u25442?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u21457?\u31080?\u30331?\u-29776?\u-30616?\u30340?\u24207?\u21495?\u24555?\u-28641?\u22635?\u20805?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u21592?\u24037?\u-29013?\u20221?\u-29759?\u20013?\u24555?\u-28641?\u25552?\u21462?\u20986?\u29983?\u26085?\u26399?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6) \u26082?\u29983?\u29788?\u20309?\u29983?\u20142?\u-225?\u20196?\u20154?\u24778?\u21497?\u30340?\u8220?\u24555?\u-28641?\u22635?\u20805?\u8220?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?Excel\u30340?\u19977?\u32423?\u20445?\u25252?\u26426?\u21046?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u22914?\u20309?\u-26992?\u-31281?\u21333?\u20803?\u26684?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u24037?\u20316?\u-30616?\u20445?\u25252?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u24037?\u20316?\u31807?\u20445?\u25252?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?Excel\u25991?\u20214?\u30340?\u20445?\u25252?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u23494?\u30721?\u24536?\u20102?\u20063?\u19981?\u29992?\u24597?\u-244?\u30772?\u-29743?Excel\u24037?\u20316?\u-30616?\u20445?\u25252?\u-255?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?\u24039?\u29992?EXCEL\u26465?\u20214?\u26684?\u24335?\u-29783?\u20320?\u30340?\u-29406?\u21153?\u25253?\u-30616?\u21464?\u24778?\u-32141?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u-32278?\u21160?\u-29754?\u21035?\u19982?\u26631?\u-29776?\u-28211?\u22797?\u20540?\u19982?\u21807?\u19968?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u24555?\u-28641?\u26680?\u23545?\u-29383?\u29992?\u25253?\u-27392?\u21333?\u26159?\u21542?\u-28211?\u22797?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u21033?\u29992?\u26465?\u20214?\u26684?\u24335?\u-29762?\u32622?\u21452?\u20241?\u26085?\u21152?\u29677?\u-29383?\u-29791?\u31639?\u30340?\u25552?\u-28270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u21033?\u29992?\u26465?\u20214?\u26684?\u24335?\u25968?\u25454?\u-30616?\u-26988?\u-30644?\u22635?\u20805?\u24213?\u32441?\u30340?\u-29762?\u32622?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u12289?\u-29406?\u21153?\u25928?\u29575?\u25552?\u21319?\u31070?\u22120?\u-230?\u22810?\u31181?\u26041?\u24335?\u25552?\u21462?\u21015?\u21807?\u19968?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8\u12289?\u24039?\u29992?Excel\u25490?\u24207?\u21151?\u-32515?\u21046?\u20316?\u-26490?\u23548?\u25152?\u-26880?\u-29406?\u21153?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u25353?\u29031?\u29992?\u25143?\u24847?\u24895?\u30340?\u29305?\u27530?\u24207?\u21015?\u25490?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u25353?\u29031?\u-26468?\u-32142?\u26469?\u25490?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u-28716?\u22238?\u25490?\u24207?\u21069?\u30340?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u21033?\u29992?\u-28795?\u21161?\u21015?\u24555?\u-28641?\u23436?\u25104?\u24037?\u-29372?\u26465?\u30340?\u21046?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9\u12289?\u-29406?\u21153?\u30456?\u20851?\u-30616?\u26684?\u20923?\u32467?\u19982?\u25286?\u20998?\u31383?\u21475?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10\u12289?Excel\u30340?\u25968?\u25454?\u28304?\u-30268?\u-31997?\u19982?\u21333?\u20803?\u26684?\u30340?\u-32278?\u23450?\u20041?\u26684?\u24335?\u20195?\u30721?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11\u12289?\u-29406?\u21153?\u-30616?\u26684?\u-28663?\u25321?\u24615?\u31896?\u-29388?\u30340?\u22937?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u25209?\u-28209?\u-29693?\u25972?\u24037?\u-29372?\u30340?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u25928?\u29575?\u32763?\u20493?\u23558?\u-30616?\u26684?\u31896?\u-29388?\u20026?\u22270?\u29255?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u25991?\u26412?\u21644?\u25968?\u23383?\u26684?\u24335?\u20114?\u25442?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u23558?\u20844?\u24335?\u25152?\u-28716?\u22238?\u30340?\u20540?\u-28820?\u21270?\u20026?\u30495?\u27491?\u30340?\u25968?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u27178?\u21521?\u-30616?\u26684?\u21464?\u20026?\u32437?\u21521?\u-30616?\u26684?\u30340?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12\u12289?\u-29406?\u21153?\u24517?\u30693?\u30340?EXCEL\u23450?\u20301?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u21033?\u29992?\u23450?\u20301?\u24555?\u-28641?\u23436?\u25104?\u24635?\u-29402?\u31185?\u30446?\u30340?\u24555?\u-28641?\u22635?\u20805?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u21033?\u29992?\u26597?\u25214?\u19982?\u26367?\u25442?\u23436?\u25104?\u25353?\u25968?\u20540?\u23450?\u20301?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u20165?\u22797?\u21046?\u21487?\u-30271?\u21306?\u22495?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13\u12289?\u-29406?\u21153?\u-30616?\u26684?\u24120?\u29992?\u30340?\u25171?\u21360?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u-27265?\u-30616?\u26684?\u25171?\u21360?\u22914?\u20309?\u21152?\u20837?\u-30616?\u22836?\u-32756?\u19981?\u30772?\u22351?\u21407?\u-30616?\u26684?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u-29208?\u21306?\u22495?\u25171?\u21360?\u30340?\u-29762?\u32622?\u23567?\u22937?\u25307?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u20108?\u-28440?\u20998? \u-28709?\u-27082?\u31687?\u-230?\u-29406?\u21153?\u20154?\u24120?\u29992?\u30340?\u20989?\u25968?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u25805?\u20316?\u25216?\u24039?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u-29406?\u21153?\u20154?\u24517?\u25026?\u30340?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u-32278?\u21160?\u27714?\u21644?\u19982?Sum\u30340?\u24212?\u29992?\u21450?\u26696?\u20363?\u31934?\u-29774?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u32477?\u23545?\u24341?\u29992?\u12289?\u30456?\u23545?\u24341?\u29992?\u21644?\u28151?\u21512?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u24490?\u24207?\u28176?\u-28709?\u23398?If\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?Vlookup\u30340?\u24212?\u29992?\u25216?\u24039?\u21450?\u26696?\u20363?\u31934?\u-29774?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 a\u12289?Vlookup\u31934?\u30830?\u26597?\u25214?\u30340?10\u20010?\u24120?\u-30271?\u30340?\u-27367?\u-29713?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 b\u12289?Vlookup\u30340?\u27169?\u31946?\u26597?\u25214?\u8212?\u8212?\u32463?\u20856?\u30340?\u20108?\u20998?\u27861?\u26597?\u25214?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 c\u12289?\u21033?\u29992?VLOOKUP\u20989?\u25968?\u26597?\u25214?\u21592?\u24037?\u23545?\u24212?\u30340?\u-30619?\u-29388?\u21644?\u25152?\u23646?\u-28440?\u-27160?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 d\u12289?\u20010?\u20154?\u25152?\u24471?\u31246?7\u32423?\u-29307?\u-26467?\u32047?\u-28709?\u31246?\u29575?\u20844?\u24335?\u-29762?\u32622?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u8220?\u30334?\u21464?\u23567?\u31934?\u28789?\u8221?Text\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u-247?\u25991?\u26412?\u26367?\u25442?\u20989?\u25968?Substitute\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7\u-247?\u-29791?\u31639?\u25991?\u26412?\u-27265?\u24230?Len\u12289?LenB\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u25928?\u29575?\u32763?\u20493?\u25286?\u20998?\u-26503?\u30446?\u21517?\u31216?\u21644?\u-28207?\u-26467?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8\u-247?\u24050?\u30693?\u26085?\u26399?\u27714?\u20986?\u24180?\u19982?\u26085?Year\u12289?Month\u12289?Day\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9\u-247?\u26143?\u26399?\u20989?\u25968?Weekday\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10\u-247?Excel\u-28212?\u30340?\u-26992?\u-31281?\u20989?\u25968?Datedif\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 11\u-247?\u-29791?\u25968?\u19982?\u27714?\u21644?Countifs\u19982?Sumifs\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 12\u-247?\u29992?Indirect\u20989?\u25968?\u-28709?\u-30644?\u31532?\u19977?\u20010?\u32500?\u24230?\u30340?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 13\u-247?\u20559?\u31227?\u20989?\u25968?OFFSET\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u-29208?\u-30616?\u24341?\u29992?\u25968?\u25454?\u29992?\u20110?\u26680?\u23545?\u20250?\u-29791?\u24635?\u-29402?\u19982?\u26126?\u32454?\u-29402?\u20313?\u-26467?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u-29406?\u21153?\u32479?\u-29791?\u19982?\u20998?\u26512?\u30340?\u21033?\u22120?\u8212?\u8212?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1)\u-29788?\u-29754?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u24067?\u23616?\u31649?\u29702?\u22120?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2)\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u32473?\u20104?\u32531?\u23384?\u30340?\u29305?\u24615?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3)\u22914?\u20309?\u21512?\u24182?\u23621?\u20013?\u25490?\u21015?\u21333?\u20803?\u26684?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4)\u25913?\u21464?\u-24872?\u-29788?\u30340?\u-30644?\u26631?\u31614?\u21387?\u32553?\u26174?\u31034?\u26041?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5)\u22914?\u20309?\u20445?\u-29759?\u21047?\u26032?\u21518?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u21015?\u23485?\u19981?\u21464?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6)\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u26631?\u-26472?\u30340?\u22635?\u20889?\u30340?\u-27056?\u23450?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7)\u21516?\u19968?\u23383?\u27573?\u30340?\u22810?\u31181?\u27719?\u24635?\u20381?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8)\u23545?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-28709?\u-30644?\u31579?\u-28663?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 9)\u23545?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-28709?\u-30644?\u25490?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 10)\u32473?\u-28657?\u-30266?\u-30616?\u21152?\u19978?\u19968?\u23545?\u32709?\u-32384?\u8212?\u21046?\u20316?\u21452?\u21160?\u24577?\u30340?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u31532?\u19977?\u-28440?\u20998? \u-31683?\u22320?\u31687?\u-230?\u-29406?\u21153?\u20154?Excel\u23454?\u21153?\u26696?\u20363?\u-31683?\u22320?\u24212?\u29992?\u31934?\u-29774?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u-247?\u24212?\u25910?\u-29402?\u27454?\u23545?\u-29402?\u20989?\u21046?\u20316?\u-28729?\u31243?\u31934?\u-29774?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u-247?\u23567?\u-30268?\u27169?\u32435?\u31246?\u20154?\u-27056?\u-26467?\u-29791?\u31639?\u-30616?\u21046?\u20316?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u-247?\u-25896?\u25928?\u25353?\u-28440?\u-27160?\u25286?\u20998?\u24037?\u-29372?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u-247?\u-27402?\u-30644?\u25215?\u20817?\u27719?\u31080?\u21040?\u26399?\u25552?\u-28270?\u-30616?\u26684?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u-247?\u24555?\u-28641?\u19968?\u23545?\u22810?\u26597?\u25214?\u21592?\u24037?\u-27402?\u-30644?\u21345?\u21495?\u20844?\u24335?\u-29762?\u32622?\u25216?\u24039?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u-247?\u21033?\u29992?\u20989?\u25968?\u25110?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u21046?\u20316?\u24212?\u25910?\u-29402?\u27454?\u-29402?\u-24700?\u20998?\u26512?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u22235?\u12289?\u24037?\u20855?\u31687?\u-230? \u21033?\u29992?Excel\u30340?\u31532?\u19977?\u26041?\u25554?\u20214?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u24555?\u-28641?\u21512?\u24182?\u24037?\u20316?\u31807?\u19982?\u25286?\u20998?\u24037?\u20316?\u31807?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u25968?\u25454?\u23545?\u27604?\u8212?\u8212?\u30456?\u21516?\u-26503?\u19982?\u19981?\u21516?\u-26503?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u22312?\u25209?\u27880?\u-28212?\u-28709?\u-30644?\u26597?\u25214?\u19982?\u26367?\u25442?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u22914?\u20309?\u24555?\u-28641?\u21019?\u24314?\u24102?\u26377?\u-29307?\u-27394?\u25509?\u30340?\u24037?\u20316?\u-30616?\u30446?\u24405?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u24555?\u-28641?\u19977?\u-28820?\u25442?\u-248?\u20844?\u24335?\u-28820?\u25968?\u20540?\u12289?\u25991?\u26412?\u22411?\u25968?\u23383?\u-28820?\u25968?\u20540?\u12289?\u25968?\u20540?\u-28820?\u25991?\u26412?\u22411?\u25968?\u23383?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6\u12289?\u21019?\u24314?\u25991?\u20214?\u-27394?\u25509?\u21015?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-27068?\u24405?\u-230?Vlookup\u30340?10\u22823?\u24120?\u-30271?\u-27367?\u-29713? (\u-29774?\u24072?\u21407?\u21019?)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 a)\u25552?\u-28270?Vlookup\u20989?\u25968?\u30340?\u31532?\u20108?\u21442?\u25968?\u24212?\u24403?\u-29762?\u32622?\u20026?\u32477?\u23545?\u24341?\u29992?\u-244?\u20197?\u20445?\u-29759?\u22312?\u30456?\u23545?\u24341?\u29992?\u26102?\u-244?\u24341?\u29992?\u21306?\u22495?\u19981?\u21457?\u29983?\u21464?\u21270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 b)\u27880?\u24847?Vlookup\u21442?\u25968?1\u30340?\u25968?\u25454?\u31867?\u22411?\u19982?\u21442?\u25968?2\u26368?\u24038?\u21015?\u30340?\u25968?\u25454?\u31867?\u22411?\u19968?\u-32268?\u-244?\u21487?\u29992?\u30334?\u21464?\u31934?\u28789?Text\u20989?\u25968?\u-28709?\u-30644?\u25209?\u-28209?\u30340?\u26684?\u24335?\u21270?\u25991?\u26412?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 c)Vlookup\u20989?\u25968?\u21482?\u21487?\u20197?\u20174?\u24038?\u24448?\u21491?\u26597?\u25214?\u-244?\u19981?\u-32515?\u20174?\u21491?\u21521?\u20570?\u26597?\u25214?\u-244?\u22914?\u26524?\u24819?\u20174?\u21491?\u21521?\u20570?\u26597?\u25214?\u-244?\u21487?\u20197?\u21033?\u29992?INDEX\u21644?MATCH\u20004?\u20010?\u20989?\u25968?\u23884?\u22871?\u-30237?\u20915?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 d)Vlookup\u20989?\u25968?\u30340?\u31532?\u22235?\u21442?\u25968?\u-244?\u29992?\u20110?\u20915?\u23450?Vlookup\u26159?\u31934?\u30830?\u26597?\u25214?\u25110?\u27169?\u31946?\u26597?\u25214?\u-244?\u31934?\u30830?\u26597?\u25214?\u21442?\u25968?\u20026?FALSE\u25110?0\u-244?\u27169?\u31946?\u26597?\u25214?\u21442?\u25968?\u20026?TRUE\u25110?1\u-244?\u22914?\u26524?\u31532?\u22235?\u21442?\u25968?\u25972?\u20307?\u32570?\u30465?\u-244?\u21017?\u20989?\u25968?\u20026?\u27169?\u31946?\u26597?\u25214?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 e)Vlookup\u22312?\u24341?\u29992?\u21516?\u19968?\u24352?\u24037?\u20316?\u-31356?\u-28212?\u30340?\u25968?\u25454?\u28304?\u26102?\u-248?\u21253?\u25324?\u21516?\u24037?\u20316?\u31807?\u-28212?\u30340?\u19981?\u21516?\u24037?\u20316?\u-30616?\u-247?\u31532?\u20108?\u21442?\u25968?\u-24872?\u-29788?\u20026?\u30456?\u23545?\u24341?\u29992?\u-244?\u-32756?\u22312?\u24341?\u29992?\u20854?\u20182?\u24037?\u20316?\u-31356?\u30340?\u25968?\u25454?\u28304?\u26102?\u-24872?\u-29788?\u20026?\u32477?\u23545?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 f)Vlookup\u30340?\u31532?\u19968?\u21442?\u25968?\u-244?\u22240?\u20174?EPR\u-28817?\u20214?\u-28212?\u23548?\u20986?\u25968?\u25454?\u26377?\u21518?\u32512?\u31354?\u26684?\u-244?\u21487?\u20197?\u29992?\u20998?\u21015?\u21151?\u-32515?\u25110?\u-32763?TRIM\u20989?\u25968?\u21024?\u25481?\u31354?\u26684?\u-244?\u21028?\u26029?\u31532?\u19968?\u21442?\u25968?\u26159?\u21542?\u26377?\u21518?\u32512?\u31354?\u26684?\u-244?\u21487?\u20197?\u29992?LEN\u20989?\u25968?\u21028?\u26029?\u25991?\u26412?\u-27265?\u24230?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 g)\u22914?\u26524?Vlookup\u20989?\u25968?\u-28716?\u22238?#N/A\u-248?\u21253?\u25324?MATCH\u20989?\u25968?\u-247?,\u20195?\u-30616?\u31532?\u19968?\u21442?\u25968?\u22312?\u31532?\u20108?\u21442?\u25968?\u30340?\u26368?\u24038?\u21015?\u27809?\u26377?\u25214?\u21040?\u20540?\u-244?\u27492?\u26102?\u21487?\u20197?\u29992?IFERROR\u20989?\u25968?\u23884?\u22871?\u20351?\u29992?\u-244?\u-28738?\u21040?\u25490?\u-27367?\u21151?\u-32515?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 h)\u22914?\u26524?vlookup\u30340?\u31532?\u19977?\u21442?\u25968?\u22823?\u20110?\u31532?\u20108?\u21442?\u25968?\u21015?\u30340?\u21015?\u25968?\u24635?\u-29791?\u-244?\u21017?Vlookup\u-28716?\u22238?#REF!\u-27367?\u-29713?\u-244?\u20999?\u-29776?\u20351?\u29992?\u20989?\u25968?\u26102?\u-244?\u19981?\u24471?\u20135?\u29983?\u-28613?\u-28783?\u21028?\u26029?\u30340?\u-27367?\u-29713?\u-244?\u20989?\u25968?\u20351?\u29992?\u26159?\u-26880?\u-30335?\u20005?\u-29656?\u30340?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 i)Vlookup\u20989?\u25968?\u22312?\u-28709?\u-30644?\u31934?\u30830?\u26597?\u25214?\u30340?\u26102?\u20505?\u-244?\u-28716?\u22238?\u30340?\u20540?\u22987?\u32456?\u-28419?\u26159?\u31532?\u20108?\u21442?\u25968?\u26368?\u20808?\u20986?\u29616?\u30340?\u20540?\u-244?\u20989?\u25968?\u26412?\u-29013?\u24182?\u19981?\u-32515?\u-28709?\u-30644?\u19968?\u23545?\u22810?\u30340?\u26597?\u25214?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 j)Vlookup\u20989?\u25968?\u-28709?\u-30644?\u-28706?\u32493?\u22810?\u21015?\u26597?\u25214?\u26102?\u-244?\u21487?\u20197?\u19982?COLUMN\u20989?\u25968?\u25645?\u-28339?\u-244?\u23545?Vlookup\u31532?\u19977?\u21442?\u25968?\u-28709?\u-30644?\u21160?\u24577?\u24341?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u24635?\u32467?\u19982?\u29616?\u22330?\u31572?\u30097?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u28487?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 CTA\u27880?\u20876?\u31246?\u21153?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20013?\u32423?\u20250?\u-29791?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-30337?\u24037?\u22823?\u24494?\u-28817?\u-29788?\u-29759?\u20013?\u24515?Excel\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29406?\u20250?\u25104?\u-27265?\u23398?\u-32047?\u29305?\u-32680?Excel\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22825?\u22320?\u22521?\u-29779?Excel\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u20219?\u-230?\u24179?\u23433?\u23551?\u-27031? \u-26492?\u31639?\u31649?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u20219?\u-230?\u20013?\u-28589?\u-29406?\u31246? \u21672?\u-29726?\u22521?\u-29779?\u32463?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u29616?\u20219?\u-230?\u19975?\u-29372?\u26143?\u28023?\u31246?\u21153?\u24072?\u20107?\u21153?\u25152? \u-26503?\u30446?\u32463?\u29702?/\u-29406?\u31246?\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25797?\u-27265?\u-26490?\u22495?\u-230?Excel\u22312?\u-29406?\u21153?\u-28212?\u30340?\u24212?\u29992?\u-244?Excel\u20989?\u25968?\u19982?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-244?Excel\u25968?\u25454?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u23454?\u25112?\u32463?\u-25972?\u-230?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u28487?\u26408?\u-32767?\u24072?\u25317?\u26377?14\u24180?\u-29406?\u31246?\u24037?\u20316?\u32463?\u21382?\u-229?\u29616?\u20219?\u26576?\u31246?\u21153?\u24072?\u20107?\u21153?\u25152?\u-26503?\u30446?\u32463?\u29702?\u-244?\u21271?\u20140?\u-29406?\u20250?\u25104?\u-27265?\u23398?\u-32047?\u29305?\u-32680?Excel\u-29774?\u24072?\u-244?\u-30337?\u24037?\u22823?\u24494?\u-28817?\u-29788?\u-29759?\u20013?\u24515?Excel\u29305?\u-32680?\u-29774?\u24072?\u-244?\u25797?\u-27265?Excel\u20989?\u25968?\u21644?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-244?\u25484?\u25569?\u30340?\u20989?\u25968?\u-29307?\u-28729?100\u20010?\u-244?\u25484?\u25569?Excel Vba\u31243?\u24207?\u-29762?\u-29791?\u-29715?\u-30208?\u-244?\u25797?\u-27265?Excel\u19982?\u-29406?\u21153?\u23454?\u-27067?\u24037?\u20316?\u30456?\u32467?\u21512?\u21644?\u21033?\u29992?Excel\u-28709?\u-30644?\u-29406?\u21153?\u20998?\u26512?\u-244?\u21407?\u21019?\u24320?\u21457?\u12298?\u-29406?\u21153?Excel\u20174?\u20837?\u-27160?\u21040?\u31934?\u-28646?\u31995?\u32479?\u23398?\u20064?\u29677?\u12299?\u12289?\u12298?Excel\u30340?\u27494?\u21151?\u31192?\u31821?\u8212?\u8212?\u25171?\u-28646?\u20320?\u25104?\u20026?Excel\u-25896?\u25163?\u30340?\u20219?\u30563?\u20108?\u-32503?\u12299?\u31561?\u-29698?\u31243?\u20307?\u31995?\u-244?Excel\u25480?\u-29698?\u-28738?\u21040?100\u22330?\u-244?\u25480?\u-29698?\u28608?\u24773?\u24189?\u-24872?\u-244?\u-30549?\u23398?\u21592?\u31216?\u20026?\u8220?\u-30644?\u-29328?\u30340?Excel\u25216?\u24039?\u24211?\u8221?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u-28440?\u20998?\u25480?\u-29698?\u26696?\u20363?\u-230?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22825?\u22320?\u22521?\u-29779?\u23454?\u-29779?\u-29698?\u31243?\u12298?\u20250?\u-29791?\u29609?\u-28820?Excel\u12299?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20013?\u-28589?\u-29406?\u31246?\u-24892?\u22484?\u29677?\u12298?\u19978?\u24093?\u30340?\u-30266?\u-30254?\u30475?\u25968?\u25454?\u8212?\u-29406?\u21153?\u29609?\u-28820?Excel\u12299?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29406?\u20250?\u25104?\u-27265?\u23398?\u-32047? \u12298?\u-29406?\u21153?Excel\u20174?\u20837?\u-27160?\u21040?\u31934?\u-28646?\u31995?\u32479?\u23398?\u20064?\u29677?\u12299?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20027?\u-29774?\u-29698?\u31243?\u-230?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12298?\u19978?\u24093?\u30340?\u-30266?\u-30254?\u30475?\u25968?\u25454?\u8212?\u-29406?\u21153?\u29609?\u-28820?Excel\u12299?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12298?Excel\u30340?\u27494?\u21151?\u31192?\u31821?\u8212?\u8212?\u25171?\u-28646?\u20320?\u25104?\u20026?Excel\u-25896?\u25163?\u30340?\u20219?\u30563?\u20108?\u-32503?\u12299?\u31561?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u25480?\u-29698?\u-26418?\u26684?\u-230?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u28487?\u26408?\u-32767?\u24072?\u30340?\u-29698?\u31243?\u25480?\u-29698?\u28608?\u24773?\u24189?\u-24872?\u12289?\u28145?\u20837?\u27973?\u20986?\u12289?\u26696?\u20363?\u20016?\u23500?\u12289?\u-29715?\u-30208?\u-28646?\u20439?\u26131?\u25026?\u-244?\u21892?\u20110?\u23558?\u22797?\u26434?\u-27154?\u-26472?\u31616?\u21333?\u21270?\u12289?\u-29698?\u31243?\u20013?\u30340?\u-29768?\u22810?\u26696?\u20363?\u22343?\u26469?\u28304?\u23454?\u25112?\u32463?\u-25972?\u-244?\u-26786?\u24120?\u21892?\u20110?\u25226?\u25569?\u23458?\u25143?\u-26880?\u27714?\u-244?\u20048?\u20110?\u20542?\u21548?\u23398?\u21592?\u30340?\u25552?\u-27154?\u-244?\u20174?\u-32756?\u23637?\u24320?\u26377?\u-27512?\u23545?\u24615?\u30340?\u-29774?\u25480?\u-244?\u24110?\u21161?\u23398?\u21592?\u-30835?\u20250?\u-29393?\u-28646?\u12289?\u23398?\u20197?\u-32268?\u29992?\u12290?\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}