Iziko ledatha e Excel: dala iimpawu, iisampulu neencam

Excel sisixhobo esinamandla ohlanganisa iluncedo kakhulu kwaye ezinxulumene nemisebenzi abasebenzisi. Ezi ziquka imizobo, iitheyibhile, iitshathi, ingxelo, ukulungiselela izibalo, yokubala imisebenzi eyahlukeneyo, njalo-njalo. Siye sifunde kule nqaku, njani ukudala uvimba ku Excel, kutheni na, yaye yintoni icebiso okuya kusinceda lula umsebenzi wakhe.

Yintoni database?

Esi sakhiwo okhethekileyo, equlethe nokugcina iimathiriyeli ulwazi ngokweenjongo ezahlukeneyo. Ngamagama alula, iseti nemibutho wayibeka phezu ezishelifini kolwazi. Indlela abantu abaninzi bafunda eklasini, iimpawu zabo, imihla yokuzalwa kunye nengxelo ikhadi - konke oku kunye kuyinto database. Kubhaliwe kudingeka yonke indawo - amashishini mveliso nakwezobugcisa, amaziko emfundo zonyango, ii-arhente zokunyanzelisa umthetho nkqu ezabelwe ukutya. Eneneni, uluhlu izitya, iresiphi zabo kilojoules, kwakunye inkcazelo nalo yokugcina lwe data.

Apha siyaqonda. Ngoku ke kufuneka ufumanise ukuba yintoni na database Excel, nendlela uyidala.

Ukudala yempahla data kwi Excel

Database owadalwa kuthi, kuya kuba lula yaye ngaphandle frills. Ezi izikhongozeli data efanayo - kunokuba ngumsina yaye bamele inkqubo yolwazi enkulu i "core 'ngaphakathi, nto leyo iquka ezininzi imigca yemithetho ebhaliweyo specialist.

Umsebenzi wethu uya kuba itafile enye, nto leyo eza kuba yonke ingcaciso eyimfuneko. Phambi kokuba baqale ukujongana nomba indlela yokwenza database Excel, kufuneka ufunde imigaqo yobugcisa asetyenziswa xa kunxityelelwana ngalo.

iilayini ezithe tye kwiphepha lophawulo "Excel" ekuthiwa iirekhodi, nemihlathi nkqo - emasimini. Ungafumana emsebenzini. Vula i nkqubo kwaye udale incwadi entsha. Ngoko, kwi kumgca wokuqala ufuna ukubhala amagama endle.

Iimpawu Cell Format

Kuluncedo ukuba ufunde ukwenza imixholo yeseli ngayo ngokufanelekileyo. Ukuba yakho kwiziko ledatha ye-Excel iya kuba nayiphi na imali, kungcono ukuba ukubonisa imihlaba eyiyo ifomati lwamanani apho emva kokuba kwesishumi aya kuya amanani amabini. Kwaye ukuba kukho nawuphi na umhla eqhelekileyo, kubalulekile ukwahlula le ndawo, kwaye kananjalo ukuba ukuseka i ifomati efanelekileyo yokufundela. Ngoko ke, zonke iinkcukacha zakho ziya ukuqhubekekiswa kakuhle ngaphandle iimpazamo. Yonke imisebenzi ngamasimi engenanto inkqubo zenziwa nge kwimeko menu of "Iiseli Format."

Kwakhona kubalulekile kunye noyilo ahambelana le projekthi. Sheet, eyiprojekthi ukungena ukunqanda uphazamiseko. Ukuze ukuba inkqubo uyakwazi ukwahlula phakathi isiqulatho elula iiheader utyikityo, kufuneka yabelwe kubo kekeleyo, umgca okanye itekisi ngqindilili, ngoxa singalibalanga ukubeka igama ibe eqhiwukileyo, nosentsimini zidityanisiwe. Kuyimfuneko ukuba uyenze ukuze ukwazi ukusebenzisa izixhobo ezifana AutoShape kunye uHluzo.

Yintoni AutoShape kwi "Excel" yaye kutheni kufuneka?

Yenza database ku Excel - ingqesho kunzima kwaye onzima. Ukuze kuncedwe umsebenzisi ukuququzelela lo msebenzi, le nkqubo kufuneka ukuba anikele, oko ngokuzenzekelayo ukuzalisa iiseli ulwazi kwangaphambili. Umzekelo, ububanzi umhlathi, ukuphakama, ubungakanani bomgca, uhlobo bomgca, umbala intsimi, njl - .. All in unqakrazo olunye angenza ntoni wena AutoShape, ukuba uqwalasele kakuhle. Lula, akunjalo na?

