Naomba msaada kutoka kwa wataalamu wa Microsoft Excel

[gobraco]

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

 

[mij]

EXCEL INA FORMULA NYINGI SANA. Hapo inategemea una-deal na kitu gani.

 

[Alola]

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.

 

[lbaraka]

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

 

[Kyatsvapi]

Usiache kusoma na namna ya kusummarize data kwa kutumia pivot table.

 

[gobraco]

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.

duh! balaaa , cn u tl me more, aplication ya iziVLOOKUP,ISNUMBER,ISTEXT,FI ND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK

 

[HIMARS]

Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe

 

[momentoftruth]

Je mtu akitaka tengeneza sheets ambazo moja inakuwa ni ya kuweka hesabu ya mizigo, nyingine ya mauzo. Ukiuza kitu kule kwenye store inajibadilisha yenyewe

Kioñgozi hapo itategemea unaulizwa kitu gani mambo Ni mengi sana!

 

[karibukwetusingida]

Kuna kitu kinaitwa VLOOKUP lazima ukijue mkuu vinginevo ......

 

[Alola]

duh! balaaa , cn u tl me more, aplication ya iziVLOOKUP,ISNUMBER,ISTEXT,FI ND,SUBSTITUTE,LEFT,RIGHT,CONCATENATE,IFERROR,ISBLANK

Ingia youtube mkuu. Tutorial zipo za kutosha

 

[MwanaCBE]

Kuna kitu kinaitwa VLOOKUP lazima ukijue mkuu vinginevo ......

Pia kuna HLOOKUP hii huvuta taarifa horizontally.

 

[mwalim.mkuu]

Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest

 

[Alola]

Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest

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]

Mweeee
Shikamoo excel. Ni nzuri sana kama unaijulia

 

[karibukwetusingida]

Mimi naomba msaada kwenye formula ya kuzidisha na jins ya kupanga ranks kutoka the highest average to the lowest

SORTING inatosha kabisa

 

[Alola]

Mweeee
Shikamoo excel. Ni nzuri sana kama unaijulia

Excel si mchezo. Waweza kujiona umeijua siku ukamkuta mtu anafanya vitu vya ajabu ukajiona hujui kitu.

 

[neggirl]

Excel si mchezo. Waweza kujiona umeijua siku ukamkuta mtu anafanya vitu vya ajabu ukajiona hujui kitu.

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

 

[mwalim.mkuu]

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

Mkuu nashukuru sana hiyo if nested naipata shida ilikuwa hyo ya kuzidisha na hiyo ya sort

 

[MTAZAMO]

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 .......

 

[badiebey]

kama ni sehemu bado nipo shallow basi ni excel,ina vikororo vingi sana yani.