Maupangiri 5 apamwamba a Microsoft Excel mu Office 365
Kaya mumagwira ntchito yowerengera ndalama, lembani ma invoice, kapena kungolemba manambala ena mwachisawawa, Microsoft Excel ndi pulogalamu yothandiza kwambiri kwa mabizinesi ndi ogula. Komabe, mosiyana ndi mapulogalamu ena a Office 365, Excel imayang'ana kwambiri pa data, zomwe zingakhale zoopsa kwa ena. Osadandaula, chifukwa tsopano tikukupatsirani malingaliro ena omwe timakonda kwambiri a Excel ndi machenjerero a Office 365. Malangizo ndi zidulezi sizimangokupulumutsani nthawi komanso zingapangitse zinthu kukhala zosavuta komanso kukuthandizani kuti mukhale katswiri wa Excel.
Gwiritsani ntchito njira zazifupi
Monga mapulogalamu ena a Office 365, pali njira zazifupi za kiyibodi zomwe zingagwiritsidwe ntchito mu Excel.
Mukamagwiritsa ntchito manambala ndi maspredishiti omwe amatha kukhala ndi mizere ndi mizere yopanda malire, njira zazifupizi zimatha kukupulumutsirani nthawi komanso mutu.
Tasonkhanitsa zina mwazokonda zathu .
- CTRL + Lowani: kubwereza malembawo. Dinani pa gulu lonse la maselo kenako lembani zomwe mukufuna kubwereza mu selo lomaliza, kenako dinani Ctrl + Lowani. Zomwe mudalemba zimapita ku selo lililonse..
- Alt + F1: Gwiritsani ntchito njira yachiduleyi kuti mupange ma chart pamasamba omwewo ndi data yanu. Mofananamo, kukanikiza F11 Kupanga tchati pa pepala losiyana
- Shift + F3 Gwiritsani ntchito njira yachidule iyi kuti muyike chinthu
- Alt + H + D + C: Gwiritsani ntchito njira yachiduleyi kuti mufufute ndime
- Alt + H + B: Gwiritsani ntchito njira yachidule iyi kuti muwonjezere malire ku selo
- Ctrl + Shift + $: Gwiritsani ntchito njira yachiduleyi kuti mugwiritse ntchito mtundu wa ndalama
- Ctrl + Shift + %: Gwiritsani ntchito njira yachiduleyi kuti mugwiritse ntchito mtundu wamtundu
- Ctrl + Shift + &: Gwiritsani ntchito njira yachiduleyi kuti mugwiritse ntchito malire a autilaini
- F5: Gwiritsani ntchito njira yachiduleyi kupita ku selo. Ingolembani F5 ndikusintha dzina la cell kapena cell
Yesani ntchito za IFS Boolean kuti muchotse kufunikira kwa mafomu omwe ali ndi zisa
IFS ndi ntchito yakwanuko yomwe imadziwika kuti "Ngati, izi, ndiye, ndi izo". Izi zimagwiritsidwa ntchito ndi akatswiri padziko lonse lapansi, ndipo zimatha kuwunika momwe zinthu ziliri mu Excel kuti musagwiritse ntchito mafomu omwe adakhazikitsidwa.
Mbali angagwiritsidwe ntchito polowa =IFS mu bar formula, kutsatira mawu. Kenako IFS imayang'ana kuti ione ngati zinthu zakwaniritsidwa ndipo ibweza mtengo womwe umagwirizana ndi TRUE. Chitsanzo cha IFS chikuwonetsedwa pansipa.
Pachithunzi chotsatira, tikugwiritsa ntchito fomula kuti tipange zigoli mu spreadsheet.
Gwiritsani ntchito bar kuti muwone momwe data ilili
Palibe amene amakonda kuwerengera mwachangu, koma Excel imatha kukukonzerani datayo mwachangu. Ngati muli ndi pepala la manambala, kapena manambala, malo owerengera amatha kukonza manambala anu mosavuta popanda kulemba fomula. Izi zikuphatikiza scalar, scalar, min, max, sum. Mukungoyenera kuwunikira deta kuti muyambe. Nthawi zina, mungafunike kuyatsa kaye. Ngati ndi choncho, dinani kumanja pa sitepe bar, ndipo dinani kuti mutsegule zosankha za ziwerengero zomwe mukufuna kuziwona.
Yesani mipiringidzo ya data kuti muwone deta yanu mwachiwonekere
Deta yayikulu ndiyothandiza, koma palibe chowoneka bwino kuposa infographics. Ndi mawonekedwe a Data Bars mu Excel, mutha kuwonjezera mipiringidzo pamagome anu omwe alipo popanda kuwonjezera graph. Mutha kuchita izi posankha deta ndi ma cell omwe mukufuna kujambula, kenako kupita Tsamba lofikira Kunyumba, ndi kusankha Conditional Formating , sankhani Mipiringidzo ya Data. Mutha kusankha kuchokera kudzaza kwa gradient kapena kudzaza mtundu.
Funsani thandizo ku Excel
Ngati mupeza kuti mwatayika mu Excel, pulogalamuyo imatha kukuthandizani. Ingodinani pabokosi lomwe lili pamwamba pomwe likunena Aliraza Ndipo mudzatha kusaka ntchito yomwe mukufuna kuchita mu Excel.
Bokosi losakira lidzakupatsani mwayi. Kapenanso, mutha kulemba nthawi zonse " Thandizeni" Mukusaka uku kuti muyimbe ndikupeza mndandanda wamitu ndi ntchito zodziwika bwino za Excel. Mitu ina yomwe yatchulidwa apa ndi momwe mizere, ntchito, maselo, mawonekedwe, masanjidwe, matebulo, ndi zina.
Kodi mudzatha kupeza mulingo wapamwamba mu Excel?
Pali zambiri zomwe mungachite ndi Microsoft Excel, ndipo ndizovuta kuzilemba mu positi imodzi yokha. Malangizo athu ndi zidule zathu zimangokhudza zoyambira, koma pali zambiri zoti mupeze. Tiuzeni m'mawu omwe ali pansipa maupangiri anu ndi zidule za Excel ndi Office 365.
Momwe mungakonzere zolakwika za Microsoft Excel
