10 MS Excel kubereka matipi kubva kune nyanzvi

MS Excel mazano ekubereka

Iyo  Microsoft Office   spreadsheet software  MS Excel   inoshandiswa zvakanyanya kune yakakura yakawanda michina, kubva pakuchengeta runyorwa rwezvinhu kusvika parizvino kusvika mukugadzira mavovoice kana kunyange kutamba mitambo yemavhidhiyo.

Nekudaro, mukushandiswa kwemabhizimusi kwemazuva ese, vazhinji vevashandisi vekutanga havatomboziva nezvepundu rakakosha rekubuditsa Excel iyo inogona kuvachengeta nguva yakawanda nesimba, semuenzaniso kuverenga nhamba yezvirevo mune runyorwa rwezviuru zvemanyorerwo, kana zvimwe zvakapusa mashandiro akadai sekuwana chinzvimbo chemunhu tambo uye kumwe kuita.

Ndichingova zvishoma zvishoma zvekudzidziswa, zvinokwanisika kushandisa mune yezuva nezuva bhizinesi kushandiswa kwakakosha functionalities neExcel wildcards, iyo seti yemavara inogona kutsiva chero imwe imwe mune fomula. Ichishandiswa mune yepamusoro Vlookup muExcel vanokwanisa kuva vane simba zvakanyanya.

Isu takabvunza nharaunda yehunyanzvi mazano avo akanaka pane  MS Excel   kushandiswa, uye heino mhinduro dzavo:

 Iwe uri kushandisa MS Excel nguva dzose? Ndeipi imwechete tipi iyo inobatsira yako yezuva nezuva kubereka pabasa uye iwe yaunogona kugovera?

Stacy Caprio, Kukura Shambadziro: chengetedza zvinyorwa zvako zveExcel mugore

Imwe chete Excel yekubudirira tip ndeyekutsigira ako epamusoro magwaro pane gore.

Ndakashanda kwemavhiki nemakore makore pane chaiwo magwaro uye ndaitarisira kuti vagare varipo, asi ndazova nemamiriro ezvinhu apo kombiyuta yangu yakaputsika nekuda kwechinyorwa chekuparadzira mvura kana kumwe kutadza, ndikarasikirwa nemashizha angu akanaka. Ikozvino ndinoziva kugara ndichivadzosa saka ndichava navo kunyangwe kana chimwe chinhu chisingatarisirwe chikaitika, ndosaka ndichi chengeta iyo yakavakirwa negore nguva dzose.

Kenny Trinh, Netbooknews: bvisa mbeva uye uende 3-5 nguva nekukurumidza!

Enda mbeva-isina.

Iwe unowedzera kukurumidza kwako 3-5X paunobvisa mbeva. Nzira yakanaka yekutanga kudzidza izvi ndeye:

• 1.Iisa iyo ALT kiyi - uchaona mavara nenhamba zvinoratidzika kumusoro kwese menyu, ndiwo mafambiro aunoita kubva zvino
• 2. Dhinda iro peji reKhibhodi Shortcuts (search keyboard mapfupi pane google mifananidzo) uye tora iyo pakombuta yako

Kugadzikana uchishandisa Excel usina mbeva kunotora anenge 2-3 vhiki.

Kiyi dzekubudirira ndeidzi:

• Kumhanya -> enda panya-isina
• Automation -> dzidza kunyora mafomula makuru uye mafomu maspredishithi intuitively

Dai ndaizoisa nhamba yekuwedzera 3, heyi maitiro andinovagadzirira:

• 1. Kugadzira & chaiyo mafomula (prep anotyisa anotaridzika mishumo uye automate mabasa)
• 2. Kuongororwa kwedata - kusefa, kugadzirisa uye kuongorora data
• 3. Kuona kwedata - matafura, machati, uye maviri-axis machati

David Johnson, Mulytic Labs: Mhedziso kureva mamwe mimwe minda

Mhedziso Revhisheni yakachengetedza hupenyu hwangu, handizvikudza zvikuru kuti nditaure. Matenga akavhurika pandiri pandakadzidza kushandisa iyo '$' kugadzira zvirevo zvakakwana kune dzimwe minda. Kune vasina kubvumidzwa, iyo '$' iri pamberi petsamba inogadzirisa mutsetse uye iyo '$' pamberi pehuwandu inogadzirisa mutsara. Kubva ipapo, mareferensi anogona kuve akagadzikana sezvaunoda. Izvo zvakanyatsoita kuti hupenyu hwangu huve nyore kwazvo kana uchiita nekukurukura dhatabhesi nekukurumidza.

