Susa umugqa ku-Microsoft Excel

Lapho usebenza ne-Excel, kuvame ukuthi uphendukele kwinqubo yokususa imigqa. Le nqubo ingaba yodwa noma iqembu, kuya ngemisebenzi oyabelwe. Okuthakazelisa kakhulu kulokhu ukususwa kwesimo. Ake sibheke izinketho ezahlukahlukene zale nqubo.

Inqubo yokususa umugqa

Ukususwa kwe-stitch kungenziwa ngezindlela ezihluke ngokuphelele. Ukukhethwa kwekhambi elithile kuncike emisebenzini umsebenzisi azibekele yona. Cabanga ngezinketho ezahlukahlukene, kusukela ezilula kuya kwezindlela eziyinkimbinkimbi.

Indlela yoku-1: ukususwa okukodwa ngemenyu yokuqukethwe

Indlela elula yokususa imithungo inguhlobo olulodwa lwale nqubo. Ungayisebenzisa usebenzisa imenyu yokuqukethwe.

1. Qhafaza kwesokudla kunoma yisiphi amaseli womugqa ofuna ukuwususa. Kumenyu yokuqukethwe evela, khetha "Susa ...".



2. Kuvulwa iwindi elincane lapho udinga ukucacisa ukuthi yini okudingeka isuswe. Sishintsha switch siye esikhundleni "Umugqa".

   

   Ngemuva kwalokho, into ebekiwe izosuswa.

   Ungachofoza futhi kwesobunxele kwinombolo yomugqa kuphaneli yokuqondisa mpo. Okulandelayo, chofoza kukhetho ngenkinobho yegundane elifanele. Kumenyu evulekile, khetha into Susa.

   

   Kulesi simo, inqubo yokususa yenzeka ngokushesha futhi asikho isidingo sokwenza isenzo esingeziwe ewindini lokukhetha into esebenzayo.

Indlela yesi-2: Ukususwa Okuodwa Kusetshenziswa Amathuluzi Wephepha

Ngaphezu kwalokho, le nqubo ingenziwa kusetshenziswa amathuluzi kubambo, atholakale kuthebhu "Ikhaya".

1. Yenza ukukhetha noma ikuphi kulayini ofuna ukuwasusa. Iya kuthebhu "Ikhaya". Sichofoza isithonjana ngesimo sonxantathu omncane, otholakala kwesokudla kwesithonjana Susa ebhokisini lamathuluzi "Amaseli". Uhlu luyavela lapho udinga ukukhetha into "Susa imigqa kwishidi".



2. Ulayini uzosuswa ngokushesha.

Ungase futhi ukhethe umugqa wonke ngokuchofoza ngakwesobunxele kwinombolo yakhe kwiphaneli yokuqondisa mpo. Ngemuva kwalokho, ukuba kuthebhu "Ikhaya"chofoza isithonjana Susaesisebhokisini lamathuluzi "Amaseli".

Indlela 3: ukukhishwa ngobuningi

Ukuze wenze imidwebo yokususa iqembu, okokuqala, udinga ukukhetha izinto ezidingekayo.

1. Ukuze ususe imigqa eminingana eseduze, ungakhetha amaseli wedatha asondelene akukholamu efanayo. Ukuze wenze lokhu, bamba phansi inkinobho yegundane kwesobunxele bese uhambisa ikhesa ngaphezulu kwalezi zinto.

   

   Uma ububanzi bukhulu, khona-ke ungakhetha iseli eliphezulu kakhulu ngokuchofoza ngakwesokunxele kulo. Bese ubamba ukhiye I-Shift bese uchofoza kuseli eliphansi kakhulu lebanga ofuna ukulisusa. Zonke izinto eziphakathi kwazo zizoqokonyiswa.

   

   Uma kwenzeka udinga ukususa amabanga womugqa akhiwe kude nenye, bese ukhetha lawo, chofoza kwelinye lamaseli akhiwe kuwo, chofoza ngakwesobunxele ngenkinobho efanayo ecindezelwe Ctrl. Zonke izinto ezikhethiwe zizomakwa.



