Momwe mungapangire kalendala yanthawi mu Excel sitepe ndi sitepe

Crear una línea de tiempo en Excel Excel ndi njira imodzi yabwino kwambiri yosinthira magawo a polojekiti, kukonza ntchito, kapena kuwonetsa zochitika zingapo. Ngakhale Excel ikhoza kuwoneka ngati chida cha spreadsheet- komanso manambala, imapereka ntchito zingapo ndi zosankha kuti zisinthe mindandanda yosavuta kukhala mindandanda yanthawi yabwino.

Nthawi zambiri timagwirizanitsa nthawi ndi mapulogalamu enaake oyendetsera polojekiti, koma zoona zake n'zakuti Excel ili ndi kusinthasintha kokwanira kukwaniritsa zosowa zaumwini ndi zamalonda. Chofunikira ndikumvetsetsa zomwe zikupereka, kuphatikiza ma templates, ndikupezerapo mwayi pakusintha mwamakonda kuti zotsatira zake zikhale zomveka, zowoneka bwino, komanso zothandiza kwambiri. Pansipa pali kalozera wathunthu komanso waposachedwa kwambiri kuti muphunzire kupanga ndandanda yanthawi mu Excel sitepe ndi sitepe, pogwiritsa ntchito njira zamanja ndi ma templates ndi zowonjezera. Tiwonanso momwe tingasinthire kapangidwe kake ndikuwunika zina. Tiyeni tiyambepo momwe mungapangire kalendala yanthawi mu Excel. 

Kodi ndondomeko yanthawi ndi chiyani ndipo chifukwa chiyani pangani imodzi mu Excel?

A nthawi, amene amatchedwanso cronograma, ndi chida chowoneka chomwe chimawonetsa mndandanda wa zochitika, zochitika, kapena zochitika zazikulu zokonzedwa motsatira nthawi motsatira sikelo. Ntchito yake yaikulu ndi kulola kumvetsetsa kwachangu momwe polojekiti ikuyendera kapena kutsatizana kwa zochitika zofunika, kuthandizira kasamalidwe ka ntchito, masiku omalizira ndi omwe ali ndi udindo.

Onani m'maganizo mwanu zochitika zazikulu Pulojekitiyi imathandiza magulu kumvetsetsa momwe zinthu zilili pang'onopang'ono, kuyembekezera zolepheretsa, ndikufotokozera momwe zikuyendera komanso nthawi yomaliza kwa omwe akukhudzidwa nawo. Ngakhale zida ngati Microsoft Project kapena mapulogalamu apaintaneti ngati GanttPRO amakhazikika pa izi, Excel ndi njira yopezeka komanso yosinthika zomwe ogwiritsa ntchito ambiri ndi makampani ali nazo.

Zosankha zopangira nthawi mu Excel

Mutha kupanga ndandanda kuyambira poyambira pogwiritsa ntchito ntchito za Excel, makamaka pogwiritsa ntchito ma chart a scatter kapena mizere; kapena mukhoza kusankha zokonzedweratu zidindo ndi akatswiri mapangidwe zomwe zimapangitsa kuti ntchito ikhale yosavuta. Kuphatikiza apo, pali njira zina kunja kwa Excel ngati mukufuna kuthamanga kwambiri.

• Tchati chobalalitsa pamanja: Imakulolani kuti mupange nthawi yokhazikika kuchokera pamatebulo anu ndi data.
• Official Excel kapena Office.com templates: Iwo ndi ofulumira, owoneka bwino kwambiri komanso abwino kwa iwo omwe amaika patsogolo mapangidwe ndi zochitika.
• Mapulagini ndi mapulogalamu akunja: Mapologalamu ngati GanttPRO amapereka nthawi yopangira nthawi ndikudina pang'ono ndi zina zambiri zowonetsera.

Chitsogozo cha pang'onopang'ono popanga kalendala yanthawi mu Excel

1. Lowetsani zochitika zanu zazikulu ndi madeti patebulo

