Contents
Ba da daɗewa ba, sigar Excel 2016 ta gaba tana jiran ku. A halin yanzu, sigar Preview Technical kyauta na Office 2016 ya riga ya kasance don kowa ya duba. Bari mu ga abin da ke sabo da dadi a Redmond.
Gabaɗaya ra'ayi
Kamar yadda kuke gani daga hoton da ya gabata, yanayin yanayin yanayin gaba ɗaya bai canza da yawa ba. Bayanan kintinkiri ya zama kore, kuma ribbon da kansa ya juya launin toka, wanda, a ganina, yana da kyau - ana iya ganin shafin mai aiki a fili kuma ribbon ba ya haɗuwa da takardar, kamar yadda yake a baya. Excel. Sunayen shafukan sun yi bankwana da CAPITAL - ɗan ƙaramin abu, amma yana da kyau.
A cikin saituna Fayil - Zaɓuɓɓuka zaka iya, kamar baya, canza tsarin launi na ƙirar ƙirar, amma zaɓi (kamar yadda ya gabata) saboda wasu dalilai gabaɗaya. Baya ga kore da fari mai tsabta, ana kuma bayar da sigar launin toka mai duhu:
... da jet baki:
Ba mai wadata ga shirin da ke da masu amfani da biliyan a duk duniya suna kallon sa'o'i 5-10 a rana wani lokaci. Har yanzu akwai sauran damar ingantawa ta fuskar ƙira, wannan gaskiya ne. (Bayanin marubuci: Shin ni kaɗai ne na gaji da wannan zane-zane mara fuska mara fuska a ko'ina da kewaye?)
taimako
Wani fili ya bayyana a saman kusurwar dama na allon taimako. Wannan wani nau'i ne na sake reincarnation na shahararren Paperclip - injin bincike mai sauri don duk ayyuka da kayan aikin Excel. A cikin wannan filin, zaku iya fara buga sunan umarni ko aiki, kuma taimako da sauri yana ba da jerin shawarwari waɗanda zaku iya amfani da su:
Tabbas, yana buƙatar ƙayyadaddun tsari masu sauƙi kuma daidai tare da ƙa'idodin hukuma ("layi mai haske", ba "microdiagrams", da sauransu), amma abu ne mai kyau. Masu amfani da novice a cikin halin da ake ciki "Na tuna cewa akwai aiki, amma ban tuna inda" ya kamata ya so shi.
Ina fatan cewa a nan gaba wannan abu ba zai bincika kawai a cikin taimako ba, amma yana goyan bayan shigarwar murya da fahimtar ilimin ilimin harshe - to, za ku iya gaya wa Excel abin da kuke so ku yi: "Yi rahoton kwata-kwata ta yanki kuma aika shi zuwa ga ku. shugaba!”
Sabbin nau'ikan ginshiƙi
Lokaci na ƙarshe da Microsoft ya ƙara sabbin nau'ikan ginshiƙi zuwa Excel shine a cikin 1997-kusan shekaru 20 da suka gabata! Kuma a ƙarshe, ƙanƙara ta karye akan wannan batu (ba tare da pendles na abokantaka ga masu haɓakawa daga membobin ƙungiyar MVP ba, zan gaya muku wani sirri). A cikin Excel 2016, kusan sabbin nau'ikan ginshiƙi guda 6 sun bayyana nan da nan, yawancin waɗanda a cikin tsoffin juzu'in za a iya gina su ta amfani da ƙari na musamman ko raye-raye tare da tambourine. Yanzu duk abin da aka yi a cikin motsi biyu. Don haka, hadu:
Chart na Waterfall
Sauran sunaye: gada (gada), "matakai", zane-zane na ruwa. Wani nau'in ginshiƙi da ake amfani da shi sau da yawa a cikin nazarin kuɗi (kuma ba kawai) wanda ke nuna ƙarar yanayin canjin siga akan lokaci (gudanar kuɗi, saka hannun jari) ko tasirin abubuwa daban-daban akan sakamakon (binciken farashin farashi). A baya, don gina irin wannan zane, dole ne ku yi shamanize ko siyan ƙari na musamman.
Matsayi (Treemap Chart)
Takamaiman nau'in ginshiƙi don nuna gani na rarraba siga ta rukuni a cikin nau'i na nau'in "patchwork quilt" mai siffar rectangular. Haka kuma, za ka iya amfani da ninki biyu matakin nesting na Categories (birane a cikin kasar). Ya dace don amfani don gani, misali, riba ta yanki ko kudaden shiga ta nau'in samfur. A cikin tsofaffin juzu'ai, gina irin wannan ginshiƙi yana da matuƙar wahala kuma yawanci yana buƙatar shigar da ƙarin ƙari.
Tsarin Sunburst
Analogue na nau'in da ya gabata, amma tare da bayanan madauwari a cikin sassan, kuma ba a cikin rectangles ba. A zahiri, wani abu kamar kek da aka tattara ko ginshiƙi donut. Don ganin yadda ake rarrabawa, wannan shine ainihin abin, kuma ba a iyakance ku zuwa matakan gida biyu ba, amma kuna iya rarraba su zuwa uku (kasuwa-samfurin-nau'i) ko fiye.
Pareto (Tsarin Pareto)
Tsarin zane na yau da kullun don ganin "dokar 80/20" ko "Dokar Pareto", wanda mutane da yawa, ina tsammanin, sun ji aƙalla. A cikin sharuddan gabaɗaya, an ƙirƙira shi azaman "20% na ƙoƙarin yana ba da 80% na sakamakon." Lokacin da aka yi amfani da shi zuwa kasuwanci, ana tsaftace shi zuwa "20% na samfurori suna samun kashi 80% na kudaden shiga", "20% na abokan ciniki suna haifar da 80% na matsaloli", da dai sauransu. a matsayin histogram kuma, a lokaci guda, jadawali na orange yana nuna tarin kudaden shiga. Inda layin ya ratsa kashi 80% (kusa da Abarba) kuma zaku iya zana layi na tsaye a hankali don raba mahimman abubuwa (zuwa hagu na Abarba) daga waɗanda basu da mahimmanci (zuwa dama na Abarba). Taswirar mega mai amfani don nazarin ABC da abubuwa makamantansu.
Akwatin gashin baki (BoxPlot Chart)
Wani suna kuma shine “Scatter plot” ko Chart-da-Whiskers Chart. Wani nau'in ginshiƙi na gama gari da aka yi amfani da shi wajen kimanta ƙididdiga wanda ke nunawa don saitin bayanai lokaci ɗaya:
- ma'anar lissafi - darajan cruciform
- tsaka-tsaki (50% quantile) - layin kwance akan akwatin
- na ƙasa (25%) da babba (75%) quntiles su ne ƙananan iyakoki da na sama na akwatin
- watsi - a cikin nau'i na maki daban-daban
- matsakaicin mafi ƙarancin ƙima - a cikin nau'in gashin baki
Mitar histogram (Chansin Histogram)
Don ƙayyadadden saitin bayanai, yana nuna adadin abubuwan da suka faɗi cikin ƙayyadaddun kewayon ƙima. Ana iya saita faɗin tazara ko lambar su. Zane mai fa'ida sosai a cikin nazarin mita, rarrabuwa da makamantansu. A baya can, ana magance irin wannan aikin ta hanyar haɗawa ta tazara na lambobi a cikin teburi ko ta amfani da add-in. Kunshin Nazari.
Tambayar .arfi
Ƙara-in shigo da bayanai Tambayar .arfi, wanda a baya aka tura shi daban don Excel 2013, yanzu an gina shi ta tsohuwa. A kan shafin data (Kwanan wata) an gabatar da shi a matsayin rukuni Zazzage & Maida:
Yin amfani da kayan aikin wannan rukunin, zaku iya zazzage tebur zuwa Excel daga kusan dukkanin manyan tsare-tsaren bayanan bayanai, Intanet da sauran hanyoyin:
Bayan lodawa, bayanan da aka karɓa kuma za'a iya sarrafa su ta amfani da Query Query, "tunatar da shi":
- gyara lambobi-as-rubutu da kwanakin-as-rubutu
- ƙara ginshiƙan ƙididdiga ko cire waɗanda ba dole ba
- haɗa bayanai daga teburi da yawa zuwa ɗaya ta atomatik, da sauransu.
Gabaɗaya, wannan ƙari ne mai fa'ida sosai ga waɗanda ke loda manyan bayanai lokaci-lokaci daga duniyar waje zuwa cikin Excel.
Tabon pivot
Irin wannan kayan aiki mai amfani kamar allunan pivot a cikin wannan sigar sun sami ƙananan haɓaka guda biyu. Da fari dai, a cikin panel tare da jerin filayen, lokacin gina taƙaitaccen bayani, kayan aiki don gano filin da ake so da sauri ya bayyana:
Abu mai fa'ida sosai idan akwai ginshiƙai da yawa a cikin tebur ɗin ku + kun ƙara filayen ƙididdigewa daga kanku.
Na biyu, idan aka tace pivot tebur ta Slicer ko Scale, kuma ka danna tantanin halitta sau biyu tare da bayanai don "fadi" cikin cikakkun bayanai, yanzu ana la'akari da sigogin da aka zaɓa akan yanka da sikelin (a baya sun kasance. an yi watsi da shi, kamar babu yanka, babu sikeli kwata-kwata).
Kayan aikin hasashen
Excel 2016 ya sami sabbin kayan aikin hasashen da yawa. Na farko, a cikin rukuni Bayanan lissafi (Kididdiga) akwai ayyuka don ƙididdige hasashen ta yin amfani da hanyar santsi mai ma'ana:
- FORECAST.ETS - yana ba da ƙima da aka annabta don kwanan wata da aka bayar a nan gaba ta amfani da hanyar daidaitawa na yanayi.
- FORECAST.ETS.DOVINTERVAL - Yana ƙididdige tazarar amincewa don hasashen
- FORECAST.ETS.SEASONALITY - Yana gano yanayin yanayi a cikin bayanai kuma yana ƙididdige lokacin sa
- FORECAST.ETS.STAT - Yana ba da cikakkun ƙididdiga akan jerin lambobi don ƙididdigar ƙididdiga
- PREDICT.LINEST - Yana ƙididdige yanayin layi
Wani kayan aiki mai dacewa don yin tsinkaya akan tashi ya kuma bayyana - maɓallin Takardar hasashen tab data (Kwanan wata):
Idan ka zaɓi bayanan tushen (lokaci ko kwanan wata da ƙima) kuma danna wannan maɓallin, to zamu ga taga mai zuwa:
Kamar yadda kake gani, zaka iya sauƙi saita sigogin hasashen da ake buƙata a ciki kuma nan da nan ga sakamakon a cikin hoton hoto - mai dacewa sosai. Idan kun danna maɓallin Create, sannan sabon takarda zai bayyana, inda za a samar da samfurin hasashen ta atomatik tare da dabara:
Kyawawan kaya. A baya can, alal misali, a horon tsinkaya, mun yi wannan da hannu "daga" da "zuwa" - kuma ya ɗauki lokaci mai kyau.
Hakanan a cikin wannan sigar, sanannun ayyukan lissafi da ƙididdiga sun ƙaura zuwa rukunin karfinsu (Dacewa), domin maimakon su, “zuriyarsu” mafi kamala sun bayyana.
Ƙarshe na ƙarshe
Binciken Fasaha ba saki ba ne, kuma wataƙila a cikin sigar ƙarshe za mu ga wasu ƙarin canje-canje da haɓakawa. Amma, a fili, babu wani abu na allahntaka da ya kamata a sa ran (wani zai ce wannan don mafi kyau, watakila). Microsoft da gangan yana goge abubuwan da ke akwai kuma a hankali yana ƙara sababbi daga siga zuwa sigar.
Yana da kyau cewa, a ƙarshe, sababbin nau'ikan ginshiƙi sun bayyana cewa kowa yana jira na dogon lokaci, amma har yanzu akwai dakin haɓaka - sigogin aikin (Gantt, Timeline), ma'auni ("thermometers"), da dai sauransu sun kasance a baya. al'amuran. Har ila yau, na yi shiru game da gaskiyar cewa za a iya yin sparklines na dogon lokaci ba nau'i uku ba, amma mahimmanci, kamar yadda yake a cikin asali.
Yana da kyau cewa add-ons masu amfani (Query Query, Power Pivot) an gina su a cikin shirin ta tsohuwa, amma kuma zai yiwu a yi karimci ko da akan Neman Fuzzy tare da Taswirar Wuta. Abin takaici, ba tukuna.
Kuma da kaina, na yi nadama cewa ba za mu gani ba, da alama, a cikin sabon sigar Excel 2016, ba kayan aikin ci-gaba don aiki tare da jeri ba (kwatancin kewayon, alal misali), ko haɓakawa a cikin yanayin shirye-shiryen Kayayyakin Kayayyakin Kayayyakin (waɗanda) Ba a canza ba tun 1997), ko sabbin ayyuka kamar VLOOKUP2 ko Sum a cikin kalmomi.
Ina fatan in rayu har zuwa lokacin da duk wannan ya bayyana a cikin Excel, amma a yanzu dole ne in yi amfani da kullun da aka saba.