Tupeane maujanja ya Excel

chilubi · Dec 16, 2016

Tutor B said:
Unatumia Ms excel au? Ebu weka hilo file lako alafu upatiwe ufafanuzi haraka haraka ...

Ndio natumia Ms excel katika macbook. Nakutumia izi file zicheki moja ni sample cash listings ambayo hio ndo ina contain details za matumizi ya hela na nyengine Summery sample file, ambayo hii ni summery ya hio cash listings file, inakuwa na amount to corresponding to dates na each department, data zake zinatoka huko cash listings. Sasa nlifahamishwa lkn nkasahau jinsi ya kuweka hio pivot table ambayo itannionesha summery from each date and department na kunirahisishia kudrag data kutoka cash listing na kuzidrop katika summery file. sijui kama nimeeleweka mana si mzuri wa kuexplain mie 😀

Mkuu xls is not supported kumbe sasa nimeziweka katika pdf hio cash listing sijui kama utaielewa kuipanga but i hope you will

Mkazamoyo · Dec 17, 2016

Tutor B said:
Ebu kuwa wazi .. unayajua haya vizuri
Workbook = hili ndo file lilisaviwa kwenye excel
Worksheet = sehemu ya kufanyia kazi
Column = mgawanyo wa wima
Row = mgawanyo wa mlalo
Cell = Mahali zinapokutana column na row
Usichojua kuprotect ni kipi kati ya hayo yote?

Sorry hapo mwisho nilikuwa namaanisha cell yaan mfano nna data zangu zipo cell A1:E1 Then kwenye cell ya F1 ndo formula ya hzo data zingine zilipo let say ni =Sum. Sasa mm nataka niprotect hyo F1 ili mtu asibadili formula but cell zingine zbakie km zilivyo yaan zisiwe protected. Sasa nimejaribu kutumia Sheet protect naona inaprotect cell zote(whole sheet). Ni hivyo mkuu.

Tutor B · Dec 19, 2016

chilubi said:
Ndio natumia Ms excel katika macbook. Nakutumia izi file zicheki moja ni sample cash listings ambayo hio ndo ina contain details za matumizi ya hela na nyengine Summery sample file, ambayo hii ni summery ya hio cash listings file, inakuwa na amount to corresponding to dates na each department, data zake zinatoka huko cash listings. Sasa nlifahamishwa lkn nkasahau jinsi ya kuweka hio pivot table ambayo itannionesha summery from each date and department na kunirahisishia kudrag data kutoka cash listing na kuzidrop katika summery file. sijui kama nimeeleweka mana si mzuri wa kuexplain mie 😀

Mkuu xls is not supported kumbe sasa nimeziweka katika pdf hio cash listing sijui kama utaielewa kuipanga but i hope you will

Nakupa sasa kazi ambayo imeishafanyika tayari then nakuwekea maelekezo ... sample zako sijazielewa ...

Tutor B · Dec 19, 2016

Mkazamoyo said:
Sorry hapo mwisho nilikuwa namaanisha cell yaan mfano nna data zangu zipo cell A1:E1 Then kwenye cell ya F1 ndo formula ya hzo data zingine zilipo let say ni =Sum. Sasa mm nataka niprotect hyo F1 ili mtu asibadili formula but cell zingine zbakie km zilivyo yaan zisiwe protected. Sasa nimejaribu kutumia Sheet protect naona inaprotect cell zote(whole sheet). Ni hivyo mkuu.

soma hapo kwenye window ndogo ya fomart cell

jay311 · Dec 19, 2016

Ngoja nianze kusoma sasa manual deaign kwa spreadsheet so wakuu nahitaji darasa la kutosha.... Sijui hata nianzie wapi....

multiple · Dec 19, 2016

Saaafi saana nitarudi na mimi kuna baadhi vitu napenda kushare na wengine..hapa

chilubi · Dec 20, 2016

Tutor B said:
Nakupa sasa kazi ambayo imeishafanyika tayari then nakuwekea maelekezo ... sample zako sijazielewa ...

Sawa mkuu nakusubiri.... Itakuwa kheri

Nukta5 · Dec 21, 2016

Tunaomba video kule telegram Ethos

kindboy · Dec 22, 2016

Thanks alot kwa hii thread

kindboy · Dec 22, 2016

Thanks alot kwa hii thread

Pota · Dec 24, 2016

Huu uzi mzuri sana.
Nishukuru kwa mleta uzi kwani elimu tuliyiipata hapa kwa wingi wetu...mtu angelipia malaki jwa malaki.
Nishukuru kwa mara nyingine kwa kuwa actve kujibu changamoto za wadau.

