"Ukuthola isixazululo" Excel 2010. Uphi superstructure "Ukucinga isixazululo" Excel

Konke emhlabeni uyashintsha, kodwa uzitshela kwenzeka kungakhathaliseki izifiso zethu nawe. Lokhu qiniso eliyisisekelo is ikakhulukazi ukwazi kahle abasebenzisi computer, asebethathe nomkhuba wokuphuza kakhulu olusha nge imvamisa emangalisayo. Ngenhlanhla, lezi Suites ehhovisi akuzona ethintekile kakhulu, nakuba phakathi kwabo kukhona okuhlukile.

Kuyini ukubaluleka amaphakheji software ehhovisi?

Noma yimuphi software ehhovisi - iyithuluzi Ukugunda, yakhelwe ukusebenza nge yolwazi enkulu, inani izakhi asizayo lapho kakhulu anda. Manje ngosizo ngeso amathuluzi kwavela izinguqulo ezintsha lezi zinhlelo, umsebenzi sekulula kakhulu. Kukhona isixhumanisi kucinga entsha, kakhulu isheshisa umsebenzi nge ukugeleza enkulu yolwazi. Yebo, futhi-Microsoft Excel 2010 ishesha kakhulu.

Kunengqondo ukuphetha ngokuthi ngempela muva unobhala kahle ukuhlakanipha MS Office 2007 njengendawo ukuhalalisa-Office 2010 ukukhululwa, okuyinto wanezela ikhanda muncu. Kodwa akufanele sicabange ukuthi inguqulo entsha ye "Ufaka" kubasebenzisi bayo nobunzima kuphela.

Isibonelo salokhu - "izixazululo" Excel 2010. Lokhu add-e akuyona kuphela ewusizo, kodwa futhi kukusiza ukuba wenze umsebenzi wakho elinethebula umhleli lapho elikhiqizayo, okuvumela ukuba uxazulule izinkinga kakhulu eziyinkimbinkimbi ngokwengeziwe. Ikakhulukazi kulungile nokwenza, okuyinto efanele izinkampani eziningi zanamuhla.

Kungani 2010 nguqulo?

Njengoba i-Excel le nguqulo ethile, khona-ke wathatha izinguquko okukhulu nakakhulu. Ikakhulukazi, abaningi amaphutha aye ilungiswe ifomula, yingakho the izinhlelo esidlule zohlelo wayevame ukubhekana amaphutha sasivumela sína izibalo. Akubuzwa, ukuthi miscalculation kancane igcwele nemiphumela ebuhlungu kakhulu lapho Fielding umklomelo osayizi.

With the new "iribhoni" esibonakalayo lapho kungenzeka ukubonisa kusengaphambili we uhlobo imidvwebo namashadi ukuze kufakwe zabo ngokushesha ku etafuleni, umsebenzisi kulula ukwenza ngisho eyinkimbinkimbi kunazo imibhalo professional-grade.

Ngaphezu kwalokho, ngo-inguqulo yamanje lo mhleli-spreadsheet babefake izinhlobo ezintsha amafomula ukuthi kuyoba kakhulu ewusizo for ezimali zezomnotho. Leli qiniso waphinda libonisa Microsoft «curtsy" ohlangothini kuba abasebenzisi bebhizinisi. Uma ucabanga ukuthi ezimweni ezilandelayo acace kubo, akukho isimanga kule.

Okubalulekile! Uma ungazange wasebenzisa "izixazululo" Excel 2010, khona-ke lesi sengezo kumele afakwe ngokwehlukana.

Kanjani ukuyifaka?

Ngenhlanhla, kulula kakhulu ukukwenza. Uma usebenzisa Excel 2003 nangaphezulu, khona-ke kumelwe ukuya "Amathuluzi" imenyu bese ukhetha lapho into "Izengezo". Futhi lapho Excel «ukufuna amakhambi," uma-ke kuyinto izinguqulo zamuva nezanamuhla hlelo?

