Excel

Don yin wasu ayyuka a cikin Excel, yana da muhimmanci don gano wasu ƙwayoyin ko jeri. Ana iya yin wannan ta hanyar sanya sunan. Saboda haka, idan ka bayyana shi, shirin zai fahimci cewa wannan yanki ne a kan takardar. Bari mu ga yadda zaka iya yin wannan hanya a Excel.

Wani fasali mai mahimmanci a cikin Microsoft Excel shine zaɓi na zabin. Amma, ba kowane mai amfani san game da damar wannan kayan aiki ba. Tare da shi, zaka iya karɓar darajar asali, fara daga sakamakon karshe da kake so ka cimma. Bari mu ga yadda zaka iya amfani da aikin zaɓin saiti a cikin Microsoft Excel.

A yayin da kake aiki tare da furofayil ɗin Excel, wani lokaci kana buƙatar ɓoye wasu yankunan da takardar. Sau da yawa wannan yana aikata idan, alal misali, ana samun samfurori a cikinsu. Bari mu gano yadda za mu ɓoye ginshiƙai a wannan shirin. Algorithms don ɓoye Akwai zažužžukan da yawa don yin wannan hanya. Bari mu gano abin da ainihin su.

Akwai yanayi lokacin da takardun ya buƙaci maye gurbin nau'i daya (ko rukuni na haruffa) tare da wani. Dalili na iya zama da yawa, yana fitowa daga kuskuren banal, kuma yana ƙarewa tare da sauya samfuri ko cire wasu wurare. Bari mu ga yadda za mu maye gurbin kalmomi a cikin Microsoft Excel. Hanyoyi don maye gurbin haruffa a Excel Hakika, hanya mafi sauki don maye gurbin hali ɗaya tare da wani shine don shirya kwayoyin halitta tare da hannu.

Daga cikin ayyukan daban-daban na Excel, wanda aka nufa don yin aiki tare da rubutu, mai amfani PRAVSIMV ya fito fili don ba zai yiwu ba. Ayyukansa shine a cire wasu adadin haruffa daga ƙayyadaddun tantanin halitta, ƙidaya daga ƙarshen. Bari mu koyi game da yiwuwar wannan afaretan kuma game da nuances na amfani dashi don dalilai masu amfani tare da misalai na musamman.

Lokacin aiki tare da Tables na Excel, sau da yawa wajibi ne a zabi su bisa ga wani takaddama ko a kan yanayi da yawa. Shirin zai iya yin hakan a hanyoyi masu yawa ta amfani da kayan aikin da dama. Bari mu kwatanta irin yadda za a samo asali a cikin Excel ta amfani da zabin iri-iri. Samfur Samun samfurori ya ƙunshi hanyar zaɓi daga jerin tsararren waɗanda sakamakon da ya dace da yanayin da aka ƙayyade, tare da samfurin su na ƙarshe a kan takarda a jerin da aka raba ko a cikin farko.

Siffar cibiyar yanar gizon tana da allon da aka nufa don zartar da shirin shirin da kuma kula da aiwatar da shi. Don ƙwarewar sana'a akwai aikace-aikace na musamman, kamar MS Project. Amma ga ƙananan masana'antu da kuma bukatun kasuwanci na sirri, ba shi da mahimmanci don saya kayan aiki na musamman da kuma ciyar da lokaci mai yawa na ilmantarwa game da aiki a ciki.

Daga cikin masu aiki na Excel daban daban, aikin OSTAT ya bambanta da damarta. Yana ba ka damar nunawa cikin ƙayyadaddun tantanin halitta ragowar rarraba lambar ɗaya ta wani. Bari mu ƙara koyo game da yadda za a iya amfani da wannan aiki a cikin aiki, da kuma bayyana yadda ake aiki tare da shi. Aikace-aikace na aiki Sunan wannan aikin ya fito ne daga sunan da aka rage ta kalmar "raguwa na rabuwa".

Yin aiki tare da ƙididdiga a cikin Excel ba ka damar ƙaddamar da sauƙi da sarrafawa da lissafi. Duk da haka, ba lallai ba ne a kowane lokaci ya zama dole a haifar da sakamakon zuwa bayanin. Alal misali, idan ka canza dabi'u a cikin sel masu dangantaka, bayanan da aka samo zai canza, kuma a wasu lokuta wannan bai zama dole ba. Bugu da ƙari, lokacin da canja wurin tebur da aka buga tare da samfurin zuwa wani yanki, ƙimar za a iya "rasa".

Hotkeys suna aiki ne, ta hanyar rubuta wani maɓalli na haɗin kai a kan keyboard, yana ba da dama ga wasu siffofin tsarin aiki, ko kuma shirin raba. Wannan kayan aiki yana samuwa ga Microsoft Excel. Bari mu ga abin da hotkeys suke a cikin Excel, da kuma abin da za ku iya yi tare da su.

