Msaada: Matumizi ya MS EXCEL

ARISTOTLE79 · May 15, 2015

Habari Wadau wa humu ndani mie Sina mda mrefu humu kama member ila nimekua mfuatiliaji wa Mambo humu kwa muda mrefu.

Nimekuja hapa Naomba msaada juu ya Mambo mawili Kuhusu ms Excel

1. Kubadilisha neno liliandikwa kwa herufi ndogo kwenda herufi kubwa CAPITAL LETTERS

2. Kupanga orodha kubwa ya takwimu let's say majina, marks, miaka nk katika seniority.
Mi huwa lazima nibadili language ya computer kwenda ARMENIA ndo ikubali so kwa yeyote anayeweza kunisaidia kupanda bila kubadili Lugha ya computer yangu ntashukuru sana

Naomba kuwasilisha.

KAKA YAKO NAPITA · May 16, 2015

ARISTOTLE79 said:
Habari Wadau wa humu ndani mie Sina mda mrefu humu kama member ila nimekua mfuatiliaji wa Mambo humu kwa muda mrefu.

Nimekuja hapa Naomba msaada juu ya Mambo mawili Kuhusu ms Excel

1. Kubadilisha neno liliandikwa kwa herufi ndogo kwenda herufi kubwa CAPITAL LETTERS

2. Kupanga orodha kubwa ya takwimu let's say majina, marks, miaka nk katika seniority.
Mi huwa lazima nibadili language ya computer kwenda ARMENIA ndo ikubali so kwa yeyote anayeweza kunisaidia kupanda bila kubadili Lugha ya computer yangu ntashukuru sana

Naomba kuwasilisha.

Kubadili kwenda Herufi kubwa =&A& the press enter, A ni cell unayotaka kubadili

kupanga majina nenda SORTING zen arrange kutoka ndogo kwenda kubwa au kubwa kwenda ndogo

Mgumu04 · May 16, 2015

nenda sorting kisha chagua ascend or descend

mansakankanmusa · May 16, 2015

Leo umenipa mpya ya armenia...ikoje hiyo fafanua ndg mleta uzi

kabugira · May 16, 2015

Hiyo ya Amenia hata kwangu sioni correlation na tatizo lake alilowakilisha

ARISTOTLE79 · May 23, 2015

Kwa wale wanaopanha kazi kubwa wenye column nyingi na labda nataka kusort let's say column A ascending, then columnB descending then column H ascending n.k sizungumzii unasort only one column,

Mfano A miaka ya kuzaliwa,B tarehe ya ajira, C tarehe ya kuthibitishwa kazi, C check namba, F mshahara., sasa hapo unataka kupanga seniority list inayojumuisha taarifa zote.

Ukitumia sort then ascending au descending Huwezi kupanga zote at a time, ila ukibadili lugha ya pc yako kuwa Armenia inawezekana, sometimes inachosha kubadilibadili lugha ndo nkawa nataka msaada

ARISTOTLE79 · May 23, 2015

"Kaka yako napita" sijakuelewa kwenye CAPITALIZATION

KAKA YAKO NAPITA · May 24, 2015

ARISTOTLE79 said:
"Kaka yako napita" sijakuelewa kwenye CAPITALIZATION

mfano jina MWANDAGO wataka kulibadili na lipo kwenye cell A,Peleka cursor kwenye cell B afu type hyo formular

ARISTOTLE79 · May 24, 2015

Okay mkuu ntajaribu halafu ntakupa mrejesho

KAKA YAKO NAPITA · May 24, 2015

ARISTOTLE79 said:
Okay mkuu ntajaribu halafu ntakupa mrejesho

ni rahisi sana mkuu ila lazma uanze na equal sign kwenye cell B

ARISTOTLE79 · May 24, 2015

Kubadili kwenda Herufi kubwa =&A& the press enter, A ni cell unayotaka kubadili

Mkuu inanambia
If you are trying to enter a formula, avoid using Ana equal sign(=) or minus(-), precede it with a single quotation mark(')

Kwa msaada zaidi niPM namba nikupigie

Njuka II · May 11, 2019

ARISTOTLE79 said:
Kubadili kwenda Herufi kubwa =&A& the press enter, A ni cell unayotaka kubadili

Mkuu inanambia
If you are trying to enter a formula, avoid using Ana equal sign(=) or minus(-), precede it with a single quotation mark(')

Kwa msaada zaidi niPM namba nikupigie

Kubadili herufi ndogo kwenda herufi kubwa,Tumia UPPER function

Eg.

=UPPER(D5)

Kubadili herufi kubwa kwenda herufi ndogo,Tumia LOWER function

Eg

=LOWER(D5)

D5 ni cell ambayo ina hilo neno unalotaka kulibadili

Msaada: Matumizi ya MS EXCEL

ARISTOTLE79

JF-Expert Member

KAKA YAKO NAPITA

JF-Expert Member

Mgumu04

JF-Expert Member

mansakankanmusa

JF-Expert Member

kabugira

JF-Expert Member

ARISTOTLE79

JF-Expert Member

ARISTOTLE79

JF-Expert Member

KAKA YAKO NAPITA

JF-Expert Member

ARISTOTLE79

JF-Expert Member

KAKA YAKO NAPITA

JF-Expert Member

ARISTOTLE79

JF-Expert Member

Njuka II

JF-Expert Member

Similar Discussions