20 zidule kuti inu mphunzitsi Excel

Munthu aliyense amene akugwira ntchito pa kompyuta, kuyankha kuti inde, ngati inu kukamufunsa ngati iye amadziwa ntchito mu kupambana. Komabe, ngati inu anamufunsa njira ina ndi kuyesa kupeza momwe bwino, ambiri izo chisokonezo. Koma pakhoza kukhala wokhoza kuthana? Ndipotu pulogalamu zimasunga ndi yaikulu zinsinsi zomwe chabe musati mupereke chidwi. Koma ngati inu mukudziwa za iwo, iwo mwamsanga kukhala mumaikonda kwambiri. Choncho, m'nkhani ino mudzaphunzira za makumi awiri zidule osiyana mu "Eksele" kuti aliyense ayenera kudziwa.

Sankhani onse ndi pitani imodzi yokha

Mu chapamwamba kumanzere ngodya ya m'munda pali batani palibe wina zambiri sichiwakanikiza. Ndipo ndi zothandiza, monga timatha chimodzi pitani kusankha maselo onse chikalata panopa.

Inayambira owona angapo

processing Data - ichi ndi mbali yaikulu ya pulogalamu imeneyi, koma kodi kuchita ngati muli ambiri owona, omwe mukufuna kugwiritsa ntchito? Kwenikweni m'pofunika kutsegula aliyense wa padera? Ndipotu, pali wina tsenga kuti adzalola kuti kupirira ntchito mofulumira. Sankhani owona mukufunika ndi akanikizire Lowani - iwo onse lotseguka popanda nkhondo pakati pawo.

Ataona owona

Pamene mukuchita nalo ambiri zikalata, kwambiri limakhumudwitsa kufunika pamanja kusinthana pakati pawo. Mukhoza musavutike pogwiritsa ntchito mitundu kiyi Ctrl + Tab, amene basi masiwichi kwa tsamba lotsatira.

zinthu menyu

Anthu ambiri amakhulupirira kuti "Save", "Forward" ndi "Back" - awa ndi options chilipo mu pulogalamu ya ku menyu pamwamba. Koma mukhoza kuwonjezera iwo kuti chiwerengero cha ntchito kupyolera zoikamo wapadera chipika - ingokumbukirani kuti zolemba anasonyeza awiri - zotsalazo ndidzafotokoza kubisika.

Mfundo opendekera muchipindachi

Nthawi zina muyenera kudziikira selo opendekera mzere kuti kugawana nzeru kusinthidwa kwa izo. Koma momwe angachitire izo? Onse amatha kufotokoza malire a maselo, koma ngati inu dinani "Borders More", udzapeza osati mzere opendekera, komanso zodabwitsa zina.

Powonjezera mizere zambiri kapena mizati

Aliyense akudziwa m'mene kuwonjezera mzere kapena ndime ya maselo. Koma kuwonjezera angapo zidutswa payokha - ndi wovuta weniweni. Chotero, inu kulibwino kusankha nambala Napempha kwa maselo zizigwirizana ndi nambala Napempha kwa mizere kapena mizati, ndipo kenako abwereza ntchito muyezo.

Fast ukuthamana

Kodi ngati mukufuna kungoloŵerera ndime imodzi deta? Kuti tichite zimenezi, sunthani cholozera kumalire a mzati, kufikira zimatengera mtundu wa mtanda woboola pakati muvi, pite nkhani za mzati ndi mtima wonse.

Kuchotsa maselo kanthu

Mu ndondomekoyi, nthawi zambiri pali ambiri maselo kanthu, amene amawononga maonekedwe a mpukutuwu. Mungathe kuchotsa iwo mmodzimmodzi - kapena ntchito njira yachidule. Kuti tichite zimenezi, muyenera zosefera deselect katunduyo "Onse" ndi kusankha "Chopanda" - izo yomweyo amasankha maselo akusowekapo onse mu chikalata mukhoza kuchotsa ndi pitani limodzi.

kufufuza zolakwika

Aliyense amadziwa kugwiritsa ntchito kufufuza mwamsanga, koma anthu ochepa kudziwa chakuti simungathe kufufuza machesi enieni, ndipo zotsatira makalata umodzi kapena kuposerapo. Kufufuza kalata imodzi, muyenera mu kufufuza kapamwamba kulowa chizindikiro cha funso, ndipo ngati mukufuna kufufuza ndi kulowa makalata angapo - Gwiritsani ntchito ndi asterisk.

Pangani mtengo wapadera

Anthu ambiri amagwiritsira ntchito Zosefera, koma konse pafupifupi kuyang'ana mu gawo patsogolo. Koma ndi izo, inu mukhoza mwatchutchutchu mtengo wapadera kwa selo makamaka ngati mukufuna kuti ntchito kapena pa zolinga zina.