Kapyungu A · Dec 24, 2016

jay311 said:
Ngoja nianze kusoma sasa manual deaign kwa spreadsheet so wakuu nahitaji darasa la kutosha.... Sijui hata nianzie wapi....

Mkuu ni powa sana. Yaani mimi huwa na set equation zangua naacha sehemu za kuweka variable. Inakuwa kama simulation fulani hivi. Ukichenge variable moja data zina change zote. Kama ni manager inakuwa nzuri pia. Kwan unaweza kufanya decision haraka kwa kufanya simulation na kujua impact ya unachotaka kukifanya

NYANYADO · Dec 26, 2016

Ethos said:
ukisahau password ndio imetoka

Jaribu kulifungua kwa Kutumia ubuntu

brazuka · Dec 26, 2016

Ethos said:
Safi sana... VLOOKUP hata kama una bidhaa 1000 unaweza Jua bei ya kila kitu au information yeyote ndani ya dakika moja!

Kabla sijaijua vlookup...nikiwa mgeni kwenye kazi my first assignment nkapewa file mbili niadjust price, reference, barcode...nlitamani kukimbia.
Weeknd nzima nlishinda kutafta item moja moja...
Thanx to excel manouver

Mediocrist · Dec 26, 2016

Kapyungu A said:
Mkuu ni powa sana. Yaani mimi huwa na set equation zangua naacha sehemu za kuweka variable. Inakuwa kama simulation fulani hivi. Ukichenge variable moja data zina change zote. Kama ni manager inakuwa nzuri pia. Kwan unaweza kufanya decision haraka kwa kufanya simulation na kujua impact ya unachotaka kukifanya

Mkuu hii kitu mimi nashindwa kuanza kuweka formular before yakuweka variable mkuu ebu nipe muongozo kwa hilo

Kapyungu A · Dec 26, 2016

Mediocrist said:
Mkuu hii kitu mimi nashindwa kuanza kuweka formular before yakuweka variable mkuu ebu nipe muongozo kwa hilo

Mkuu naweka formula na namba zote ambazo ni constant. Unaacha tu zile unazotaka kubadili ili upate majibu fulani. Mfano unataka kujua effect ya kitu kama power consumption kwenye price na profitability ya product kwa wale wanaofanya kwenye manufacturing industry. Unaweza tengeneza equation yote kwenye karatasi na baadae unaitransifer kwenye excel. Simulation kama hii inaweza kukusaidia kujua kwenye power consumption kiasi gani unapata faida au hasara huku ukiweka constant Labour na maintenance cost. Mimi huwa natumia hii kupredict decision ya nini kifanyike

castongo · Jan 2, 2017

umande said:
Naomba kujua nawezaje kupanga division kwa matokea masomo ya secondary. Maana nikiandaa matokeo. division huwa napiga moja moja manually.

Jarib pia kucheki hii hapa nilijaribu nadhani ni hiyo hiyo kwa namna flan click hapa

Mchana · Jan 2, 2017

Kyatsvapi said:
Mkuu Ethos,

Nakushukuru kwa kuwa na moyo wa kusaidia wengine. Naona wengi hapa wanafaidika na somo lako. Hongera sana.

Nimeona nikuunge mkono kwa kutengeneza 'template' rahisi kwa ajili ya 'kucontrol' mikopo katika vikundi vya ujasiriamali, kuaidiana na hata vikoba. Nimeiambatanisha na andiko hili.

Template hii nimeitengeneza na kuiweka kwa lugha ya kiswahili ili wengi iwanufaishe na kuwasaidia katika kufuatilia mikopo katika vikundi vyao.

Ni matumaini yangu itasaidia.

Nawasilisha.

Mkuu, template hiyo ya ku control mikopo uliyosema umeambatanisha hatujaiona baadhi yetu, je unaweza kutuwekea tena? tunatanguliza shukrani

dustless · Jan 7, 2017

Jamani nimenufaika sana na uzi huu. Tatizo langu ni kuchora maumbo ya hisabati, huwa napata tabu sana.

dustless · Jan 7, 2017

Jerrymsigwa said:
Ingia youtube chief kila kitu kipo

Kwenye utube unafanyaje kujifunza.

Tupeane maujanja ya Excel

JF-Expert Member

Attachments

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

Senior Member

Senior Member

JF-Expert Member

JF-Expert Member

JF-Expert Member

Senior Member

JF-Expert Member

JF-Expert Member

Member

Senior Member

JF-Expert Member

JF-Expert Member