Yadda ake yin ginshiƙi a cikin hijira

Microsoft Excel yana ba da damar yin aiki tare da lambobin lambobi, amma kuma yana ba da kayan aiki don shingen gini dangane da sigogin da aka shigar. Nunin gani na gani zai iya zama daban-daban kuma ya dogara da hanyoyin mai amfani. Bari mu gano yadda za a zana nau'ikan zane-zane daban-daban ta amfani da wannan shirin.

Cart Balaguri a Foreved

Saboda fice zaka iya saurin aiwatar da bayanan lambobi da sauran bayanai, kayan aiki don gina zane a nan yana aiki a cikin daban-daban. A cikin wannan editan, akwai daidaitattun nau'ikan zane-zane da aka danganta da daidaitattun bayanai da kuma ikon ƙirƙirar abu don zanga-zangar mai ban sha'awa ko ma a fili nuna doka. Bayan haka, zamuyi magana game da hanyoyi daban-daban na ƙirƙirar waɗannan abubuwan.

Zabi 1: Gina ginshiƙi a kan tebur

Ana gina ginin nau'ikan zane-zane na zane-zane kusan, kawai a wani matakin da kuke buƙatar zaɓar nau'in gani da ya dace.

1. Kafin ka fara ƙirƙirar kowane ginshiƙi, wajibi ne don gina tebur tare da bayanai akan abin da za a gina shi. Bayan haka je zuwa shafin "Saka" ka ware fannin tebur, wanda za a bayyana a cikin zane.



2. A kan tef a cikin saka ajiya, mun zabi ɗayan manyan nau'ikan guda shida:
   • Mashaya mai kai;
   • Jadawalin;
   • Madauwari;
   • Layi;
   • Tare da yankuna;
   • Ma'ana.



3. Bugu da kari, ta danna kan maɓallin "Sauran", zaku iya tsayawa a ɗayan ƙananan nau'ikan: Stock, farfajiya, Farko, kumfa, petal.



4. Bayan haka, danna kowane nau'in zane-zane, da ikon zaɓar takamaiman rarar kuɗi. Misali, ga tarihi ko zane ko zane, irin waɗannan sassa za su zama abubuwan da ke gaba: Trustogram na saba, gwargwado, cylindal, conal, pylindal.



5. Bayan zabar takamaiman sassa, ana ƙirƙirar zane ta atomatik. Misali, tarihin bincike zai yi kama da wanda aka nuna a cikin hotunan allo a ƙasa:



6. Shafi a cikin hanyar zane zai zama kamar haka:



7. Zabi tare da yankuna zai dauki irin wannan:

Aiki tare da zane-zane

Bayan an ƙirƙiri abu, ƙarin kayan aiki don gyara da canjin ya zama samuwa a cikin sabon shafin "aiki tare da ginshiƙi".

1. Akwai nau'in canji, salon da sauran sigogi.



2. Tabare tare da zane-zane "Tablowingarin wasu ƙarin keɓaɓɓun shafuka guda uku:" Tsarin "," amfani da shi, tsari ", amfani da shi, zaka iya daidaita taswirar kamar yadda zai zama dole. Misali, don ambace zane, buɗe shafin "layout" kuma zaɓi ɗaya daga sunayen suna: a tsakiyar ko daga sama.



3. Bayan an yi shi, daidaitaccen rubutun "Sunan zane" ya bayyana. Mun canza shi a kan kowane rubutu da ya dace a cikin mahallin wannan tebur.



4. Daidai an sanya sunan ax ɗin zane-zane daidai daidai, amma ga wannan kuna buƙatar danna maɓallin "Axis sunayen".

Zabin 2: Alamun nuni a cikin dari

Don nuna raguwar rabo daga cikin alamomi daban-daban, ya fi kyau a gina zane mai laushi.

1. Hakanan, yadda aka gaya mana, mun gina tebur, sannan ka zabi kewayon bayanai. Abu na gaba, je zuwa shafin "Saka" Saka zane mai rufewa a kan tef ɗin kuma a cikin jerin Danna sai a cikin kowane nau'in.



2. Shirin da kansa ya fassara mu cikin ɗayan shafuka don aiki tare da wannan abun - "mai zanen." Zabi tsakanin shimfidar wuri a cikin kintinkiri na kowane, wanda akwai alamar kashi.



3. Canjin madauwari tare da nuna bayanai a cikin kashi cikin 100 a shirye.

Zabi na 3: Gina Par Matsace

A cewar ka'idar Wilferdo ta Wilfredo, kashi 20% na ayyukan da suka fi dacewa su kawo kashi 80% na sakamakon gaba daya. Dangane da sauran 80% na jimlar ayyukan da basu da inganci, 20% na sakamakon da suka kawo. An tsara iyayen gini kawai don ƙididdige yawancin ayyukan da ke ba da matsakaicin dawowa. Yi amfani da shi ta amfani da Microsoft Excel.

1. Ya fi dacewa don gina wannan abu a cikin nau'in tarihi, wanda muka riga mun faɗi a sama.
2. Bari mu ba da misali: teburin ya ƙunshi jerin abinci. A cikin shafi daya, da darajar siyan duk girma na takamaiman nau'in samfuran kayayyaki da aka rubuta, kuma a karo na biyu - riba daga aiwatar da ita. Dole ne mu tantance wadanne kaya suna ba mafi girman "dawowar" lokacin sayarwa.

   Da farko dai, muna gina tsarin tarihi: muna zuwa shafin "Saka", muna rarraba duk yankin dabi'un, danna "Halittar Maɗaukaki kuma zaɓi nau'in da ake so.



3. Kamar yadda kake gani, an kafa ginshiƙi tare da nau'ikan ginshiƙai guda biyu a matsayin sakamako: shuɗi da ja. Yanzu ya kamata mu canza launin ja zuwa tsarin - Zaɓi waɗannan ginshiƙai da siginan kwamfuta da maɓallin "Maɓallin" na maɓallin "Canjin".



4. An buɗe taga taga taga. Je zuwa sashin "Jadawalin" kuma saka nau'in ya dace don dalilan mu.



5. Don haka, an gina zane-zane. Yanzu zaku iya gyara abubuwan da ta gabata (sunan abu da gatura, salon, da sauransu) kamar yadda aka bayyana akan misalin wani ginshiƙi na zane-zane.

Kamar yadda kake gani, ficelf yana gabatar da ayyuka da yawa don gini da kuma gyara nau'ikan zane-zane daban-daban - mai amfani ya kasance don yanke shawarar wanne nau'in ya zama dole ga tsinkaye na gani.