2. Ukuze sifeze inqubo eqondile yokususa imigqa, sibiza imenyu yokuqukethwe noma siye kumathuluzi asephathini, bese silandela izincomo ezinikezwe ngenkathi kuchazwa izindlela zokuqala nezesibili zale ncwadi.

Ungase futhi ukhethe izinto ezidingekayo ngokusebenzisa iphaneli yokuqondisa mpo. Kulokhu, akuqokonyiswa amaseli ngamanye, kepha imigqa izovele ngokuphelele.

1. Ukukhetha iqembu eliseduze lemigqa, bamba inkinobho yegundane kwesobunxele bese unyakazisa isikhombisi kuphaneli yokuqondisa mpo kusuka entweni ephezulu yomugqa okudingeka ukuthi isuswe iye phansi.

   

   Ungasebenzisa futhi inketho usebenzisa ukhiye I-Shift. Qhafaza kwesobunxele kunombolo yokuqala yomugqa okufanele isuswe. Bese ubamba ukhiye I-Shift bese uchofoza inombolo yokugcina yendawo echaziwe. Lonke uhla lwemigqa phakathi kwalezi zinombolo luzoqokonyiswa.

   

   Uma imigqa esusiwe ihlakazekile kulo lonke ishidi futhi ingalinganiseli elinye nelinye, khona-ke kuleli cala, kufanele uchofoze ngakwesobunxele kuzo zonke izinombolo zalayini emugqeni wokuxhumanisa ngokhiye ocindezelwe Ctrl.



2. Ukuze ususe imigqa ekhethiwe, chofoza kwesokudla kunoma yikuphi ukukhetha. Kumenyu yokuqukethwe, yeka ku Susa.

   

   Umsebenzi wokususa zonke izinto ezikhethiwe uzokwenziwa.

Isifundo: Ungayenza kanjani ukukhetha ku-Excel

Indlela 4: susa izinto ezingenalutho

Kwesinye isikhathi etafuleni kungahle kube nemigqa engenalutho, idatha kusuka lapho isuswe ngaphambili. Izakhi ezinjalo zisuswa ngokuphelele kusuka kwishidi ngokuphelele. Uma zitholakala eduze komunye nomunye, lapho-ke kungenzeka ukusebenzisa enye yezindlela ezichazwe ngenhla. Kepha kuthiwani uma kunemigqa eminingi engenalutho futhi ihlakazeka endaweni yonke yetafula elikhulu? Ngemuva kwakho konke, inqubo yokufuna kwabo nokususa ingathatha isikhathi eside. Ukusheshisa ikhambi lale nkinga, ungafaka i-algorithm echazwe ngezansi.

1. Iya kuthebhu "Ikhaya". Kubha yamathuluzi, chofoza isithonjana Thola nokugqamisa. Itholakala eqenjini "Ukuhlela". Kuluhlu oluvulayo, chofoza entweni "Khetha iqembu lamaseli".



2. Kuvulwa iwindi elincane lokukhetha iqembu lamaseli. Sibeka kuyo ukushintshwa kusikhundla Amaseli angenalutho. Ngemuva kwalokho chofoza inkinobho "Kulungile".



3. Njengoba sibona, ngemuva kokusebenzisa lesi senzo, zonke izinto ezingenalutho ziyakhethwa. Manje ungasebenzisa ukususa noma yiziphi izindlela ezichazwe ngenhla. Isibonelo, ungachofoza inkinobho Susaetholakala kubambo kuthebhu efanayo "Ikhaya"lapho sisebenza khona manje.

   

   Njengoba ukwazi ukubona, zonke izinto ezingenalutho zetafula zisusiwe.

Nakani! Uma usebenzisa le ndlela, umugqa kufanele ungabi nalutho ngokuphelele. Uma ithebula linezinto ezingenalutho ezitholakala kumugqa oqukethe idatha ethile, njengasesithombeni esingezansi, le ndlela ayikwazi ukusetshenziswa. Ukusetshenziswa kwayo kungaholela ekuguqukeni kwezinto kanye nokwephulwa kwesakhiwo setafula.