Endabeni isicelo Excel 2007 inguqulo ye inkinobho "isixazululo Ukucinga" zingatholakala ku "Idatha" ithebhu.

is it kanjani usebenza?

Naphezu sobala incazelo extensiveness, lokhu kusebenza superstructure ngempela okunengqondo, futhi nentuthuko yayo ayidingi kufanele ukuba ungungqondongqondo ikhompyutha. Ngakho ngokugcwele isimiso sokusebenza kwawo, sizoxoxa ngayo kulesibonelo elula.

Ngakho, ingabe lo "izixazululo" indlela Excel 2010? Ake sithi ubungakwazi abhekane nenselele - Prize ukusatshalaliswa enhlanganweni yakho. Ukuze kube lula ukuxazulula inkinga, ucabange ukuthi ukusabalalisa umklomelo phakathi bonke abasebenzi bakwa-legatsha. Usayizi isabelomali ibhonasi - ruble ayizigidi ezingu-100. Kwenze kungenzeka yahlukanisa inani premium yokukhokha yomrholo kilabo abasebenzi.

Kanjani ukuqala umsebenzi?

Yiqiniso, ukuthi umsebenzi uzoqala ukuthuthukiswa etafuleni, okwenza kube yonke idatha edingekayo namazwi lelingantjintji. Umphumela kuzofundwa inani yonke imali umklomelo.

Kubalulekile ukwazi ukuthi iseli target (sicabangela ukuthi kuyoba C8) kwakuhambisana nezinga esigabeni, okuyinto kuzohluka (E2, isibonelo). Ngakho, kuleli uhla C2-C7 ahlelwe amafomula okwengeziwe eniyokwazi ukubala ibhonasi lenkokhelo ngoba isisebenzi ngasinye.

Ngemva kwalokho uqala superstructure "Ukucinga Solutions" Excel 2010, bese iwindi asethwe amagugu edingekayo. Qaphela ukuthi izinguqulo ezahlukahlukene ukubukeka Office suite yalezi amabhokisi engxoxo kungaba ayahlukahluka, ngakho kungase kudingeke uqonde isimo. Ngenhlanhla, abekho umehluko oyisisekelo, ngakho-ke akudingeki ukubhekana isikhathi eside.

Yini ngemigudu ekhona ebhokisini lengxoxo kukhona?

Ukuze iwenze ube lula umsebenzi wakho, kufanele sikhulume ngalabo amagugu, okuyizinto ngokuvamile iyatholakala ku ethize zokusebenza ezahlukene.

Okokuqala, kungenxa uqobo kuseli target. Nakani! Ngokungafani namanye ukuthengiselana lokho kungase kuhilele ukusetshenziswa ehlukahlukene ukubonisa idatha, kulesi simo, kungaba eyodwa kuphela!

Okwesibili, qiniseka ukuthi khumbula ukuthi kukho nokwenza kungaba eziningana. Nakani esiphezulu noma ubuncane kungenzeka inani, kanye yalokho ethize. Uma udinga kukho zokugcina, kubalulekile ukuba ucacise ngokunembile umphumela ayethanda emkhakheni input.

Kufanele kukhunjulwe ukuthi indima amaseli ekushintsheni ingaba njengesihluthulelo Amasimu ehlukile, futhi wonke ebangeni yabo. Eqinisweni, yingenxa senhlobo izinhlelo futhi kuthatha inani, ukuqhathanise ukuba inguqulo idatha yoqobo.

Indlela ungeze imikhawulo?

Uma ufuna ukwengeza ezinye imikhawulo, kufanele usebenzise inkinobho ethi "Engeza". Qaphela ukuthi uma usetha lezi zimiso kudingeka uqaphe kakhulu. Njengoba Excel «Ukucinga Solutions" (izibonelo zazo sisuke sicabanga) isetshenziswa imisebenzi kunalokho ngenkani, kubalulekile ukuthola amagugu efanele kakhulu.