El primer paso es fotokozani zochitika zazikulu za polojekiti yanu. Pangani tebulo laling'ono mu Excel lomwe lili ndi zigawo ziwiri zazikuluzikulu: kufotokozera kwakukulu ndi tsiku logwirizana nalo. Mutha kuwonjezera ndime yowonjezereka kuti mugawire kuchuluka kwa manambala pamwambo uliwonse, kukulolani kuti muyike pamitali yosiyana mkati mwa tchati ndikuletsa zilembo kuti zisadutse:

• Columna A: Kufotokozera kwa Milestone (Chitsanzo: "Yambani", "Kutumiza Gawo 1", "Msonkhano Womaliza").
• Columna B: Tsiku la Milestone.
• Mzere C (posankha): Kutsatizana kwa manambala ngati 1, 2, 3, 4, kubwerezedwa ngati muli ndi malo angapo. Mwanjira iyi, mfundozo zidzawoneka pamtunda wosiyana.

Malangizo: Ngati muli ndi zochitika zambiri, sinthani manambala (monga 1, 2, 1, 2) kuti malembo asasunthike ndipo asadumphane.

2. Ikani tchati chomwaza

Mukamaliza kukonza tebulo, sankhani cell yopanda kanthu papepala ndikudina pa tabu Insertar. M'gulu lazithunzi, sankhani Dispersión ("Kubalalika") kapena "Tchati cha Bubble". Tchati chopanda kanthu chidzawonekera, kuyembekezera kukonzedwa.

Mtundu uwu wa tchati ndi wabwino kwa nthawi, chifukwa Mutha kufotokozera ma axes onse a X (masiku) ndi Y (mtengo / gawo lalikulu). mwamakonda kwambiri.

3. Onjezani deta yanu ku tchati

Dinani kumanja pa malo oyera a tchati ndikusankha Seleccionar datosZenera la magwero a data lidzatsegulidwa. Dinani pa Agregar kupanga mndandanda watsopano.

• X Makhalidwe: Sankhani deti lonse patebulo lanu.
• Y Makhalidwe: Sankhani ndime ya manambala. Ngati simunapange ndime iyi, mutha kuyika mfundo zonse pamlingo womwewo, ngakhale tikulimbikitsidwa kuti musinthe zikhalidwe kuti mulekanitse zochitika mkati mwa tchati.

Kanikizani Aceptar ndipo chiwembu chanu chobalalitsa chidzasintha kusonyeza mfundo zomwe zaikidwa malinga ndi tsiku ndi chiwerengero cha chiwerengero.

4. Sinthani graph kukhala nthawi

Muli nawo kale mfundozo, koma kuti graph igwire ntchito ngati ndandanda yanthawi yake muyenera kusintha mawonekedwe ake:

• Elimina elementos innecesarios: Dinani batani losankha ma chart (sign +) ndikuchotsa mizere ya gridi, mutu wa tchati, ndi mayendedwe oyima (Y), ndikusiya mtunda wokhawokha.
• Onjezani zilembo ndi zolakwika: Onani zosankha za Etiquetas de datos kusonyeza mayina a zochitika zazikuluzikulu ndi Mipiringidzo yolakwika kulumikiza madontho ku nthawi.
• Sinthani makonda a zolakwika: Dinani kumanja pa cholakwa chilichonse, sankhani Dar formato ndikuziyika kukhala mizere yowongoka ("Minus") ndikuziyika ku 100% kuchuluka kuti awoloke kuchokera pachiwonetsero kupita ku gulu la nthawi.

Kodi mukuwona kuti zopingasa ndizosafunikira kapena mumangofuna yoyima? Konzani mawonekedwe kuti muchotse bala yopingasa ndikusiya kapamwamba kokha, kusintha mtundu, makulidwe, ndi kuwonekera kuti muwonekere bwino.

5. Sinthani mapangidwe ndi makonda

Panthawi imeneyi mukhoza kale sinthani nthawi yanu momwe mungathere:

