{\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-28709?\u-27082?-\u25968?\u25454?\u32479?\u-29791?\u19982?\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 MKT008444\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/008444.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 Excel\u-28709?\u-27082?-\u25968?\u25454?\u32479?\u-29791?\u19982?\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?\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?27\u26085? \u21040? 2025\u24180?03\u26376?28\u26085? \u21271?\u20140? 4500\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22 2025\u24180?04\u26376?14\u26085? \u21040? 2025\u24180?04\u26376?15\u26085? \u-32049?\u24030? 4500\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22 2025\u24180?04\u26376?24\u26085? \u21040? 2025\u24180?04\u26376?25\u26085? \u19978?\u28023? 4500\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22 2025\u24180?05\u26376?15\u26085? \u21040? 2025\u24180?05\u26376?16\u26085? \u21271?\u20140? 4500\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2025\u24180?02\u26376?17\u26085? \u21040? 2025\u24180?02\u26376?18\u26085? \u19978?\u28023? 4500\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?12\u26376?13\u26085? \u21040? 2024\u24180?12\u26376?14\u26085? \u-32049?\u24030? 4500\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/gkk7/046168.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u28145?\u22323?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk4/035978.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-32049?\u24030?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk4/035977.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u19978?\u28023?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk/008444.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?\u25968?\u25454?\u32479?\u-29791? \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?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23545?\u20110? Excel \u-28711?\u20010?\u24037?\u20855?\u-244?\u25105?\u20204?\u24050?\u32463?\u30693?\u-28589?\u23427?\u24456?\u24378?\u22823?\u-244?\u24182?\u19988?\u24050?\u32463?\u25484?\u25569?\u20102?\u-28797?\u22909?\u30340?\u-28720?\u29992?\u25216?\u-32515?\u12290?\u20294?\u26159?\u22914?\u20309?\u20351?\u29992?\u23427?\u24110?\u21161?\u25105?\u20204?\u20570?\u26356?\u22810?\u30340?\u24037?\u20316?\u12289?\u25552?\u-25896?\u24037?\u20316?\u25928?\u29575?\u-225?\u26412?\u-29698?\u31243?\u-26782?\u21521?\u20855?\u22791?\u19968?\u23450? Excel \u22522?\u30784?\u30340?\u20154?\u21592?\u-244?\u24819?\u-30335?\u-30237?\u20915?\u26356?\u-25896?\u32423?\u30340?\u-26946?\u-26472?\u22914?\u-230?\u22914?\u20309?\u-29783?\u25253?\u-30616?\u-32278?\u21160?\u21270?\u12289?\u-28545?\u20813?\u27599?\u20010?\u26376?\u-28419?\u-30335?\u-28211?\u26032?\u21046?\u20316?\u-225?\u22914?\u20309?\u21046?\u20316?\u28789?\u27963?\u22810?\u21464?\u30340?\u21160?\u24577?\u22270?\u-30616?\u-225?\u24590?\u20040?\u23545?\u20960?\u21313?\u20010?\u12289?\u20960?\u30334?\u20010?\u26684?\u24335?\u30456?\u21516?\u30340? Excel \u25991?\u20214?\u-28709?\u-30644?\u27719?\u24635?\u-225?\u8230?\u8230?\u23398?\u20250?\u20102?\u-26004?\u19978?\u23601?\u-32515?\u29992?\u21040?\u24037?\u20316?\u20013?\u-244?\u-29783?\u25105?\u20204?\u20570?\u25968?\u25454?\u20998?\u26512?\u12289?\u25253?\u-30616?\u30340?\u26102?\u-27148?\u22823?\u22823?\u32553?\u30701?\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 \u20102?\u-30237?\u25968?\u25454?\u20998?\u26512?\u27493?\u-25948?\u-244?\u21450?\u22312?\u-28217?\u-26938?\u25968?\u25454?\u12289?\u21152?\u24037?\u25972?\u21512?\u29615?\u-32126?\u20013?\u25152?\u-26880?\u-30335?\u30340?\u30456?\u20851?\u25216?\u26415?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25484?\u25569?\u25968?\u25454?\u32479?\u-29791?\u20013?\u24120?\u29992?\u30340?\u20989?\u25968?\u22914? COUNTIFS/SUMIFS/IF/VLOOKUP/INDEX/OFFSET \u31561?\u29992?\u27861?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25484?\u25569?\u25968?\u25454?\u20998?\u26512?\u21033?\u22120?\u8212?\u8212?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u26356?\u22810?\u24212?\u29992?\u25216?\u24039?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25484?\u25569?\u24120?\u-30271?\u30340?\u22270?\u-30616?\u21046?\u20316?\u25216?\u24039?\u-244?\u20197?\u21450?\u21033?\u29992?\u20989?\u25968?+\u25511?\u20214?\u21046?\u20316?\u21160?\u24577?\u25253?\u-30616?\u30340?\u25216?\u24039?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25484?\u25569? SQL \u30340?\u22522?\u26412?\u26597?\u-29726?\u-29715?\u27861?\u-244?\u20197?\u21450?\u21033?\u29992? SQL \u23454?\u29616?\u22810?\u-30616?\u21512?\u24182?\u26597?\u-29726?\u25216?\u26415?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20102?\u-30237? VBA \u24320?\u21457?\u29615?\u22659?\u12289?\u22522?\u26412?\u23545?\u-29599?\u27169?\u22411?\u-244?\u25484?\u25569?\u29992? VBA \u23439?\u25209?\u-28209?\u21512?\u24182?\u25968?\u25454?\u30340?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u22521?\u-29779?\u23545?\u-29599?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20174?\u20107?\u20154?\u21147?\u-29372?\u28304?\u12289?\u-29406?\u21153?\u31649?\u29702?\u12289?\u25968?\u25454?\u20998?\u26512?\u12289?\u20449?\u24687?\u25216?\u26415?\u21450?\u31649?\u29702?\u20154?\u21592?\u31561?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26412?\u-29698?\u31243?\u19981?\u26159? Excel \u22522?\u30784?\u-29698?\u-244?\u-30335?\u27714?\u23398?\u21592?\u20855?\u22791?\u19968?\u23450?\u30340?\u-28720?\u29992?\u25216?\u-32515?\u-244?\u20363?\u22914?\u-230?\u26085?\u24120?\u30340?\u-30616?\u26684?\u26684?\u24335?\u-29762?\u32622?\u12289?\u25171?\u21360?\u-29762?\u32622?\u31561?\u25805?\u20316?\u25216?\u24039?\u-244?\u20197?\u21450?\u24120?\u29992?\u30340?\u24555?\u25463?\u-27346?\u-229?\u20250?\u23545?\u25968?\u25454?\u20316?\u31579?\u-28663?\u19982?\u25490?\u24207?\u22788?\u29702?\u-229?\u22522?\u26412?\u30340?\u32479?\u-29791?\u20989?\u25968?\u22914?SUM/AVERAGE/COUNT/MIN/MAX\u-229?\u22522?\u26412?\u30340?\u25991?\u26412?\u22788?\u29702?\u20989?\u25968?\u22914? LEN/TRIM/LEFT/RIGHT\u-229?\u22522?\u26412?\u26085?\u26399?\u-29791?\u31639?\u20989?\u25968?\u22914? TODAY/NOW/YEAR/MONTH/DAY\u-229?\u20250?\u21046?\u20316?\u26609?\u24418?\u22270?\u12289?\u25240?\u32447?\u22270?\u12289?\u-26244?\u22270?\u12289?\u26465?\u24418?\u22270?\u31561?\u-244?\u24182?\u20250?\u-29762?\u32622?\u22270?\u-30616?\u24120?\u-30271?\u30340?\u21442?\u25968?\u-229?\u20250?\u20351?\u29992?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-28709?\u-30644?\u31616?\u21333?\u30340?\u25253?\u-30616?\u21046?\u20316?\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 \u19968?\u12289?\u25968?\u25454?\u20998?\u26512?\u27010?\u-28688?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \u25968?\u25454?\u20998?\u26512?\u22522?\u26412?\u24605?\u-29201?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u26126?\u30830?\u30446?\u30340?\u-230?\u20998?\u26512?\u30340?\u-27154?\u-26472?\u26159?\u20160?\u20040?\u-225?\u24819?\u-25972?\u-29759?\u20160?\u20040?\u-30270?\u28857?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u-28217?\u-26938?\u25968?\u25454?\u-230?\u25968?\u25454?\u20174?\u21738?\u-28212?\u26469?\u-225?\u22914?\u20309?\u-28217?\u-26938?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u21152?\u24037?\u25972?\u21512?\u-230?\u25968?\u25454?\u19981?\u-30268?\u-31997?\u-244?\u22914?\u20309?\u-28820?\u21270?\u12289?\u25552?\u21462?\u12289?\u31579?\u-28663?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u20998?\u26512?\u21576?\u29616?\u-230?\u20351?\u29992?\u20160?\u20040?\u20998?\u26512?\u26041?\u27861?\u12289?\u20998?\u26512?\u24037?\u20855?\u-225?\u24590?\u20040?\u21576?\u29616?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6 \u25253?\u21578?\u25776?\u20889?\u-230?\u24471?\u20986?\u20102?\u21738?\u20123?\u32467?\u-29766?\u-225?\u24590?\u20040?\u32452?\u32455?\u23436?\u25972?\u30340?\u25253?\u21578?\u20869?\u23481?\u-225?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20108?\u12289?\u-28217?\u-26938?\u25968?\u25454?\u-230?\u-30268?\u-31997?\u30340?\u-30616?\u26684?\u26356?\u21033?\u20110?\u20998?\u26512?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 Excel \u20013?\u30340?\u20004?\u31181?\u-30616?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u-30268?\u-31997?\u30340?\u25968?\u25454?\u24211?\u-30616?\u26684?\u-29762?\u-29791?\u-30335?\u27714?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u21046?\u20316?\u25968?\u25454?\u-28217?\u-26938?\u27169?\u26495?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u-27056?\u21046?\u-28781?\u20837?\u25968?\u20540?/\u26085?\u26399?\u30340?\u31867?\u22411?\u19982?\u-31997?\u22260?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u-27056?\u21046?\u25152?\u-28781?\u20837?\u25991?\u26412?\u30340?\u23383?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u21046?\u20316?\u19979?\u25289?\u26694?\u21450?\u20108?\u32423?\u21160?\u24577?\u19979?\u25289?\u26694?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23545?\u25968?\u25454?\u27169?\u26495?\u28155?\u21152?\u20445?\u25252?\u25514?\u26045?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u-31817?\u21462?\u22806?\u-28440?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23548?\u20837?\u25991?\u26412?\u20013?\u30340?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23548?\u20837?\u22806?\u-28440? Excel \u25991?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19977?\u12289?\u21152?\u24037?\u25972?\u21512?\u-230?\u-30616?\u26684?\u19982?\u25968?\u25454?\u26684?\u24335?\u22788?\u29702?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \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 2 \u20462?\u25913?\u-27367?\u-29713?\u30340?\u25991?\u26412?\u26684?\u24335?\u30340?\u25968?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u-26786?\u27861?\u26684?\u24335?\u30340?\u26085?\u26399?\u24555?\u-28641?\u20462?\u27491?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u21024?\u-27036?\u25968?\u25454?\u20013?\u30340?\u-28211?\u22797?\u20869?\u23481?\u12289?\u21482?\u20445?\u30041?\u21807?\u19968?\u-29776?\u24405?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u23558?\u19968?\u21015?\u20869?\u23481?\u25286?\u20998?\u20026?\u22810?\u21015?\u12289?\u23558?\u22810?\u21015?\u20869?\u23481?\u21512?\u24182?\u21040?\u19968?\u21015?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6 \u31070?\u22855?\u30340?\u24555?\u-28641?\u22635?\u20805?\u-244?\u19968?\u-27346?\u23436?\u25104?\u20998?\u21015?\u19982?\u21512?\u24182?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7 \u25968?\u25454?\u25353?\u26465?\u20214?\u31579?\u-28663?\u19982?\u-26993?\u26426?\u25277?\u26679?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 8 \u25353?\u29031?\u23398?\u21382?/\u-32692?\u21153?/\u22320?\u21306?\u31561?\u25351?\u23450?\u-26502?\u24207?\u-28709?\u-30644?\u25490?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u22235?\u12289?\u20998?\u26512?\u24037?\u20855?\u-230?\u24120?\u29992?\u30340?\u20989?\u25968?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \u30456?\u23545?\u24341?\u29992?\u12289?\u28151?\u21512?\u24341?\u29992?\u19982?\u32477?\u23545?\u24341?\u29992?\u30340?\u21306?\u21035?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u26681?\u25454?\u29305?\u23450?\u26465?\u20214?\u26469?\u-29791?\u25968?\u25110?\u27714?\u21644? COUNTIFS/SUMIFS\u-230?\u-27392?\u21806?\u-29790?\u21333?\u25968?\u19982?\u19994?\u32489?\u32479?\u-29791?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u-28613?\u-28783?\u21028?\u26029?\u20989?\u25968? IF\u-230?\u21028?\u26029?\u-32765?\u-29756?\u26631?\u20934?\u12289?\u-29791?\u31639?\u24037?\u-24700?\u24037?\u-29372?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u26597?\u25214?\u24341?\u29992?\u20989?\u25968?\u-230?VLOOKUP/INDEX/MATCH\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u26085?\u26399?\u20989?\u25968?\u-230?DATE/EOMONTH/DATEDIF/WEEKDAY\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6 \u25991?\u26412?\u22788?\u29702?\u20989?\u25968?\u-230?MID/FIND\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 7 \u26497?\u20540?\u19982?\u25490?\u21517?\u-29791?\u31639?\u-230?LARGE/SMALL/RANK\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20116?\u12289?\u20998?\u26512?\u24037?\u20855?\u-230?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \u-28657?\u-30266?\u-30616?\u21019?\u24314?\u19982?\u24212?\u29992?\u-230?\u25353?\u-28440?\u-27160?\u12289?\u22320?\u21306?\u12289?\u20154?\u21592?\u31561?\u22810?\u32500?\u24230?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u-29762?\u32622?\u20540?\u27719?\u24635?\u20381?\u25454?\u21644?\u30334?\u20998?\u27604?\u26174?\u31034?\u26041?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u22312?\u-28657?\u-30266?\u-30616?\u20013?\u31579?\u-28663?\u21450?\u25490?\u24207?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u32452?\u21512?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23545?\u26085?\u26399?\u29983?\u25104?\u24180?\u24230?/\u23395?\u24230?/\u26376?\u24230?\u25253?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23545?\u25968?\u20540?\u25353?\u19981?\u21516?\u21306?\u-27148?\u20998?\u32452?\u32479?\u-29791?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23545?\u25991?\u26412?\u23383?\u27573?\u32452?\u21512?\u20998?\u31867?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u28155?\u21152?\u20998?\u31867?\u27719?\u24635?\u24182?\u23621?\u20013?\u26174?\u31034?\u24102?\u26631?\u31614?\u30340?\u21333?\u20803?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6 \u21019?\u24314?\u25968?\u25454?\u-28657?\u-30266?\u22270?\u-230?\u19982?\u19978?\u19968?\u24180?\u24230?\u19994?\u32489?\u21516?\u27604?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20845?\u12289?\u20998?\u26512?\u21576?\u29616?\u-230?\u22270?\u-30616?\u21046?\u20316?\u25216?\u24039?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \u21452?\u22352?\u26631?\u-28812?\u22270?\u-30616?\u-230?\u25968?\u25454?\u24046?\u24322?\u-28797?\u22823?\u30340?\u31995?\u21015?\u32472?\u21046?\u22312?\u19968?\u24352?\u22270?\u-30616?\u20013?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u-30616?\u-28738?\u23454?\u-27067?\u19994?\u32489?\u19982?\u-29791?\u21010?\u19994?\u32489?\u27604?\u-28797?\u12289?\u30456?\u21516?\u25351?\u26631?\u30340?\u23545?\u27604?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u22312?\u26609?\u24418?\u22270?\u19978?\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 \u28431?\u26007?\u22270?\u26174?\u31034?\u-28656?\u27493?\u31579?\u-28663?\u-28729?\u31243?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u21046?\u20316?\u-27392?\u21806?\u19994?\u32489?\u-28656?\u26376?\u-29217?\u-29142?\u22270?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6 \u26465?\u20214?\u26684?\u24335?\u-230?\u21046?\u20316?\u26465?\u24418?\u22270?\u12289?\u25552?\u31034?\u25968?\u25454?\u24322?\u24120?\u12289?\u21512?\u21516?\u21040?\u26399?\u-32278?\u21160?\u21464?\u-32142?\u25552?\u-28270?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u19971?\u12289?\u-28709?\u-27082?\u25216?\u24039?\u-230?\u19968?\u21171?\u27704?\u-28616?\u30340?\u25253?\u-30616?\u25216?\u26415?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 \u19968?\u21171?\u27704?\u-28616?\u8221?\u25253?\u-30616?\u-30335?\u-30237?\u20915?\u30340?\u20004?\u20010?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 \u21160?\u24577?\u25253?\u-30616?\u25216?\u26415?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u20351?\u29992?\u25968?\u25454?\u-25972?\u-29759?+\u20989?\u25968?\u21046?\u20316?\u-230?\u19981?\u21516?\u20998?\u20844?\u21496?\u20135?\u21697?\u-27392?\u-28209?\u23545?\u27604?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u20351?\u29992?\u20989?\u25968?+\u25511?\u20214?\u21046?\u20316?\u-230?\u25353?\u-28440?\u-27160?\u26597?\u30475?\u-29383?\u29992?\u25903?\u20986?\u26126?\u32454?\u12289?\u28378?\u21160?\u26174?\u31034?\u26368?\u26032? N \u20010?\u26376?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u21046?\u20316?\u20132?\u20114?\u24335?\u21160?\u24577?\u-28657?\u-30266?\u-30616?\u-230?\u25353?\u24180?/\u26376?/\u22320?\u21306?/\u20135?\u21697?\u31561?\u22810?\u32500?\u24230?\u-32278?\u30001?\u32452?\u21512?\u26465?\u20214?\u26597?\u30475?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 \u25968?\u25454?\u28304?\u22686?\u21152?\u20102?\u22914?\u20309?\u-28675?\u21152?\u21040?\u25253?\u-30616?\u20013?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u22312?\u20989?\u25968?\u25253?\u-30616?\u20013?\u31616?\u21333?\u26131?\u-30644?\u30340?\u-30237?\u20915?\u26041?\u26696?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u20351?\u29992? OFFSET \u20989?\u25968?\u23450?\u20041?\u21160?\u24577?\u25968?\u25454?\u28304?\u21306?\u22495?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u20351?\u29992?\u-30616?\u26684?\u-29783?\u25968?\u25454?\u28304?\u26377?\u22686?\u21152?\u26102?\u25253?\u-30616?\u26356?\u26041?\u20415?\u30340?\u21047?\u26032?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4 \u25968?\u32452?\u20844?\u24335?\u30340?\u27010?\u24565?\u21450?\u22522?\u26412?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u25968?\u32452?\u21450?\u32500?\u24230?\u30340?\u27010?\u24565?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u25968?\u32452?\u20844?\u24335?\u30340?\u-28781?\u20837?\u26041?\u27861?\u19982?\u-28720?\u31639?\u21407?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u24212?\u29992?\u26696?\u20363?\u-230?\u27714?\u32489?\u25928?\u24635?\u20998?\u25968?\u12289?\u23454?\u29616? VLOOKUP \u21521?\u24038?/\u22810?\u20851?\u-27346?\u23383?\u26597?\u25214?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23558?\u19981?\u26029?\u21464?\u21270?\u30340?\u21517?\u21333?\u-32278?\u21160?\u25552?\u21462?\u20026?\u19981?\u-28211?\u22797?\u30340?\u21517?\u21333?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5 \u21033?\u29992? SQL \u26597?\u-29726?\u23454?\u29616?\u22810?\u-30616?\u21512?\u24182?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23545?\u21516?\u19968?\u24037?\u20316?\u31807?\u20013?\u26684?\u24335?\u30456?\u21516?\u30340?\u22810?\u24352?\u-30616?\u26684?\u21512?\u24182?\u26597?\u-29726?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u20851?\u-32684?\u26597?\u-29726?\u21516?\u19968?\u24037?\u20316?\u31807?\u20013?\u22810?\u24352?\u-30616?\u30340?\u19981?\u21516?\u23383?\u27573?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u21512?\u24182?\u27719?\u24635?\u19981?\u21516?\u24037?\u20316?\u31807?\u20013?\u30340?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u20843?\u12289?\u-28709?\u-27082?\u25216?\u24039?\u-230?\u24102?\u20320?\u-28709?\u20837?\u31070?\u31192?\u30340? VBA \u27583?\u22530?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1 VBA \u24320?\u21457?\u22522?\u30784?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u29087?\u24713? VBA \u24320?\u21457?\u29615?\u22659?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u25191?\u-30644? VBA \u31243?\u24207?\u30340?\u20960?\u31181?\u26041?\u27861?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u26465?\u20214?\u-29715?\u21477?\u19982?\u24490?\u29615?\u-29715?\u21477?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u-28729?\u31243?\u19982?\u20989?\u25968?\u-230?\u24320?\u21457?\u19968?\u20010?\u-32278?\u23450?\u20041?\u20989?\u25968?\u24182?\u22312?\u24037?\u20316?\u-30616?\u20013?\u20351?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2 Excel VBA \u24120?\u29992?\u23545?\u-29599?\u30340?\u-28720?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? Workbook/Worksheet/Range \u23545?\u-29599?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? Sheets \u19982? Selection\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23454?\u20363?\u-28720?\u29992?\u-230?\u-29701?\u21462?\u25110?\u20462?\u25913?\u21333?\u20803?\u26684?\u20013?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u23454?\u20363?\u-28720?\u29992?\u-230?\u26681?\u25454?\u25351?\u23450?\u21517?\u21333?\u25209?\u-28209?\u21019?\u24314?\u24037?\u20316?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3 VBA \u24320?\u21457?\u23454?\u25112?\u26696?\u20363?\u-30237?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u21512?\u24182?\u21516?\u19968?\u20010?\u24037?\u20316?\u-31356?\u20013?\u26684?\u24335?\u30456?\u21516?\u30340?\u22810?\u24352?\u24037?\u20316?\u-30616?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u-29701?\u21462?\u19968?\u20010?\u30446?\u24405?\u19979?\u25152?\u26377? Excel \u25991?\u20214?\u20013?\u30340?\u20869?\u23481?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u25209?\u-28209?\u25171?\u21360?\u22995?\u21517?\u29260?\u24037?\u20855?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u10146? \u26576?\u20844?\u21496?\u24037?\u-29372?\u25253?\u-30616?\u29983?\u25104?\u31995?\u32479?\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 \u19987?\u19994?\u-32564?\u26223?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-32678?\u28966?\u20110? Excel/PPT \u-25896?\u25928?\u21150?\u20844?\u24212?\u29992?\u-244?\u24494?\u-28817?\u-29788?\u-29759? Office \u19987?\u23478?\u-244?\u20013?\u20851?\u26449?\u20154?\u25165?\u24066?\u22330?\u29305?\u-32680?\u-29774?\u24072?\u-244?\u21271?\u20140?\u22521?\u-29779?\u-30644?\u19994?\u-32684?\u21512?\u20250?\u29702?\u20107?\u-244?\u22269?\u23478?\u-32692?\u19994?\u-29372?\u26684?\u-29788?\u-29759?\u20225?\u19994?\u22521?\u-29779?\u24072?\u-244?2013 \u24180?\u-31901?\u-31817?\u25628?\u29392?\u8220?\u26368?\u20339? Excel \u23454?\u25112?\u-29774?\u24072?\u8221?\u-244?2016 \u24180?\u-31901?\u-31817?\u32593?\u26131?\u8220?\u24180?\u24230?\u-26418?\u20113?\u30334?\u24378?\u-29774?\u24072?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u25480?\u-29698?\u-26418?\u26684?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u23454?\u25112?\u26696?\u20363?\u-230?\u20351?\u29992?\u20225?\u20107?\u19994?\u21333?\u20301?\u24037?\u20316?\u22330?\u26223?\u20013?\u30340?\u30495?\u23454?\u26696?\u20363?\u-244?\u23398?\u21592?\u23398?\u20250?\u20102?\u31435?\u-26004?\u-32515?\u29992?\u21040?\u24037?\u20316?\u20013?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u21551?\u21457?\u24341?\u23548?\u-230?\u24503?\u23453?\u-32767?\u24072?\u30340?\u-29698?\u31243?\u-28589?\u12289?\u26415?\u32467?\u21512?\u12290?\u23545?\u20110?\u-28589?\u-244?\u19981?\u26159?\u29983?\u30828?\u30340?\u28748?\u-28781?\u-28589?\u29702?\u-244?\u-32756?\u26159?\u-28646?\u-28729?\u26696?\u20363?\u23545?\u27604?\u-29783?\u23398?\u21592?\u-32278?\u24049?\u24863?\u24735?\u21040?\u-229?\u23545?\u20110?\u26415?\u-244?\u24503?\u23453?\u-32767?\u24072?\u20250?\u20146?\u-32278?\u31034?\u-31997?\u25805?\u20316?\u-244?\u24182?\u21152?\u20197?\u24713?\u24515?\u25351?\u23548?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20005?\u-29656?\u27835?\u23398?\u-230?\u-29788?\u30495?\u23545?\u24453?\u27599?\u19968?\u22530?\u-29698?\u12289?\u27599?\u19968?\u20301?\u23398?\u21592?\u12289?\u27599?\u19968?\u20010?\u-27154?\u-26472?\u12290?\u25480?\u-29698?\u31283?\u-28211?\u20013?\u20063?\u19981?\u20047?\u24189?\u-24872?\u-244?\u20294?\u23545?\u20110?\u21482?\u-28675?\u27714?\u-29698?\u22530?\u28909?\u-27143?\u27668?\u27675?\u-32756?\u19981?\u-29774?\u31350?\u23454?\u25928?\u30340?\u23458?\u25143?\u-244?\u-29705?\u21247?\u-28544?\u-29705?\u24503?\u23453?\u-32767?\u24072?\u25480?\u-29698?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26381?\u21153?\u20225?\u19994?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u31070?\u21326?\u-26938?\u22242?\u12289?\u20013?\u28023?\u27833?\u12289?\u20013?\u30707?\u21270?\u12289?\u22235?\u24029?\u30465?\u30005?\u21147?\u31185?\u23398?\u-27038?\u12289?\u26032?\u28010?\u32593?\u12289?\u25628?\u25151?\u32593?\u12289?\u20964?\u20976?\u32593?\u12289?\u21271?\u20140?\u26131?\u23453?\u25903?\u20184?\u-244?\u22269?\u30005?\u20449?\u12289?\u22823?\u21776?\u30005?\u20449?\u12289?\u21271?\u20140?\u30005?\u20449?\u12289?\u21271?\u20140?\u-32684?\u-28646?\u12289?\u19978?\u28023?\u30005?\u20449?\u-244?\u24314?\u-29762?\u-27402?\u-30644?\u23665?\u19996?\u20998?\u-30644?\u12289?\u20013?\u22269?\u20892?\u19994?\u-27402?\u-30644?\u12289?\u25104?\u-28419?\u-27402?\u-30644?\u12289?\u21253?\u21830?\u-27402?\u-30644?\u-244?\u20013?\u22269?\u31185?\u25216?\u22823?\u23398?\u12289?\u21335?\u24320?\u22823?\u23398?\u12289?\u22269?\u23478?\u24320?\u25918?\u22823?\u23398?\u12289?\u21271?\u20140?\u31185?\u25216?\u22823?\u23398?\u-244?\u-26218?\u-28419?\u26426?\u22330?\u12289?\u21335?\u26041?\u-32214?\u31354?\u12289?\u20013?\u22269?\u-28641?\u-28654?\u29289?\u27969?\u-248?EMS\u-247?\u12289?\u27784?\u-27085?\u19977?\u26143?\u30005?\u23376?\u12289?\u29305?\u27493?\u-26938?\u22242?\u12289?\u22825?\u27941?\u23500?\u21147?\u22478?\u12289?\u20013?\u31918?\u-26938?\u22242?\u12289?\u-31591?\u29275?\u-26938?\u22242?\u12289?\u26477?\u24030?\u19992?\u27604?\u12289?\u-31995?\u21488?\u-26938?\u22242?\u30333?\u-28207?\u-28334?\u-244?\u19996?\u-26418?\u27773?\u-28826?\u-26938?\u22242?\u12289?\u27779?\u23572?\u27779?\u-248?\u19978?\u28023?\u-247?\u12289?\u20013?\u22269?\u27773?\u-28826?\u30740?\u31350?\u20013?\u24515?\u12289?\u21335?\u20140?\u27773?\u-28826?\u12289?\u22855?\u29790?\u25463?\u-29575?\u-29201?\u-31154?...........\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}