David Johnson, MBA, BA Computer Science, yakamboshanda muindasitiri ye tech kwemakore makumi maviri ichitungamira zvikwata zvepasi rese uye zvigadzirwa zvehunyanzvi muUS, Europe, uye APAC kumakambani akaita IBM neSungard. Parizvino ndiye Chief Technology Officer paMulytic Labs, apo achiitawo dhata uye tekinoroji manejimendi yekubvunza kuCloud Blue Data.

Norhanie Pangulima, Centriq: shandisa Flash kuzadza

Heino nhamba yangu yekutanga Excel yekubereka tip: Tenzi kushandiswa kwemafuta kuzadza. Flash kuzadza ibasa rakasimba kwazvo iro riri nyore kana zvasvika pakugadzirisa huwandu hwe data. Panzvimbo pekutsvagisa data rimwe nerimwe, unogona 'kudzidzisa' vhenekera kuzadza zvaunoda. Nyora mune izvo zvaunoda muchitokisi padivi pane yakaomeswa data kano wobva waedza kana iyo Flash kuzadza basa ichidzidza icho. Dzimwe nguva iwe ungazoda kunyora zvakanyanya kuti Excel izive maitiro, asi kana ikangoita, inokuitira basa racho.

Kuti uite izvi, tinya sero kwaunoda data kuti rive. Uye wobva wawana iyo Flash kuzadza bhatani. Iwe unogona kuzviona pane iyo Kumba tebhu, mune Editing pane iyo inogona kuwanikwa kurudyi chikamu chikamu cheExcel hwindo. Tsvaga iro Bhatisa bhatani pasi pe AutoSum uye tinya pasi pekuburitsa. Pakupedzisira, tinya paFlash Kuzadza uye tarisa mashiripiti. Hapana chinogona kuva nekubudirira kupfuura kugona kupa data kubva pasaiti rako rekushanda pasina kuita bhuku remanyorero.

Ini ndiri Outreach Mutevedzeri kuCentriq- iyo yekutarisira imba iyo inoratidzwa / yakanyorwa mumaresitoreti seNTT, Iyi Imba Yekare, Real Estate Zuva Nezuva, Brit + Co, nevamwe. PaCentriq, ndinoshanda nechikwata chedu chemukati kugadzira SEO-yakagadziriswa zvirimo nezvekugadziriswa kwemba, décor yemumba, kuchengetedzwa kwemba, nezvimwe.

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

Mike Richards, Gorofu Einstein: kugara uchidzidza kweazvino kudzokorora

Ini ndashandisa  MS Excel   apo kunyora zvakakosha bhizinesi ruzivo uye imwe tsumo yandinorarama nayo ndichiita chokwadi chekuti ndinozvichengetedza ndakagadziriswa neyekupedzisira zvinyorwa uye mapfupi sekhibhodi neyefomisi mapfupi ayo asina kungomhanyisa basa rangu asi akandikurudzirawo. kuramba uchidzidza. Iyi tsika yakagadzira 'inogara ichidzidza' mindset yakandiita kuti ndikurudzirwe kukura uye kuva nekubudirira

Ini zita rangu ndinonzi Mike uye ini ndiri gorofu anofarira uye muvambi weGorufu Einstein, bhurogu kwandinogovana nepo mhinduro yangu pane zvese zvine hukama negorofu!

Shayne Sherman, TechLoris: shandisa data rekunzwisisa

Zano rangu rakanakisa, zvisinei, rakapusa: * Shandisa data rekunzwisisa! Ndinoziva, ndoziva, iwe unofanirwa kunge uri kupfuura izvo, handizvo? Ndiri kureva kuti unogona kuve nechokwadi chekuti unoperetera mazita nemazvo, handiti? Teerera, zvinongotora imwe nguva yekushandisa maawa uchiedza kufunga kuti sei mashizha ako nested ekuverenga akangoerekana aputswa obva aziva kuti inyaya yekuti iwe unoisa dhiisheni isiriyo kwauri kuti uone kukosha kwe data data.