mfundo ya nkhani

Osati aliyense amadziwa kuti mukhoza kuika malire pa zomwe adzakhala adalowa selo. Mwachitsanzo, ngati inu akhazikitsa mndandanda wa anthu oitanidwa ku mwambowu, ndi mibadwo yawo akhoza zosiyanasiyana, kuyambira 18 mpaka 60 zaka (yekha manambala lonse), ndiye onse mungachite izi mukhoza kusankha ku menyu "Data" ndiyeno mfundo zina chabe sadzayanjidwa .

navigation Quick

Kuyenda mofulumira kudzera tsamba chikalata, mungathe kugwiritsa ntchito Ctrl kiyi mivi. Ngati inu ntchito kuphatikiza, inu kuwafika endpoint maselo zambiri.

kusinthika

Nthawi zina ndizofunikira kutembenukira mzati mu mzere, kapena mosinthanitsa. Ndipotu, izo zikhoza kuchitidwa zapamwamba. Kuchita izi, inu ayenera kutsatira mfundo anakhumba, kenako muiike iyo ku menyu ndi kusankha "Sinthani" - ndipo nambala yanu liti liwonerere kwa mzati.

Kodi kubisa imfomeshoni yomwe mukufuna?

Mu "Eksele" angathe kubisala zambiri, koma izo zikhoza kuchitidwa mosiyanasiyana. Mukhoza alemba pa foni ndi kusankha "Bisani" chake, koma ayi zotsatira zabwino. Choncho tikulimbikitsidwa kuti ntchito foni Zokongoletsa kwa Mtundu mtundu ;;; - izo amalola inu infomeshoni yodalirika saona kuwafunsa mafunso ochititsa manyazi.

Yonseyi deta ku maselo

Ngati muli maselo angapo, ndipo muyenera kuphatikiza mfundo amasungidwa iwo mu lina, mudzadziwa sikuti zonse kwathunthu anasintha. Kungokhala ntchito imene maselo pakati mayina a chofunika Ikani "ampersand" mafano - zotsatira mu selo anasankha, iwe deta onse ya anthu m'mbuyomo.

Kusintha lowercase kuti zazikulu

Ngati mukufuna lemba la ku selo imodzi kwathunthu yalembedwa m'malembo, inu simukusowa kuti Lembaninso kwathunthu ndi adamulowetsa CapsLock. Inu muyenera kugwiritsa ntchito chapamwamba mu parentheses akusonyeza wotani selo anafunika atembenuke.

Data kuyambira 0

Nthawi zina, mungafunike kulowa deta selo imene imayamba ndi 0. Mwatsoka, ndi kusakhulupirika, pulogalamu basi amachotsa ziro, kusiya kokha kufunika inteja. Mukhoza kusintha mtundu wa khungu, koma ndi ndondomeko yaitali kuti n'kosavuta m'malo losavuta chizindikiro umodzi amagwira. Ngati inu n'kuiika kutsogolo kwa phindu lanu, ndiye ziro tidzakhalabe malo.

autocorrection

Anthu ambiri amagwiritsira ntchito AutoCorrect monga anafunira, kuti si mantha kusindikiza zolakwika, chifukwa iwo akudziwa kuti mapulogalamu awo adzalungamitsa. Koma anthu ochepa kwambiri amabwera msanga m'maganizo mwanu kuti mukhoza kugwiritsa ntchito mbali wosalira ntchito yake. Ngati muli mawu chosatha yaitali, maina, ndiye inu mukhoza kuwonjezera iwo pa mndandanda wa mawu kuti autocorrection muziganizira analemba za chachiwiri - ndi pulogalamu yokha awatsogolere mu mawonekedwe woyenera, muyenera kudzifunsa kamodzi m'malo mwa mazana.

zambiri

Ngati inu kusankha khungu mu ngodya m'munsi pomwe pali zambiri za izo. Komabe, kutali wathunthu, koma mukhoza kupeza mwayi mwamtheradi deta onse. Kuti tichite zimenezi, muyenera fungatirani chakumanja pa mfundo ndi kumadula pa mbewa batani bwino - umathandiza zenera, umene muli deta zonse pa khungu imeneyi.

renaming masamba

Imodzi mwa njira zosavuta, amene pazifukwa zina pafupifupi aliyense amagwiritsa ntchito. Nthawi zambiri, inu muyenera Sinthani dzina masamba chikalata, ndi kuti inu alemba pa dzina, dinani-kumanja, ndiye kusankha "Sinthani dzina", ndiye kusintha dzina. Koma ndondomeko akhoza kwambiri wosalira pogwiritsa ntchito tsamba mfundo mofanana ndi njira yachidule ndi owona mu Windows. Iwiri pitani pa dzina la tsamba kumakupatsani mwayi yomweyo kusintha ndi kusintha mwamsanga.