Ukulungisa i "cap" database

Ukongezelela, musa ukulibala uhlumo lukrozo lokuqala. Ngo-Excel 2007, unako ukwenza ngolu hlobo lulandelayo: yiya kwi tab "View", uze ukhethe "ngumkhenkce Izahlulo" kwaye nqakraza kwi menu yentsingiselo kwi "Lungisa umgca phezulu." Oku kufuneka ukuba ukulungisa i "cap" umsebenzi. Ekubeni database Excel kunokuba enkulu kakhulu ngumqulu, xa urholela ngaphezulu nasezansti ziya kuphulukana iinkcukacha eziphambili - amagama endle, apho kungelula umsebenzisi.

Xa umgca phezulu Iqinisekile, lugxininisa imigca ezintathu zokuqala ledatha elizayo kwaye udibanise imida cell.

Ukuqhuba umsebenzi kwi projekthi

Ukuze uqhubeke, kufuneka eze iinkcukacha ezingundoqo, nto leyo eya kuba uvimba e-Excel. Umzekelo kokuba kuboniswe ngezantsi.

Masithi sifuna ukwenza iziko ledatha le mali eqokelelwe kubazali kwingxowa-mali yesikolo. Le ntlawulo kakuhle, yaye yahlukile lomntu ngamnye. Iklasi ukufunda nabantwana 25, kuthetha, kwaye abazali baya kuba mali ahambelana. Ukuze ukuba bafumbe iziko ledatha inani elikhulu iirekhodi, kuyimfuneko ukwenza ukuwa-phantsi uluhlu ukufihla ulwazi okungeyomfuneko, yaye xa kufuneka kwakhona, bona zayincedayo ukunika kwakhona.

Indlela ukwakha uluhlu drop-phantsi?

Khuphela amagama intsimi, aze aziphose kuxwebhu engenanto, nto kuba lula kwakhona kuyimfuneko ukubalula. Vuma, umzekelo, "Abazali". Xa i data zikotshwe, ngaphantsi kwawo ubhale zingabinanto iiseli lonke ulwazi oluyimfuneko.

Ukuze database MS Excel inika ithuba ukukhetha data evela yotsalo-phantsi uluhlu, kufuneka udale indlela ekhethekileyo. Ukuze wenze oku, kufuneka ukucwangcisa lonke ulwazi malunga abazali uluhlu lwamaxabiso ezinamagama. Qhubeka ukuze sheet, apho ebhalwe zonke iinkcukacha phantsi igama "Abazali" kwaye ukuvula i window eyodwa ukudala igama. Umzekelo, e-Excel 2007, ungenza njalo ngokunqakraza kwi "Formula 'kwaye ngoko zama" Nika igama ". Egameni zerekhodi: FIO_roditelya_vybor. Kodwa ukuba ubhale uluhlu lwamaxabiso? Apha, yonke into nzima ngakumbi.

Uluhlu lwamaxabiso in Excel

Kukho iindidi eziliqela parameter lwamaxabiso. Range ngayo thina sisebenze, siya kuthiwa linamandla. Oku kuthetha ukuba zonke iiseli ezibizwa kwiziko ledatha bangatshintsha imida yayo. utshintsho yabo kwenzeka ngokuxhomekeke Inani lamaxabiso uluhlu ethile.

Ukuze ufumane uluhlu eliguqukayo, kuyimfuneko ukuba ukusebenzisa ifomula offset. Ngoko, kungakhathaliseki ukuba sele unikwe izizathu, ubuyisela kubhekiswa idatha yoqobo. Kwi-drop-down list, leyo ntoni ekugqibeleni, akuthethi ukuhlangabezana amaxabiso null. Nale alwa kanye ngokugqibeleleyo uluhlu eliguqukayo. Yena ichazwa zilungelelanise ezimbini iseli: ilungelo yasekhohlo kunye ezantsi phezulu, ngokungathi kwi idiagonal. Ngoko ke, simele sinikele ingqalelo kuloo ndawo apho itafile yakho luqala, okanye kunoko, kwi uququzelelo yeseli phezulu ekhohlo. Vumela tablet luqala e A5 kuyo. Eli xabiso iya kuba iseli ephezulu ngasekhohlo. Ke kaloku, ukuba umba wophendlo yokuqala kufunyanwa, dlulela owesibini.

