Mukati
Nenguva isipi, iyo inotevera vhezheni yeExcel 2016 yakakumirira iwe. Parizvino, yemahara Technical Preview vhezheni yeHofisi 2016 yatovepo kuti munhu wese aongorore. Ngationei kuti chii chitsva uye chinonaka muRedmond.
General maonero
Sezvauri kuona kubva pane yakapfuura skrini, iyo yekutarisa yese interface haina kuchinja zvakanyanya. Mhedziso yeribhoni yakave yakasvibirira, uye ribhoni pachayo yakashanduka grey, iyo, mukuona kwangu, yakanaka - iyo inoshanda tab inogona kuonekwa zvakajeka uye ribhoni haibatanidzi nepepa, sezvazvaiva kare. Excel. Mazita ematabo akati zvakanaka kuCAPITAL - zvishoma, asi zvakanaka.
Muzvirongwa Faira - Sarudzo iwe unogona, sekare, shandura iyo ruvara chirongwa cheiyo interface, asi sarudzo (sepakutanga) kune chimwe chikonzero inosiririsa. Pamusoro pegirinhi uye yakachena chena, yakasviba grey vhezheni inopihwa zvakare:
... uye jet dema:
Haisi kupfuma kune chirongwa chine bhiriyoni vashandisi pasi rese vachitarisa kwemaawa 5-10 pazuva dzimwe nguva. Pachine nzvimbo yekuvandudzwa maererano nemagadzirirwo, ichokwadi. (Chinyorwa chemunyori: ndini ndega ndaneta neiyi flat isina kumeso flat-dhizaini kwese nekutenderedza?)
mubatsiri
Munda wakabuda mukona yepamusoro yekurudyi yechidzitiro mubatsiri. Iyi imhando yekuzvarwa patsva kweiyo yakakurumbira Paperclip - inokurumidza yakavakirwa-mukati yekutsvaga injini yeese mabasa uye zvishandiso zveExcel. Mundima iyi, unogona kutanga kutaipa zita rekuraira kana basa, uye mubatsiri nekukurumidza inopa runyoro rwematipi aunogona kushandisa:
Ehe, zvinoda manyorerwo akareruka uye akakwana ane izwi repamutemo ("sparklines", kwete "microdiagrams", nezvimwewo), asi chinhu chakanaka. Vashandisi veNovice vari mumamiriro ezvinhu "Ndinorangarira kuti pane basa, asi handiyeuke kuti kupi" rinofanira kurifarira.
Ndinovimba kuti mune ramangwana chinhu ichi hachingotsvage murubatsiro, asi tsigiro yekuisa izwi uye kunzwisisa -language morphology - ipapo unogona kungoudza Excel zvaunoda kuita: "Ita rondedzero yekota nedunhu uye utumire kune yako. boss!”
Mhando itsva dzechati
Nguva yekupedzisira Microsoft yakawedzera mhando nyowani dzechati kuExcel yaive muna 1997 — angangoita makore makumi maviri apfuura! Uye pakupedzisira, chando chaputsika panyaya iyi (kwete pasina hushamwari pendles kune vanogadzira kubva kunhengo dzeMVP nharaunda, ini ndichakuudza chakavanzika). MuExcel 20, anosvika matanhatu marudzi matsva emachati akaonekwa nekukurumidza, mazhinji ayo mushanduro dzekare aingogona kuvakwa pachishandiswa akakosha ekuwedzera kana matambiro ane ngoma. Iye zvino zvinhu zvose zvinoitwa mumafambiro maviri. Saka, kusangana:
Waterfall Chart
Mamwe mazita: bhiriji (bhiriji), "matanho", dhayagiramu yemapopoma. Rudzi rwechati rinonyanya kushandiswa mukuongorora kwemari (uye kwete chete) rinonyatso ratidza kushanduka kweparameta nekufamba kwenguva (kuyerera kwemari, mari) kana pesvedzero yezvakasiyana-siyana pamhedzisiro (price factor analysis). Pakutanga, kuti uvake dhizaini rakadaro, waifanira kuita shamanize kana kutenga akakosha ekuwedzera.
Hierarchical (Treemap Chati)
Rudzi rwakati rwechati yekuratidzira kugovera kweparameter nechikamu muchimiro chemhando yerectangular "patchwork quilt". Uyezve, iwe unogona kushandisa kaviri nhanho yekugara kwezvikamu (maguta mukati menyika). Zviri nyore kushandisa pakuona, semuenzaniso, purofiti nedunhu kana mari nechikamu chechigadzirwa. Mushanduro dzekare, kuvaka chati yakadaro kwaive kwakaoma zvakanyanya uye kazhinji kwaida kuiswa kwemamwe maadd-ons.
Sunburst Chart
Analogue yemhando yapfuura, asi ine denderedzwa kuiswa kwedata muzvikamu, uye kwete mumakona. Muchidimbu, chimwe chinhu chakaita sepai yakarongedzwa kana donut chati. Kuona kugovera, ichi ndicho chinhu chaicho, uye hausisiri kuganhurirwa kumatanho maviri ekugara, asi unogona kuaparadza kuita matatu (chikamu-chigadzirwa-mhando) kana kupfuura.
Pareto (Pareto Chati)
Dhiagiramu yemhando yepamusoro yekuona "mutemo we80/20" kana "mutemo wePareto", uyo vazhinji, ndinofunga, vakambonzwa nezvawo. Kazhinji, inogadzirwa se "20% yekuedza inopa 80% yemugumisiro." Kana inoshandiswa kune bhizinesi, izvi zvinonatswa ku "20% yezvigadzirwa zvinogadzira 80% yemari", "20% yevatengi vanogadzira 80% yematambudziko", nezvimwewo. Mumufananidzo wakadaro, mari yose yechigadzirwa chimwe nechimwe inoratidzwa. se histogram uye, panguva imwecheteyo, girafu reorange rinoratidza chikamu chakaunganidzwa chemari. Apo mutsara unoyambuka 80% (pedyo nePineapple) uye iwe unogona kudhirowa mupfungwa mutsara wakatwasuka kuti uparadzanise zvinhu zvakakosha (kuruboshwe rwePineapple) kubva kune zvisina kukosha (kurudyi kwePineapple). A mega-inobatsira chati yeABC kuongororwa uye zvimwe zvakafanana.
Mustache Bhokisi (BhokisiPlot Chati)
Rimwe zita nderokuti "kuparadzira zano" kana Bhokisi-uye-Whiskers Chati. Mhando yakajairika yechati inoshandiswa mukuongororwa kwenhamba inotaridza data seti kamwechete:
- arithmetic zvinoreva - cruciform notch
- pakati (50% quantile) - mutsara wakatwasuka pabhokisi
- iyo yakaderera (25%) uye yepamusoro (75%) quantiles ndiyo yakaderera uye yepamusoro miganhu yebhokisi.
- kubudiswa - nenzira yezvikamu zvakasiyana
- huwandu uye hushoma kukosha - nenzira yemasharubu
Frequency histogram (Histogram Chati)
Kune yakatarwa data seti, inoratidza huwandu hwezvinhu zvinowira mukati meiyo yakatarwa yezvikoshi. Upamhi hwezvikamu kana nhamba yavo inogona kuiswa. Dhiyagiramu inobatsira kwazvo mukuongorora frequency, segmentation uye nezvimwe. Kare, basa rakadaro raiwanzogadziriswa nekuunganidza nenhamba dzenhamba mumatafura epivot kana kushandisa add-in. Analysis Package.
Simba Query
Data Kupinza Kuwedzera-mukati Simba Query, yakambotumirwa zvakasiyana yeExcel 2013, ikozvino yakavakirwa-mukati nekukasira. Pa tab Data (Zuva) inoratidzwa seboka Dhaunirodha & Shandura:
Uchishandisa maturusi eboka iri, unogona kudhawunirodha matafura kuExcel kubva kune angangoita ese makuru mafomati emadatabase, iyo Internet uye mamwe masosi:
Mushure mekurodha, iyo data yakagamuchirwa inogona zvakare kugadziriswa uchishandisa Power Query, "kuunza iyo mupfungwa":
- gadzirisa nhamba-se-zvinyorwa uye mazuva-se-zvinyorwa
- wedzera makoramu akaverengerwa kana kubvisa zvisina basa
- batanidza data kubva kumatafura akati wandei kuita imwe otomatiki, nezvimwe.
Kazhinji, iyi inobatsira zvikuru yekuwedzera kune avo vanopota vachiisa yakawanda data kubva kunze kwenyika kuenda kuExcel.
Pivot matafura
Chishandiso chinobatsira sematafura epivot mune iyi vhezheni yakagamuchira zvigadziriso zviviri zvidiki. Chekutanga, mupaneru ine runyorwa rweminda, pakuvaka pfupiso, chishandiso chekukurumidza kuwana munda waunoda chakaonekwa:
Chinhu chinobatsira kana paine akawanda makoramu mutafura yako + iwe wakawedzera akaverengerwa minda kubva kwauri.
Kechipiri, kana iyo tafura yepivot yakasefa neSlicer kana Scale, uye iwe uchidzvanya kaviri pane sero ine data kuti "uwire mukati" mune izvo ruzivo, ikozvino maparamendi akasarudzwa pazvimedu uye zviyero anotariswa (kare aivepo. kufuratirwa, sekunge pakanga pasina zvimedu, hapana chikero zvachose).
Maturusi ekufanotaura
Excel 2016 yakagamuchira akati wandei maturusi ekufanotaura. Kutanga, muchikwata Statistical (Nhamba) kune mabasa ekuverenga iyo yekufanotaura uchishandisa exponential smoothing nzira:
- FORECAST.ETS - inopa kukosha kwakafanotaurwa kwezuva rakapihwa mune ramangwana uchishandisa iyo mwaka yakagadziridzwa exp.smoothing nzira
- FORECAST.ETS.DOVINTERVAL - Inoverengera nguva yekuvimba yekufungidzira
- FORECAST.ETS.SEASONALITY - Inoona mwaka mune data uye inoverengera nguva yayo
- FORECAST.ETS.STAT - Inopa huwandu hwehuwandu hwehuwandu hwehuwandu hwehuwandu hwekufungidzira.
- PREDICT.LINEST - Inoverengera mutsara maitiro
Chishandiso chiri nyore chekuita fungidziro panhunzi yakaonekwa zvakare - bhatani Forecast sheet Tab Data (Zuva):
Kana ukasarudza iyo sosi data (nguva kana misi uye kukosha) uye tinya bhatani iri, tozoona hwindo rinotevera:
Sezvauri kuona, iwe unogona nyore kuseta inodiwa yekufanotaura ma paramita mairi uye wobva waona mhedzisiro mune graphical inomiririra - yakanyanya kunaka. Kana ukadzvanya bhatani sika, ipapo pepa idzva richaonekwa, uko modhi yekufungidzira inozogadzirwa otomatiki nemafomula:
Zvinhu zvakanaka. Pakutanga, semuenzaniso, pakudzidziswa kwekufanotaura, takaita izvi nemaoko "kubva" uye "kusvika" - uye zvakatora nguva yakanaka kwazvo.
Zvakare mune iyi vhezheni, akati wandei anozivikanwa masvomhu uye manhamba mabasa akatamira kuchikamu kugarisana (Kuenderana), nokuti panzvimbo pavo, “vazukuru” vavo vakakwana zvikuru vakaoneka.
Mhedziso yekupedzisira
Iyo Technical Preview haisi yekusunungurwa, uye pamwe mushanduro yekupedzisira tichaona dzimwe shanduko nekuvandudzwa. Asi, sezviri pachena, hapana chinhu chinoshamisa chinofanira kutarisirwa (mumwe munhu achataura kuti izvi zviri nani, zvichida). Microsoft inokwenenzvera nemaune uye nenzira kwayo izvo zviripo uye zvishoma nezvishoma inowedzera zvitsva kubva kushanduro kuenda kune shanduro.
Zvakanaka kuti, pakupedzisira, mhando itsva dzemachati dzakaonekwa kuti munhu wese anga akamirira kwenguva yakareba, asi pachine nzvimbo yekukura - machati eprojekiti (Gantt, Timeline), machati esikeri ("mathermometers"), nezvimwe zvakasara kumashure. zviitiko. Ini zvakare ndakanyarara nezve chokwadi chekuti sparklines angadai akagadzirwa kwenguva yakareba kwete marudzi matatu, asi zvakanyanya zvakanyanya, sepakutanga.
Zvakanaka kuti ma-add-ons anobatsira (Simba Query, Power Pivot) akavakirwa muchirongwa nekukasira, asi zvino zvinogoneka kuve nerupo kunyangwe paFuzzy Lookup ine Simba Mepu. Sezvineiwo, handisati.
Uye ini pachangu, ndine hurombo kuti hatizoone, zvinoita sekunge, mushanduro itsva yeExcel 2016, kana maturusi epamusoro ekushanda nemarenji (kufananidza, semuenzaniso), kana kuvandudzwa muVisual Basic programming nharaunda (iyo haina kuchinjwa kubvira 1997), kana mabasa matsva seVLOOKUP2 kana Sum mumashoko.
Ndinovimba kurarama kusvika panguva iyo zvese izvi zvinoonekwa muExcel, asi parizvino ndichafanira kushandisa madondoro akajairika.