Vele, amafomula ku-Excel abe futhi ahlala ingelinye lamathuluzi ayinhloko, kodwa ngezinye izikhathi, ngokushesha, kungaba lula kakhulu ukwenza izibalo ngaphandle kwazo. Kunezindlela eziningana zokwenza lokhu.
Namathisela okukhethekile
Ake sithi sinenqwaba yamaseli anesamba esikhulu semali:
Kudingekile ukuwaguqula abe "ama-ruble ayizinkulungwane", okungukuthi, uhlukanise inombolo ngayinye ngo-1000. Ungakwazi, vele, uhambe ngendlela yakudala futhi wenze elinye itafula elinosayizi ofanayo eduze kwalo, lapho ungabhala khona amafomula ahambisanayo (= B2/1000, njll.)
Futhi kungaba lula:
- Faka u-1000 kunoma iyiphi iseli yamahhala
- Kopisha leli seli ebhodini lokunamathisela (Ctrl + C noma chofoza kwesokudla - Kopisha)
- Khetha wonke amaseli anenani lemali, chofoza kwesokudla kuwo bese ukhetha Namathisela okukhethekile (Namathisela Okukhethekile) noma chofoza I-Ctrl + Alt + V.
- Khetha kumenyu yokuqukethwe Amanani (Amanani) и Ukuhlukanisa (Hlukanisa):
I-Excel ngeke ifake u-1000 kuwo wonke amaseli akhethiwe esikhundleni sezibalo (njengoba ibingenza ngokunamathisela okuvamile), kodwa izohlukanisa zonke izibalo ngenani elikubhafa (1000), okuyikhona okudingekayo:
Kulula ukubona ukuthi lokhu kulula kakhulu:
Bala noma yiziphi izintela ngamanani angaguquki (i-VAT, intela yeholo lomuntu siqu ...), okungukuthi engeza intela kumanani akhona noma uyisuse.
Guqula amaseli anesamba esikhulu semali abe “inkulungwane”, “isigidi” ngisho “nezigidigidi”
Guqula ububanzi obunamanani emali buwayise kwezinye izinhlobo zemali ngenani
Shifta wonke amadethi ebangeni uye kwedlule noma esizayo ngenombolo ecacisiwe yekhalenda (hhayi ibhizinisi!) izinsuku.
Ibha yesimo
Kushibhile, kujabule futhi kwaziwa abaningi. Uma uhla lwamaseli lukhethiwe, ibha yesimo ibonisa ulwazi kuwo:
Okungaziwa kakhulu ukuthi uma uchofoza kwesokudla kulawa manani, ungakhetha ukuthi iziphi izici ongazibonisa:
Elula futhi elula.
I-Calculator
Ikhibhodi yami inenkinobho ehlukile ezinikele yokufinyelela ngokushesha kumshini wokubala we-Windows ojwayelekile - into ewusizo kakhulu endaweni yokusebenza. Uma ikhibhodi yakho ingenayo, ungakha enye ku-Excel. Kwalokhu:
- Chofoza kwesokudla kubha yamathuluzi yokufinyelela Ngokushesha ekhoneni eliphezulu kwesokunxele bese ukhetha Ukwenza ngokwezifiso ibha yamathuluzi yokufinyelela ngokushesha (Enza ngendlela oyifisayo ibha yamathuluzi yokufinyelela okusheshayo):
- Ewindini elivulayo, khetha Wonke amaqembu (Yonke imiyalo) kokwehliswayo okuphezulu esikhundleni sokuthi Imiyalo esetshenziswa njalo (Imiyalo Edumile).
- Thola inkinobho I-Calculator(Isibali) futhi uyengeze kuphaneli usebenzisa inkinobho Engeza (Engeza):
- Ukuhlanganisa amakholomu amabili edatha ne ukufaka okukhethekile
- Ungayakha kanjani ifomethi yakho yangokwezifiso (ama-ruble ayinkulungwane namanye angewona ajwayelekile)
- Indlela yokushintsha imigqa ibe amakholomu futhi ngokuphambene nalokho