Zithunzi za network mu Excel

Chithunzi cha network ndi tebulo lopangidwa kuti likonzekere dongosolo ndikuwongolera pakukhazikitsa kwake. Chifukwa ntchito yomanga yaluso ili ndi mapulogalamu apadera, monga MS Project. Koma kwa mabizinesi ang'onoang'ono ndipo makamaka zosowa zachuma, sizikumveka kugula mapulogalamu apadera ndikukhala ndi nthawi yophunzitsa zikopazo. Ndi ntchito yomanga zithunzi za network, purosesa yopambana yaposachedwa imathamangitsidwa bwino, yomwe imayikidwa kuchokera kwa ogwiritsa ntchito ambiri. Tiyeni tiwone momwe mungakwaniritsire ntchito yomwe ili pamwambapa.

Pa izi, kupanga kwa gome la tebulo kumaganiziridwa kutha.

Phunziro: Ma tebuloni aposachedwa

Gawo 2: Kupanga nthawi yayitali

Tsopano muyenera kupanga gawo lochuluka la zithunzi zathu zamaneti - kukula. Lidzakhala mizati yamitundu, iliyonse yomwe imafanana ndi nthawi imodzi polojekiti. Nthawi zambiri, nthawi imodzi imafanana ndi tsiku limodzi, koma pali zochitika zochepa zomwe kuchuluka kwa nthawiyo kumawerengeredwa m'masabata, miyezi, malo opita, ngakhale zaka.

Mwachitsanzo, gwiritsani ntchito njirayo ikakhala yofanana ndi tsiku limodzi. Tiyeni tipangitse nthawi yayitali kwa masiku 30.

1. Pitani kumalire oyenera patebulo lathu. Kuyambira m'malire ano, timagawa mizati yosiyanasiyana ya 30, ndipo kuchuluka kwa mizere idzakhala yolingana ndi kuchuluka kwa mizere yomwe tidapanga koyambirira uja.



2. Pambuyo pake, dongo pa "malire" mu "Border yonse" mode.



3. Kutsatira malire ofotokozedwa, tidzakonza masiku munthawi yake. Tiyerekeze kuti tikuwongolera ntchitoyi ndi nthawi yochita kuchokera pa 1 mpaka 30 June 2017. Pankhaniyi, dzina la nthawi yozungulira likufunika kukhazikitsidwa molingana ndi nthawi yomwe mwakhala. Zachidziwikire, mumagwirizana ndi madeti onse chifukwa chotopetsa, motero timagwiritsa ntchito chida cha kuwombera, chomwe chimatchedwa "Kudutsa".

   Choyambirira cha nthawi ya shakal shakal ikani tsiku "01.06.2017". Kusamukira ku "Home" ndi dongo pa chithunzi cha "Dzazani". Seed yowonjezera imatsegula komwe mungafune kusankha chinthucho "kupita patsogolo ...".



4. Kutsegulira kwa "Proglupsiress" Yambitsidwa. Gulu la "Malo" liyenera kulembedwa "zingwe", popeza tidzaza mutu woyimirira ngati chingwe. Mu mtundu wa mtundu, tsiku la tsiku liyenera kulembedwa. Mu chipikacho "mayunitsi", ikani mayendedwe pafupi ndi "tsiku". Mu "sitepe" payenera kukhala mawu akuti "1". Pa mtengo wake, timawonetsa tsiku la 06/30/2017. Dinani pa "Chabwino".



5. Mitundu yambiri idzadzazidwa ndi masiku obwereza mpaka pa Okutobala 1 mpaka Juni 30, 2017. Koma chifukwa cha ndandanda ya netiweki, tili ndi ma cell kwambiri, omwe amakhumudwitsa kuthekera kwa tebulo, ndipo, zikutanthauza, komanso mawonekedwe ake. Chifukwa chake, tikhala ndi mabupulidwe kuti tikonzetse tebulo.

   Sankhani chipewa cha nthawi. Dongo pamaputala odzipereka. Mndandandawo wayimitsidwa pamaselo.



6. Pawindo lolemba lomwe limatsegulira gawo la "Ululu". M'dera la "kutsata", timakhazikitsa mtengo wake "madigiri 90", kapena posamukira chitoletso "cholembedwa". Clay pa batani la "Ok".