Ndave ndichishandisa Excel kwemakore. Mune mamwe matanho andaimboita, paive nejoko rekuti chero basa randakapihwa (kusanganisira kuraira masikati kana kugadzira zvirongwa zvekufamba) ndaigona kuita zvirinani neExcel. Nokutendeseka, ini pamwe ndaigona.

Polly Kay, Chirungu Mapofu: unganidza data kubva kune kumwe kunobva

Kushandisa Excel Macros kugadzirisa nguva-yakakura uye kudzokorora mabasa ave ari chaiwo mutambo-unochinja, uye pamwe chinhu chimwe chete chakanyatso gadzirisa maererano nekuti Excel yakafambisa sei basa rangu.

Kubatanidza data kubva kune zvimwe zviwanikwa neExcel mabhuku mabhuku ndechimwe chinhu chinobatsira, uye pane zvishoma zvakanyanya izvo zvisingakwanise kubatanidzwa muExcel workflow kuti ubatanidze iyo. Kamwezve, unogona kuendesa izvi zvimwe zvinhu otomatiki kuti ugone kugonesa positi data uye kuongorora.

Kungo simudza mubvunzo kuti utore masheji usati wagadzira chirevo kunopa mukati-kudzikira ruzivo rwunogona kuzivisa analytics uye sarudzo sarudzo, uye inoita kuti iwe ugone kuratidza uye kuyambuka-tarisa ese ako akasiyana siyana mamwe mafomu ezvemukati zvakare.

Polly ane makore anopfuura gumi eruzivo semutevedzeri wekushambadzira weadhijitari uye maneja mukuru wekushambadzira, anoshanda akasiyana siyana evatengi kubva kumaSME kusvika kumakambani makuru epasi rose nemazita emhuri.

Reuben Yonatan, GetVoIP: shandisa HLOOKUP uye VLOOKUP

Pandakanga ndichitanga kudzidza Excel, ini ndinorangarira kuti iyo HLOOKUP uye VLOOKUP chaizvo yakavhura zvinhu zvakawanda zvinoshamisa zvandaisamboziva kuti iwe unogona kuita neExcel.

SaMukuru, ini ndichiri kushandisa izvo mabasa kuvaka chaizvo mapepa akasarudzika ayo anodhonza mu data kubva kune mamwe ma tabhera mukati mekuparadzira, iro rine simba kune data ratinogadziridza nguva nenguva.

Gintaras Steponkus, Guid Guides: gadzirira maChati uye maGirafu eese mapepa ekuparadzira

Kuva Manager weProjekti, ndinofanira kushandisa kudarika zuva nezuva. Ini ndinofanirwa kugara ndichiona nezve tani yedhata uye kuiongorora zuva nezuva kuwedzera kukosha kwekambani. Ndawana Excel sechinhu chakasimba chishandiso mune izvi.

Ini ndinofanirwa kugadzirira mishumo zuva nezuva. Nguva zhinji ini ndinofanirwa kutaura kune yekare maspredishithi. Inova iri basa rinotyisa kuti ripfuure rese data. Nekudaro, ini ndinogadzira girafu uye machati edatha anodiwa, ayo andinogona kuburitsa mune mamwe mafomu zvakare sePDP. Zvinondibatsira kunyora zvakawanikwa muchimono. Izvo zvinondipa kukurumidza kutarisa kwekuti nhamba pane pamapepa ekuparadzira anoenderana sei nemumwe. Ichi chiitiko chinova chinobata mabasa ekukurumidzira uko ini ndine shoma nguva yekugadzirira mishumo. Nekudaro, iyo mamiriro ekuti iwe une data rese seyakanangana neExcel mirawo.

Zita rangu ndinonzi Gintaras Steponkus uye ndiri weSocial Media Marketer kuSolidguides. Solid Guides ipurojekiti yakagadzirwa nechikwata chevanofarira kuti vatsvage kutsvaga nekunyora ongororo. Isu tinoda kwazvo nezveInternet, uye tinoziva kuti inzvimbo huru yakatakura nezvakawanda zvekunyepedzera neruzivo rusina basa. Isu takagadzira maSolid Guides ekuita kuti internet ive nzvimbo yakachengeteka yevatengi, uye nekuti tinoda kutsvaga nekuzivisa.

