数据透视表--实例教程一.xls

数据透视表--实例教程一.xls

《数据透视表--实例教程一.xls》由会员分享，可在线阅读，更多相关《数据透视表--实例教程一.xls（18页珍藏版）》请在冰点文库上搜索。

国国家家/地地区区销销售售人人员员订订单单金金额额订订单单日日期期订订单单IDID英国Buchanan￥440.007/16/200310248英国Suyama￥1,863.407/10/200310249美国Peacock￥1,552.607/12/200310250美国Leverling￥654.067/15/200310251美国Peacock￥3,597.907/11/200310252美国Leverling￥1,444.807/16/200310253英国Buchanan￥556.627/23/200310254英国Dodsworth￥2,490.507/15/200310255美国Leverling￥517.807/17/200310256美国Peacock￥1,119.907/22/200310257美国Davolio￥1,614.887/23/200310258美国Peacock￥100.807/25/200310259美国Peacock￥1,504.657/29/200310260美国Peacock￥448.007/30/200310261美国Callahan￥584.007/25/200310262英国Dodsworth￥1,873.807/31/200310263英国Suyama￥695.628/23/200310264美国Fuller￥1,176.008/12/200310265美国Leverling￥346.567/31/200310266美国Peacock￥3,536.608/6/200310267美国Callahan￥1,101.208/2/200310268英国Buchanan￥642.208/9/200310269美国Davolio￥1,376.008/2/200310270英国Suyama￥48.008/30/200310271英国Suyama￥1,456.008/6/200310272美国Leverling￥2,037.288/12/200310273英国Suyama￥538.608/16/200310274美国Davolio￥291.848/9/200310275美国Callahan￥420.008/14/200310276美国Fuller￥1,200.808/13/200310277美国Callahan￥1,488.808/16/200310278美国Callahan￥351.008/16/200310279美国Fuller￥613.209/12/200310280美国Peacock￥86.508/21/200310281美国Peacock￥155.408/21/200310282美国Leverling￥1,414.808/23/200310283美国Peacock￥1,170.378/27/200310284美国Davolio￥1,743.368/26/200310285美国Callahan￥3,016.008/30/200310286美国Callahan￥819.008/28/200310287美国Peacock￥80.109/3/200310288英国King￥479.408/28/200310289美国Callahan￥2,169.009/3/200310290英国Suyama￥497.529/4/200310291美国Davolio￥1,296.009/2/200310292美国Davolio￥848.709/11/200310293MicrosoftWordDocument练习指导美国Peacock￥1,887.609/5/200310294美国Fuller￥121.609/10/200310295英国Suyama￥1,050.609/11/200310296英国Buchanan￥1,420.009/10/200310297英国Suyama￥2,645.009/11/200310298美国Peacock￥349.509/13/200310299美国Fuller￥608.009/18/200310300美国Callahan￥755.009/17/200310301美国Peacock￥2,708.8010/9/200310302英国King￥1,117.809/18/200310303美国Davolio￥954.409/17/200310304美国Callahan￥3,741.3010/9/200310305美国Davolio￥498.509/23/200310306美国Fuller￥424.009/25/200310307英国King￥88.809/24/200310308美国Leverling￥1,762.0010/23/200310309美国Callahan￥336.009/27/200310310美国Davolio￥268.809/26/200310311美国Fuller￥1,614.8010/3/200310312美国Fuller￥182.4010/4/200310313美国Davolio￥2,094.3010/4/200310314美国Peacock￥516.8010/3/200310315美国Davolio￥2,835.0010/8/200310316英国Suyama￥288.0010/10/200310317美国Callahan￥240.4010/4/200310318英国King￥1,191.2010/11/200310319英国Buchanan￥516.0010/18/200310320美国Leverling￥144.0010/11/200310321英国King￥112.0010/23/200310322美国Peacock￥164.4010/14/200310323英国Dodsworth￥5,275.7110/10/200310324美国Davolio￥1,497.0010/14/200310325美国Peacock￥982.0010/14/200310326美国Fuller￥1,810.0010/14/200310327美国Peacock￥1,168.0010/17/200310328美国Peacock￥4,578.4310/23/200310329美国Leverling￥1,649.0010/28/200310330英国Dodsworth￥88.5010/21/200310331美国Leverling￥1,786.8810/21/200310332英国Buchanan￥877.2010/25/200310333美国Callahan￥144.8010/28/200310334英国King￥2,036.1610/24/200310335英国King￥285.1210/25/200310336美国Peacock￥2,467.0010/29/200310337美国Peacock￥934.5010/29/200310338美国Fuller￥3,354.0011/4/200310339美国Davolio￥2,436.1811/8/200310340英国King￥352.6011/5/200310341美国Peacock￥1,840.6411/4/200310342美国Peacock￥1,584.0011/6/200310343美国Peacock￥2,296.0011/5/200310344美国Fuller￥2,924.8011/11/200310345美国Leverling￥1,618.8811/8/200310346美国Peacock￥814.4211/8/200310347美国Peacock￥363.6011/15/200310348英国King￥141.6011/15/200310349英国Suyama￥642.0612/3/200310350美国Davolio￥5,398.7211/20/200310351美国Leverling￥136.3011/18/200310352英国King￥8,593.2811/25/200310353美国Callahan￥568.8011/20/200310354英国Suyama￥480.0011/20/200310355英国Suyama￥1,106.4011/27/200310356美国Davolio￥1,167.6812/2/200310357英国Buchanan￥429.4011/27/200310358英国Buchanan￥3,471.6811/26/200310359美国Peacock￥7,390.2012/2/200310360美国Davolio￥2,046.2412/3/200310361美国Leverling￥1,549.6011/28/200310362美国Peacock￥447.2012/4/200310363美国Davolio￥950.0012/4/200310364美国Leverling￥403.2012/2/200310365美国Callahan￥136.0012/30/200310366英国King￥834.2012/2/200310367美国Fuller￥1,689.7812/2/200310368美国Callahan￥2,390.4012/9/200310369英国Suyama￥1,117.6012/27/200310370美国Davolio￥72.9612/24/200310371英国Buchanan￥9,210.9012/9/200310372美国Peacock￥1,366.4012/11/200310373美国Davolio￥459.0012/9/200310374美国Leverling￥338.0012/9/200310375美国Davolio￥399.0012/13/200310376美国Davolio￥863.6012/13/200310377英国Buchanan￥103.2012/19/200310378美国Fuller￥863.2812/13/200310379美国Callahan￥1,313.821/16/200410380美国Leverling￥112.0012/13/200310381美国Peacock￥2,900.0012/16/200310382美国Callahan￥899.0012/18/200310383美国Leverling￥2,222.4012/20/200310384美国Davolio￥691.2012/23/200310385英国Dodsworth￥166.0012/25/200310386美国Davolio￥1,058.4012/20/200310387美国Fuller￥1,228.8012/20/200310388美国Peacock￥1,832.8012/24/200310389英国Suyama￥2,090.8812/26/200310390美国Leverling￥86.4012/31/200310391美国Fuller￥1,440.001/1/200410392美国Davolio￥2,556.951/3/200410393美国Davolio￥442.001/3/200410394英国Suyama￥2,122.921/3/200410395美国Davolio￥1,903.801/6/200410396英国Buchanan￥716.721/2/200410397美国Fuller￥2,505.601/9/200410398美国Callahan￥1,765.601/8/200410399美国Davolio￥3,063.001/16/200410400美国Davolio￥3,868.601/10/200410401美国Callahan￥2,713.501/10/200410402美国Peacock￥855.011/9/200410403美国Fuller￥1,591.251/8/200410404美国Davolio￥400.001/22/200410405英国King￥1,830.781/13/200410406美国Fuller￥1,194.001/30/200410407美国Callahan￥1,622.401/14/200410408美国Leverling￥319.201/14/200410409美国Leverling￥802.001/15/200410410英国Dodsworth￥966.801/21/200410411美国Callahan￥334.801/15/200410412美国Leverling￥2,123.201/16/200410413美国Fuller￥224.831/17/200410414美国Leverling￥102.401/24/200410415美国Callahan￥720.001/27/200410416美国Peacock￥11,188.401/28/200410417美国Peacock￥1,814.801/24/200410418美国Peacock￥2,097.601/30/200410419美国Leverling￥1,707.841/27/200410420美国Callahan￥1,194.271/27/200410421美国Fuller￥49.801/31/200410422英国Suyama￥1,020.002/24/200410423英国King￥9,194.561/27/200410424英国Suyama￥360.002/14/200410425美国Peacock￥338.202/6/200410426美国Peacock￥651.003/3/200410427英国King￥192.002/4/200410428美国Leverling￥1,441.372/7/200410429美国Peacock￥4,899.202/3/200410430美国Peacock￥1,892.252/7/200410431美国Leverling￥485.002/7/200410432美国Leverling￥851.203/4/200410433美国Leverling￥321.122/13/200410434美国Callahan￥631.602/7/200410435美国Leverling￥1,994.522/11/200410436美国Callahan￥393.002/12/200410437美国Leverling￥454.002/14/200410438英国Suyama￥1,078.002/10/200410439美国Peacock￥4,924.132/28/200410440美国Leverling￥1,755.003/14/200410441美国Leverling￥1,792.002/18/200410442美国Callahan￥517.442/14/200410443美国Leverling￥1,031.702/21/200410444美国Leverling￥174.902/20/200410445英国Suyama￥246.242/19/200410446美国Peacock￥914.403/7/200410447美国Peacock￥443.402/24/200410448美国Leverling￥1,838.202/27/200410449美国Callahan￥425.123/11/200410450美国Peacock￥3,849.663/12/200410451美国Callahan￥2,018.502/26/200410452美国Davolio￥407.702/26/200410453美国Peacock￥331.202/25/200410454美国Callahan￥2,684.003/3/200410455美国Callahan￥557.602/28/200410456美国Fuller￥1,584.003/3/200410457英国King￥3,891.003/4/200410458美国Peacock￥1,659.202/28/200410459美国Callahan￥176.103/3/200410460美国Davolio￥1,538.703/5/200410461美国Fuller￥156.003/18/200410462英国Buchanan￥713.303/6/200410463美国Peacock￥1,609.283/14/200410464美国Davolio￥2,518.003/14/200410465美国Peacock￥216.003/13/200410466美国Callahan￥235.203/11/200410467美国Leverling￥717.603/12/200410468美国Davolio￥956.673/14/200410469美国Peacock￥1,820.803/14/200410470美国Fuller￥1,328.003/18/200410471美国Callahan￥1,036.803/19/200410472美国Davolio￥230.403/21/200410473英国Buchanan￥1,249.103/21/200410474英国Dodsworth￥1,505.184/4/200410475美国Callahan￥180.483/24/200410476英国Buchanan￥558.003/25/200410477美国Fuller￥471.203/26/200410478美国Leverling￥10,495.603/21/200410479英国Suyama￥756.003/24/200410480美国Callahan￥1,472.003/25/200410481美国Davolio￥147.004/10/200410482英国King￥668.804/25/200410483美国Leverling￥386.204/1/200410484美国Peacock￥1,584.003/31/200410485美国Davolio￥1,272.004/2/200410486美国Fuller￥889.703/28/200410487美国Callahan￥1,512.004/2/200410488英国Suyama￥439.204/9/200410489英国King￥3,163.204/3/200410490美国Callahan￥259.504/8/200410491美国Leverling￥851.204/11/200410492美国Peacock￥608.404/10/200410493美国Peacock￥912.004/9/200410494美国Leverling￥278.004/11/200410495英国King￥190.004/7/200410496英国King￥1,380.604/7/200410497美国Callahan￥575.004/11/200410498美国Peacock￥1,412.004/16/200410499英国Suyama￥523.264/17/200410500英国Dodsworth￥149.004/16/200410501美国Fuller￥816.304/29/200410502英国Suyama￥2,048.504/16/200410503美国Peacock￥1,388.504/18/200410504美国Leverling￥147.904/21/200410505英国Dodsworth￥415.805/2/200410506英国King￥749.064/22/200410507美国Davolio￥240.005/13/200410508美国Peacock￥136.804/29/200410509英国Suyama￥4,707.544/28/200410510美国Peacock￥2,550.004/21/200410511英国King￥525.304/24/200410512英国King￥1,942.004/28/200410513美国Leverling￥8,623.455/16/200410514美国Fuller￥9,921.305/23/200410515美国Fuller￥2,381.055/1/200410516美国Leverling￥352.004/29/200410517美国Peacock￥4,150.055/5/200410518英国Suyama￥2,314.205/1/200410519英国King￥200.005/1/200410520美国Callahan￥225.505/2/200410521美国Peacock￥2,318.245/6/200410522英国King￥2,444.315/30/200410523美国Davolio￥3,192.655/7/200410524美国Davolio￥818.405/23/200410525美国Peacock￥1,151.405/15/200410526英国King￥1,503.005/7/200410527英国Suyama￥392.205/9/200410528英国Buchanan￥946.005/9/200410529美国Leverling￥4,180.005/12/200410530英国King￥110.005/19/200410531英国King￥796.355/12/200410532美国Callahan￥2,222.205/22/200410533美国Callahan￥465.705/14/200410534美国Peacock￥1,940.855/21/200410535美国Leverling￥1,645.006/6/200410536美国Davolio￥1,823.805/19/200410537英国Dodsworth￥139.805/16/200410538英国Suyama￥355.505/23/200410539美国Leverling￥10,191.706/13/200410540美国Fuller￥1,946.525/29/200410541美国Davolio￥469.115/26/200410542美国Callahan￥1,504.505/23/200410543美国Peacock￥417.205/30/200410544美国Callahan￥210.006/26/200410545美国Davolio￥2,812.005/27/200410546美国Leverling￥1,792.806/2/200410547美国Leverling￥240.106/2/200410548英国Buchanan￥3,554.275/30/200410549英国King￥683.306/6/200410550美国Peacock￥1,677.306/6/200410551美国Fuller￥880.506/5/200410552美国Fuller￥1,546.306/3/200410553美国Peacock￥1,728.526/5/200410554英国Suyama￥2,944.406/4/200410555美国Fuller￥835.206/13/200410556英国Dodsworth￥1,152.506/6/200410557美国Davolio￥2,142.906/10/200410558英国Suyama￥520.416/13/200410559美国Callahan￥1,072.426/9/200410560美国Fuller￥2,844.506/9/200410561美国Davolio￥488.706/12/200410562美国Fuller￥965.006/24/200410563美国Peacock￥1,234.056/16/200410564美国Callahan￥639.906/18/200410565英国Dodsworth￥1,761.006/18/200410566美国Davolio￥2,519.006/17/200410