{\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\u22312?\u24037?\u20316?\u20013?\u30340?\u23454?\u25112?\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 MKT027837\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/gkk3/027837.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 Excel\u22312?\u24037?\u20316?\u20013?\u30340?\u23454?\u25112?\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?07\u26376?10\u26085? \u21040? 2025\u24180?07\u26376?10\u26085? \u26477?\u24030? 1080\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?07\u26376?25\u26085? \u21040? 2024\u24180?07\u26376?25\u26085? \u26477?\u24030? 1080\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2023\u24180?12\u26376?28\u26085? \u21040? 2023\u24180?12\u26376?28\u26085? \u26477?\u24030? 1080\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/gkk3/027837.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u26477?\u24030?\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-32564?\u26223?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u32463?\u-244?\u20320?\u26159?\u21542?\u-26782?\u23545?\u22797?\u26434?\u30340?\u25968?\u25454?\u26463?\u25163?\u26080?\u31574?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u32463?\u-244?\u20320?\u26159?\u21542?\u25171?\u24320?\u25968?\u21313?\u20010?\u25968?\u25454?\u-30616?\u26080?\u-32694?\u30340?\u22797?\u21046?\u31896?\u-29388?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u32463?\u-244?\u20320?\u26159?\u21542?\u20026?\u20934?\u22791?\u19968?\u20010?\u-29406?\u21153?\u25253?\u-30616?\u-28706?\u32493?\u21152?\u29677?\u19968?\u21608?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26366?\u32463?\u-244?\u20320?\u26159?\u21542?\u24635?\u-30263?\u24471?\u26377?\u26356?\u-25896?\u25928?\u30340?\u26041?\u27861?\u20998?\u26512?\u25968?\u25454?\u21364?\u22987?\u32456?\u23547?\u-32756?\u19981?\u24471?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23545?\u24378?\u22823?\u30340?\u25968?\u25454?\u24037?\u20855?\u32570?\u20047?\u-29788?\u-29754?\u19982?\u20102?\u-30237?\u-244?\u-27059?\u20302?\u20102?\u25105?\u20204?\u24037?\u20316?\u30340?\u20934?\u30830?\u24230?\u-244?\u25439?\u22833?\u20102?\u24040?\u-28209?\u30340?\u26102?\u-27148?\u-244?\u-28640?\u25104?\u20225?\u19994?\u-29372?\u28304?\u30340?\u22823?\u24133?\u28010?\u-29383?\u-32756?\u25105?\u20204?\u21364?\u24448?\u24448?\u-30266?\u-32756?\u19981?\u-30271?\u12290?\u26159?\u26102?\u20505?\u-29723?\u25552?\u-25896?\u25105?\u20204?\u30340?Excel\u25805?\u20316?\u27700?\u24179?\u21862?\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 1\u12289?\u-29372?\u28145?\u24494?\u-28817?\u-29788?\u-29759?\u-29774?\u24072?\u-244?\u25277?\u19997?\u21093?\u-31961?\u-244?\u20840?\u-26782?\u-28657?\u-30266?Excel\u24037?\u20316?\u-30616?\u31649?\u29702?\u12289?\u25968?\u25454?\u24211?\u21015?\u-30616?\u12289?\u20844?\u24335?\u19982?\u20989?\u25968?\u12289?\u25968?\u25454?\u26597?\u-29726?\u12289?\u25968?\u25454?\u32479?\u-29791?\u20998?\u26512?\u12289?\u22270?\u-30616?\u-29762?\u-29791?\u12289?\u23439?\u19982?\u25511?\u20214?\u31561?\u19971?\u22823?\u26680?\u24515?\u24212?\u29992?\u27169?\u22359?\u-244?\u24110?\u21161?\u23398?\u21592?\u25484?\u25569?Excel\u-25896?\u32423?\u24212?\u29992?\u25216?\u24039?\u-255?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u20174?\u20225?\u19994?\u29992?\u25143?\u-26880?\u27714?\u20986?\u21457?\u-244?\u23558?Excel\u30340?\u26680?\u24515?\u21151?\u-32515?\u-28646?\u-28729?\u26412?\u-29698?\u31243?\u30340?\u22521?\u-29779?\u26377?\u25928?\u-28214?\u25918?\u20986?\u26469?\u-255?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u26412?\u-29698?\u31243?\u31934?\u-28663?\u26469?\u-32278?\u22810?\u20010?\u-30644?\u19994?\u23458?\u25143?\u30340?\u30005?\u23376?\u-30616?\u26684?\u26696?\u20363?\u-244?\u-28646?\u29992?\u19988?\u23454?\u29992?\u-244?\u24110?\u21161?\u23398?\u21592?\u-30237?\u20915?\u26085?\u30410?\u22797?\u26434?\u30340?\u22522?\u20110?\u30005?\u23376?\u-30616?\u26684?\u30340?\u25968?\u25454?\u22788?\u29702?\u20219?\u21153?\u-255?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u21442?\u21152?\u23545?\u-29599?\u-230?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21508?\u-28440?\u-27160?\u32463?\u29702?\u12289?\u20027?\u31649?\u12289?\u19987?\u21592?\u12289?\u21161?\u29702?\u-244?excel\u29233?\u22909?\u-32763?\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 \u27169?\u22359?\u19968?\u12289?\u26681?\u22522?\u-230?\u25216?\u27861?\u31649?\u31397?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1. \u25171?\u-28646?\u20219?\u30563?\u20108?\u-32503?\u-244?\u21407?\u26469?Excel\u23601?\u26159?\u-28711?\u20040?\u31616?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u27934?\u24713?Excel\u-30616?\u26684?\u30028?\u30340?\u-28641?\u25104?\u24515?\u27861?\u-230?\u28165?\u21333?\u21644?\u25253?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u24314?\u31435?\u21512?\u29702?\u30340?\u-30616?\u26684?\u32467?\u26500?\u-230?\u-29788?\u-29754?\u25968?\u25454?\u-30268?\u-31997?\u21644?\u31867?\u22411?\u12289?\u26126?\u30830?\u27491?\u30830?\u25645?\u24314?\u-30616?\u32467?\u26500?\u30340?\u25511?\u21046?\u20869?\u23481?\u-244?\u20197?\u21450?\u21019?\u24314?\u-30616?\u26684?\u-28729?\u31243?\u30340?\u27880?\u24847?\u20107?\u-26503?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u26368?\u31616?\u21333?\u26368?\u30465?\u24515?\u30340?3\u20010?1\u24037?\u20316?\u27169?\u24335?\u-230?1\u20010?\u24037?\u20316?\u31807?1\u20010?\u24037?\u20316?\u-30616?1\u20010?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u25968?\u25454?\u26377?\u25928?\u24615?\u21046?\u20316?\u19979?\u25289?\u26694?\u21450?\u20108?\u32423?\u26377?\u25928?\u24615?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u24207?\u21015?\u30340?\u25968?\u25454?\u26469?\u28304?\u22312?\u24403?\u21069?\u-30616?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u24207?\u21015?\u30340?\u25968?\u25454?\u26469?\u28304?\u22312?\u-26786?\u24403?\u21069?\u-30616?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u24688?\u24403?\u30340?\u26377?\u25928?\u24615?\u-29762?\u-29791?\u20250?\u-29783?\u20320?\u30340?\u-30616?\u26684?\u22635?\u25253?\u26356?\u-28805?\u26494?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3. \u8220?\u-28706?\u20307?\u8221?\u25968?\u25454?\u30340?\u24555?\u-28641?\u20998?\u24320?\u19982?\u21512?\u25104?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u25968?\u25454?\u20998?\u24320?\u19982?\u21512?\u25104?\u-28419?\u26377?\u-32278?\u24049?\u30340?\u-29774?\u31350?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u25968?\u25454?\u20998?\u21015?\u24110?\u24744?\u24555?\u-28641?\u20998?\u24320?\u-28706?\u20307?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20108?\u12289?\u27719?\u24635?\u-230?\u20989?\u25968?\u20844?\u24335?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4. \u20989?\u25968?\u20844?\u24335?\u22522?\u30784?\u-230?\u19981?\u20250?\u32477?\u23545?\u24341?\u29992?\u21644?\u30456?\u23545?\u24341?\u29992?\u23601?\u19981?\u20250?\u20889?\u20989?\u25968?\u20844?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u20989?\u25968?\u20837?\u-27160?\u31532?\u19968?\u20851?\u-244?\u20320?\u19981?\u21487?\u20197?\u-28669?\u-28545?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u21333?\u20803?\u26684?\u22320?\u22336?\u30340?\u24341?\u29992?\u26377?4\u31181?\u24418?\u24335?\u-230?\u20840?\u-27391?\u12289?\u-27391?\u-30644?\u12289?\u-27391?\u21015?\u12289?\u19981?\u-27391?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5. \u25253?\u-30616?\u27719?\u24635?\u22522?\u26412?\u20989?\u25968?\u-230?\u21333?\u26465?\u20214?\u19982?\u22810?\u26465?\u20214?\u-29791?\u25968?\u20989?\u25968?(1)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u21333?\u26465?\u20214?\u-29791?\u25968?\u20989?\u25968? --COUNTIF(range, criteria)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u22810?\u26465?\u20214?\u-29791?\u25968?\u20989?\u25968?\u-248?\u27604?\u22914?3\u20010?\u26465?\u20214?\u30340?\u-29791?\u25968?\u-247?--\u29992?COUNTIF\u20989?\u25968?\u21487?\u20197?\u21527?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6. \u25253?\u-30616?\u27719?\u24635?\u22522?\u26412?\u20989?\u25968?\u-230?\u21333?\u26465?\u20214?\u19982?\u22810?\u26465?\u20214?\u27714?\u21644?\u20989?\u25968?(2)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u21333?\u26465?\u20214?\u27714?\u21644?\u20989?\u25968? --SUMIF(range, criteria, [sum_range])\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u22810?\u26465?\u20214?\u27714?\u21644?\u20989?\u25968?\u-248?\u27604?\u22914?3\u20010?\u26465?\u20214?\u30340?\u-29791?\u25968?\u-247?--\u29992?SUMIF\u20989?\u25968?\u21487?\u20197?\u21527?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7. \u25968?\u25454?\u26597?\u-29726?\u22522?\u26412?\u20989?\u25968?\u-230?\u31934?\u30830?\u19982?\u27169?\u31946?\u26597?\u25214?\u20989?\u25968?(3)\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u31934?\u30830?\u26597?\u25214?\u20989?\u25968? -- VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\u-244?\u20854?\u20013?range_lookup\u20026?0\u25110?FALSE\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u27169?\u31946?\u26597?\u25214?\u20989?\u25968?-- VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\u-244?\u20854?\u20013?range_lookup\u20026?1\u25110?TRUE\u-244?table_array\u-26218?\u21015?\u24517?\u-26501?\u26159?\u21319?\u24207?\u25490?\u21015?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19977?\u12289?\u22270?\u-30616?\u-230?\u28436?\u32462?\u-29301?\u21183?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8. \u21160?\u24577?\u22270?\u-30616?\u20043?\u22797?\u-28663?\u26694?\u22270?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 * \u22270?\u-30616?\u-25772?\u26415?\u-230?\u21033?\u29992?\u22797?\u-28663?\u26694?\u25511?\u20214?\u21644?\u20989?\u25968?\u21046?\u20316?\u26032?\u30340?\u22270?\u-30616?\u25968?\u25454?\u28304?\u-244?\u20174?\u-32756?\u-29762?\u-29791?\u20986?\u19968?\u20010?\u-32515?\u-26993?\u-24800?\u26631?\u21246?\u-28663?\u19981?\u21516?\u22797?\u-28663?\u26694?\u-32756?\u20132?\u20114?\u21464?\u21270?\u30340?\u22270?\u-30616?\u-244?\u-28711?\u32477?\u23545?\u-32515?\u-29783?\u24744?\u30340?\u-32767?\u26495?\u30524?\u21069?\u19968?\u20142?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u26446?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 Office\u19994?\u21153?\u24212?\u29992?\u-30237?\u20915?\u26041?\u26696?\u19987?\u23478?\u-229?\u-29372?\u28145?\u23454?\u25112?\u22411?Excel\u12289?PPT\u12289?Word\u22521?\u-29779?\u-29774?\u24072?\u-229?10\u24180?Excel\u30740?\u31350?\u32463?\u21382?\u12289?6\u24180?PPT\u25991?\u26696?\u-29762?\u-29791?\u23454?\u25112?\u32463?\u-25972?\u-229?\u24494?\u-28817?\u-29788?\u-29759?Excel\u-25896?\u32423?\u22521?\u-29779?\u24072?\u-229?PPT\u21576?\u29616?\u-26490?\u22495?\u-29372?\u28145?\u30740?\u31350?\u-32763?\u-229?\u20225?\u19994?\u20449?\u24687?\u21270?\u-26490?\u22495?\u-29372?\u28145?\u19994?\u21153?\u19987?\u-229?\u26366?\u20219?\u30693?\u21517?\u-26938?\u22242?\u20844?\u21496?\u-248?\u24040?\u20154?\u-26938?\u22242?\u-247?\u19994?\u21153?\u31995?\u32479?\u23454?\u26045?\u32463?\u29702?\u12289?\u25968?\u25454?\u25903?\u25345?\u-25896?\u32423?\u32463?\u29702?\u12289?\u-28720?\u-31707?\u24635?\u30417?\u21161?\u29702?\u31561?\u-32692?\u-229?\u26366?\u-29409?\u-29405?\u23454?\u26045?\u-26938?\u22242?\u20449?\u24687?\u21270?\u24314?\u-29762?\u-248?\u21253?\u25324?\u24191?\u21578?\u20419?\u-27392?\u-29383?\u29992?\u31649?\u29702?\u24179?\u21488?\u21450?SAP ERP\u31995?\u32479?\u23454?\u26045?\u12289?\u27969?\u31243?\u20877?\u-28640?\u21450?\u31995?\u32479?\u32500?\u25252?\u-247?\u-229?\u-28719?10\u24180?\u30340?\u20844?\u21496?\u26680?\u24515?\u23703?\u20301?\u30340?\u19994?\u21153?\u32463?\u-25972?\u-244?\u29087?\u24713?\u25972?\u20010?\u20844?\u21496?\u30340?\u-31707?\u-28720?\u31649?\u29702?\u12289?\u-29406?\u21153?\u31649?\u29702?\u12289?\u20449?\u24687?\u21270?\u31649?\u29702?\u20197?\u21450?\u20154?\u20107?\u-30644?\u25919?\u31649?\u29702?\u24037?\u20316?\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}