By endleleni, kusukela ukulinganiselwa miphumela efanayo futhi ancike. Khumbula ukuthi kungenziwa isethwe kuphela amanye amaseli ngabanye, kodwa nezalo lonke ka amabanga abo. Yini izinketho ezibonakaliso amafomula ingasetshenziswa ngesikhathi esifanayo kukhona?

izinhlamvu yakho ingasetshenziswa: "=", "> =", "<=". Ngaphezu kwalokho, kuvunyelwe ifomula: "Int", "Bin" (kanambambili noma inamba) kanye "Isikhathi". Okubalulekile! Inketho yokugcina evumela ukusetshenziswa namanani ahlukene. Itholakala kuphela ezinguqulweni Excel 2010 noma ngaphezulu, okuyinto esinye isizathu ukuhambisa kubo. Lezi amakhambi e-software ehhovisi amaphakheji e-Excel «search for the best" wenziwa ngokushesha nje kuphela, kodwa futhi ngcono kakhulu.

Uma sikhuluma ukubala amaphrimiyamu, Coefficient kumele kube ngokuqinile omuhle. Misa le ipharamitha kungenzeka ngezindlela eziningana. Kulula ukwenza lo msebenzi ngokusebenzisa inkinobho "Engeza". Ngaphezu kwalokho, ungasetha ibhokisi isheke "Yenza kwenombolo ngaphandle komkhawulo non-mubi." Kuphi ukuthola le ndlela ezinguqulweni amadala hlelo?

Uma usebenzisa emsebenzini Excel 2007 nangaphezulu, kuba uma uchofoza "Options", lapho kukhona into "Okuthuthukisiwe yokusesha izixazululo."

Sifuna umphumela siphelile

Ukucinga isixazululo turnkey, nawe nje kudingeka uchofoze "Run" (noma "ukuthola isixazululo"). Khona-ke "Imiphumela yokusesha Solutions" ibhokisi lengxoxo lizovela.

Uma weneliseka impendulo yokugcina, udinga nje ukuba uchofoze "KULUNGILE". Ngemva kwalokho okuthandayo impendulo silotshwe etafuleni. Esimweni lapho ukubaluleka etholwe into ephikisana izintandokazi zakho, wena nje kudingeka uchofoze "Khansela" inkinobho. Khona-ke ngokushesha etafuleni ubuyele ukubaluleka yayo yasekuqaleni, bese uzoqhubekela ukucinga ikhambi elilungile.

Okubalulekile! Uma ngandlela-thile ziye ushintshe idatha yokuqala, isinqumo kuyodingeka wenze kuqala.

Kukuphi lapho kungaba singaba usizo kabi isengezo Excel «ukufuna amakhambi"? Ake sibheke esinye isibonelo.

izindleko ukunciphisa

Njengoba sishilo ngenhla, lo msebenzi ingasetshenziswa nokwandisa izinqubo zokukhiqiza. Sizama ukunciphisa izindleko lenkampani, okuyinto waziphatha ukwakhiwa ongaphakeme liphumele. Kukhona inkampani uqobo, kanye abahlinzeki ezintathu ukuthi bekwi kokunikeza zokwakha.

Kusho ukuthi izindleko into kubaqoqi zizokwenziwa zonke izindleko ukwakhiwa yayo, futhi ngenxa yalokho izithakazelo ibhizinisi ukuze ukhethe umphakeli, omsebenzi wakhe kuyoba eshibhile zonke. Yikuphi ukwaziswa okudingeka lokushaya MS Excel «ukufuna amakhambi"?

Kufanele ucacise izindleko zokwakha, izidingo zabo esakhiweni, kanye izindleko bethutha izimpahla, ucabangela pair of "umthengi umphakeli" ngamunye. Kuseli target, lemali kumele kuboniswe izindleko jikelele ngezinto zokuhamba.

Uma wenza konke ngendlela efanele, umsebenzi "izixazululo" Excel kuzokuvumela ukudala isu inzuzo kakhulu wakha ibhizinisi ukuthi kuyokulethela inzuzo esiphezulu. Ngikufisela inhlahla!