• Mitundu yamadontho: Dinani kumanja chikhomo chilichonse ndikusankha "Format Data Series." Kuchokera pa menyu, sankhani mtundu wa chikhomo chomwe mukufuna kuwunikira chochitika chilichonse.
• Kuwonekera kwa zolumikizira: Ngati zolumikizira zowongoka zikuwoneka zolimba kwambiri, sinthani mawonekedwe ake pogwiritsa ntchito mawonekedwe a bar yolondola.
• Malo a zochitika zazikuluzikulu: Kumbukirani kuti mutha kusintha manambala omwe ali mugawo la "Height" patebulo loyambira kuti musunthire m'mwamba kapena pansi ndikuletsa zilembo kuti zisadutse.
• Sinthani malire a masiku: Dinani kumanja pa axis deti ndikusankha "Format Axis" kuti musinthe zochepera komanso zopambana kuti zigwirizane ndi tchatichi kunthawi yomwe mukufuna.

Importante: Mutha kugwiritsa ntchito mitu ndi masitayilo a Excel Kuti musinthe mwachangu mitundu, mafonti, ndi masitaelo a tchati kuchokera pa Mapangidwe a Tsamba kapena Mapangidwe a Ma chart, ingosankhani mutu kapena phale lamtundu kuti musinthe mawonekedwe anu onse a nthawi yanu.

Momwe mungapangire kalendala yanthawi mu Excel?

6. Onjezani maudindo ndi zilembo zofotokozera

Musaiwale kuti zochitika zazikulu ziyenera kukhala zosavuta kuzizindikira. Kuwonetsa mayina ofunikira:

• Dinani kumanja pa lebulo lililonse patchati ndikusankha Mtundu wa zilembo za data.
• Sankhani Mtengo wa cell ndipo imawonetsa kusiyanasiyana komwe muli ndi zofotokozera zanu patebulo.
• Mutha kuchotsa njira ya "Y Value" kuti dzina lofunika kwambiri liwonetsedwe.

Zotsatira zake ndi ndondomeko ya nthawi yomwe imaphatikizapo zochitika, mizere yolumikizira, ndi zolemba zofotokozera, zonse zogwirizana ndi nthawi yomwe mukufuna.

7. Sinthani ndikusintha nthawi yanu mu Excel

Mukakhazikitsa zoyambira, mutha kukhala ndi mphindi zochepa kuti nthawi yanu iwoneke ngati yaukadaulo:

• Personaliza los colores y fuentes: Pitani ku "Mapangidwe a Tsamba"> "Mitu" kuti musinthe mawonekedwe onse mwachangu. Mutha kusintha mitundu ndi mafonti payekhapayekha.
• Gwiritsani ntchito utoto wa tchati: Kuchokera pa Chart Design tabu, dinani penti yolembedwa "Sintha Mitundu" kuti mugwiritse ntchito mitundu yapadziko lonse lapansi.
• Sinthani kugawa: Ngati muwona malo opanda kanthu kumanzere kapena kumanja, sinthani malire a axis kuti mugwiritse ntchito m'lifupi lonse la tchati.
• Sindikizani kapena kutumiza kunja: Mukamaliza, nthawi yanu imatha kusindikizidwa mosavuta, kusungidwa ngati PDF, kapena kuphatikizidwa muzowonetsa.

Un consejo clave es kugawana template ya nthawi ndi ogwira nawo ntchito kapena akuluakulu kuti akupatseni chithunzithunzi cha zomwe polojekiti yanu ikupita komanso momwe polojekiti ikuyendera. Izi zimathandiza kuti aliyense azidziwa komanso azigwirizana ndi zolinga. Ngati mukufuna kupitiliza kuphunzira za Excel, onani nkhani ina iyi Mafomula ofunikira kwambiri a Excel kuti ayambirenso ngati proTili nawo osawerengeka aiwo Tecnobits, ingogwiritsani ntchito search engine.