Iseli esezantsi ekunene uzimisele kwimeko enjalo, bukwangako nobubanzi, ukuphakama. Ixabiso yokugqibela makubenjalo lingana-1, kwaye ifomula lokuqala ubala SCHOT3 (Abazali $ B $ 5 :! $ I $ 5).

Ngoko, kwi kuluhlu bhala endle = lisisiqalo (Abazali $ A $ 5, 0, 0; COUNT (Abazali $ A :! $ A) -1;! 1). Cinezela iqhosha Kulungile. Kuzo zonke zibe zilandelayo kuqalwa A utshintsho B, C njalo njalo. D.

Ukusebenza database e-Excel selugqityiwe. Siya ubuyele iphepha lokuqala nokudala uluhlu imenyu-phantsi iibhokisi ezifanelekileyo. Ukuze wenze oku, nqakraza kwi ariya engenanto (umzekelo B3), ibekwe phantsi intsimi "Igama abazali." Kuya kufakwa. Xa "Khangela amaxabiso igalelo" kwi tab ebizwa ngokuba "izilungiselelo" lokubhala kwi "Umthombo" = FIO_roditelya_vybor. Xa "Uhlobo Data" menu i "List".

Ngokufanayo sichubeka ngamasimi eseleyo, ukutshintsha igama lesixhobo idata iiseli esihambelanayo. Umsebenzi on yolahlo-phantsi uluhlu selugqityiwe. Emva koko khetha i iseli yesithathu "yokunabisa" kuyo phesheya itafile. Iziko ledatha e Excel cishe ukulungele!

database Appearance

design Beautiful kwakhona idlala indima ebalulekileyo ekudaleni le projekthi. Iprogram ye-Excel sinokwenza umsebenzisi kukhetho lo ezahlukahlukeneyo ukuyila ledatha. Inani kwezikim nombala esisityebi kunene, animele ukhethe kuphela imibala efanelekileyo komphefumlo. Ngaphezu koko, akukho mfuneko yokuba enze yonke database kwi indlela enye, wena Ungayipeyinta umhlathi omnye ngemisonto, enye - in green, njalo-njalo ..

Indlela yokukhuphela uvimba ukusuka Excel ukuya Access

Excel nje kuphela nje ungenza ledatha. Microsoft likhuphe elinye imveliso leyo ilawulwa ngokugqibeleleyo nale nzima. Igama it - Access. Ekubeni le nkqubo apha naphaya ngakumbi ekudaleni uvimba kwe Excel, uze ukusebenza kulo liya kuba ngokukhawuleza kwaye lula ngakumbi.

Kodwa njani ukwenza njalo, ukufumana database Access? Excel ivumela umnqweno yomsebenzisi. Oku kunokwenziwa ngeendlela ezininzi:

• Ungakhetha lonke ulwazi oluqulethwe kule an lokusebenzela Excel, khuphela uze uyisuse uyise kwenye program. Ukuze wenze oku, khetha idata ofuna ukukhuphela, kwaye nqakraza i ekunene iqhosha lemouse. Cinezela i "Kuphela" kwi menu yentsingiselo. Olwalo ku Access, khetha i tab "Uluhlu", iqela 'ukumelwa "kwaye ngokukhuselekileyo klikha kwiqhosha" Unikezelo ". Khetha ukhetho "Indlela Uluhlu" kwaye ufake iinkcukacha ngokunqakraza ekunene iqhosha lemouse ekunene kwaye ukhethe "Cola".

• Unako ukungenisa ifomati uluhlu .xls (.xlsx). Access Vula, pre-ukuvala Excel. Kule menu, khetha "import", uze ucofe kwi kwinguqulelo wacela nkqubo uya ukungenisa ifayile kuyo. Emva koko ucinezela "Kulungile".

• Unako ukunxulumana iifayile Excel kunye iitafile e Access. Ukulungiselela le njongo, "Eksele" kuyimfuneko ukukhetha uluhlu iiseli eziqulathe ulwazi oluyimfuneko kwaye nqakraza kwi ekunene iqhosha le mouse, khetha igama lebanga. Gcina uze uvale Excel. Vula i "Access 'tab ebizwa ngokuba" Fumana uluhlu lweenkcukacha zangaphandle ", khetha" E-Excel itafile "kwaye ngenisa igama layo. Emva koko nqakraza kumba ukuba isebenza ukudala itafile ukuba uqhagamshelwano ukuya kumthombo data ze ucacise igama layo.

Kuko konke. Sebenza ukulungele!