Video
Kugadziriswa kwedambudziko
Tine tafura yatinogara tichishanda nayo (kuronga, sefa, kuverenga chimwe chinhu pairi) uye zvirimo zvinogara zvichichinja (wedzera, bvisa, gadzirisa). Zvakanaka, zvirinani, semuenzaniso - heino seizvi:
Saizi - kubva pamakumi akawanda kusvika kumazana ezviuru zvemitsara - haina kukosha. Basa ndere kurerutsa uye kuita kuti hupenyu hwako huve nyore munzira dzese nekushandura maseru aya kuita tafura "yakangwara".
mhinduro
Sarudza chero sero mutafura uye pane tab Home (Musha) wedzera rondedzero Fomati setafura (Fomati setafura):
Mune inodonhedza-pasi rondedzero yezvitaera, sarudza chero sarudzo yekuzadza kune kuravira kwedu uye ruvara, uye muhwindo rekusimbisa reiyo yakasarudzwa, tinya. OK uye tinowana zvinotevera zvinobuda:
Nekuda kweizvozvo, mushure mekushandurwa kwakadaro kweiyo renji kuita "smart" tafura (nemavara makuru!) tine mafaro anotevera (kunze kwedhizaini yakanaka):
- Created tafura anowana zita Tafura 1,2,3 etc. iyo inogona kuchinjwa kuita imwe yakakwana pane tab Constructor (Dhizaini). Iri zita rinogona kushandiswa mune chero mafomula, kudonhedza-pasi zvinyorwa, uye mabasa, senge data sosi yetafura yepivot kana yekutarisa array yeVLOOKUP basa.
- Yakagadzirwa kamwe tafura inozvigadzirisa pakukura pakuwedzera kana kudzima data kwairi. Kana ukawedzera kune vakadaro tafura mitsva mitsva - ichatambanudza pasi, kana ukawedzera makoramu matsva - ichawedzera muhupamhi. Mukona yezasi yekurudyi matafura iwe unogona kuona iyo inofambisa muganho marker uye, kana zvichidikanwa, gadzirisa chinzvimbo chayo negonzo:
- Muheti matafura vanonzi AutoFilter inobatidza (inogona kumanikidzwa kudzima pane iyo tab Data (Zuva)).
- Kana uchiwedzera mitsetse mitsva kwavari otomatiki mafomula ese akakopwa.
- Paunenge uchigadzira koramu nyowani ine fomula - inozoteedzerwa otomatiki kune iyo koramu yese - hapana chikonzero chekudhonza formula ine dema autocomplete cross.
- Pakupuruzira matafura pasi misoro yembiru (A, B, C…) inoshandurwa kuita mazita emunda, kureva kuti hauchakwanisa kugadzirisa musoro wepamusoro sepakutanga (muExcel 2010 kunewo autofilter):
- Nekugonesa bhokisi rekutarisa Ratidza mutsara wose (Total row) Tab Constructor (Dhizaini) tinowana otomatiki totals row kumagumo matafura nekwaniso yekusarudza basa (sum, avhareji, kuverenga, nezvimwewo) kune imwe neimwe column:
- Ku data mu tafura inogona kugadziriswa kushandisa mazita ezvimiro zvayo. Semuenzaniso, kuunganidza nhamba dzese muVAT column, unogona kushandisa fomula =SUM(Table1[VAT]) panzvimbo =SUM(F2:F200) uye kwete kufunga nezvehukuru hwetafura, nhamba yemitsara uye kururamisa kwemaitiro ekusarudza. Zvinogonekawo kushandisa zvirevo zvinotevera (tichifunga kuti tafura ine zita rakajairwa Tafura 1):
- =Tafura1[#Zvose] - chinongedzo kutafura yese, kusanganisira misoro yekoromo, data uye yakazara mutsara
- =Tafura1[#Data] - data-chete link (hapana zita rezita)
- =Tafura1[#Misoro] - batanidza chete kumutsara wekutanga wetafura ine misoro yemakoramu
- =Tafura1[#Zvose] - chinongedzo kune iyo yakazara mutsara (kana yakaverengerwa)
- =Tafura1[#Mutsara uyu] - kunongedzera kumutsara uripo, semuenzaniso, fomula = Tafura1[[#Mutsara uyu];[VAT]] ichareva kukosha kweVAT kubva pamutsara wetafura iripo.
(Mushanduro yeChirungu, maopareta aya anonzwika, zvichiteerana, se #All, #Data, #Headers, #Totals uye #This row).
PS
MuExcel 2003 pakanga paine chimwe chinhu chiri kure chakafanana nematafura "akangwara" akadaro - yainzi Rondedzero uye yakagadzirwa kuburikidza nemenyu. Data - Rondedzero - Gadzira Rondedzero (Data - Rondedzero - Gadzira runyorwa). Asi kunyange hafu yekushanda kwemazuva ano yakanga isipo zvachose. Mavhezheni echinyakare eExcel akange asinawo izvozvo.