7. Pambuyo pa dzinali, mzati mu mtundu wa masikuwo adasintha mawonekedwe awo osunthika. Koma chifukwa chakuti maselowo sanasinthe kukula kwake, mayinawo adasawerengeka, chifukwa sanali okwanira m'mapepala omwe adasankhidwa ndi osimba. Kusintha mawonekedwe a zinthu, kugawa zomwe zili mumutu. Dongo pa "mtundu" chizindikiro, chomwe chili mu "cell" block. Pa mndandanda, mumayimitsa panjira "auto-gawo la kutalika kwa chingwe."



8. Pambuyo polongosoleredwa ndi dzina la mzazi zowoneka ngati miyala ya maselo, koma m'lifupi mwake maselowo sanakhale copict yambiri. Apanso, timawonetsa kuchuluka kwa malo ndi dongo pa batani la "Fomu". Nthawi ino, pa mndandanda, sankhani njira ya "Columpun Collemmery".



9. Tsopano tebulo ilinso mogwirizana, ndipo zinthu zogulitsira zidavomereza mawonekedwe ake.

Gawo 3: Kudzaza deta

Kenako muyenera kudzaza tebulo la data.

1. Timabwerera pamwamba pa tebulo ndikulemba "chochitika" ndi mtundu wa ntchito zomwe zakonzedwa pa ntchitoyi. Ndipo mu mzere wotsatira, timayambitsa mayina a anthu odalirika omwe adzayang'anira ntchito yokwaniritsa zochitika zina.



2. Pambuyo pake, muyenera kudzaza "P / P" mzati. Ngati zochitikazo ndi pang'ono, ndiye kuti izi zitha kuchitika, zoyendetsedwa pamanja ndi chiwerengerocho. Koma ngati akufuna kuchita ntchito zambiri, zidzakhala zomveka kwambiri kuti zithandizireni kudzola. Kuti tichite izi, tinayika koyamba nambala ya nambala "1". Croturror amatsogozedwa ndi m'mphepete mwa kumanzere kwa chinthucho, kudikirira nthawi ikasinthidwa kukhala mtanda. Mumasinthana kwambiri fungulo la CTRL ndi batani lakumanzere, lokani mtanda pansi patebulo.



3. Gawo lonse lidzadzaza ndi mfundo zoyenera.



4. Kenako, pitani ku "Choyambira". Apa muyenera kutchula tsiku loyambira la chochitika chilichonse. Timachita. Nthawi ina, timanena kuchuluka kwa masiku omwe ayenera kugwiritsa ntchito kuti athetse ntchito yomwe yatchulidwayi.



5. Mu "zolemba", mutha kudzaza zambiri monga zikufunikira, kuwonetsa mawonekedwe a ntchito inayake. Kupanga zidziwitso mu mzerewu sikuyenera kuchita zinthu zonse.



6. Kenako tikutsindika maselo onse a tebulo lathu, kupatula mphunzitsi wamkulu ndi gululi. Clay pa "mtundu" pa tepi, zomwe tidakambirana kale, timadina mndandanda wa mndandanda wa m'lifupi mwake "yomwe imatsegula.



7. Pambuyo pa izi, m'lifupi mwake mizati ya zinthu zosankhidwa ndizochepetsetsa maselo, momwe kutalika kwa data kumayerekezera ndi zinthu zotsalira za mzati. Chifukwa chake, malowo amapulumutsidwa papepala. Nthawi yomweyo, pamutu wa patebulo, mayina amasamutsidwa malinga ndi mawu mu zinthu zomwe sizikugwirizana ndi gawo. Zinachitika kuti zichitike chifukwa chakuti tidakhazikitsa zisoti za zisoti za zisoti zomwe zidayandikira "malinga ndi" gawo.

Gawo 4: Mawonekedwe

Panthawi ina yogwira ntchito ndi ndandanda ya netiweki, tiyenera kutsanulira mtundu wa khungu la Grid lomwe limagwirizana ndi nthawi yochita chochitika china. Izi zitha kuchitika pogwiritsa ntchito mawonekedwe a mawonekedwe.

