Yawancin masu amfani ba su ma san cikakken ikon Excel ba. Da kyau, eh, mun ji cewa shirin don aiki tare da tebur, eh suna amfani da shi, suna kallon wasu takardu. Na yarda, Na kasance mai amfani iri ɗaya, har sai da nayi tuntuɓe kan wani aiki mai kamar ba shi da sauƙi: don ƙididdige adadin sel a ɗayan teburina a cikin Excel. Na kasance ina yin wannan akan kalkuleta (yanzu abin ban dariya ne :-P), amma wannan lokacin teburin yayi yawa sosai, kuma ya yanke shawarar lokaci yayi da zamuyi nazari a kalla daya ko biyu masu sauki ...
A cikin wannan labarin zan yi magana game da jimlar tsari don sauƙaƙa fahimta, yi la'akari da couplean misalai masu sauƙi.
1) Don yin lissafin kowane adadin primes, zaku iya danna kowane sel a cikin Excel ku rubuta a ciki, misali, "= 5 + 6", sannan kawai danna Shigar.
2) Sakamakon bai dauki lokaci mai tsawo ba, a cikin tantanin da kuka rubuta dabarnan sakamakon "11" ya bayyana. Af, idan ka danna kan wannan tantanin (inda aka rubuta lamba 11) - a layin dabara (duba hoton allo a sama, kibiya mai lamba 2, a hannun dama) - ba zaka ga lamba 11 ba, amma duk iri daya ne "= 6 + 5".
3) Yanzu bari muyi kokarin lissafin jimlar lambobin daga sel. Don yin wannan, mataki na farko shine zuwa sashin "FORMULAS" (menu na sama).
Bayan haka, zaɓi sel da yawa waɗanda adadin kuɗin da kuke son lissaftawa (a cikin sikirin kariyar da ke ƙasa, ana ba da fifikon ribar uku a cikin kore). Sai hagu-danna akan shafin "AutoSum".
4) Sakamakon haka, jimlar sel uku da suka gabata zasu bayyana a cikin tantanin da ke kusa. Duba hotunan allo a kasa.
Af, idan muka je tantanin tare da sakamako, to zamu ga tsarin da kansa: "= SUM (C2: E2)", inda C2: E2 shine jerin sel da ake buƙatar ƙarawa.
5) Af, idan kuna son yin lissafin jimlar a cikin dukkan layuka da suka rage a cikin tebur, to kawai kwafa dabarar (= SUM (C2: E2)) zuwa duk sauran ƙwayoyin. Excel zai lissafta komai ta atomatik.
Ko da irin wannan dabara mai sauƙi - yana sa Excel kayan aiki mai ƙarfi don lissafin bayanai! Yanzu tunanin cewa Excel ba ɗaya bane, amma daruruwan nau'ikan dabaru daban daban (ta hanyar, Na riga na yi magana game da aiki tare da mafi mashahuri). Godiya garesu, zaku iya lissafta komai da komai, yayin da kuke adana ton na lokacinku!
Shi ke nan, sa'a ga kowa da kowa.
