Tupeane maujanja ya Excel


Ethos

Ethos

JF-Expert Member
Joined
Aug 1, 2015
Messages
2,291
Points
2,000
Ethos

Ethos

JF-Expert Member
Joined Aug 1, 2015
2,291 2,000
Wadau,

Kujua Excel Spreadsheets ni muhimu sana...

Tunaweza tukashirikishana tricks mbalimbali katika Excel hapa ili tujifunze wote..

Unaweza pandishwa CHEO au Kupata kazi kirahisi Kwa kujua EXCEL vizuri.. Watanzania wengi udhaifu wao upo hapo.. So Unaifanya WEAKNESS hiyo kuwa Strength kwako.Kwenye Ofisi yeyote mtu ambaye haogopi excel huwa anaonekana ni kichwa sana.. unaweza pia ukamvutia bosi wako kama utaijua kumshinda yeye na atakufanya rafiki yako ili usimuumbue...

Kwenye Interview ndio utawamaliza kabisa ..ukikutana na viherehere wakakuchokoza hapo ndio unawaonesha ujuzi wako wote... wengi huwa hawaijui kwasababu ya uvivu... Kwa hiyo usiogope..Niliwahi ulizwa swali na panelist kwenye Interview nikaenda deep mpaka akaogopa maana kuna vitu alikuwa havijui na yeye akaamua apotezee hilo swali akarukia kitu kingine kukwepa aibu..

Weka Trick yako hapo chini ili wengine wafaidi au kama unaswali uliza nitakujibu mimi au wadau wengine...

Ingependeza sana pale unapokwama uulize swali hapa.. Ili tujadiliane vitu ambavyo ni useful katika mazingira yetu ya shule au kazini...

Dunia ya sasa sio lazima uende darasani.. Unaweza tumia muda wako na MB zako vizuri mtandaoni na ukaongeza Ujuzi polepole

**Kama unatafuta kazi na umeandika Kwenye CV kwamba una ujuzi na Excel fuatilia huu uzi na group uwe updated na vitu mbalimbali ili usije umbuka siku ukiwa unafanya written au Oral Interview

** Nitakuwa naelezea Common questions ambazo waajiri hupenda kuuliza kukupima uelewa wako katika Spreadsheets.. Ni Muda na MB zako tu.. Sihitaji kingine...

Please NOTE

** Usiulize kitu unachokijua kupima watu Bali andika trick unayoijua ili wengine wafaidi na kama unaswali ULIZA wataalam tutakusaidia



PS:
Kama upo Telegram unaweza Ingia Kwenye Public Channel ipo hapo chini Kwa vitu ambavyo haviwezekani kuelezewa hapa vizuri..Kama video na files. Ni public channel ya kusoma na Sio sehemu ya chatting!


gonga hapo >>>> Excel/SpreadsheetsTZ

Naomba kuwasilisha!

Ethos
 
SPYMATE

SPYMATE

JF-Expert Member
Joined
Apr 17, 2013
Messages
905
Points
500
Age
39
SPYMATE

SPYMATE

JF-Expert Member
Joined Apr 17, 2013
905 500
Mkuu nisaidie kujua namna ya kuandika barua kwa excel na kuituma kwa mtu zaidi ya mmoja.....
Utakuwa umechanganya madawa!! Hiyo inayozungumzia ni Mailing & Merge.
Ms Word ndiyo inahusika kwenye kazi hiyo siyo excel
 
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined
Sep 3, 2013
Messages
396
Points
500
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined Sep 3, 2013
396 500
Utakuwa umechanganya madawa!! Hiyo inayozungumzia ni Mailing & Merge.
Ms Word ndiyo inahusika kwenye kazi hiyo siyo excel
Mkuu hyo mailing &merge inahusika kote kemwenye xcel na ms word kwa maana kuwa unaweza fanya xcel ndo source ya data unazotaka kufanyia hyo mail &merge kwenye ms word. Lkn pia xcel unaweza kuandika barua (km ms word vile) kisha ukazituma kwa watu wote kwa kutumia lookup function. Lakin njia nzuri na rahs zaidi ni hyo ya mail merge ya ms word.
 
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined
Sep 3, 2013
Messages
396
Points
500
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined Sep 3, 2013
396 500
Kifupi xcel ni kila kitu unachokitaka cha msingi ni kukazana na mazoezi kila wkt maana hii kitu ni km hesabu kila cku lazma usolve ili usisahau na uwe fit zaid. Juzi kati nimetengeneza student id kwenye xcel kwa kutumia lookup function. Ilikuwa ni ktk harakati za kupanua uelewa wangu wa xcel(trial and error)
 
Khalidoun

Khalidoun

JF-Expert Member
Joined
Feb 12, 2013
Messages
2,605
Points
2,000
Khalidoun

Khalidoun

JF-Expert Member
Joined Feb 12, 2013
2,605 2,000
PS:
Kama upo Telegram unaweza Ingia Kwenye Public Channel ipo hapo chini Kwa vitu ambavyo haviwezekani kuelezewa hapa vizuri..Kama video na files. Ni public channel ya kusoma na Sio sehemu ya chatting!


gonga hapo >>>> Excel/SpreadsheetsTZ

Ethos
Ujumbe kutoka Telegram kwenda kwa creator wa Channel Ndugu Ethos;

The account of the user that created this channel has been inactive for the last 5 months. If the account of the creator remains inactive in the next 28 days, it will be self-destructed and the channel will lose its creator.
 
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined
Sep 3, 2013
Messages
396
Points
500
Mkazamoyo

Mkazamoyo

JF-Expert Member
Joined Sep 3, 2013
396 500
Jamani mbona uzi upo kimya sana mkuu Ethos uko wapi bwana njoo tuzidi kupeana maujuzi huku
 
F

FaruJohn

Member
Joined
Dec 10, 2016
Messages
53
Points
125
Age
49
F

FaruJohn

Member
Joined Dec 10, 2016
53 125
Sasa we jamaa, uliyoitoa inakuwa kama manually kwa kuwa kila somo itanibidi nitafute idadi ya A peke yake kwanza, kisha B+ peke yake, kisha B peke yake, kisha C peke take, n.k yaani mpaka masomo yote 9 ni shughuli.
Sasa mi nataka formula ya ku-process masomo yote 9 na kwa wanafunzi wote (hata wakiwa 600 kwa mfano) ili nipate summary ya jumla ya grades hizo kwa kila somo kwa wanafunzi wote.
Yap... jamaa solution yake too manual. Hapo unatakiwa kutumia pivot table. Inakusaidia ku summarize data zako kwa namna unavyotaka

Sent using Jamii Forums mobile app
 
philipo mduma

philipo mduma

Senior Member
Joined
Aug 24, 2016
Messages
101
Points
225
philipo mduma

philipo mduma

Senior Member
Joined Aug 24, 2016
101 225
Uzi mzuri sana nimepata kujifunza mambo.
 
Nukta5

Nukta5

JF-Expert Member
Joined
Jun 7, 2014
Messages
874
Points
1,000
Nukta5

Nukta5

JF-Expert Member
Joined Jun 7, 2014
874 1,000
Kuna kazi ya excel nataka nifanye Ethos uko wapi
 

Forum statistics

Threads 1,284,842
Members 494,294
Posts 30,842,176
Top