Contents
ʻAʻole koke, ke kali nei ka mana hou o Excel 2016 iā ʻoe. I kēia manawa, ua loaʻa i nā mea a pau ke nānā ʻana i kahi mana ʻenehana ʻenehana manuahi o Office 2016. E ʻike kākou i nā mea hou a ʻono ma Redmond.
Nānā nui
E like me kāu e ʻike ai mai ke kiʻi kiʻi mua, ʻaʻole i loli nui ka nānā holoʻokoʻa o ka interface. Ua ʻōmaʻomaʻo ke kāʻei kua o ka lipine, a ʻo ka lipine ponoʻī ua lilo i hina, i koʻu manaʻo, ua maikaʻi - hiki ke ʻike maopopo ʻia ka pā hana a ʻaʻole hui pū ka lipine me ka lau, e like me ka wā ma mua. Excel. Ua ʻōlelo maikaʻi nā inoa o nā tabs iā CAPITAL - he mea liʻiliʻi, akā maikaʻi.
Ma nā hoʻonohonoho Kōnae - Nā koho hiki iā ʻoe, e like me ka wā ma mua, e hoʻololi i ke kala kala o ka interface, akā ʻo ke koho (e like me ka wā ma mua) no kekahi kumu he pōʻino loa. Ma waho aʻe o ka'ōmaʻomaʻo a me ke keʻokeʻo maʻemaʻe, hāʻawi pūʻia kekahiʻano hina hina:
… a ʻeleʻele ʻeleʻele:
ʻAʻole waiwai no kahi papahana he piliona mea hoʻohana a puni ka honua e nānā ana no 5-10 mau hola i ka lā i kekahi manawa. Aia nō ka lumi no ka hoʻomaikaʻi ʻana ma ke ʻano o ka hoʻolālā, he ʻoiaʻiʻo. (Ka moʻolelo a ka mea kākau: ʻo wau wale nō ka luhi i kēia hoʻolālā palahalaha maka ʻole ma nā wahi a puni?)
hoalawehana na
Ua ʻike ʻia kahi kahua ma ka ʻaoʻao ʻākau o ka pale hoalawehana na. ʻO kēia kahi ʻano reincarnation o ka Paperclip kaulana - kahi ʻenekini huli wikiwiki i kūkulu ʻia no nā hana āpau a me nā mea hana o Excel. Ma kēia kahua, hiki iā ʻoe ke hoʻomaka e kākau i ka inoa o kahi kauoha a i ʻole hana, a hoalawehana na hāʻawi koke i kahi papa inoa o nā ʻōlelo aʻoaʻo hiki iā ʻoe ke hoʻohana:
ʻOiaʻiʻo, pono ia i nā ʻōlelo maʻalahi a pololei me nā huaʻōlelo kūhelu ("sparklines", ʻaʻole "microdiagrams", etc.), akā he mea maikaʻi. ʻO nā mea hoʻohana hou i ke kūlana "Ke hoʻomanaʻo nei au aia kahi hana, akā ʻaʻole wau e hoʻomanaʻo i kahi" makemake ia.
Manaʻo wau i ka wā e hiki mai ana ʻaʻole e ʻimi wale kēia mea i ke kōkua, akā kākoʻo i ka hoʻokomo leo a hoʻomaopopo i ka morphology ʻōlelo - a laila hiki iā ʻoe ke haʻi iā Excel i kāu mea e makemake ai e hana: haku!”
Nā ʻano pakuhi hou
ʻO ka manawa hope loa i hoʻohui ai ʻo Microsoft i nā ʻano pakuhi hou i Excel i ka makahiki 1997—kokoke 20 makahiki aku nei! A ʻo ka hope, ua haki ka hau i kēia pilikia (ʻaʻole me ka ʻole o nā pendles aloha i nā mea hoʻomohala mai nā lālā o ke kaiāulu MVP, e haʻi aku wau iā ʻoe i kahi mea huna). Ma Excel 2016, ua ʻike koke ʻia ka nui o nā ʻano kiʻi kiʻi hou he 6, ʻo ka hapa nui o ia mau mea ma nā mana kahiko hiki ke kūkulu ʻia me ka hoʻohana ʻana i nā mea hoʻohui kūikawā a i ʻole nā hula me kahi pahu kani. I kēia manawa ua hanaʻia nā mea a pau iʻelua mau neʻe. No laila, hui:
Pakuhi Waterfall
Nā inoa ʻē aʻe: bridge (bridge), “steps”, waterfall diagram. ʻO kahi ʻano o ka pakuhi i hoʻohana pinepine ʻia i ka nānā ʻana kālā (a ʻaʻole wale) e hōʻike maopopo ana i ka dynamics o kahi hoʻololi ʻana i ka manawa (ke kahe kālā, nā hoʻopukapuka) a i ʻole ka hopena o nā kumu like ʻole i ka hopena (ka helu kumu kūʻai). Ma mua, no ke kūkulu ʻana i ia kiʻi, pono ʻoe e shamanize a kūʻai paha i nā mea hoʻohui kūikawā.
Hierarchical (Papa Laau Laau)
He ʻano palapala kikoʻī no ka hōʻike maka ʻana i ka puʻunaue ʻana o kahi ʻāpana ma ke ʻano ma ke ʻano o ke ʻano o ka "patchwork quilt". Eia kekahi, hiki iā ʻoe ke hoʻohana i ka pae ʻelua o ka nesting o nā ʻāpana (nā kūlanakauhale i loko o ka ʻāina). He mea maʻalahi ke hoʻohana no ka nānā ʻana, no ka laʻana, loaʻa kālā ma ka ʻāina a i ʻole ka loaʻa kālā ma ka ʻāpana huahana. I nā mana kahiko, paʻakikī loa ke kūkulu ʻana i ia pakuhi a pono e hoʻokomo i nā mea hoʻohui hou.
Pākuʻi Sunburst
ʻO kahi analogue o ke ʻano ma mua, akā me kahi hoʻonohonoho pōʻai o ka ʻikepili i nā ʻāpana, ʻaʻole i nā ʻāpana. ʻO ka mea nui, he mea like me kahi pai i hoʻopaʻa ʻia a i ʻole ka palapala donut. No ka ʻike ʻana i ka hāʻawi ʻana, ʻo ia ka mea, a ʻaʻole ʻoe i kaupalena ʻia i ʻelua pae o ka nesting, akā hiki ke hoʻokaʻawale iā lākou i ʻekolu (category-product-sort) a ʻoi aku paha.
Pareto (Pareto Chart)
He kiʻikuhi maʻamau no ka nānā ʻana i ke "kānāwai 80/20" a i ʻole "kānāwai Pareto", aʻu i manaʻo ai, ua lohe nui ʻia. Ma nā ʻōlelo maʻamau, ua hoʻokumu ʻia ʻo "20% o ka hoʻoikaika ʻana e hāʻawi i 80% o ka hopena." Ke hoʻohana ʻia i kahi ʻoihana, hoʻomaʻemaʻe ʻia kēia i "20% o nā huahana e hana i ka 80% o ka loaʻa kālā", "20% o nā mea kūʻai aku e hana i 80% o nā pilikia", a pēlā aku. ma ke ʻano he histogram a, ma ka manawa like, hōʻike ka pakuhi ʻalani i ka ʻāpana o ka loaʻa kālā. Ma kahi e hele ai ka laina i 80% (kokoke i ka Pineapple) a hiki iā ʻoe ke kaha noʻonoʻo i kahi laina kūpaʻa e hoʻokaʻawale i nā mea kī (ma ka ʻaoʻao hema o Pineapple) mai nā mea nui ʻole (ma ka ʻākau o Pineapple). ʻO kahi pakuhi mega-pono no ka nānā ʻana ABC a me nā mea like.
Pahu ʻumiʻumi (BoxPlot Chart)
ʻO kekahi inoa ʻo "scatter plot" a i ʻole Box-and-Whiskers Chart. He ʻano maʻamau o ka pakuhi i hoʻohana ʻia i ka loiloi helu helu e hōʻike ana no kahi hoʻonohonoho ʻikepili i ka manawa hoʻokahi:
- helu helu - cruciform notch
- median (50% quantile) - laina laina ma ka pahu
- ka lalo (25%) a me luna (75%) quantiles nā palena lalo a me luna o ka pahu
- hoʻokuʻu - ma ke ʻano o nā kiko kaʻawale
- ka nui a me ka waiwai liʻiliʻi - ma ke ʻano o ka ʻumi
ʻO ka histogram alapine (Histogram Chart)
No ka pūʻulu ʻikepili i ʻōlelo ʻia, hōʻike i ka helu o nā mea i hāʻule i loko o nā pae o nā waiwai. Hiki ke hoʻonohonoho ʻia ka laulā o nā kikowaena a i ʻole kā lākou helu. He kiʻi pono loa i ka nānā pinepine ʻana, ka ʻāpana a me nā mea like. Ma mua, ua hoʻoholo pinepine ʻia kēlā hana ma o ka hui ʻana e nā manawa helu ma nā papa pivot a i ʻole ka hoʻohana ʻana i ka add-in. Pūʻolo Kānāwai.
Nīnau Uila
Pākuʻi Hoʻokomo ʻikepili Nīnau Uila, i hoʻouna ʻokoʻa ʻia no Excel 2013, ua kūkulu ʻia i loko o ka paʻamau. Ma ka pā 'Ikepili (Lā) hōʻike ʻia ma ke ʻano he hui Hoʻoiho a hoʻololi:
Ke hoʻohana nei i nā mea hana o kēia pūʻulu, hiki iā ʻoe ke hoʻoiho i nā papa i Excel mai kahi kokoke i nā ʻano kumu nui o nā waihona, ka Pūnaewele a me nā kumu ʻē aʻe:
Ma hope o ka hoʻouka ʻana, hiki ke hana ʻia ka ʻikepili i loaʻa me ka hoʻohana ʻana i ka Power Query, "e lawe mai i ka manaʻo":
- hoʻoponopono i nā helu-like-text a me nā lā-like-text
- hoʻohui i nā kolamu i helu ʻia a i ʻole e wehe i nā kolamu pono ʻole
- hoʻohui i nā ʻikepili mai kekahi mau papa i hoʻokahi maʻalahi, etc.
Ma keʻano laulā, he mea hoʻohui maikaʻi loa kēia no ka poʻe e hoʻouka i ka nui o ka ʻikepili mai ka honua waho i Excel.
Nā papa pākuʻi
Ua loaʻa i kahi mea hana pono e like me nā papa pivot i kēia mana i ʻelua mau hoʻomaikaʻi liʻiliʻi. ʻO ka mea mua, i ka papa me kahi papa inoa o nā māla, i ka wā e kūkulu ai i kahi hōʻuluʻulu, ua ʻike ʻia kahi mea hana no ka ʻimi wikiwiki ʻana i ka māla i makemake ʻia:
He mea maikaʻi loa inā loaʻa nā kolamu he nui i kāu pākaukau + ua hoʻohui pū ʻoe i nā mahina helu mai iā ʻoe iho.
ʻO ka lua, inā kānana ʻia ka papa pivot e kahi Slicer a i ʻole Scale, a kaomi pālua ʻoe i kahi kelepona me ka ʻikepili e "hāʻule" i loko o nā kikoʻī, i kēia manawa ua mālama ʻia nā ʻāpana i koho ʻia ma nā ʻāpana a me nā unahi (ma mua. nānā ʻole ʻia, me he mea lā ʻaʻohe ʻāpana, ʻaʻohe unahi).
Mea hana wānana
Ua loaʻa iā Excel 2016 kekahi mau mea hana wānana hou. ʻO ka mua, ma ka māhele ʻO Statistical (Heluhelu) aia nā hana no ka helu ʻana i ka wānana me ka hoʻohana ʻana i ke ʻano smoothing exponential:
- FORECAST.ETS - hāʻawi i kahi waiwai wānana no ka lā i hāʻawi ʻia i ka wā e hiki mai ana me ka hoʻohana ʻana i ke ʻano exp.smoothing i hoʻoponopono ʻia i ka manawa.
- FORECAST.ETS.DOVINTERVAL - Ke helu nei i kahi manawa hilinaʻi no ka wānana
- FORECAST.ETS.SEASONALITY - ʻIke i ka manawa i ka ʻikepili a helu i kona manawa
- FORECAST.ETS.STAT - Hāʻawi i nā helu kikoʻī e pili ana i ka helu helu no ka wānana i helu ʻia
- PREDICT.LINEST - Heluhelu i kahi au laina
Ua ʻike pū ʻia kahi mea hana maʻalahi no ka hana ʻana i nā wānana ma ka lele - ke pihi Pepa wānana uku pila 'Ikepili (Lā):
Inā koho ʻoe i ka ʻikepili kumu (nā manawa a i ʻole nā lā a me nā waiwai) a kaomi i kēia pihi, a laila e ʻike mākou i kēia pukaaniani:
E like me kāu e ʻike ai, hiki iā ʻoe ke hoʻonohonoho maʻalahi i nā ʻāpana wānana e pono ai i loko a ʻike koke i ka hopena i kahi kiʻi kiʻi - kūpono loa. Inā ʻoe e kaomi i ke pihi Hoʻoulu, a laila e hōʻike ʻia kahi pepa hou, kahi e hana ʻia ai ke ʻano wānana me nā ʻōkuhi:
Mea maikaʻi. Ma mua, no ka laʻana, ma kahi hoʻomaʻamaʻa wānana, hana mākou i kēia me ka lima "mai" a "i" - a ua lawe i kahi manawa kūpono loa.
Ma kēia ʻano hoʻi, ua neʻe kekahi mau hana makemakika a me ka helu helu i ka māhele hoʻokaulike (Hoʻohālikelike), no ka mea, ma kahi o lākou, ua ʻike ʻia kā lākou "mau mamo" maikaʻi loa.
Nā hopena hope loa
ʻAʻole hoʻokuʻu ʻia ka Technical Preview, a ma ka mana hope paha e ʻike mākou i kekahi mau loli hou a me nā hoʻomaikaʻi. Akā, ʻoiai, ʻaʻohe mea e manaʻo ʻia (e ʻōlelo kekahi no ka maikaʻi, malia paha). Hoʻopololei ʻo Microsoft i nā hiʻohiʻona e kū nei a hoʻohui mālie i nā mea hou mai ka mana i ka mana.
Maikaʻi, ʻo ka hope, ua ʻike ʻia nā ʻano papa kuhikuhi hou i kali ʻia e nā mea a pau no ka manawa lōʻihi, akā aia nō kahi wahi no ka ulu ʻana – nā palapala papahana (Gantt, Timeline), nā palapala ʻala ("thermometers"), etc. nā hiʻohiʻona. ʻAʻole hoʻi au i ʻoluʻolu e pili ana i ka hiki ke hana ʻia nā sparklines no ka manawa lōʻihi ʻaʻole ʻekolu mau ʻano, akā ʻoi aku ka nui, e like me ka mea mua.
Maikaʻi ke kūkulu ʻia ʻana o nā mea hoʻohui pono (Power Query, Power Pivot) i loko o ka papahana ma ke ʻano maʻamau, akā hiki ke hāʻawi manawaleʻa ʻoiai ma Fuzzy Lookup me Power Map. ʻO ka mea pōʻino, ʻaʻole i kēia manawa.
A ʻo wau iho, kala wau ʻaʻole mākou e ʻike, me he mea lā, i ka mana hou o Excel 2016, ʻaʻole nā mea hana kiʻekiʻe no ka hana ʻana me nā pae (ka hoʻohālikelike pae, no ka laʻana), ʻaʻole hoʻi i nā hoʻomaikaʻi ʻana i ka ʻōnaehana hoʻonohonoho Visual Basic (ʻo ia hoʻi. ʻAʻole i hoʻololi ʻia mai ka makahiki 1997), ʻaʻole nā hana hou e like me VLOOKUP2 a i ʻole Sum i nā huaʻōlelo.
Manaʻo wau e ola a hiki i ka manawa e ʻike ʻia ai kēia mau mea ma Excel, akā i kēia manawa pono wau e hoʻohana i nā koʻokoʻo maʻamau.