Tsamba loyamba kwa Microsoft Excel
Muyenera kuphunzira momwe mungagwiritsire ntchito Microsoft Excel, spreadsheet yotchuka kwambiri padziko lonse lapansi? Komabe, zingakhale zoopsa pokhapokha mutayambitsa pulogalamuyo. Mmene Mungagwiritsire ntchito Excel ndi maphunziro opangidwa ndi maganizo oyamba. Malangizo awa akuphatikizapo zitsanzo zotsatila ndi zitsanzo za momwe mungagwiritsire ntchito Excel kukhazikitsa spreadsheet yofunikira; sankhani phunziro kuti muyambe!
Zojambula Zisudzo Zojambula
Masewero awa a Screen Screen Elements amadziwika zigawo zazikulu za pepala la Excel, poganizira:
- Selo ndi yogwira ntchito
- Onjezani chithunzi cha pepala
- Makalata olembera
- Nambala ya mazere
- Babu lachikhalidwe
- Bwalo lamula
- Bokosi la dzina
- Mabatani a Ribbon ndi Ribbon
- Fufuzani tabu
Tsamba loyamba la Excel
Phunziro la Basic Excel Spreadsheet lili ndi zofunikira zokonza ndi kupanga mapepala apamwamba mu Excel zatsopano. Mitu yophimbidwa ndi:
- Kulowa deta
- Kupanga mawonekedwe osavuta
- Kufotokozera dzina lotchulidwa
- Kujambula ma fomu ndi mankhwala odzaza
- Kugwiritsa ntchito nambala ndi mawonekedwe a selo ku tsamba la ntchito
- Kuwonjezera maonekedwe a selo
Excel Math
Phunzirani kuwonjezera, kuchotsa, kuonjezera ndi kugawa ziwerengero mu phunziro la Excel Math . Phunziroli likuphatikizanso kusintha kayendetsedwe ka ntchito mu machitidwe, zolemba ndi masombuli a Excel.
Mutu uliwonse umaphatikizapo chitsanzo chotsatira ndi ndondomeko momwe mungapangire ndondomeko yomwe idzachita chimodzi kapena zingapo pa masamu anayi ofunika ku Excel.
Kuwonjezera Pamwamba Pamwamba Ndi Ntchito SUM
Gawo ndi siteji malangizo a momwe mungagwiritsire ntchito ntchito ya Excel ya SUM . Popeza kuwonjezerapo mizere ndi nambala yazithunzi ndi chimodzi mwa ntchito zofala ku Excel, Microsoft yakuphatikizira njirayi kuti ntchitoyi ikhale yosavuta. Maphunzirowa akuphatikiza:
- Ntchito ya syntax ndi ndemanga
- Kulowa ntchito ya SUM
- AutoSUM
- SUM ntchito ntchito dialog box
Sungani kapena Lembani Data
Mu phunziro ili, phunzirani momwe mungagwiritsire ntchito makiyi afupikitsidwe kuti mudule, kukopera ndi kusunga deta mu Excel . Sungani deta kumalo atsopano kapena muwerenge mobwerezabwereza. Maphunzirowa akuphatikiza:
- Njira zokopera deta
- Chojambulajambula ndi kudutsa deta
- Mukugwiritsa ntchito makina achingwe kuti mupange ndikuyika
- Pogwiritsa ntchito mndandanda wamakono kuti mukope deta
- Pogwiritsa ntchito masewera omwe ali pa Tsambali la Pakiti kuti mukope deta
- Kusuntha deta ndi makina osinthika
- Kusuntha deta ndi menyu yoyenera ndi kugwiritsa ntchito tsamba la Home
Onjezerani / Chotsani Zikhoma ndi Mizere
Mukufunikira kusintha ndondomeko ya deta yanu? M'malo mongowasuntha deta, bwanji osangowonjezera, kapena kuchotsa zipilala ndi mizere kuti muwonjeze kapena kuchepetsa malo ogwira ntchito ngati mukufunikira? Phunzirani njira zabwino zowonjezeretsera kapena kuchotsa zipilala zosawerengeka kapena zingapo ndi mizere yambiri pogwiritsa ntchito njira yachinsinsi kapena menyu.
Bisani / Sungani Zikhoma ndi Mizere
Mukhoza kubisa mizere ndi mizere yomwe ili ndi deta mu spreadsheet. Kuchita zimenezi kungakhale kosavuta kuganizira pazinthu zina, zofunikira pa tsambali ndipo n'zosavuta kubwezeretsanso pamene mukuwona deta yobisika.
Kulowa Tsiku
Phunzirani momwe mungagwiritsire ntchito njira yachinsinsi kuti mulowetse mwamsanga nthawi ndi nthawi yowonjezera pa Excel spreadsheet. Ngati mungafune kukhala ndi ndondomeko ya tsiku mpaka tsiku lomwe likupezeka nthawi zonse pamene tsamba lidatsegulidwa, gwiritsani ntchito ntchito YA MASIKU ano m'malo mwake.
Kulowa Data mu Excel
Musaphonye ndondomeko izi zisanu ndi ziwiri pazochita zabwino zowalowetsa deta muzomwe muli nawo :
- Kukonzekera tsamba
- Kuyika deta
- Kulowa mutu ndi deta
- Kuteteza mawonekedwe apakompyuta
- Kugwiritsa ntchito ma selolo m'mafomu
- Sungani deta yanu
Chati cha Column
Zomwe zimatchedwanso bar grafu, zigawo zachitsulo zimagwiritsidwa ntchito kusonyeza kufanana pakati pa zinthu za deta. Chigawo chilichonse mu tchatichi chikuimira kusiyana kwa deta kuchokera pa tsamba. Phunzirani momwe mungagwiritsire ntchito bwino mu phunziro ili.
Mzere wa Mzere
Ma graph a mzere kapena mzere wa mzere amagwiritsidwa ntchito kusonyeza zochitika pa nthawi. Mzere uliwonse mu graph umasonyeza kusinthika kwa mtengo wa deta imodzi yamtengo wapatali kuchokera pa tsamba.
Chitsa Chapala
Mapepala amapepala amagwiritsidwa ntchito kusonyeza peresenti. Mndandanda wosakanikirana wa deta uli wokonzedweratu ndipo pagawo lililonse limaphatikizapo chiwerengero chimodzi cha deta kuchokera pa tsamba la ntchito.