Isifundo: Ungasusa kanjani imigqa engenalutho ku-Excel

Indlela yesi-5: sebenzisa ukuhlunga

Ukuze ususe imigqa ngesimo esithile, ungafaka isicelo sokuhlunga. Ngemuva kokuhlunga izakhi ngokuya ngesikhombisi esisunguliwe, singakwazi ukuqoqa yonke imigqa eyanelisa lesi simo ndawonye, ​​uma ihlakazekile kulo lonke itafula, futhi sizisuse ngokushesha.

1. Khetha yonke indawo yetafula ongayihlela, noma eyodwa yamaseli ayo. Iya kuthebhu "Ikhaya" bese uchofoza isithonjana Hlunga nesihlungietholakala eqenjini "Ukuhlela". Uhlu lwezinketho ezizovula, khetha Uhlobo Lwezifiso.

   

   Izenzo ezihlukile nazo zingathathwa eziholela ekuvulekeni kwewindi lokuhlunga ngokwezifiso. Ngemuva kokukhetha noma iyiphi into etafuleni, iya kuthebhu "Idatha". Lapho eqenjini lezilungiselelo Hlunga nesihlungi chofoza inkinobho "Hlunga".



2. Iwindows yokuhlunga ngokwezifiso iyaqala. Qiniseka ukuthi ubheka ibhokisi, uma lilahleka, eduze kwento "Imininingwane yami iqukethe izihloko"uma itafula lakho linekhanda. Ensimini Hlunga udinga ukukhetha igama lekholomu lapho ukukhethwa kwamanani wokususa kuzokwenzeka. Ensimini "Hlunga" udinga ukucacisa ukuthi yikuphi ukukhetha okuyokwenzeka:
   • Amanani
   • Umbala weseli;
   • Umbala wefonti;
   • Isithonjana seseli.

   Konke kuya ngezimo ezithile, kepha ezimweni eziningi kufanelekile "Amanani". Yize ngokuzayo sizokhuluma ngokusebenzisa isikhundla esihlukile.

   Ensimini "I-oda" udinga ukucacisa ukuthi imininingwane ezohlungwa ngokulandelana kwayo. Ukukhethwa kwemibandela kule nkambu kuya ngefomethi yedatha yekholomu ekhethiwe. Isibonelo, ngemininingwane yombhalo, i-oda lizoba "Kusuka ku-A kuye ku-Z" noma "Kusuka ku-Z kuye ku-A", nangosuku "Kusuka kwakudala kuye okusha" noma "Kusuka kokusha kuya kokudala". Empeleni, i-oda ngokwalo alinandaba kangako, ngoba kunoma yikuphi, amanani wentshisekelo kithi azotholakala ndawonye.
   Ngemuva kokuthi izilungiselelo ezikule windi seziqediwe, chofoza inkinobho "Kulungile".



3. Yonke imininingwane yekholomu ekhethiwe izohlelwa ngezinqubo ezicacisiwe. Manje sesingakhetha izinto eziseduzane nganoma iyiphi yalezo zinketho obekuxoxwa ngazo uma kubhekwa izindlela zangaphambilini, bese sizisusa.

Ngendlela, indlela efanayo ingasetshenziswa ekuhlukaniseni ukususwa kwesigcawu kwemigqa engenalutho.

Ukunaka! Kumele kuqashelwe ukuthi lapho wenza lolu hlobo lokuhlunga, ngemuva kokususa amaseli angenalutho, isikhundla semigqa siyohluka kwesokuqala. Kwezinye izimo lokhu akubalulekile. Kepha, uma udinga ukubuyisela indawo yokuqala, bese ngaphambi kokuhlunga, udinga ukwakha ikholomu eyengeziwe bese ubhala yonke imigqa ekuyo, uqale kusukela kowokuqala. Ngemuva kokuba izinto ezingafuneki zisusiwe, ungahlela kabusha ngekholomu lapho lokhu kubalwa kutholakala kusuka kokuncane kuya kokukhulu. Kulokhu, itafula lizothola i-oda langempela, ngokwemvelo, lisuse izinto ezisusiwe.

