Naomba msaada kutoka kwa wataalamu wa Microsoft Excel

G

gobraco

Member
Joined
Jul 2, 2014
Posts
54
Reaction score
22
guys natakiwa kwenye final interviews its all about excel , i will be given computer and excel sheet with questions , pls nipen ma formula na techniques wadau, nimetumia excel ofcn for more thn 3years bt i still believe kuna vitu cvijui so pls seriously comments will b highly apreciated

thanks
 
EXCEL INA FORMULA NYINGI SANA. Hapo inategemea una-deal na kitu gani.
 
Kwa kuanzia ni ;
SUM,AVERAGE,MAX,MIN,COUNT,DSUM,DAVERAGE,DMAX,DMIN,DCOUNT,VLOOKUP,ISNUMBER,ISTEXT,FIND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK. Pia Arithmetic Operations, Conditional Formatting na Absolute Reference. Ukiadvance kuna Macro zinakusubiri. Kila la kheri.
 
Excel is very broad in terms of formulas and calculations. But interview inategemea na level yako ya education. Kama una level ya degree and above utaulizwa kivyovyote, so kuwa tayari kwa lolote guy
 
Usiache kusoma na namna ya kusummarize data kwa kutumia pivot table.
 

duh! balaaa , cn u tl me more, aplication ya iziVLOOKUP,ISNUMBER,ISTEXT,FI ND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK
 
Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe
 
andybird314 said:
Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe
Click to expand...

Kioñgozi hapo itategemea unaulizwa kitu gani mambo Ni mengi sana!
 
gobraco said:
duh! balaaa , cn u tl me more, aplication ya iziVLOOKUP,ISNUMBER,ISTEXT,FI ND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK
Click to expand...

Ingia youtube mkuu. Tutorial zipo za kutosha
 
Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest
 
mwalim.mkuu said:
Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest
Click to expand...

Kuzidisha tunatumia '*' operator, kupanga grade mfano A(81-100), B(61-80), n.k Google how to use IF( ) function. Kupanga highest to lowest tumia SORT button
 
neggirl said:
Mweeee
Shikamoo excel. Ni nzuri sana kama unaijulia
Click to expand...

Excel si mchezo. Waweza kujiona umeijua siku ukamkuta mtu anafanya vitu vya ajabu ukajiona hujui kitu.
 
Alola said:
Excel si mchezo. Waweza kujiona umeijua siku ukamkuta mtu anafanya vitu vya ajabu ukajiona hujui kitu.
Click to expand...

Ila nadhani kwa jinsi ulivyouliza swali lako.. utapata majibu mengi sn na mengine hayatakusaidia zaidi ya kukuchanganya.

Ingekuwa poa ukasema
nature ya kazi unayokwenda kufanya. Hiyo kitu ni pana sana utapata kizunguzungu bure
 
Alola said:
Kuzidisha tunatumia '*' operator, kupanga grade mfano A(81-100), B(61-80), n.k Google how to use IF( ) function. Kupanga highest to lowest tumia SORT button
Click to expand...

Mkuu nashukuru sana hiyo if nested naipata shida ilikuwa hyo ya kuzidisha na hiyo ya sort
 
Nawapongeza wote waliochangia uzi huu bila kejeli wala mizaha .....nimefurahi kusoma comment zinazoonesha watu kuwa tayari kusaidia. Hii ndio faida ya mitandao .....mtu usichojua anajua mwingine hivyo hakuna mjuzi wa kila kitu......safi sana .......
 
kama ni sehemu bado nipo shallow basi ni excel,ina vikororo vingi sana yani.
 
You must log in or register to reply here.

Similar Discussions

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…