1. Timalemba ma cell ang'onoang'ono a maselo osowa pa nthawi yake, yomwe imayimiriridwa ngati mauna a mawonekedwe ake.



2. Dinani pa "mawonekedwe azomwe mungagwiritse ntchito". Ili mu "masitayilo" block ndiye kuti mndandandawu utsegulira. Ziyenera kusankha njira "pangani ulamuliro".



3. Zenera limakhazikitsidwa lomwe mukufuna kupanga lamulo. Pamunda wa kusankha mtundu, tikuwona kuti chinthucho chimatanthawuza kugwiritsa ntchito formula kuti usapangitse mawonekedwe. Mu "gawo la mtundu wa" TIMAYESA, tiyenera kukhazikitsa lamulo lotulutsidwa monga njira. Kwanenedwe yathu kwa nkhani yathu, ili ndi mawonekedwe awa:

   = Ndi (g $ 1> = $ d2; g $ 1

   Koma kuti musinthe fomu iyi ndi ndandanda yanu ya network, yomwe ndi yotheka, idzakhala ndi magwiridwe ena, tiyenera kutanthauza njira yojambulidwayo.

   "Ndipo" ntchito yophatikizidwa bwino, yomwe imayang'ana ngati malingaliro onse omwe amapanga monga chowonadi ndi chowonadi. Syntax ndi:

   = Ndi (zomveka_Mor1; Zolowera_Dar2; ...)

   Onse, mpaka 255 mfundo zomveka zimagwiritsidwa ntchito ngati zotsutsana, koma timangofunika awiri okha.

   Kukangana koyamba kumalembedwa ngati mawu akuti "g $ 1> = $ D2". Imayang'ana kuti mtengo munthawi yayitali amakhala ndi zambiri kapena zofanana ndi tsiku lolingana loyambira chochitika china. Momwemonso, ulalo woyamba m'mawu uwu amatanthauza khungu loyamba la chingwe pa nthawi yake, ndipo chachiwiri ndiye chinthu choyamba cha mzere wa tsiku loyambira. Chizindikiro cha dollar ($) chimakhala kuti chimagwirizana ndi magwiridwe antchito omwe chizindikiritso ichi sichinasinthidwe, ndikukhala mtheradi. Ndipo pa nthawi yanu, muyenera kukhazikitsa zizindikiro za dollar m'malo oyenera.

   Mkangano wachiwiri ukuimiridwa ndi mawu akuti "g $ 1

   Ngati izi zikanatsutsana za njirayi zikuyimiridwe ndizowona, kenako kwa maselo, mawonekedwe amtundu wawo wokhala ndi utoto wawo udzagwiritsidwa ntchito.

   Kusankha mtundu wina wadzaza, dongo pa "mtundu ..." batani.



4. Pawindo latsopano, kusunthira gawo la "Dzazani". Gulu la "mitundu yakumbuyo" limapereka matenda osiyanasiyana. Tikuwona mtundu womwe maselo a masiku omwe ali ofanana ndi nthawi yochita ntchito inayake. Mwachitsanzo, sankhani mtundu wobiriwira. Pambuyo pa mthunziwo adawonetsedwa mu gawo la "zitsanzo", dongo pa "Chabwino".



5. Pambuyo pobwerera ku zenera lolenga, malamulowo amakhala ndi batani la "Ok".



6. Mukamaliza kuchita chomaliza, mtundu wa ziwonetsero zamaneti, zomwe zikugwirizana ndi nthawi yomwe kuphedwa, zidapaka utoto wobiriwira.

Pa izi, kupanga kwa zithunzi zamaneti kumatha kuganiziridwa kumaliza.

Phunziro: Mawonekedwe oyenera mu Microsoft Excel

Mukugwira ntchito, tapanga ndandanda ya ma network. Iyi si njira yokhayo ya tebulo lofananalo lomwe lingapangidwe bwino, koma mfundo zoyambirira zochitira ntchitoyi sizingasinthe. Chifukwa chake, ngati munthu angafune, wogwiritsa ntchito aliyense amatha kukonza tebulo loyimiriridwa pa zitsanzo motsatira zosowa zake.