Isifundo: Hlunga idatha ku-Excel

Indlela 6: sebenzisa ukuhlunga

Ungasebenzisa futhi ithuluzi njengokuhlunga ukususa imigqa equkethe amanani athile. Inzuzo yale ndlela ukuthi uma ungaphinde uyidinge le migqa, ungahlala uyibuyisela.

1. Khetha yonke itafula noma unhlokweni nesikhombisi ngenkathi uphethe inkinobho yegundane kwesobunxele. Chofoza inkinobho esivele siyazi Hlunga nesihlungietholakala kuthebhu "Ikhaya". Kepha kulokhu, kusuka ohlwini oluvulayo, khetha isikhundla "Hlunga".

   

   Njengasekuqaleni kwendlela, umsebenzi nawo ungaxazululwa ngethebhu "Idatha". Ukuze wenze lokhu, ngokuba kuyo, udinga chofoza inkinobho "Hlunga"etholakala kwibhulokhi yamathuluzi Hlunga nesihlungi.



2. Ngemuva kokwenza noma yisiphi isenzo esingenhla, uphawu lokuhlunga olufana nonxantathu olukhomba ezansi lizovela eduze komngcele wesokudla weseli ngalinye kusihloko. Chofoza kulolu phawu kukholamu lapho inani litholakala khona, lapho sizosusa khona imigqa.



3. Imenyu yokuhlunga iyavula. Ungahloli amanani emigqeni esifuna ukuwasusa. Ngemuva kwalokho, cindezela inkinobho "Kulungile".

Ngakho-ke, imigqa equkethe amanani osusethwe kukho izofihlwa. Kepha angahlala ebuyiselwa futhi ngokususa ukuhlunga.

Isifundo: Ukufaka isihlungi ku-Excel

Indlela 7: Ukufomatha okunemibandela

Ngokuqondile, ungacacisa imingcele yokukhetha imigqa uma usebenzisa amathuluzi wokufometha anemibandela ngokuhlunga noma ukuhlunga. Kunezindlela eziningi zokukhetha ukungena kulezi zimo kuleli cala, ngakho-ke sizocubungula isibonelo esithile ukuze uqonde indlela yokusebenzisa lesi sici. Sidinga ukususa imigqa etafuleni lapho inani lemali engaphansi kwama-ruble ayi-11,000.

1. Khetha ikholamu "Imali Yengeniso"esifuna ukusebenzisa ukufomatha okunemibandela kukho. Ukuba kuthebhu "Ikhaya"chofoza isithonjana Ukufomatha okunemibandelaetholakala etheyiphu emabhulokini Izitayela. Ngemuva kwalokho, uhlu lwezenzo luyavula. Khetha isikhundla lapho Imithetho Yokukhetha Iseli. Okulandelayo, enye imenyu yethulwa. Kuyo, udinga ukukhetha ngokukhethekile umongo womthetho. Kufanele kube nokukhetha okusekelwe emsebenzini wangempela. Esimweni sethu ngasinye, udinga ukukhetha isikhundla "Ngaphansi ...".



2. Iwindi lokufometha okunemibandela liqala. Ensimini yangakwesokunxele, setha inani 11000. Onke amanani angaphansi kwalokho azofakwa. Ensimini efanele, ungakhetha noma yimuphi umbala wokufometha, yize futhi ungashiya inani elizenzakalelayo lapho. Ngemuva kokuthi izilungiselelo seziqediwe, chofoza inkinobho "Kulungile".



3. Njengoba ukwazi ukubona, wonke amaseli lapho kunamanani entengo angaphansi kwama-ruble ayi-11,000 adwetshwe ngombala okhethiwe. Uma kudingeka silondoloze i-oda langempela, ngemuva kokususa imigqa, senza izinombolo ezingeziwe kukholamu eliseduze kwetafula. Vula iwindi lokuhlela ikholomu esivele silijwayele "Imali Yengeniso" noma yiziphi izindlela ezixoxwe ngenhla.



