Nzira yekuita tafura inotarisa zvakanaka sei muExcel
Nzira yekuita nayo Excel kutarisa zvakanaka
Kufungisisa kuti ungaita sei tafura kutarisa zvakanaka mu MS Excel 2013?
Heano matanho mashomanana okukubatsira iwe, nemuenzaniso wakakwana pasi apa:
Ita sepafurafura, uchishandisa Excel maitiro akafananidzwa,
https://www.ybierling.com/v2/fr/: Tsvaga mabasa emunharaundaKopora mafomati, kubva pane imwe sero kuenda kune imwe,
Kubatana uye nzvimbo, apo tsanangudzo yesero inoshanda kune dzimwe nhamba / mitsetse,
Wedzerai miganhu, kuti muonekwe muchidimbu zvibato zvakakosha zvinokosha,
Isa magwaro kuti ushingaire, kuti uone maziso ekukosha,
Fomera masero anokosha, kuratidza zvakanaka nhamba, zvikamu, ...
Resize mapuroni kuti akwanise zvinhu.
Iwe unogona kugara uchienda mberi, asi matanho aya ari nyore uye anokurumidza achaita kuti yako Excel itafura ioneke zviri nani.
Nzira yekuita nayo Excel kutarisa zvakanaka
Kutanga kubva patafura isina kuenzaniswa, sezvinoonekwa pasi apa, unogona kuona pane zvakawanda zvokuvandudza.
Nhanho yekutanga, shandisa imwe yeExcel tafura kune zvinyorwa zvakasiyana. Sarudza ivo, uye shandisa iyo Fomu seTableoption kubva muStyles box mu Menu HOME.
Iwe unogona kushandisa Medium mafambiro ezvakagadzirwa, uye Nemafasi emumvuri kune zvinyorwa zvinyorwa, sezvinoratidzwa mumuenzaniso.
Iva excel Pro: Joinha kosi yedu!
Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.
Nyoresa pano
Kana uine mamwe masero, uye unoda kushandisa chimiro chakafanana, sarudza sero kubva pane iyo chimiro inofanira kunyorwa, tora pa Format Painter kubva kuBhokisi reBhokisi reBhokisi muKUTA menu, uye chengetera pamasero maunoda kukopa format.
Kana masero akawanda achimiridza ruzivo rumwechete, panzvimbo pekudziputira, funga kuti seni yokutanga yekusarudzwa (kubva kuruboshwe kumusarudzo yakanyanyisa, kana kuti kumusoro kwezvakananga kusarudzwa), sarudza masero ezvinyorwa zvinofanira kunge ane mashoko akafanana, uye shandisai Merge & Centre sarudzo kubva muBhokisi Rokubatanidza mumusangano weKUSHAYA.
Kuti uite zvimwe zvikamu zvemashoko zvakajeka, semuenzaniso zvinyorwa uye zvikamu, sarudza mutsara wakatarisana kana korombo, uye shandisa Border kubva paPolic box mukati memenyu MAP.
Inogonawo kuva yakakosha kugadzirisa ipapo muBold kubva pane imwechete Font mukati memenyu MAP.
Zvimwe zvinyorwa zvingada kushandurwa, semuenzaniso nhamba dzinongoratidzira 2 dzakatarwa, kana dzimwe nhamba dzakarongerwa se Percentage. Sarudza dhesi raunoda kufomira, kurudyi, chofa pakusarudzwa, uye sarudza maFomisi ekufambisa ... sarudzo.
Muchigadziro ichocho, sarudza sangano raunoda kushandisa, uye shandura zvasarudzo kuti zvikwanise zvaunoda, kwatiri isu Mazana ne 2 decimals.
Zvadaro, sarudza mapuranga, uye kana uine ikiratidzo sezvinoratidzwa pamufananidzo nekutsanangura kumativi ekutsanangurwa kwemashure maviri emutsara, kaviri kacho kuti uenzanise ivo vose.
Uye voilà! Tafura yako inofanira kuonekwa iye zvino zviri nani uye iwe zvino unogona kugovera.
Nzira yekuita tafura yakaisvonaka yeExcel
Kuti uite tafura yakanaka yekutarisa muExcel, sarudza tafura, uye enda kumenu menu Home> Faira seTebhete> sarudza tafura yekufambisa.
Zvinogoneka kutamisa mouse pamusoro pemitauro yakasiyana, uye ona kuchinja munguva chaiyo patafura. Kana imwe nzira yakakwana yakawanikwa patafura, zvinyoronyoro pairi mumutambo semuchina wepafura kuti uishandise, uye ita tafura yakanaka yekutarisa muExcel.
Maitiro Aungaita Ma Spreadsheets Wako Pasi Pamberi
Mibvunzo Inowanzo Bvunzwa
- Maitiro ekuita kuti tafura yekunakidza inotaridzika zvakanaka?
- Kuti uite tafura yekunyanyisa inotaridzika zvakanaka, iwe unogona kusarudza tafura uye shandisa maitiro kubva ku'fomu setswa yetafura yebhuta iri mumba yekutandarira. Gadzirisa column midthths, kusanganisa uye pakati masero ane ruzivo rwakajairika, uye shandisa miganhu uye zvakashinga kuumbwa kuratidza nzvimbo dzakakosha. Yeiyo nhamba yehuwandu, masero emhando yekuratidzira nhamba, muzana, nezvimwewo, nenzira kwayo.
- Ndedzipi dzimwe nzira dzinobudirira dzekuvandudza kufadza kwekuona kwetafura muExcel?
- Kuvandudza chikumbiro chetafura
Zadzisa 2019 Excel yeVatanga mune vhidhiyo
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.
Iva excel Pro: Joinha kosi yedu!
Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.
Nyoresa pano