Good rana Yau an labarta hotunan waƙa. Watakila duk wanda ya taba yin lissafin, ko kuma ya yi wani shiri - ya kasance dole ya gabatar da sakamakon su a matsayin nau'in hoto. Bugu da ƙari, ana iya ganin sakamakon ƙididdiga a wannan nau'i da sauƙi. Ni kaina na ci karo da hotuna a karo na farko lokacin da na gabatar da gabatarwa: don ganin ido ga masu sauraro inda za ku yi amfani da riba, ba za kuyi tunanin wani abu mafi kyau ... A cikin wannan labarin na so in nuna maka yadda za a gina jadawali a Excel a cikin daban-daban iri: 2010 da 2013.

Ga masu amfani da Microsoft Excel ba asiri ba cewa an sanya bayanai a cikin wannan maɓallin tabular a cikin kwayoyin halitta. Domin mai amfani don samun damar wannan bayanai, kowane ɓangaren takardar an sanya adireshin. Bari mu gano abin da aka kirkiro abubuwa a cikin Excel kuma yana yiwuwa a canza wannan lambar.

Lokacin aiki tare da fayilolin Excel, akwai lokuta ba kawai idan kana buƙatar shigar da hoto a cikin wani takarda, amma kuma sake juyawa yanayin inda adadi, a akasin wannan, ya buƙaci a cire shi daga littafin. Don cimma wannan burin, akwai hanyoyi biyu. Kowane ɗayan su ne mafi dacewa a wasu yanayi. Bari mu dubi kowane ɗayan su domin ku iya sanin wane daga cikin zaɓin da aka fi dacewa a cikin wani akwati.

Idan waɗannan alamu da aka kwatanta da "more" (>) da "kasa" (suna da sauƙi a kan kwamfutar kwamfuta, sa'an nan kuma rubuta rubutun "ba daidai ba" (≠) yana haifar da matsalolin, tun da alama ta bace. samfurori na kayan aiki, amma yana da mahimmanci ga Microsoft Excel, tun da yake yana ɗauke da lissafin ilimin lissafi da na ilimin lissafi don abin da wannan alamar ta zama dole.

Yin aiki da allo shine babban aikin Microsoft Excel. Rashin ikon ƙirƙirar Tables shine ainihin mahimmancin aiki a wannan aikace-aikacen. Saboda haka, ba tare da kwarewar wannan fasaha ba, ba zai yiwu a ci gaba gaba da koyo yadda za a yi aiki a cikin shirin ba. Bari mu ga yadda za mu ƙirƙiri tebur a cikin Microsoft Excel.

Ɗaya daga cikin matakai mafi muhimmanci yayin aiki a cikin Excel shine tsarawa. Tare da taimakonsa, ba wai kawai bayyanar teburin ba ne, amma kuma alamar yadda shirin ya gane bayanan da ke cikin tantanin halitta ko kewayon an ƙayyade. Ba tare da fahimtar yadda wannan kayan aiki ke aiki ba, ba za ka iya kula da wannan shirin sosai ba.

Arctangent ya shiga jerin maganganu masu mahimmanci marasa mahimmanci. Ya saba da tangent. Kamar dukkanin dabi'u masu kama da juna, an ƙidaya shi a cikin 'yan Rasha. A Excel akwai aiki na musamman wanda zai bada lissafi na arctangent don lambar da aka ba su. Bari mu kwatanta yadda za mu yi amfani da wannan afaretan.

Kayan iya ƙirƙirar ɓangaren litattafai a cikin Excel a cikin littafi guda ɗaya zai iya ba da damar ƙirƙirar takardu da yawa a cikin fayil ɗaya, kuma, idan ya cancanta, haɗi da su tare da nassoshi ko dabara. Tabbas, wannan yana ƙara haɓaka aikin wannan shirin kuma yana ba ka damar fadada yanayin da ayyuka ke. Amma wani lokacin ya faru cewa wasu daga cikin takardun da ka ƙirƙiri ɓacewa ko duk gajerun hanyoyi a cikin matsayi na mashi ya ɓace.

Lokacin aiki a Excel, ana aiki a wasu lokuta don haka bayan shigar da kwanan wata a cikin tantanin halitta, ana nuna rana ta mako, wanda ya dace da ita. A al'ada, don magance wannan matsala ta hanyar irin wannan mai amfani mai sarrafawa kamar Excel, yiwuwar, da kuma hanyoyi da dama. Bari mu ga abin da zaɓuɓɓuka zasu kasance don yin wannan aiki.

Yana da matukar damuwa lokacin da, saboda kullun wuta, kwakwalwa ta kwamfutarka ko sauran gazawar, bayanan da ka danna cikin tebur amma ba a gudanar da samun ceto bace. Bugu da ƙari, sauƙaƙe da hannu tare da ceton sakamakon aikin su - wannan yana nufin kasancewa ya ɓata daga babban aiki kuma ya rasa ƙarin lokaci.