Contents
Video
Samar da matsala
Muna da tebur wanda muke aiki akai-akai da shi (jera, tacewa, ƙididdige wani abu akansa) da abinda ke ciki wanda ke canzawa lokaci-lokaci (ƙara, sharewa, gyara). To, aƙalla, alal misali - a nan shi ne kamar haka:
Girman - daga dubun-duba da dama zuwa layin dubu dari - ba shi da mahimmanci. Ayyukan shine sauƙaƙe da sauƙaƙe rayuwar ku ta kowace hanya mai yuwuwa ta hanyar juya waɗannan sel zuwa teburin "mai wayo".
Magani
Zaɓi kowane tantanin halitta a cikin tebur da kan shafin Gida (Gida) fadada lissafin Tsara azaman tebur (Format a matsayin tebur):
A cikin jerin zaɓuka na salo, zaɓi kowane zaɓi na cikawa ga dandano da launi, kuma a cikin taga tabbatarwa don kewayon da aka zaɓa, danna. OK kuma muna samun fitarwa mai zuwa:
A sakamakon haka, bayan irin wannan canji na kewayon zuwa "smart" Table (tare da babban wasiƙa!) muna da abubuwan farin ciki masu zuwa (sai dai ƙira mai kyau):
- Ƙirƙiri Table yana samun suna Table 1,2,3 da sauransu waɗanda za a iya canza su zuwa mafi isassun ɗaya akan shafin Constructor (Zane). Ana iya amfani da wannan suna a kowace dabara, jerin abubuwan da aka saukar, da ayyuka, kamar tushen bayanai don tebur mai pivot ko tsarin bincike don aikin VLOOKUP.
- An ƙirƙira sau ɗaya Table ta atomatik daidaita zuwa girman lokacin ƙarawa ko goge bayanan zuwa gare ta. Idan kun ƙara zuwa irin wannan Table sababbin layi - zai shimfiɗa ƙasa, idan kun ƙara sababbin ginshiƙai - zai faɗaɗa cikin faɗin. A cikin ƙananan kusurwar dama Tables zaka iya ganin alamar kan iyaka mai motsi ta atomatik kuma, idan ya cancanta, daidaita matsayinsa tare da linzamin kwamfuta:
- A cikin hula Tables ta atomatik AutoFilter yana kunna (ana iya tilastawa kashewa akan shafin data (Kwanan wata)).
- Lokacin ƙara sababbin layi zuwa gare su ta atomatik an kwafi duk hanyoyin.
- Lokacin ƙirƙirar sabon ginshiƙi tare da dabara - za a kwafi shi ta atomatik zuwa dukkan ginshiƙi - babu bukatar ja dabara tare da baki autocomplete giciye.
- Lokacin gungurawa Tables saukar an canza rubutun shafi (A, B, C…) zuwa sunayen filin, watau ba za ku iya sake gyara kewayon taken kamar da ba (a cikin Excel 2010 akwai kuma autofilter):
- Ta hanyar kunna akwati Nuna jimlar layi (Jimlar jere) tab Constructor (Zane) muna samun jimlar jimlar ta atomatik a ƙarshen Tables tare da ikon zaɓar aiki ( jimla, matsakaita, ƙidaya, da sauransu) ga kowane shafi:
- Ku data in Table za a iya magance ta amfani da sunayen daidaikun abubuwan sa. Misali, don taƙaita duk lambobin da ke cikin ginshiƙin VAT, zaku iya amfani da dabarar =SUM(Table1[VAT]) maimakon = SUM (F2: F200) kuma kada kuyi tunani game da girman tebur, adadin layuka da daidaitattun jeri na zaɓi. Hakanan yana yiwuwa a yi amfani da maganganun masu zuwa (zaton tebur yana da daidaitaccen suna Table 1):
- =Table1[#All] - hanyar haɗi zuwa gabaɗayan tebur, gami da taken shafi, bayanai da jimillar jeri
- =Table1[#Data] - hanyar haɗin bayanai-kawai (babu mashaya take)
- =Table1[#Headers] – haɗi kawai zuwa jere na farko na tebur tare da kanun shafi
- = Tebur 1 [# Jimlar] - hanyar haɗi zuwa jimlar jeri (idan an haɗa shi)
- =Table1[#Wannan jere] - koma ga jere na yanzu, misali, dabara =Table1[[#Wannan jere];[VAT]] zai koma ga darajar VAT daga layin tebur na yanzu.
(A cikin fassarar Ingilishi, waɗannan masu aiki za su yi sauti, bi da bi, kamar # Duk, #Data, # Headers, #Totals da #Wannan jere).
PS
A cikin Excel 2003 akwai wani abu mai kama da irin waɗannan tebur "masu wayo" - an kira shi Jerin kuma an ƙirƙira ta cikin menu. Bayanai - Lissafi - Ƙirƙiri Jerin (Bayani - Lissafi - Ƙirƙiri jerin). Amma ko da rabin aikin na yanzu ba a wurin kwata-kwata. Tsoffin sigogin Excel ma ba su da wannan.