4. Iwindi lokuhlela liyavula. Njengasikhathi sonke, naka into "Imininingwane yami iqukethe izihloko" kwakukhona uphawu lokuhlola. Ensimini Hlunga khetha ikholomu "Imali Yengeniso". Ensimini "Hlunga" inani elisethiwe Umbala Weseli. Ensimini elandelayo, khetha umbala omugqa wakho ofuna ukusula, ngokuya ngokufometha okunemibandela. Kithi, kupinki. Ensimini "I-oda" khetha lapho izingcezu ezikhethiwe zizobekwa khona: ngaphezulu noma ngaphansi. Kodwa-ke, lokhu akubalulekile. Kuyafaneleka futhi ukuphawula ukuthi igama "I-oda" ingashintshelwa kwesokunxele sensimu uqobo. Ngemuva kokuthi wonke amalungiselelo angenhla eseqediwe, chofoza inkinobho "Kulungile".



5. Njengoba ukwazi ukubona, yonke imigqa lapho kukhona amaseli akhethwe yisimo ahlelwe ndawonye. Zizotholakala phezulu noma phansi kwetafula, kuya ngokuthi yimaphi amasethingi umsebenzisi achaziwe kuwindi lokuhlela. Manje vele ukhethe le migqa ngendlela esiyithandayo bese uyisula usebenzisa imenyu yokuqukethwe noma inkinobho kubambo.



6. Ngemuva kwalokho ungahlela amanani ngekholamu ngenombolo ukuze itafula lethu lithathe i-oda langaphambilini. Ikholamu enezinombolo esephenduke engadingekile ingasuswa ngokuyiqokomisa futhi ngokucindezela inkinobho ejwayelekile Susa ekhasethini.

Umsebenzi osesimweni esinikeziwe uyaxazululwa.

Ngaphezu kwalokho, ungenza umsebenzi ofanayo ngokufometha okunemibandela, kodwa kuphela ngemuva kokwenza lokhu kuhlunga imininingwane.

1. Ngakho-ke, faka ukufomatha okunemibandela kukholamu "Imali Yengeniso" esimweni esifanayo. Sinika amandla ukuhlunga etafuleni sisebenzisa enye yezindlela esezivele zamenyezelwa ngaphezulu.



2. Ngemuva kokuthi izithonjana ezifanekisela ukuhlunga kuvela enhlokweni, chofoza kulelo elise kukholamu "Imali Yengeniso". Kumenyu evulayo, khetha "Hlunga ngombala". Ebhulokini lamapharamitha Isihlungi Seseli inani lokukhetha "Cha gcwalisa".



3. Njengoba ubona, ngemuva kwalesi senzo yonke imigqa ebigcwele umbala isebenzisa ukufomatha okunemibandela inyamalala. Zifihliwe okokuhlunga, kepha uma ususa ukuhlunga, kulokhu ke, izinto ezikhonjisiwe zizokhonjiswa kudokhumenti futhi.

Isifundo: Ukufomatha okunemibandela ku-Excel

Njengoba ukwazi ukubona, kunezindlela eziningi kakhulu zokususa imigqa engadingekile. Yikuphi ukukhetha ukusebenzisa kuncike emsebenzini nenombolo yezinto okufanele zisuswe. Isibonelo, ukususa umugqa owodwa noma emibili, kungenzeka ukuthi ungene ngamathuluzi ajwayelekile wokususa okukodwa. Kodwa ukuze ukhethe imigqa eminingi, amaseli angenalutho noma izinto ngokuya ngesimo esinikeziwe, kukhona ama-algorithms wesenzo enza lula umsebenzi wabasebenzisi futhi ugcine isikhathi sabo. Amathuluzi anjalo afaka iwindi lokukhetha iqembu lamaseli, ukuhlunga, ukuhlunga, ukufometha okunemibandela, njll.