Msaada kwa Wataalamu wa Excel

John Cannor · Jul 14, 2016

Kama upo ofisini na umewekwa kimkakati na uncle au shemeji bora uresign tu.

Nyie ndio mnaoziba nafasi za wenye vyeti halali na ufanisi kupewa ajira maofisini.

Kamanda Sirro njoo uanzie huku!

cc12 · Jul 14, 2016

John Cannor said:
Kama upo ofisini na umewekwa kimkakati na uncle au shemeji bora uresign tu.

Nyie ndio mnaoziba nafasi za wenye vyeti halali na ufanisi kupewa ajira maofisini.

Kamanda Sirro njoo uanzie huku!

hahahahah mim nimejiajir mjomba hii nifanya tu kudhibit wiz idiot mwiz mwenyew

cc12 · Jul 14, 2016

ombi said:
Nimeshindwa kupakia excel hapa.

Aina noma mkuu Hesabu za Excel noma

John Cannor · Jul 14, 2016

cc12 said:
hahahahah mim nimejiajir mjomba hii nifanya tu kudhibit wiz idiot mwiz mwenyew

Sasa umejiajiri without skills? Kama una mteja si umemchomesha sana hindi kukusubiri kaunta umfanyie kazi yake.?

Acha hizo rudi shule kamalizie hiyo program ya Ms Excel.

pleo · Jul 14, 2016

cc12 said:
hahahahah mim nimejiajir mjomba hii nifanya tu kudhibit wiz idiot mwiz mwenyew

weka column g, f, na h kwanza kwenye # format moja drag formula angalia jibu elekeza tofauti tu fix cell kutatua tatzo kwa ujumla.

++hata 200000 haikutakiwa kuwa kwenye formula++

cc12 · Jul 14, 2016

ombi said:
View attachment 366248

Au unataka iwe "automatic" bila ku-drag?

ndio mkuu kama ikiwezekana ingekuwa poa zaid hii yako nimeifanya iko fresh kbs
shukran kbs kama inafaa niambie tu nimoja ya kujifunza pia

cc12 · Jul 14, 2016

pleo said:
weka column g, f, na h kwanza kwenye # format moja drag formula angalia jibu elekeza tofauti tu fix cell kutatua tatzo kwa ujumla.

++hata 200000 haikutakiwa kuwa kwenye formula++

sijaelewaha hapo mkuu kbs umeniacha boss

Rogie · Jul 14, 2016

cc12 said:
Niaje Wakuu niende moja kwa moja kwenye point

Kuna Spread sheet nataka kutengeneza ambayo inakuwa na Expenses, Derbit, Credit na Cash Flow kwenye Bank Acc mfano nimenunua sukari 200tsh hii itakuwa derbit (Nimetoa kwenye Acc yang ambayo ina shiling elfu 5000) iikabak 4800 nikapewa hela na juma shiling 600 hii inakuwa ni credit (4800+600=5400 ambacho nikias kwenye akiba yangu) sasa nataka kiweka hii kitu kwenye Excel lakin formula imenipiga chenga mkuu na sehemu inayotakiwa kuwa na Formula ni moja tu kwenye Cash Flow Basi

CC ymollel Chief-Mkwawa na wengine

Kulingana na maelezo yako cheki formula hapa chini, unachofanya ni kuweka figure zako kwenye expenses, debit, credit drag cell I na J itakuwa jibu kwenye cash flow na ndio balance yako itakayokuwa imebaki Bank.

Rogie · Jul 14, 2016

cc12 said:
mkuu ujanilewa vzr hapo unapochukua credit-debit sijui unapata nin mim nina idea ila namna ya kupresent kwente Fx sasa ndio mziki labda nina laki mbil yangu nikitaka kujua nimeingia nimetoa sina naweka 200,000-Debit+Credit ila nikiweka hii kwenye sheet haiwiii carry foward angalia hapa yan formula inakuwa applicable kwenye row ya kwanza tu ukijaribu kwenye
row ya pil kwa kudrag inakataa inatoa jibu la uongo

Unajichanganya mwenyewe kwenye hii excel yako. Njoo PM nikusaidie.

LUCAS MSUKA · Jul 14, 2016

Ukiingia excel pale kuna kitu kinaitwa help, kitakusaidia kila kitu na jins ya kuandika formula itakuelekeza

Karimu123 · Jul 14, 2016

Bassem said:
Kulingana na maelezo yako cheki formula hapa chini, unachofanya ni kuweka figure zako kwenye expenses, debit, credit drag cell I na J itakuwa jibu kwenye cash flow na ndio balance yako itakayokuwa imebaki Bank.

View attachment 366260

duuuuh hi formula yako sio kbs mana yangu inaunganisha debit na credit tu hakuna expenses

Rogie · Jul 14, 2016

Karimu123 said:
duuuuh hi formula yako sio kbs mana yangu inaunganisha debit na credit tu hakuna expenses

Hiyo ni yako, yangu inaonesha expenses kama mleta hoja alivyoelezea kwenye thread yake. Kinachofanyika ni kuweka item zile unazotaka against column.

Msaada kwa Wataalamu wa Excel

John Cannor

JF-Expert Member

cc12

JF-Expert Member

cc12

JF-Expert Member

John Cannor

JF-Expert Member

pleo

JF-Expert Member

cc12

JF-Expert Member

cc12

JF-Expert Member

Rogie

JF-Expert Member

Rogie

JF-Expert Member

LUCAS MSUKA

Member

Karimu123

JF-Expert Member

Rogie

JF-Expert Member

Similar Discussions