Zamkatimu
Posachedwapa, mtundu wotsatira wa Excel 2016 ukukuyembekezerani. Pakadali pano, mtundu waulere wa Technical Preview wa Office 2016 ulipo kale kuti aliyense awunikenso. Tiyeni tiwone zatsopano komanso zokoma ku Redmond.
Maonedwe ambiri
Monga mukuwonera pachithunzi cham'mbuyomu, mawonekedwe onse a mawonekedwewo sanasinthe kwambiri. Chiyambi cha riboni chasanduka chobiriwira, ndipo riboni yokhayo yasanduka imvi, yomwe, mwa lingaliro langa, ndi yabwino - tabu yogwira ntchito imatha kuwoneka momveka bwino ndipo riboni sichiphatikizana ndi pepala, monga momwe zinalili kale. Excel. Mayina a ma tabo adatsazikana ndi CAPITAL - pang'ono, koma zabwino.
Muzokonda Fayilo - Zosankha mungathe, monga kale, kusintha mtundu wa mawonekedwe a mawonekedwe, koma kusankha (monga kale) pazifukwa zina ndizomvetsa chisoni. Kuphatikiza pa zobiriwira zobiriwira komanso zoyera, mtundu wakuda wakuda umaperekedwanso:
... ndi jet yakuda:
Osalemera pulogalamu yomwe ili ndi ogwiritsa ntchito biliyoni padziko lonse lapansi akuyang'ana kwa maola 5-10 patsiku nthawi zina. Pali mwayi woti uwongolere pamapangidwe, ndi zoona. (Zidziwitso za mlembi: kodi ine ndekha ndatopa ndi kapangidwe ka lathyathyathya kopanda nkhope kulikonse ndi kozungulira?)
Wothandizira
Munda unawonekera pakona yakumanja kwa chinsalu Wothandizira. Uwu ndi mtundu wa kubadwanso kwina kwa Paperclip yotchuka - injini yosakira yokhazikika yokhazikika pazochita zonse ndi zida za Excel. M'munda uwu, mutha kuyamba kulemba dzina la lamulo kapena ntchito, ndi Wothandizira mwamsanga amapereka mndandanda wa malangizo omwe mungagwiritse ntchito:
Zachidziwikire, pamafunika kupangidwa kosavuta komanso kolondola ndi mawu ovomerezeka ("sparklines", osati "microdiagrams", etc.), koma ndichinthu chabwino. Ogwiritsa ntchito novice ali "Ndikukumbukira kuti pali ntchito, koma sindikukumbukira komwe" iyenera kuyikonda.
Ndikukhulupirira kuti mtsogolomu izi sizidzangofufuza chithandizo, koma kuthandizira kuyika mawu ndikumvetsetsa -language morphology - ndiye mutha kungouza Excel zomwe mukufuna kuchita: "Pangani lipoti la kotala ndi dera ndikutumiza bwana!”
Mitundu yatsopano yamatchati
Nthawi yomaliza Microsoft inawonjezera mitundu yatsopano ya tchati ku Excel inali mu 1997-pafupifupi zaka 20 zapitazo! Ndipo potsiriza, ayezi wathyoka pankhaniyi (osati popanda ma pendle ochezeka kwa omanga kuchokera kwa mamembala a gulu la MVP, ndikuwuzani chinsinsi). Mu Excel 2016, mitundu 6 yatsopano ya ma chart idawonekera nthawi yomweyo, yomwe ambiri mwamitundu yakale imatha kupangidwa pogwiritsa ntchito zowonjezera kapena kuvina ndi maseche. Tsopano zonse zimachitika mumayendedwe awiri. Kenako, kukumana:
Tchati Chamadzi
Mayina ena: mlatho (mlatho), "masitepe", chithunzi cha mathithi. Mtundu wa tchati womwe umagwiritsidwa ntchito nthawi zambiri posanthula zachuma (osati kokha) womwe umawonetsa bwino kusintha kwa magawo pakapita nthawi (mayendedwe a ndalama, mabizinesi) kapena chikoka cha zinthu zosiyanasiyana pazotsatira (kuwunika kwamitengo). M'mbuyomu, kuti mupange chithunzi chotere, mumayenera kuchita shamanize kapena kugula zowonjezera zapadera.
Tchati cha Treemap (Hierarchical)
Mtundu wina wa tchati chowonetseratu kugawidwa kwa magawo ndi gulu mu mawonekedwe amtundu wa "patchwork quilt" yamakona anayi. Komanso, mutha kugwiritsa ntchito milingo iwiri yomanga zisa zamagulu (mizinda mkati mwa dziko). Ndizosavuta kugwiritsa ntchito powonera, mwachitsanzo, phindu ndi dera kapena ndalama zomwe zimaperekedwa ndi gulu lazogulitsa. M'matembenuzidwe akale, kupanga tchati chotere kunali kovuta kwambiri ndipo nthawi zambiri kunkafunika kuyika zina zowonjezera.
Tchati cha Sunburst
Analogue ya mtundu wakale, koma ndi kuyika kozungulira kwa data m'magawo, osati mumakona anayi. M'malo mwake, chinthu chonga chitumbuwa kapena tchati cha donut. Kuti muwone m'maganizo kugawira, ichi ndi chinthu chomwecho, ndipo simulinso ndi magawo awiri a zisa, koma mukhoza kuwawola kukhala atatu (mtundu-mtundu-mtundu) kapena kuposa.
Pareto (Tchati cha Pareto)
Chithunzi chachikale chowonera "lamulo la 80/20" kapena "lamulo la Pareto", lomwe ambiri, ndikuganiza, adamvapo. M'mawu ambiri, amapangidwa ngati "20% ya khama limapereka 80% ya zotsatira." Mukagwiritsidwa ntchito ku bizinesi, izi zimayeretsedwa kuti "20% yazinthu zimapanga 80% ya ndalama", "20% ya makasitomala amapanga 80% ya mavuto", ndi zina zotero. monga histogram ndipo, nthawi yomweyo, graph ya lalanje ikuwonetsa gawo lomwe lapeza ndalama. Kumene mzerewu umadutsa 80% (pafupi ndi Chinanazi) ndipo mukhoza kujambula mzere wolunjika kuti mulekanitse zinthu zofunika (kumanzere kwa Nanazi) kuchokera ku zosafunika (kumanja kwa Nanazi). Tchati chothandiza kwambiri pakuwunika kwa ABC ndi zinthu zofananira.
Bokosi la Masharubu (Tchati cha BoxPlot)
Dzina lina ndi "chiwembu chomwaza" kapena Box-and-Whiskers Chart. Mtundu wodziwika bwino wa tchati womwe umagwiritsidwa ntchito powunika zomwe zimawonetsedwa pa data yomwe yakhazikitsidwa nthawi imodzi:
- kutanthauza masamu - cruciform notch
- wapakatikati (50% quantile) - mzere wopingasa pabokosi
- otsika (25%) ndi apamwamba (75%) quanties ndi malire apansi ndi apamwamba a bokosi.
- utsi - mu mawonekedwe a mfundo zosiyana
- pazipita ndi osachepera mtengo - mu mawonekedwe a masharubu
Nthawi zambiri histogram (Tchati cha Histogram)
Pama data omwe atchulidwa, amawonetsa kuchuluka kwa zinthu zomwe zikugwera m'migawo yodziwika. M'lifupi mwa intervals kapena chiwerengero chawo akhoza kukhazikitsidwa. Chithunzi chothandiza kwambiri pakuwunika pafupipafupi, magawo ndi zina zotero. M'mbuyomu, ntchito yotereyi nthawi zambiri inkathetsedwa mwa kuyika m'magulu mwa mawerengero a ma pivot tables kapena kugwiritsa ntchito chowonjezera. Phukusi la Analysis.
Kufunsa Mphamvu
Data Import Add-in Kufunsa Mphamvu, yomwe idatumizidwa kale padera ku Excel 2013, tsopano yamangidwa mwachisawawa. Pa tabu Deta (Tsiku) imaperekedwa ngati gulu Koperani & Sinthani:
Pogwiritsa ntchito zida za gululi, mutha kutsitsa matebulo ku Excel kuchokera kumitundu yonse yomwe ilipo ya nkhokwe, intaneti ndi zina:
Mukatsitsa, zomwe mwalandira zitha kukonzedwanso pogwiritsa ntchito Power Query, "kukumbukira":
- konzani manambala-monga-malemba ndi madeti-monga-malemba
- onjezani mizati yowerengedwa kapena chotsani zosafunikira
- kuphatikiza deta kuchokera kumatebulo angapo kukhala imodzi yokha, etc.
Mwambiri, izi ndizowonjezera zothandiza kwambiri kwa iwo omwe nthawi ndi nthawi amanyamula zambiri kuchokera kumayiko akunja kupita ku Excel.
Masamba ozungulira
Chida chothandiza ngati ma pivot tables mumtunduwu adalandira zosintha ziwiri zazing'ono. Choyamba, pagulu lomwe lili ndi mndandanda wa minda, pomanga chidule, chida chopezera gawo lomwe mukufuna chidawonekera:
Chinthu chothandiza kwambiri pakakhala mizati yambiri patebulo lanu + mudawonjezeranso magawo owerengeka kuchokera kwa inu.
Kachiwiri, ngati tebulo la pivot likusefedwa ndi Slicer kapena Scale, ndipo mumadina kawiri pa selo lomwe lili ndi deta kuti "mugwere" mwatsatanetsatane, tsopano magawo osankhidwa pa magawo ndi masikelo amaganiziridwa (poyamba anali kunyalanyazidwa, ngati kuti panalibe magawo, palibe sikelo konse).
Zida zolosera
Excel 2016 yalandira zida zingapo zatsopano zolosera. Choyamba, m'gulu Chiwerengero (Zowerengera) pali ntchito zowerengera zolosera pogwiritsa ntchito njira yosalala ya exponential:
- FORECAST.ETS - imapereka mtengo woloseredwa wa tsiku lomwe laperekedwa m'tsogolomu pogwiritsa ntchito njira ya exp.smoothing yosinthidwa ndi nyengo.
- FORECAST.ETS.DOVINTERVAL - Imawerengera nthawi yodalirika pazambiri
- FORECAST.ETS.SEASONALITY - Imazindikira nyengo mu data ndikuwerengera nthawi yake
- FORECAST.ETS.STAT - Amapereka ziwerengero zatsatanetsatane pamawerengero azomwe zawerengeredwa
- PREDICT.LINEST - Kuwerengera mizere yozungulira
Chida chosavuta chopangira maulosi pa ntchentche chawonekeranso - batani Tsamba lolosera tsamba Deta (Tsiku):
Mukasankha zomwe zachokera (nthawi kapena masiku ndi zikhalidwe) ndikudina batani ili, ndiye kuti tiwona zenera lotsatira:
Monga mukuwonera, mutha kukhazikitsa zolosera zofunikira momwemo ndipo nthawi yomweyo muwone zotsatira zake mu chiwonetsero chazithunzi - chosavuta kwambiri. Ngati mutasindikiza batani Pangani, kenako tsamba latsopano lidzawoneka, pomwe choloseracho chidzangopangidwa ndi mafomuwa:
Zinthu zabwino. M'mbuyomu, mwachitsanzo, pamaphunziro olosera, tidachita izi pamanja "kuchokera" ndi "kupita" - ndipo zidatenga nthawi yabwino kwambiri.
Komanso mu Baibuloli, ntchito zingapo zodziwika bwino za masamu ndi ziwerengero zasamukira kugulu ngakhale (Kugwirizana), chifukwa m’malo mwa iwo, “mbadwa” zawo zangwiro kwambiri zinawonekera.
Zomaliza zomaliza
The Technical Preview si kumasulidwa, ndipo mwinamwake mu mtundu womaliza tiwona zosintha zina zowonjezera. Koma, mwachiwonekere, palibe chauzimu chomwe chiyenera kuyembekezera (wina anganene kuti izi ndi zabwino, mwinamwake). Microsoft imapukuta mwadala komanso mwadongosolo zomwe zilipo ndikuwonjezera pang'onopang'ono zatsopano kuchokera ku mtundu kupita ku mtundu.
Ndibwino kuti, potsiriza, mitundu yatsopano ya ma chart yawonekera yomwe aliyense wakhala akudikirira kwa nthawi yayitali, koma pali malo oti akule - ma chart a polojekiti (Gantt, Timeline), ma chart chart ("thermometers"), etc. zochitika. Sindinatchulenso kuti sparklines akanatha kupangidwa kwa nthawi yayitali osati mitundu itatu, koma yochulukirapo, monga momwe idayambira.
Ndibwino kuti zowonjezera zowonjezera (Power Query, Power Pivot) zimamangidwa mu pulogalamuyi mwachisawawa, koma zingatheke kukhala owolowa manja ngakhale pa Fuzzy Lookup ndi Power Map. Tsoka ilo, ayi.
Ndipo panokha, ndikupepesa kuti sitiwona, zikuwoneka, mu mtundu watsopano wa Excel 2016, palibe zida zapamwamba zogwirira ntchito ndi ma range (kuyerekeza kwamitundu, mwachitsanzo), kapena kusintha kwa Visual Basic programming environment (yomwe sichinasinthidwe kuyambira 1997), kapena ntchito zatsopano monga VLOOKUP2 kapena Sum m'mawu.
Ndikuyembekeza kukhala ndi moyo mpaka nthawi yomwe zonsezi zidzawonekera mu Excel, koma pakalipano ndiyenera kugwiritsa ntchito ndodo zachizolowezi.