Excel Timeline Template

Izvi zvidzidzo zvinosungiridza uye kushandisa f ree timeline template kubva kuMicrosoft. Iyi template yakatarwa inogona kushandiswa mumashanduro ose eExcel kubva kuExcel 97 zvichienda mberi.

01 ye 08

Kushandisa Template Yenguva

© Ted French

Template yemangwana yeExcel inowanikwa pachena pawebsite yeMicrosoft.

Pane imwe nguva pawaiti:

  1. Dzvanya paBhatani reKutsvaga pane peji ye template.
  2. Chiziviso pamusoro peMicrosoft Agreement Service chinogona kuonekwa. Kana zvakadaro, unofanira kubvuma mazwi echibvumirano usati wazokwanisa kupfuurira nekutora. Dzvanya pahutano hwakapiwa kuti uverenge zvido zvechibvumirano usati wagamuchira.
  3. Kana iwe uchibvumirana nemitemo yechibvumirano, tora paBhitachi bhodhi kuti utange kubudiswa.
  4. Microsoft Excel inofanira kuzarurirwa ne template yemazuva yakatakurwa muchirongwa.
  5. Chengetedza template kune kombiyuta yako.

02 of 08

Kushandisa Template

© Ted French

Iyo template inongogara iri Excel worksheet iyo yave ine mabhokisi emashoko akawedzerwa kwaro uye mamwe maitiro ekufambisa akashandiswa kuti aite seanoita sezvaanoita.

Mhedzisiro yacho pachayo inogadzirwa nekuwedzera miganhu kumasero chaiwo ari mubhuku rekushanda uye nekuisa mazuva mumasero ari pasi pemutsara. Zviitiko zviri kuwedzera nekunyora mumashoko ebhokisi rakapiwa.

Zvose zviri mumutsetse, saka, zvinogona kuchinjwa kuti zvikwanise zvido zvako.

Maji anotevera anovhara kuchinja kunowanzodiwa nevanhu kuti vaite ku template.

03 of 08

Kuchinja Gwaro

© Ted French
  1. Dzvidza kamwechete pane chinyorwa cheTimeline.
  2. Dragodza kusarudza kusimbisa mutauro uripo.
  3. Dhinda reChenesa kiyi pane keyboard kuti ubvise zita rakashata.
  4. Tora iwe pachako musoro.

04 of 08

Nguva Dhidhiro

© Ted French
  1. Dzoka kaviri pazuva raunoda kuchinja. Izvi zvinoisa Excel kuHarimi mode.
  2. Dzoka kaviri pazuva rimwechete kechipiri kuti uise pachena.
  3. Dhinda reChenesa kiyi pabhokisi kuti usiye zuva rakashata.
  4. Tora zuva idzva.

05 of 08

Moving Event Boxes

© Ted French

Mabhokisi echiitiko anogona kutamiswa sezvinodiwa pamwe chete nenguva. Kutamisa bhokisi:

  1. Dzvanya pabhokisi kuti usununguke.
  2. Tungamira mutsara weguru kune rumwe rutivi rwebhokisi kusvikira iyo pointer ichinjira mumushonga we-4 (tarira chinyorwa pamusoro pemuenzaniso).
  3. Dhinda rebhokisi reboshwe uye dhonza bhokisi kunzvimbo itsva.
  4. Bvisa bundu rebhokisi apo bhokisi riri munzvimbo yakakodzera.

06 of 08

Wedzera Bhokisi reMakadhi kusvika panguva Yakatarwa

© Ted French

Kuwedzera zvimwe zviitiko mabhokisi:

  1. Tungamira mutsara weguru kumativi ose emucheto weiyo mhemberero yebhokisi kusvika iyo pointer ichinjira mumuseve we-4.
  2. Uine museve we-4 uripo, iko kona pabhokisi kuti uzarure mamiriro ekutenderera.
  3. Sarudza Kopi kubva pane zvakasarudzwa.
  4. Kungofa-chengetedza pamusana pemuganhu wekugadzirisazve mamiriro ekutenderera.
  5. Sarudza Nyora kubva pane zvakasarudzwa.
  6. Bhinda rebhokisi rakakopizwa rinofanira kuonekwa panguva yakatarwa.
  7. Shandisa mamwe matanho akanyorwa mubhuku iri kuti uende nebhokisi idzva uye kuti uchinje mavara.

07 of 08

Resize Event Boxes

© Ted French

Kugadzirisa zviitiko mabhokisi:

  1. Dzvanya pabhokisi kuti udzoke. Zviduku zviduku nezvikwereti zvichaonekwa kumativi ose ebhokisi.
  2. Tungamira mutsara weguru pane imwe yemitambo kana zvikwereti. Denderedzwa dzinokubvumira kuti uchinje zvose zvakakwirira nekukwirira kwebhokisi panguva imwechete. Zvikwereti zvinokubvumira kuti uchinje kana hurefu kana hupamhi zvichienderana neyo waunoshandisa.
  3. Apo pointer ichishandura kune mutsara wakaita mutsvuku wakaita 2, sarudza uye dhonza ne mouse kuitira kuti bhokisi rive guru kana ridiki.

Kugadzirisa zviitiko zvebhokisi bhokisi:

  1. Dzvanya pabhokisi kuti udzoke. Zviduku zviduku nezvikwereti zvichaonekwa kumativi ose ebhokisi uye madhaimondi machena anooneka pamutsara.
  2. Tungamira mutsara weguru pane imwe yemadhayamondi kusvikira pointer ichinje kuchena nyeredzi.
  3. Dzvanya uye dhonza ne mouse kuitira kuti mutsara uwedzere kana wapfupi.

08 we 08

Yakagadzirirwa Timeline

© Ted French

Iyi chinyorwa chinoratidza kuti mhedziso yakagadzirwa ingaita sei.