Gadzirai ma column mu Excel uye ita zvose zvinokwanisika kusanganiswa

Excel kuungana

Kuva nezvinhu zviviri zvakasiyana-siyana, sekutengeserana nevatengi uye mhando yezvigadzirwa, uye unoda kuvabatanidza kuwana rutsva rutsva nezvose zvinokwanisika kusanganiswa kwevatengi uye zvigadzirwa?

Mhinduro yacho yakanaka kwazvo, inokwanisika ne MS Excel mumaminitsi mashomanana, uye, kunyange nezviuru zvezvinyorwa, hazvidi kushanda nesimba - zvishoma kudarika kopi iyo inowedzera rutivi rwechipiri rwehumwe humwe hwerwendo rwekutanga - iyi yekupedzisira sarudzo kutora maawa nemazana ezvinyorwa. Ona pasi apa kuti unobatanidza sei Excel mizamu uye uite zvose zvinokwanisika kusanganiswa Excel.

Nzira yekugadzira kana kunyora zvose zvinogona kuregererwa mu Excel

• Gadzira nhamba yechirangaridzo kubva pa1 kusvika kune nhamba yezvinyorwa zvepafaira rega rega, uye, mubhuku rekupedzisira:
• Gadzira nhamba yenhamba (ID) mukhoma A kubva kubva 1 kusvika pakuwedzera kwemaverengi ekutanga mafaira uye mafaira echipiri mafaira, kuumba semigwagwa yakawanda sekubatanidzwa kwezvinhu zvose zveseti,
• Wedzera firimu, pinda iyi fomu uye uiwedzere kusvika kumugumo wokupedzisira = ROUNDUP (A2 / [Yechipiri maipinda emafaira akaverengwa]; 0),
• Wedzerai korona, pinda murairi iyi uye uwedzere kusvika kumugumo wokupedzisira = A2 - ([Chechipiri mafaira emafaira akaverengwa] * (B2-1)),
• Wedzera sehurukuro dzakawanda sezvaunoda kuwana kubva kune faira yekutanga neyechipiri, uye ita vlookups pakutsanangurwa kwakakonzerwa mumugumisiro wefaira uye mafaira ezvinyorwa.

Gadzirai data muExcel

Ona pasi apa muenzaniso wakazara wekubatanidza mavara emashizha akaisvonaka, ane Vateresi urongwa uye Zvimwe mazita.

Tanga nekusika zvidhori mukati memafaira maviri, nekuwedzera kenduru kuruboshwe, kupinda maitiro 1 uye 2 mumitsetse miviri yekutanga, kusarudza maviri masero, kutamisa mouse kurusi kukona kwezasi-kukona pakusarudzwa, uye kaviri kuvhara pa chiratidzo + ichocho kuti chiwedzere chiziviso chinowedzera kusvika kumugumo wokupedzisira.

Somugumisiro, zvitsva izvi zvakanyatsogadzirwa kusvika kumugumo wokupedzisira.

Nzira yekubatanidza mazamu muhurukuro

Tora huwandu hwekutsvaga nhamba dzeVatengi (C) uye Products (P). Gadzira faira idzva, rine chinyorwa chekucherechedza, uye dzokorora chiziviso chekuwedzera basa, kusvika kumutsara (C * P) + 1. Pasi pemuenzaniso, maitiro manomwe akasiyana nevatengi, uye 7 yeMiti, zvichiita kuti 7 * 7 = 49 masanganiswa, + 1 mutsara wokugadzirira mutsara wemusoro.

Nzira yekubatanidza masero ari nani

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Muchikamu cheB, tichaisa mitsara yeP P Per Customer, sezvo mumwe nomumwe wavo achava nemuganhu mumwechete pane Mutengo. Izvi zvinoshandiswa kuburikidza uchishandisa pasi apa mazano mumutsara wechipiri wemashizha, uye uchiwedzererera kusvika pasi (yeuka kuvhara kaviri pane + icon muzasi-kona yekamuri kusarudzwa kuti uite saizvozvo), apo X ndiyo yechipiri mafaira ekupinda

Muchikamu cheC, tichaisa chiverengero kune umwe neumwe weVatengi, kubva pa1 kusvika kuMitambo kuverengwa. Shanduro imwechete sepakutanga, uye imwe shanduro (ikozvino mutsara inoratidza kusinganisa nhamba yakasvika kune yekare Mutsetse Wemutambo), X kuva yechipiri faira kupinda

Gadzirai mikoko yakawanda muhurukuro mune imwe koromo

Tarisai kana yakashanda. Vatengi vanodzokorora P dzimwe nguva, uye nokuda kweumwe neumwe wavo, Zviratidzo zvese zvinodzokorora kubva 1 kusvika P

Ita zvose zvinogumira

Uye ndizvo zvazviri! Zvadaro, pane imwe nhare yaunoda kutora kubva kune Vatengesi kana Makombiyuta faira, wedzera imwe korombo, uye ita Vlookup pane chinyorwa chinoenderana uye faira.

Mibvunzo Inowanzo Bvunzwa

Vashandisi vanokwanisa sei kusanganisa mashoma mashoma emakoramu muExcel kuti aumbe rondedzero yezvinhu zvese zvinogoneka pasina kushandisa mafomu akaoma?

Vashandisi vanogona kushandisa Excel's Simba Query Founds yekubatanidza makoramu uye gadzira musanganiswa. Nekutakura makoramu setafura yekubvunza masimba, uye nekuwedzera tsika yekushandisa, uye wozowedzera tafura inokonzerwa, zvese zvinogoneka zvinogona kugadzirwa zvakarongeka uye zvakadzoserwa kubudikidza.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo