Sungani Maofesi ku Excel 2003

01 ya 05

Tsekani Mizati ndi Mizere Mu Excel ndi Zowonongeka

Nthawi zina zimakhala zovuta kuwerenga ndi kumvetsa mapepala akuluakulu kwambiri. Mukaponyera kutali kwambiri kumanja kapena pansi, mumataya mutu womwe uli pamwamba ndi pansi kumanzere kwa tsamba . Popanda mutu, ndi zovuta kuti muzindikire ndondomeko ya deta yomwe mukuyang'ana.

Pofuna kupewa vutoli, gwiritsani ntchito maofesi omwe amawombera ku Microsoft Excel. Ikuthandizani kuti "muzimitse" malo ena kapena mapepala a spreadsheet kotero kuti apitirize kuwoneka nthawi zonse pamene akuwombera kumanja kapena pansi. Kusunga mutu pawindo kumapangitsa kuti mukhale ovuta kuwerenga deta yanu lonse spreadsheet.

Mauthenga ofanana: Excel 2007/2010 Maofesi Otsitsa .

02 ya 05

Sungani Masewera pogwiritsa ntchito selo yogwira ntchito

Pamene mutsegula Maofesi Opanda Pulogalamu ku Excel, mizere yonse pamwamba pa selo yogwira ntchito ndizitsulo zonse kumanzere kwa selo yogwira ntchito zakhala zowonongeka.

Kuti muzitha kufalitsa ndondomekoyi ndi mizere yomwe mukufuna kuti mukhale pachiwonetsero, dinani selo kupita kumanja kwazitsulo ndi pansi pa mizera yomwe mukufuna kuti mukhale pawindo.

Mwachitsanzo - kusunga mizere 1,2, ndi 3 pazenera ndi ndondomeko A ndi B, dinani mu selo C4 ndi mbewa. Kenaka sankhani Window> Sungani Zowonongeka kuchokera ku menyu, monga momwe zasonyezedwera mu chithunzi pamwambapa.

Mukufunanso thandizo?

Chotsatira, ndi chitsanzo chachifupi ndi chitsanzo cha kukuwonetsani momwe mungagwiritsire ntchito maofesi a Microsoft Excel.

03 a 05

Pogwiritsa ntchito Excel Auto Fill

Kuti tiwonetsere mawonetseredwe owonetseratu pang'ono, tidzalowa mwachangu deta pogwiritsira ntchito Zomwe Tidzakwaniritsa kuti zotsatira za zozizira zikhale zovuta kuziwona.

Zindikirani: Maphunziro Otsogolera Excel Auto Akukuwonetsani momwe mungakwaniritsire mndandanda wanu kuti Mudzalitse.

1. Lembani "Januwale" mu selo D3 ndikusindikizira ENTER kwa makiyi.
2. Sankhani selo D3 ndikugwiritsira ntchito gwiritsirani pansi pamzere wapansi wa selo D3 kuti galimoto idzaze miyezi ya chaka chomwe chimatha ndi October mu selo M3.
3. Lembani "Lolemba" mu selo C4 ndikusindikizira ENTER .
4. Sankhani selo C4 ndipo gwiritsani ntchito gwiritsani ntchito galimoto kuti mudzaze tsiku la sabata lomaliza ndi Lachiwiri mu selo C12.
5. Lembani nambala "1" mu selo D4 ndi "2" mu selo D5.
6. Sankhani maselo onse awiri D4 ndi D5.
7. Gwiritsani ntchito chida chodzaza mu selo D5 kuti galimoto igwirizane mpaka selo D12
8. Tulutsani batani la mouse.
9. Gwiritsani ntchito chida chodzaza mu selo D12 kuti galimoto igwirizane ku M12 selo.

Chiwerengero cha 1 mpaka 9 chiyenera kudzaza zipilala D mpaka M.

04 ya 05

Kusokoneza Magulu

Tsopano kwa mbali yosavuta:

1. Dinani pa selo D4
2. Sankhani Mawindo> Sungani Mawindo kuchokera pa menyu

Mzere wandiweyani wakuda udzawoneka pakati pa zigawo C ndi D ndi mzere wolumikiza pakati pa mizere 3 ndi 4.

Mzere 1 mpaka 3 ndi zigawo A mpaka C ndizozizira pazenera.

05 ya 05

Onani Zotsatira

Gwiritsani ntchito mivi ya mpukutu kuti muwone zotsatira za mafunde ozizira pa spreadsheet.

Pezani Pansi

• Gwiritsani ntchito mpukutu wowongoka mu Excel kuti mupange pansi. Mzere 1 mpaka 3 uyenera kukhala pawindo, kuphatikizapo miyezi ya chaka pamene nambala 1 mpaka 9 zimasokonekera pa tsamba la spreadsheet.

Bwererani ku selo D4

1. Dinani pa Bokosi la Dzina pamwamba pa ndime A
2. Lembani D4 mu Bokosi la Dzina ndipo pindikizani ENTER mwachinsinsi pa kambokosi. Selo yogwira ntchito imakhala D4 kachiwiri.

Mipukutu Ponse

• Gwiritsani ntchito mivi yopendekera yopendekera kuti mupite kumanja. Phukusi A ayenera kukhala pawindo, kuphatikizapo manambala, pamene miyezi ya chaka imatha kupezeka pa tsamba la spreadsheet.