{\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 \u25171?\u-28640?\u-25896?\u32489?\u25928?\u-29406?\u21153?\u22242?\u-27105?\u8212?Excel\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u-25896?\u-27082?\u-29779?\u32451?\u-31707?\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u32534?\u21495?\u12305?\u-230?\f0\fs22\b MKT056413\b0\par\pard\plain\s0\fi0\li0\ri0\sa140\plain\f0\fs22 \u12304?\u-29698?\u31243?\u21517?\u31216?\u12305?\u-230?\f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk9/056413.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u25171?\u-28640?\u-25896?\u32489?\u25928?\u-29406?\u21153?\u22242?\u-27105?\u8212?Excel\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u-25896?\u-27082?\u-29779?\u32451?\u-31707?\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\sa140\plain\f0\fs22 \u12304?\u24320?\u-29698?\u26102?\u-27148?\u12305?\u-230?2025\u24180?05\u26376?06\u26085? \u21040? 2025\u24180?05\u26376?07\u26085? \u27784?\u-27085? 3600\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?06\u26376?20\u26085? \u21040? 2024\u24180?06\u26376?21\u26085? \u22826?\u21407? 3600\u20803?/\u20301?\par\pard\plain\s0\fi1500\li0\ri0\sa140\plain\f0\fs22\cf3 2024\u24180?06\u26376?18\u26085? \u21040? 2024\u24180?06\u26376?19\u26085? \u22823?\u-28706? 3600\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?\u22826?\u21407?\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk8/051544.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u22823?\u-28706?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk9/058249.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u27784?\u-27085?\ul0 }}\f0\fs22  \f0{\field{\*\fldinst HYPERLINK //www.apparel77.com/gkk9/056413.html}{\fldrslt \pard\plain\f0\fs22\ul\cf2 \u-27265?\u26149?\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?\u-29406?\u21153?\u22242?\u-27105? Excel\u22521?\u-29779?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u25105?\u-30335?\u25253?\u21517?\b0\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u21672?\u-29726?\u30005?\u-29731?\u-230?027-5111 9925 , 027-5111 9926\par\pard\plain\s0\fi400\li0\ri0\plain\f0\fs22 \u20540?\u29677?\u25163?\u26426?\u-230?18971071887    \u-28498?\u31665?\u-230?Service@mingketang.com\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u-29698?\u31243?\u-29722?\u24773?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-26993?\u30528?\u22823?\u25968?\u25454?\u26102?\u20195?\u30340?\u24102?\u26469?\u-244?\u25968?\u25454?\u-29302?\u26469?\u-29302?\u25104?\u20026?\u20225?\u19994?\u26368?\u23453?\u-29387?\u30340?\u-29372?\u28304?\u12290?\u20294?\u26159?\u24456?\u22810?\u20225?\u19994?\u21364?\u27809?\u26377?\u28145?\u20837?\u30340?\u25366?\u25496?\u-26992?\u-31281?\u22312?\u25968?\u25454?\u-32564?\u21518?\u30340?\u32463?\u-31707?\u31649?\u29702?\u20449?\u24687?\u-244?\u20351?\u24471?\u25968?\u25454?\u-29372?\u20135?\u27809?\u26377?\u21457?\u25381?\u24212?\u26377?\u30340?\u20215?\u20540?\u12290?\u26412?\u-29698?\u31243?\u30340?\u20027?\u-30335?\u30446?\u30340?\u22312?\u20110?\u25552?\u-25896?\u23398?\u21592?\u30340?\u25968?\u25454?\u20998?\u26512?\u25216?\u24039?\u-244?\u22521?\u20859?\u23398?\u21592?\u-28646?\u-28729?\u25968?\u25454?\u20998?\u26512?\u24471?\u20986?\u32463?\u-31707?\u31649?\u29702?\u20449?\u24687?\u30340?\u25216?\u-32515?\u-244?\u20026?\u31185?\u23398?\u20915?\u31574?\u25171?\u19979?\u22362?\u23454?\u30340?\u22522?\u30784?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u22522?\u20110?excel\u24212?\u29992?\u30340?\u24191?\u27867?\u24615?\u-244?\u20197?\u21450?\u25968?\u25454?\u23545?\u20110?\u20225?\u19994?\u31649?\u29702?\u30340?\u-28211?\u-30335?\u24615?\u-244?\u23398?\u22909?Excel\u24050?\u32463?\u19981?\u26159?\u-32692?\u22330?\u30340?\u-28663?\u20462?\u-29698?\u-244?\u-32756?\u26159?\u24517?\u20462?\u-29698?\u12290?\u26080?\u-29766?\u20320?\u20170?\u22825?\u26159?\u-32692?\u21592?\u-244?\u-28712?\u26159?\u26410?\u26469?\u-30335?\u32452?\u24314?\u22242?\u-27105?\u-244?\u29978?\u-32269?\u-30335?\u25104?\u20026?\u20225?\u19994?\u30340?\u20915?\u31574?\u-32763?\u-244?\u8220?\u25968?\u25454?\u31649?\u29702?\u-32515?\u21147?\u8221?\u-28419?\u20250?\u25345?\u32493?\u30340?\u24433?\u21709?\u20320?\u-244?\u21464?\u25104?\u20320?\u30340?\u32709?\u-32384?\u25110?\u-32763?\u25104?\u20026?\u20320?\u30340?\u25507?\u-32616?\u12290?\u30446?\u21069?\u22312?\u26377?\u24456?\u22810?\u24037?\u20316?\u20013?\u-244?\u31616?\u21333?\u30340?Excel\u25216?\u-32515?\u24050?\u32463?\u19981?\u-32515?\u28385?\u-29261?\u25105?\u20204?\u30340?\u21150?\u20844?\u-26880?\u27714?\u-244?\u-32756?\u26159?\u-26880?\u-30335?\u25105?\u20204?\u25484?\u25569?\u26356?\u-25896?\u-27082?\u30340?Excel\u23454?\u25112?\u24212?\u29992?\u25216?\u-32515?\u12290?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u12304?\u-29698?\u31243?\u25910?\u30410?\u12305?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-28646?\u-28729?\u-29698?\u31243?\u20351?\u23398?\u21592?\u28165?\u26970?\u-29788?\u-29754?\u-30268?\u-31997?\u25968?\u25454?\u30340?\u-28211?\u-30335?\u24615?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-28217?\u29992?\u20225?\u19994?\u30495?\u23454?\u26696?\u20363?\u-244?\u32467?\u21512?Office\u-28817?\u20214?\u21151?\u-32515?\u-244?\u25484?\u25569?\u25968?\u25454?\u24605?\u32500?\u22312?\u26085?\u24120?\u24037?\u20316?\u30340?\u24212?\u29992?\u-229?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-28646?\u-28729?\u26412?\u27425?\u-29698?\u31243?\u-244?\u-29783?\u23398?\u21592?\u20204?\u22312?\u32534?\u21046?\u25253?\u-30616?\u26102?\u21578?\u21035?\u32439?\u32321?\u22797?\u26434?\u30340?\u20989?\u25968?\u20844?\u24335?\u-244?\u-29783?\u24037?\u20316?\u22238?\u21040?\u31616?\u21333?\u19982?\u26234?\u-32515?\u-229?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u12304?\u-27512?\u23545?\u20154?\u32676?\u12305?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29406?\u21153?\u32463?\u29702?\u12289?\u31246?\u21153?\u32463?\u29702?\u12289?\u-29406?\u21153?\u24635?\u30417?\u12289?\u31246?\u21153?\u24635?\u30417?\u-244?\u20250?\u-29791?\u20197?\u21450?\u32463?\u24120?\u-28646?\u-28729?Excel\u22788?\u29702?\u25968?\u25454?\u12289?\u20998?\u26512?\u25968?\u25454?\u30340?\u20154?\u21592?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u12304?\u-29698?\u31243?\u22823?\u32434?\u12305?\b0\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19968?\u12289?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u22522?\u30784?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u25945?\u23398?\u30446?\u30340?\u12305?\u27627?\u19981?\u22840?\u24352?\u30340?\u-29708?\u-244?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u26159?Excel\u26368?\u-28211?\u-30335?\u30340?\u21151?\u-32515?\u-244?\u-29723?\u24037?\u20855?\u21487?\u20197?\u31435?\u20307?\u21270?\u30340?\u20998?\u26512?\u25968?\u25454?\u-244?\u22810?\u32500?\u24230?\u30340?\u-30270?\u23519?\u20998?\u26512?\u25968?\u25454?\u-244?\u26159?\u24037?\u20316?\u20013?\u26368?\u23454?\u29992?\u12289?\u24182?\u19988?\u24456?\u26131?\u29992?\u30340?\u24037?\u20855?\u-244?\u23398?\u21592?\u21153?\u24517?\u25484?\u25569?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u32467?\u26500?\u20171?\u32461?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2.\u21046?\u20316?\u22522?\u26412?\u30340?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3.\u32467?\u26500?\u30334?\u20998?\u27604?\u12289?\u29615?\u27604?\u12289?\u29615?\u27604?\u30334?\u20998?\u27604?\u25253?\u-30616?\u30340?\u21046?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4.\u21160?\u24577?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u21046?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5.\u20999?\u29255?\u22120?\u12289?\u26085?\u31243?\u-30616?\u22312?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20013?\u30340?\u24212?\u29992?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6.\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u20197?\u21450?\u22270?\u-30616?\u30340?\u32467?\u21512?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20108?\u12289?\u-29406?\u21153?\u25968?\u25454?\u22788?\u29702?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u25945?\u23398?\u30446?\u30340?\u12305?Power Query\u-28711?\u20010?\u21151?\u-32515?\u26159?\u-32278?Excel\u20986?\u29616?\u20197?\u26469?\u26368?\u-25896?\u25928?\u30340?\u19968?\u-26503?\u21151?\u-32515?\u-244?\u20182?\u21487?\u20197?\u-29783?\u25105?\u20204?\u21578?\u21035?\u31616?\u21333?\u12289?\u-28211?\u22797?\u24615?\u30340?\u21171?\u21160?\u-244?\u-29783?\u26085?\u24120?\u30340?\u25968?\u25454?\u27719?\u24635?\u12289?\u-28820?\u25442?\u21464?\u24471?\u26356?\u31616?\u21333?\u19982?\u26234?\u-32515?\u-244?\u-28711?\u23601?\u22909?\u27604?\u26159?\u19968?\u20010?\u8220?\u26234?\u-32515?\u21270?\u30340?\u25968?\u25511?\u26426?\u24202?\u8221?\u-244?\u21482?\u-30335?\u25105?\u20204?\u23558?\u21508?\u-26503?\u31243?\u24207?\u32452?\u21512?\u22312?\u19968?\u-29321?\u-244?\u20182?\u23601?\u20250?\u24110?\u21161?\u25105?\u20204?\u-32278?\u21160?\u30340?\u21435?\u22788?\u29702?\u12289?\u-28820?\u25442?\u25968?\u25454?\u-244?\u23558?\u23453?\u-29387?\u30340?\u26102?\u-27148?\u29992?\u22312?\u26356?\u26377?\u20215?\u20540?\u30340?\u24037?\u20316?\u24403?\u20013?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 (\u19968?) \u-28805?\u26494?\u27719?\u24635?\u28023?\u-28209?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u21160?\u24577?\u27719?\u24635?\u21333?\u20803?\u26684?\u21306?\u22495?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u26234?\u-32515?\u27719?\u24635?\u24037?\u20316?\u31807?\u19979?\u30340?\u25152?\u26377?\u24037?\u20316?\u-30616?\u25968?\u25454?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u31649?\u29702?\u-29383?\u29992?\u30475?\u26495?\u21046?\u20316?\u-248?Power Query\u19982?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u32467?\u21512?\u24212?\u29992?\u-244?\u-30237?\u20915?\u21333?Excel\u25991?\u20214?\u20013?\u22810?\u24352?\u24037?\u20316?\u-30616?\u25163?\u24037?\u25968?\u25454?\u27719?\u24635?\u-27154?\u-26472?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u26234?\u-32515?\u27719?\u24635?\u25351?\u23450?\u25991?\u20214?\u22841?\u19979?\u30340?\u24037?\u20316?\u31807?\u25968?\u25454?\u-248?\u22810?\u25991?\u20214?\u22841?\u22810?Excel\u25991?\u20214?\u25968?\u25454?\u21512?\u24182?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u-27392?\u21806?\u20998?\u26512?\u30475?\u26495?\u21046?\u20316?\u-248?\u-30237?\u20915?\u19968?\u20010?\u25991?\u20214?\u22841?\u20013?\u-244?\u22810?\u20010?Excel\u24037?\u20316?\u31807?\u22810?\u24352?\u24037?\u20316?\u-30616?\u25163?\u24037?\u25968?\u25454?\u27719?\u24635?\u-27154?\u-26472?\u-247?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u23398?\u20064?\u25910?\u-31817?\u12305?\u-230?\u26085?\u24120?\u24037?\u20316?\u20013?\u22914?\u28041?\u21450?\u21040?\u22823?\u-28209?\u30340?\u25968?\u25454?\u-26880?\u-30335?\u27719?\u24635?\u-244?\u24120?\u29992?\u30340?\u26041?\u27861?\u26159?\u-28211?\u22797?\u30340?\u22797?\u21046?\u12289?\u31896?\u-29388?\u-244?\u-28646?\u-28729?\u25968?\u25454?\u-31817?\u21462?\u21151?\u-32515?\u-244?\u21487?\u20197?\u21578?\u21035?\u-28211?\u22797?\u30340?\u22797?\u21046?\u12289?\u31896?\u-29388?\u-244?\u24182?\u19988?\u-28712?\u21487?\u20197?\u23454?\u29616?\u21407?\u22987?\u25968?\u25454?\u26356?\u26032?\u21518?\u-244?\u27719?\u24635?\u25968?\u25454?\u-26993?\u30528?\u26356?\u26032?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 (\u20108?) \u25968?\u25454?\u-28820?\u25442?\u8212?\u8212?\u26085?\u24120?\u24037?\u20316?\u-30616?\u25968?\u25454?\u24555?\u-28641?\u28165?\u27927?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u19981?\u-30268?\u21017?\u25968?\u25454?\u22788?\u29702?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u22635?\u20805?\u-230?\u21578?\u21035?\u21462?\u28040?\u21512?\u24182?\u21333?\u20803?\u26684?\u21518?\u30340?\u25209?\u-28209?\u22635?\u20805?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u21512?\u24182?\u26597?\u-29726?\u-230?\u20174?\u27492?\u21578?\u21035?VLOOKUP\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u-28666?\u-28657?\u-30266?\u-230?\u30636?\u-27148?\u23436?\u25104?\u20108?\u32500?\u-30616?\u-28820?\u19968?\u32500?\u-30616?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5\u12289?\u20351?\u29992?Power Query\u32534?\u-28783?\u22120?\u30340?\u27880?\u24847?\u20107?\u-26503?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u23398?\u20064?\u25910?\u-31817?\u12305?\u-230?\u26085?\u24120?\u24037?\u20316?\u20013?\u19981?\u20165?\u-26880?\u-30335?\u22823?\u-28209?\u30340?\u25968?\u25454?\u27719?\u24635?\u-244?\u-28712?\u20250?\u28041?\u21450?\u21040?\u23545?\u19981?\u-30268?\u-31997?\u25968?\u25454?\u26684?\u24335?\u30340?\u26356?\u25913?\u12289?\u25209?\u-28209?\u22635?\u20805?\u12289?\u26367?\u25442?\u31561?\u25805?\u20316?\u-244?\u-28646?\u-28729?\u26412?\u31456?\u-32126?\u30340?\u23398?\u20064?\u-244?\u21487?\u20197?\u-29783?\u23398?\u21592?\u21578?\u21035?\u26085?\u24120?\u24037?\u20316?\u20013?\u-28509?\u20123?\u22522?\u30784?\u12289?\u-28211?\u22797?\u30340?Excel\u25805?\u20316?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u19977?\u12289?\u-29406?\u21153?\u25968?\u25454?\u20998?\u26512?\u19982?\u24314?\u27169?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u25945?\u23398?\u30446?\u30340?\u12305?Power Pivot\u26159?Excel 20\u24180?\u26469?\u26368?\u22823?\u-26775?\u26032?\u25216?\u26415?\u-244?\u20182?\u21487?\u20197?\u-29783?\u19981?\u-26880?\u-30335?\u25026?\u25216?\u26415?\u30340?\u20154?\u21592?\u-244?\u24555?\u-28641?\u23436?\u25104?\u25968?\u25454?\u27169?\u22411?\u30340?\u25645?\u24314?\u20197?\u21450?\u24555?\u-28641?\u30340?\u20986?\u23616?\u20998?\u26512?\u25253?\u21578?\u-244?\u19981?\u20165?\u26159?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u30340?\u21152?\u24378?\u29256?\u26412?\u-248?\u-29307?\u32423?\u25968?\u25454?\u-28657?\u-30266?\u-30616?\u-247?\u-28712?\u26159?\u21830?\u19994?\u26234?\u-32515?\u21487?\u-30266?\u21270?\u20998?\u26512?\u-248?BI\u-247?\u30340?\u22522?\u30784?\u26680?\u24515?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1. \u25968?\u25454?\u27169?\u22411?\u-248?PowerPivot\u-247?\u31616?\u20171?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u-29788?\u-29754?DAX\u25968?\u25454?\u20998?\u26512?\u-30616?\u-28738?\u24335?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u24179?\u22343?\u-29790?\u21333?\u-27392?\u21806?\u-26467?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3. \u20351?\u29992? DAX \u-30616?\u-28738?\u24335?\u-28709?\u-30644?\u25968?\u25454?\u-29791?\u31639?\u21644?\u20998?\u26512?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 a) \u20351?\u29992? CALCULATE \u20989?\u25968?\u-28709?\u-30644?\u-29791?\u31639?\u21644?\u-28729?\u28388?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 b) \u20351?\u29992? SUMX \u20989?\u25968?\u23545?\u-30616?\u20013?\u30340?\u27599?\u19968?\u-30644?\u-28709?\u-30644?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 c) \u20351?\u29992? AVERAGE \u20989?\u25968?\u-29791?\u31639?\u24179?\u22343?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 d) \u20351?\u29992? COUNT\u20989?\u25968?\u-29791?\u31639?\u25968?\u-28209?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 e) \u20351?\u29992? MIN \u21644? MAX \u20989?\u25968?\u-29791?\u31639?\u26368?\u23567?\u20540?\u21644?\u26368?\u22823?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 f) \u20351?\u29992? RANKX \u20989?\u25968?\u-28709?\u-30644?\u25490?\u21517?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 g) \u20351?\u29992? FILTER \u20989?\u25968?\u-28709?\u-30644?\u25968?\u25454?\u31579?\u-28663?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 h) \u20351?\u29992? TOPN \u20989?\u25968?\u-28716?\u22238?\u21069? N \u20010?\u-30644?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 i) \u20351?\u29992? RELATED \u20989?\u25968?\u-31817?\u21462?\u30456?\u20851?\u-30616?\u20013?\u30340?\u20540?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4. \u26102?\u-27148?\u-30616?\u30340?\u-32278?\u21160?\u29983?\u25104?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5. SWITCH\u-230?\u-29307?\u32423?\u24378?\u22823?\u30340?\u-28613?\u-28783?\u20989?\u25968?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 6. \u20102?\u-30237?\u-27461?\u-28646?\u-230?\u23618?\u23618?\u-28654?\u-28709?\u30340?\u-28709?\u-30644?\u25968?\u25454?\u20998?\u26512?\u24605?\u32500?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u22235?\u12289?\u26102?\u-27148?\u26234?\u-32515?\u20989?\u25968?\u30340?\u-25896?\u32423?\u24212?\u29992?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1. \u26102?\u-27148?\u26234?\u-32515?\u20989?\u25968?\u30340?\u20171?\u32461?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u26399?\u21021?\u-32269?\u20170?\u24635?\u-29791?\u-29791?\u31639?\u-230?\u-28805?\u26494?\u-30237?\u20915?\u32047?\u-29791?\u20540?\u-29791?\u31639?\u30340?\u-27154?\u-26472?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3. \u27604?\u19978?\u20010?\u26102?\u-27148?\u27573?\u22686?\u-27265?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4. \u26399?\u21021?\u-32269?\u20170?\u22686?\u-27265?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 5. \u31227?\u21160?\u24179?\u22343?\u-29791?\u31639?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u26696?\u20363?\u-230?\u22810?\u32500?\u24230?\u21516?\u27604?\u12289?\u29615?\u27604?\u12289?\u22686?\u-27265?\u21516?\u27604?\u30340?\u20998?\u26512?\u25253?\u-30616?\u12289?\u22270?\u-30616?\u21046?\u20316?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u23398?\u20064?\u25910?\u-31817?\u12305?\u-230?\u-29783?\u23398?\u21592?\u21021?\u27493?\u20102?\u-30237?\u24314?\u31435?\u25968?\u25454?\u27169?\u22411?\u30340?\u26041?\u27861?\u12289?\u24605?\u32500?\u-244?\u20197?\u21450?\u-28646?\u-28729?\u25968?\u25454?\u27169?\u22411?\u30340?\u24314?\u31435?\u-244?\u21487?\u20197?\u-28738?\u21040?\u20160?\u20040?\u26679?\u30340?\u25928?\u26524?\u12289?\u28385?\u-29261?\u26085?\u24120?\u24037?\u20316?\u20013?\u21738?\u20123?\u24037?\u20316?\u22330?\u26223?\u-244?\u20197?\u25552?\u-25896?\u26085?\u24120?\u24037?\u20316?\u25928?\u29575?\u12290?\u21516?\u26102?\u-244?\u22312?Excel\u20013?\u23398?\u20250?\u20351?\u29992?PowerPivot\u21518?\u-244?\u21487?\u20197?\u26080?\u32541?\u23545?\u25509?\u-32278?\u21161?\u24335?\u21830?\u19994?\u20998?\u26512?\u-28817?\u20214?Power BI\u-244?\u20197?\u20415?\u20110?\u22312?\u20225?\u19994?\u26085?\u21518?\u30340?\u20998?\u26512?\u20013?\u-28440?\u32626?\u12289?\u20351?\u29992?BI\u-28817?\u20214?\u-244?\u21046?\u20316?\u26356?\u19987?\u19994?\u30340?\u20998?\u26512?\u25253?\u21578?\u19982?\u21508?\u-28440?\u-27160?\u-28709?\u-30644?\u21327?\u20316?\u20998?\u20139?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20116?\u12289?\u32508?\u21512?\u26696?\u20363?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?\u-27392?\u21806?\u20998?\u26512?\u25253?\u21578?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u-27392?\u21806?\u27611?\u21033?\u20998?\u26512?\u25253?\u21578?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 3\u12289?\u-32278?\u21160?\u21270?\u-26492?\u31639?\u21450?\u-26492?\u31639?\u-28738?\u25104?\u20998?\u26512?\u25253?\u21578?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 4\u12289?\u20851?\u-27346?\u32489?\u25928?\u25351?\u26631?KPI\u25253?\u21578?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u12304?\u23398?\u20064?\u25910?\u-31817?\u12305?\u-230?\u-28646?\u-28729?\u24050?\u23398?\u20064?\u30340?\u20869?\u23481?\u-244?\u21046?\u20316?\u32508?\u21512?\u24615?\u30340?\u20998?\u26512?\u25253?\u21578?\u-244?\u20307?\u-25972?\u20132?\u20114?\u24335?\u22270?\u-30616?\u30340?\u20351?\u29992?\u26041?\u27861?\u12290?\par\pard\plain\s0\fi400\li0\ri0\sb40\sa40\sl300\plain\f0\fs22\b \u27169?\u22359?\u20845?\u12289?\u-28709?\u-27082?\u23637?\u31034?\u8212?\u8212?Power BI\u22823?\u25968?\u25454?\u21487?\u-30266?\u21270?\u20998?\u26512?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1\u12289?Power BI\u20171?\u32461?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2\u12289?\u20998?\u26512?\u25253?\u21578?\u26696?\u20363?\u23637?\u31034?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u-29698?\u31243?\u24635?\u32467?\u19982?\u22238?\u-26498?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 1. \u-29698?\u31243?\u20027?\u-30335?\u20869?\u23481?\u24635?\u32467?\u19982?\u22238?\u-26498?\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 2. \u31572?\u30097?\u-30237?\u24785?\par\pard\plain\s0\fi0\li0\ri0\sb60\sa60\sl300\plain\f0\fs24\b \u20184?\u-32767?\u24072?\u20171?\u32461?\b0\par\pard\plain\s0\fi400\li0\ri0\sb80\sl300\plain\f0\fs22 \u20184?\u-32767?\u24072?\u25317?\u26377?\u21313?\u22810?\u24180?\u-29406?\u21153?\u19968?\u32447?\u24037?\u20316?\u32463?\u-25972?\u-244?\u20174?\u22522?\u30784?\u-29406?\u21153?\u24037?\u20316?\u20154?\u21592?\u24320?\u22987?\u-244?\u21382?\u20219?\u21306?\u22495?\u-29406?\u21153?\u20027?\u31649?\u12289?\u-29406?\u21153?\u32463?\u29702?\u12289?\u24635?\u-28440?\u25968?\u25454?\u20998?\u26512?\u21450?\u-26492?\u31639?\u31649?\u29702?\u-28440?\u-27160?\u20027?\u31649?\u-229?\u20219?\u-32692?\u26399?\u-27148?\u21442?\u19982?\u-26938?\u22242?\u20840?\u22269?\u24615?\u30340?\u-29372?\u-28207?\u31995?\u32479?\u12289?\u-29383?\u29992?\u25511?\u21046?\u31995?\u32479?\u30340?\u24320?\u21457?\u21450?\u24314?\u-29762?\u24037?\u20316?\u-229?\u-32278?2015\u24180?\u24320?\u22987?\u23545?\u20225?\u19994?\u21508?\u-28440?\u-27160?\u21592?\u24037?\u-28709?\u-30644?Excel\u12289?PPT\u31561?\u21150?\u20844?\u-28817?\u20214?\u30340?\u24212?\u29992?\u22521?\u-29779?\u-244?2018\u24320?\u22987?\u20026?\u22810?\u23478?\u20225?\u19994?\u25552?\u20379?\u20869?\u-29779?\u-29698?\u31243?\u-244?\u21516?\u26102?\u20026?\u22810?\u23478?\u20225?\u19994?\u25552?\u20379?\u25968?\u25454?\u20013?\u21488?\u30340?\u24314?\u31435?\u20197?\u21450?\u20010?\u24615?\u21270?\u20998?\u26512?\u20307?\u31995?\u24314?\u-29762?\u12290? \u20184?\u-32767?\u24072?\u32467?\u21512?\u-29406?\u21153?\u12289?\u31246?\u21153?\u12289?\u20154?\u20107?\u12289?\u25968?\u25454?\u20998?\u26512?\u24605?\u32500?\u32467?\u21512?Excel\u12289?Power BI\u-28817?\u20214?\u31561?\u30456?\u20851?\u30693?\u-29754?\u-244?\u32508?\u21512?\u-32278?\u-29013?\u23454?\u-27067?\u24037?\u20316?\u32463?\u-25972?\u-244?\u24110?\u21161?\u23398?\u21592?\u25552?\u-25896?\u26085?\u24120?\u21150?\u20844?\u25216?\u24039?\u-244?\u-28545?\u20813?\u-28211?\u22797?\u24615?\u30340?\u21171?\u21160?\u12290?\u31435?\u24535?\u-29783?\u23398?\u21592?\u19981?\u-30335?\u25104?\u20026?\u25968?\u25454?\u30340?\u25644?\u-28720?\u24037?\u-244?\u-29783?\u23398?\u21592?\u26377?\u26356?\u22810?\u30340?\u26102?\u-27148?\u21435?\u30740?\u31350?\u25968?\u25454?\u-32564?\u21518?\u30340?\u25925?\u20107?\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}