Tupeane maujanja ya Excel

[Bestfredy]

Mkuu mi nataka kutengeza page ya excel ntayoweka total number ya items...na kila nikitoa item moja mfano ziko jumla 20 basi nikitoa moja ibaki 19 automatically...nikitoa ingine zibaki 18 ivo ivo mpaka ziishe. Na zikiisha inipe alert kwamba zimeisha au zinakaribia kuisha!!! Nipe mwongozo hapo

Mkuu wetu naomba umsaidie huyu mtu utakua umetusaidia weng mno

 

[Saint Ivuga]

Mod hawaja u sticky huu uzi? Why

 

[kichwa kikubwa]

Mod hawaja u sticky huu uzi? Why

Moderator wana wivu. Hawatakia watu waweze ku-access kirahisi Uzi ili wajifunze vitu adimu.

 

[kichwa kikubwa]

Mkuu mi nataka kutengeza page ya excel ntayoweka total number ya items...na kila nikitoa item moja mfano ziko jumla 20 basi nikitoa moja ibaki 19 automatically...nikitoa ingine zibaki 18 ivo ivo mpaka ziishe. Na zikiisha inipe alert kwamba zimeisha au zinakaribia kuisha!!! Nipe mwongozo hapo

Total number ya items za aina moja au total number ya items za aina tofauti?

 

[Saint Ivuga]

Moderator wana wivu. Hawatakia watu waweze ku-access kirahisi Uzi ili wajifunze vitu adimu.

Kuna madini kibao

 

[Bestfredy]

Total number ya items za aina moja au total number ya items za aina tofauti?

Tofauti tofauti

 

[Mwaikibaki]

Good!

 

[Capital G]

VLOOKUP

Tuelekeze hii mkuu

 

[Capital G]

Okay,

Vlookup naifahamu vizuri,

Nahisi index+ match inaweza saidia.

Tufundishe hii mkuu

 

[Capital G]

How to draw/ plot Microsoft excell data (surveyor data) into AutoCAD.
1} PLOTING
surveyor data from the GPS devise (in UTM or other format ) or total station can be saved in excell and later ploted in AutoCAD. Those data represent coordinates of a point on earth's surface and they include Horizontal distance (in meters ) East/west (X) Noth /south(Y) , and elevations (Z) and with these data you can plot a profile or alignment in AutoCAD.
~PROCEDURES;
From the excel data will be contained in four columns horizontal distance, elevation,Nothing & easting. Join data from the column Nothing & easting into a single column with a commer in between them by using concatenate function eg 891, 351 where 891 is northing and 351 being easting.
- drag the formula through the range of data available.
-within the same column (at the upper most cell which should be empty) type the following AutoCAD command SPLINE
- Now copy the whole column data including the CAD command
-minimize the excel window and open the AutoCAD application software
- click the command line in AutoCAD, rightclick and paste data copied from excel ...click ENTER !!
-now what you see is the alignment of the surveyed area with respect to the surveyor data from the excel sheet.
Advantage of this is that you can work with large volume of data in a short time to create drawings for road alignment and profiles , water distribution network , site layouts for buildings as well as producing drawings for surveyed land properties.
Any question so far.
Nguzo1

Ungetumia kiswahili kaka ingekua poa sana

 

[Seawhale]

Wakuu naomba msaada wa namna ya kufungia vitu kwenye mfano ume-create kitambulisho kwenye publisher
, sasa ukitaka kuki-copy ki-copy kizimakizima bila kuacha kitu.

 

[Njuka II]

Wakuu naomba msaada wa namna ya kufungia vitu kwenye mfano ume-create kitambulisho kwenye publisher
, sasa ukitaka kuki-copy ki-copy kizimakizima bila kuacha kitu.

Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua Group

 

[Seawhale]

Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua Group

Shukrani Mkuu.

 

[Seawhale]

Select vitu vyote huku ukiwa umehold Ctrl button then right click then chagua Group

Boss sorry again, nifanyaje niweze kuzibadilisha tarehe zote za siku ya j2 ziwe na rangi nyekundu?

 

[Njuka II]

Boss sorry again, nifanyaje niweze kuzibadilisha tarehe zote za siku ya j2 ziwe na rangi nyekundu?

Select column ya Sunday then nenda kwenye font weka red

 

[Seawhale]

Select column ya Sunday then nenda kwenye font weka red

Kama ipo kwa mtindo huu ungebadili vipi?

 

[Njuka II]

Kama ipo kwa mtindo huu ungebadili vipi?

Hapo hakuna jinsi maana templates za ms publisher ni muunganiko wa objects mbali mbali ambazo baadae zinakuwa combined kutengeneza object moja,hazitengenezwi kama ms word doc type. Ile yenye muundo wa one month per each page unaweza ukaformat by column ama row tofauti na hiyo ya one year months per page.
Labda kama kuna njia nyingine ambayo siifahamu

 

[Seawhale]

Hapo hakuna jinsi maana templates za ms publisher ni muunganiko wa objects mbali mbali ambazo baadae zinakuwa combined kutengeneza object moja,hazitengenezwi kama ms word doc type. Ile yenye muundo wa one month per each page unaweza ukaformat by column ama row tofauti na hiyo ya one year months per page.
Labda kama kuna njia nyingine ambayo siifahamu

Ok sasa nikiwa nimefanya kwa mwezi mmoja to mwingine na nikahitaji miezi yote zionekane kwa page 1 nafanyaje?

 

[asubuhi sana]

Goal

 

[rumara]

Kuna njia ya kujiingizia kipato kwa kusaidia watu wenye shida ya kutumia Excel vizuri. Kama wewe unajiamini kwenye mambo ya Excel (bila VBA) unaweza ingia kwenye tovuti moja ya huko Amerika. Kipato chako kinaweza fika dollar 500 kwa wiki kama unao muda wa kutosha na unajua vizuri Excel.
Mimi binafusi nimefanikiwa wiki iliopita kujiunga nikachaguliwa kuwa mmoja wa ma experts. Kwa sasa hivi account yangu inasoma kipato cha dollar 80.7 baada ya siku 9.
Kama unahitaji kujiunga na watalamu wa Excel duniani kusaidia wenzako na kujiingizia kipato, unaweza tumia link hii:
Join today with this link and earn a sign on bonus!.