Iwe unoda kuchinja yako Excel spreadsheet kubva kunzvimbo yakakosha ye nhamba kuva mu nyore nyore-kudyira chiratidzo? Hapana chinoshandura data yakasvibiswa mune chimwe chinhu chinonzwisiswa sechati. Kunyange zvazvo Microsoft inonyanya kusiya mapirati kubva pakatanga kusunungurwa kweShoko uye PowerPoint yePadad, zvinenge zviri nyore kugadzira chati mu Excel. Iwe unogona kunyora mapepa kubva kuExcel uye uvanamatire muShoko kana PowerPoint.
Ngatitangei.
- Tanga Excel uye uzarure pepanheji itsva kuti uise data. Kana uri kushandisa spreadsheet iripo, unogona kugadzirisa zvakare data kuti ienderane nechadhi.
- Dhavhidha inofanira kutora fomu yegridhi, kunyange iwe unongova nemutsara mumwe wematare. Iwe unofanirwa kuva nekodhi kuruboshwe rwemutsara wega we data uye pamusoro peimwe imwe yendarama. Aya mavara achashandiswa mukugadzira chati.
- Paunenge wakagadzirira kuumba yako chati, pfupa pane sekuru-kuruboshwe pane grid yako yedata. Inofanira kunge iri jeri risingafungi riri pamusoro pemakero ako emutsara.
- Iwe unokwanisa kuwedzera kusarudzwa nenzira mbiri: (1) Paunotanga kuisa bhokisi risina chinhu, usasimudza munwe wako. Pane kudaro, shandura iyo pasi kusvika pasi-right right cell. Kusarudzwa kuchawedzerwa nemunwe wako. Kana (2), mushure mekunge vanyora musero usina kuvharika, sero richaiswa pachena nemavhudzi madema kumusoro-kuruboshwe uye nechokurudyi. Aya ndiwo anchor. Dhadza pasi-nechokuita nechokuita uye shandisa munwe wako kumucheto-kurudyi wekeri mujeri rako.
- Iye zvino kuti deta yacho yakasimbiswa, tapota "Isa" pakakwirira uye sarudza Charts.
- Kune mhando dzakawanda dzakasiyana-siyana dzinotsvaga kubva pane mabhadhi ekuisa mapeti kumatare emunharaunda kuparadzira matikiti. Shandura zvikamu uye sarudza chati yaunoda kusika.
- Kana ukasarudza rudzi rwechati, chati ichaiswa muparashiro. Iwe unogona kutora chati iyo yakapoteredza nekukwira nekuikurira iyo pachikona. Iwe unogonawo kushandisa zvishandiso (midzi midzi mumativi edenga chati) kuti ushandure tashati kuburikidza navo nekusvetedza munwe wako.
- Unoda kuchinja mavara? Kuisa chati kungasawana zvose zvakanaka. Kana iwe uchida kuchinja mavara, tora chati kuitira kuti iiswe pachena uye tapota "Shandura" kubva mumutambo weChirati.
- Usafarira chimiro? Chero nguva ipi zvayo iwe unobata chati kuti uisimbise, mhando yechati inooneka kumusoro. Iwe unogona kusarudza "Zvirongwa" kuti uchinje kune imwe yenzira dzakawanda dzakasiyana. Panewo dzimwe sarudzo dzekuchinja mavara, mararamiro emagrafu, kana kutoshandura kune rumwe rudzi rwemafirimu.
- Kana iwe usingadi chigadzirwa chekupedzisira, tanga zvakare. Ingoshandisa chati yacho uye sarudza "Bvisa" kubva pane menyu kuti ubvise chati. Simbisa grid zvakare uye sarudza chati itsva.