Aqsa Tabassam, InsideTechWorld.com: shandisa masimba pivots uye DAX mabasa

Ndiri kushandisa  MS Excel   nguva dzose kuongororwa, kubika uye kuchengeta data .. Ndinofanira kuita mushumo vhiki yega yega yezvose zviratidziro, kushambadzira uye traffic analytics kune vanoisa mari uye nevamwe vanogoverana venhau yangu webhusaiti venhau.

Excel plumbing inogona kuwedzera chikamu chekubereka nemazhinji folds. Excel plumbing inotevera nzira mbiri dzinogona kukwidza chigadzirwa chako, imwe ndiyo yakakosha nzira yekudyara uye imwe ndiyo yepamusoro yekupomba zano. Mune chirongwa chekugadzira, yakawanda yenguva yacho inoshandiswa mukutsvaga mutsva ruzivo uye kuenderera mberi nekuvandudza mishumo. Iyo inodzokororwa maitiro umo iwe urikuvandudza dhata yemishumo panzvimbo yekuichengeta.

Muchiitiko chedanho repamberi, iwe unoshandisa simba pivot kuti uwedzere kubereka kwako. Pano, iwe unowana akawanda zvakanakira. Chekutanga, kugona kubata mafaera kunowedzera. Bhirionari ezvikamu pachikamu uye mamirioni ematafura pabhuku rebasa anogona kuchengetwa. NeChipiri, nekushandisa hukama nehukama muPower Pivot Model, mabhuku ebasa anowanikwa pamwe chete uye chinongedzo chinosimbiswa pakati pematafura.

Yetatu, kuverenga kwako kwakakura kunoitwa nyore nyore kuburikidza nemabasa eAFX. Nekudaro, yega yega basa rakabatana nemagetsi pivot iri kuita kuti kuongorora, kukuru kuongorora uye kuburitsa basa kuve nyore.

Ini zita rangu ndiAqsa Tabassam, mukadzi webhizinesi, Co-Muvambi uye Mugadziri-mukuru-we InsideTechWorld. InsideTechWorld inovavarira kuburitsa ikozvino yazvino tekinoroji & yekutanga nhau, zviitiko zvevezvenhau, uye zviitiko zvinokatyamadza kune avo anoverenga pasi rese ..

Firipi Weiss, PhilipWeiss.org: auto zadza mafomula uchishandisa kiyi yekubheka

Kunyangwe ndaivenga kudzidza Excel, ndeimwe yeaya maticha anodiwa atinogona kushandisa kune akawanda maficha ebasa redu uye nehupenyu hwezuva nezuva (bhajeti, nezvimwewo).

Heino yakanaka toni yekuchengetedza nguva neExcel formula, iyo vanhu vazhinji vanowanzo kunetseka nayo. Saka zvauri kuda kuita kushandisa iyo tabhu kiyi, iyo inoita kuti uzvidimbu-sarudza mafomula. Nenzira iyi haufanire kutambisa nguva yekuzvinyora muzere nguva imwe neimwe. Paunotanga kuizadza iyo, iyo shamba ichave yakarongedza rondedzero yemazano kubva kuExcel. Ipapo zvese zvaunofanirwa kuita ndiko kufambisa museve wako kiyi kumusoro kana pasi kuti usarure formula yako, warova pinda uite.

Kana paine dambudziko nechero fomula, unogona kukurumidza kuibvisa nekusarudza fomati yacho ichirova F2. Ipapo iwe unogona kutenderera kuburikidza nezvikamu zvefomula nokubata chinja uye kupinza museve wekuruboshwe. F9 inoratidza kuverenga kwekupedzisira kwefomula, mushure meizvozvo iwe unogona kurova Esc kuchengetedza formula kana kupinda kuti uchengetedze kukosha.

Mushure mekuziva iyo 9 kusvika ku5 hupenyu hwakanga husiri kwaari, Firipo akasiya basa rake muindasitiri yekufambisa ndege uye akasarudza kufamba-famba nyika nenzira yake. Parizvino, iye ari pakati pe NYC neCambodia, iye izere-nguva yedigital nomad uye muvambi webhuku rake rekufamba, PhilipWeiss.org.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo