Mataki na Mataki na Excel na Mataki na Excel

Amfani da Excel ba ta da wuya kamar yadda yake gani

Excel shi ne kayan aiki mai kwakwalwa na lantarki (aka software ) wanda aka yi amfani dashi don adanawa, shiryawa da sarrafawa bayanai.

Ana adana bayanai a cikin kwayoyin halitta wanda ake tsarawa a cikin jerin jerin ginshiƙai da layuka a cikin takarda. Wannan tarin ginshiƙai da layuka ana kiransa tebur. Tables suna amfani da rubutun a saman jere da ƙasa gefen hagu na tebur don gano bayanan da aka adana a cikin tebur.

Excel na iya yin lissafi a kan bayanan ta amfani da matakan . Kuma don taimakawa wajen sauƙaƙe da kuma karanta bayanan a cikin takardun aiki, Excel yana da siffofin fasalin da za a iya amfani dasu ga kwayoyin halitta, zuwa layuka da ginshiƙai, ko zuwa dukkanin bayanan bayanai.

Tun da kowane takarda a cikin sassan Excel ya ƙunshi biliyoyin kwayoyin halitta ta takardun aiki, kowace tantanin halitta tana da adireshin da aka sani da tantanin halitta don a iya rubuta shi a cikin shafuka, sigogi, da sauran siffofin shirin.

Wannan koyaswar yana rufe matakan da suka cancanta don ƙirƙirar da kuma tsara fasali mai mahimmanci wanda ke dauke da teburin bayanai, dabarar, da tsarawa a cikin hoton da ke sama.

Batutuwa da suka hada da wannan koyo shine:

• Shigar da bayanai zuwa cikin tebur
• Ƙara ginshiƙai ginshiƙai na takarda
• Ƙara kwanan wata da kuma sunan da aka keɓa zuwa takardar aiki
• Ƙara ramin dabara
• Ƙara ƙididdigar albashin bas
• Kashe samfurin tare da Fill Handle
• Ƙara tsarin tsarawa zuwa bayanai
• Ƙara tsarin tsarawa

01 na 08

Fara Bayanan Data

Shigar da bayanai a cikin fayilolin aikin aiki shi ne koyaushe matakai uku.

Waɗannan matakai sune:

1. Danna kan tantanin halitta inda kake so bayanan.
2. Rubuta bayanai cikin tantanin halitta.
3. Latsa maɓallin shigarwa akan keyboard ko danna kan wani tantanin halitta tare da linzamin kwamfuta.

Kamar yadda aka ambata, kowane tantanin halitta a cikin takardun aiki yana gano ta wurin adireshi ko tunani na sel , wanda ya ƙunshi harafin shafi da lambar jigon da ke tsakanin wuri a cell.

A lokacin da aka rubuta rikodin tantanin halitta, an rubuta harafin shafi na farko da bin layi - kamar A5, C3, ko D9.

Lokacin shigar da bayanai don wannan koyaswar, yana da muhimmanci a shigar da bayanai a cikin takardun aikin rubutu daidai. Formulas shiga cikin matakai na gaba amfani da tantanin halitta tantance bayanai da aka shigar yanzu.

Shigar da Bayanan Tutorial

1. Don bi wannan koyawa, yi amfani da bayanan salula na bayanan da aka gani a cikin hoton da ke sama don shigar da dukan bayanan a cikin takarda na Excel.

02 na 08

Ginshiƙan girma a Excel

Ta hanyar tsoho, yawancin cell din yana ba da izini kawai samfurin takwas na kowane shigarwar bayanai da za a nuna a gabanin wannan bayanan ya shiga cikin cell ta gaba zuwa dama.

Idan tantanin halitta ko kwayoyin zuwa dama suna da kullun, ana shigar da bayanan da aka shigar a cikin takardun aiki, kamar yadda aka gani tare da takardun aikin ƙididdigewa na Ƙididdigar ma'aikata ya shiga cikin tantanin halitta A1.

Idan tantanin halitta zuwa dama ya ƙunshi bayanai duk da haka, abinda ke ciki na tantanin halitta na farko shi ne ƙaddara zuwa haruffa takwas na farko.

Yawancin jinsunan bayanan da aka shigar a mataki na baya, kamar lakabi Deduction Rate: shiga cikin tantanin halitta B3 da Thompson A. shiga cikin sakon A8 suna ƙaddamar saboda ƙwayoyin zuwa dama suna ƙunshe da bayanai.

Don gyara wannan matsala domin bayanin ya kasance cikakke ne, ana buƙatar ginshiƙan dake dauke da wannan bayanan.

Kamar yadda duk shirye-shiryen Microsoft, akwai hanyoyi masu yawa na ginshiƙan fadada . Matakan da ke ƙasa suna rufe yadda za a bude ginshiƙai ta amfani da linzamin kwamfuta.

Ƙara ginshiƙai na Kayan Ɗauki na Ɗaukaka

1. Sanya linzamin linzamin kwamfuta akan layin tsakanin ginshiƙai A da B a cikin maɓallin shafi .
2. Maɓin zai canza zuwa arrow mai mahimmanci.
3. Danna ka riƙe maɓallin linzamin hagu na hagu kuma ja gefen maɓallin dama zuwa dama don buƙatar shafi na A har sai dukkanin shigarwa Thompson A. yana bayyane.
4. Fadada sauran ginshiƙai don nuna bayanai kamar yadda ake bukata.

Ƙididdigar Shafuka da Takaddun Shafi

Tun lokacin da aka yi amfani da takardun aiki na tsawon lokaci idan aka kwatanta da sauran lakabi a cikin sashi na A, idan an kara wannan shafi don nuna duk take a cikin salula A1, aikin aiki ba kawai yana da kyau ba, amma zai zama da wuya a yi amfani da takardun aiki saboda da rata tsakanin labels a gefen hagu da sauran ginshiƙan bayanai.

Kamar yadda babu sauran shigarwar a jere na 1, ba daidai ba ne kawai barin lakabi kamar shi - karuwa a cikin kwayoyin zuwa dama. A madadin, Excel yana da siffar da ake kira haɗin da kuma cibiyar wanda za'a yi amfani dashi a cikin mataki na gaba don shigar da take a kan layin bayanai.

03 na 08

Ƙara Ranar da Ranar da aka sanya

Kwanan wata Kayan aiki Aiki

Yana da al'ada don ƙara kwanan wata zuwa ɗakunan rubutu - sau da yawa don nuna lokacin da aka sabunta takardar.

Excel yana da ayyuka na kwanan wata wanda zai sa ya sauƙi shigar da kwanan wata a cikin takardun aiki.

Ayyukan ayyuka kawai suna ƙaddara a cikin Excel don yin sauƙi don kammala ayyukan da aka yi - kamar ƙara kwanan wata zuwa wata takarda.

TODAY aiki yana da sauƙin amfani saboda ba shi da wata hujja - wanda shine bayanan da ake buƙatar kawowa zuwa aikin domin ya yi aiki.

Ayyukan TODAY yana ɗaya daga cikin ayyukan da ke cikin Excel, wanda ke nufin yana ɗaukaka kanta duk lokacin da aka sake dawowa - wanda shine mafi yawa lokacin da aka buɗe aikin aiki.

Ƙara Ranar tare da aikin yau

Matakan da ke ƙasa za su ƙara aikin yau a C2 C2 na takardun aiki.

1. Danna kan cell C2 don sa shi tantanin halitta mai aiki
2. Danna kan Rubutun shafin shafin rubutun
3. Danna kan Zaɓan rana da lokaci a kan rubutun don buɗe jerin ayyukan kwanan wata
4. Danna kan Ayyukan yau don ɗaukar maganganun aikin
5. Danna Ya yi a cikin akwatin maganganu don shigar da aikin kuma komawa cikin takardun aiki
6. Ya kamata a kara kwanan wata zuwa cell C2

Ganin ###### Alamomin maimakon ranar

Idan jeri na alamar alamar shuɗi ya bayyana a cell C2 maimakon kwanan wata bayan an ƙara aikin yau a wannan tantanin halitta, saboda tantanin halitta ba shi da isasshen isa don nuna bayanan da aka tsara.

Kamar yadda aka ambata a baya, lambobin da ba a lissafa ko bayanan rubutu bazuwa zuwa kullun kullun zuwa dama idan yana da yawa ga cell. Bayanan da aka tsara a matsayin takamaiman nau'in lambar - irin su waje, kwanakin, ko lokaci, duk da haka, kada ka zubar da shi zuwa cell din ta gaba idan sun fi fadi fiye da tantanin halitta inda suke. Maimakon haka, sun nuna kuskuren ######.

Don gyara matsalar, shimfiɗa shafi na C ta amfani da hanyar da aka bayyana a matakin farko na koyawa.

Ƙara wani Rangi mai suna

An kirkiro wani zaɓi mai suna lokacin da aka baiwa sifa daya ko fiye don bada lakabi don daidaitawa. Za'a iya amfani da jeri na sunayen a maimakon maye gurbin tantancewar tantanin halitta idan aka yi amfani da su a cikin ayyuka, dabarar, da kuma sigogi.

Hanyar da ta fi dacewa don ƙirƙirar jeri sunaye shine a yi amfani da akwatin suna a cikin kusurwar hagu na takardar aiki a sama da lambobi.

A cikin wannan koyo, za a ba da sunan kudi ga cell C6 don gano raguwa da aka yi amfani da albashin ma'aikaci. Za a yi amfani da jerin sunayen da aka yi amfani da su a cikin hanyar cirewa wanda za a kara zuwa kwayoyin C6 zuwa C9 na takardun aiki.

1. Zaɓi cell C6 a cikin takardun aiki
2. Rubuta "kudi" (ba a faɗi) a cikin Akwatin Akwati ba kuma latsa maɓallin Shigar da ke keyboard
3. Cell C6 yanzu tana da sunan "kudi"

Za a yi amfani da wannan sunan don sauƙaƙa ƙirƙirar ƙididdigar Deductions a mataki na gaba na koyawa.

04 na 08

Shigar da Formula Deduction Formula

Shirye-shiryen Excel Formulas

Takaddun Excel ba ka damar yin lissafi akan bayanan adadin da aka shiga cikin takardun aiki .

Ana iya amfani da takardun Excel don ƙididdigar lamba, kamar ƙari ko raguwa, da ƙididdigar ƙididdigar, kamar gano ƙimar ɗaliban a kan gwajin gwaji, da lissafin biyan kuɗi.

• Formulas a cikin Excel kullum fara da daidai ãyã ( = )
• Alamar daidai ita ce taɓa shiga cikin tantanin halitta inda kake son amsawa ta bayyana
• An kammala tsari ta latsa maɓallin Shigar da ke keyboard

Amfani da Siffofin Siffar a cikin Formulas

Hanyar da ta dace don samar da samfurori a cikin Excel ya haɗa da shigar da samfurin lissafin cikin fayilolin aikin aiki sa'annan amfani da bayanan salula don bayanai a cikin tsari, maimakon bayanai kanta.

Babban amfani da wannan tsari shi ne, idan daga baya ya zama dole don canza bayanai , yana da sauƙi na maye gurbin bayanai a cikin kwayoyin maimakon sake rubutawa da wannan tsari.

Sakamakon dabarar za ta sabunta ta atomatik sau ɗaya bayanan canje-canjen.

Amfani da Rangi Masu Magana a Formulas

Ƙarin madaurin ƙwayoyin salula shine don amfani da jeri na mai suna - irin su layin da aka sanya a cikin mataki na baya.

A cikin wata mahimmanci, aikin mai suna mai suna kamar ƙirar salula amma ana amfani da shi kullum don dabi'u waɗanda aka yi amfani da su sau da yawa a cikin maɓamai daban-daban - irin su raguwa don biyan kuɗi ko amfanin lafiyar jiki, haraji, ko kimiyya m - yayin da ƙididdigar kwayoyin halitta sun fi dacewa a cikin matakan da ke nuna zuwa bayanan bayanai sau ɗaya kawai.

A matakan da ke ƙasa, ana amfani da nassoshin tantancewar salula da kuma mai suna masu amfani da su wajen samar da samfurori.

Shigar da Formula Deduction Formula

Daftarin farko da aka gina a cikin ƙwayoyin C6 zai ninka Rajistar Maɗaukaki na ma'aikaci B. Smith ta hanyar raguwa a cell C3.

Kayan da aka gama a cikin cell C6 zai kasance:

= B6 * kudi

Ta amfani da Ƙaddamarwa don Shigar da Formula

Ko da yake yana yiwuwa a rubuta irin wannan samfurin a cikin kwayar halitta C6 kuma ana samun amsar daidai, ya fi dacewa don amfani da ma'ana don ƙara ƙididdigar sel zuwa ƙididdiga don rage girman yiwuwar kurakurai da aka halicce ta ta yin rubutu a cikin maɓallin ƙwayar salula.

Bayyanawa ya shafi danna kan tantanin halitta dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara mahimmin tantancewa ta sel ko mai suna zuwa ga wannan tsari.

1. Danna kan wayar C6 don sanya shi tantanin aiki
2. Rubuta alamar daidai ( = ) zuwa cikin cell C6 don fara wannan tsari
3. Danna b6 B6 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan alamar daidai
4. Rubuta alamar kwatankwacin ( * ) a cikin C6 cell bayan bayanan salula
5. Danna maɓallin C3 tare da maɓallin linzamin kwamfuta na ƙara don haɓaka madaidaicin mai ladabi zuwa wannan tsari
6. Latsa maɓallin shigarwa a kan keyboard don kammala tsari
7. Amsar 2747.34 ya kamata a kasance a cell C6
8. Kodayake ana nuna amsar wannan tsari a cikin cell C6, danna kan tantanin halitta zai nuna nau'in = B6 * * a cikin maɓallin tsari a sama da takardun aiki

05 na 08

Shigar da Formula na Saiti

Shigar da Formula na Saiti

An kirkiro wannan tsari a cikin cell D6 kuma yana lissafin albashi na ma'aikaci ta hanyar cirewa adadin kuɗin da aka ƙididdige a cikin ma'anar farko daga Rajistar Raho .

Sakamakon da aka gama a cell D6 zai kasance:

= B6 - C6

1. Danna kan tantanin halitta D6 don yin sautin mai aiki
2. Rubuta alamar daidai ( = ) cikin cell D6
3. Danna b6 B6 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan alamar daidai
4. Rubuta alamar m ( - ) a cikin cell D6 bayan bayanan salula
5. Danna maɓallin C6 tare da maɓallin linzamin kwamfuta zuwa wannan tantancewar salula zuwa wannan tsari
6. Latsa maɓallin shigarwa a kan keyboard don kammala tsari
7. Amsar 43,041.66 ya kamata a kasance a cell D6
8. Don ganin wannan tsari a cikin cell D6, danna kan tantanin ɗin don nuna nau'i = B6 - C6 a cikin tsari

Abubuwan Lafiyar Lafiyar Abubuwan Kulawa da Kwafi Formulas

Ya zuwa yanzu, an ƙaddamar da ƙididdigar Saiti da Namanin Sauƙi zuwa ɗayan tantanin halitta ɗaya a cikin takardun aiki - C6 da D6.

A sakamakon haka, aikin yanzu yana aiki ne kawai don ma'aikaci ɗaya - B. Smith.

Maimakon yin aiki ta lokaci-lokaci don sake juyayi kowane nau'i na sauran ma'aikatan, izini na Excel, a wasu lokuta, dabarun da za a kwafe su zuwa wasu kwayoyin.

Wadannan yanayi sun fi dacewa da amfani da takamaiman nau'in tantanin halitta - wanda aka sani da batun tantance dangi - a cikin takaddun.

Bayanin tantanin halitta da aka shigar cikin sura a cikin matakan da suka gabata sun kasance nassoshin tantancewar sel, kuma su ne ainihin irin salon tantanin halitta a cikin Excel, don yin kwashe lissafi kamar yadda ya dace sosai.

Mataki na gaba a cikin koyawa ya yi amfani da Jagoran Ƙarshe don kwafe ƙwayoyin biyu zuwa layuka da ke ƙasa don kammala labarun bayanai ga duk ma'aikata.

06 na 08

Kashe Formulas tare da cika cika

Cika Jagorar Magana

Cikakken cikaccen karamin baki ne ko square a kusurwar dama na ɓangaren mai aiki .

Maganin cika yana da amfani da dama da ya haɗa da abun ciki na cell zuwa wasu sassan . cika kwayoyin tare da jerin lambobi ko alamun rubutu, da kuma kwafin tsari.

A cikin wannan mataki na koyawa, za a yi amfani da ƙoshin da aka yi amfani da su don kwafe duka raguwa da Haɗin Kanada wanda ya kasance daga sel C6 da D6 zuwa Kwayoyin C9 da D9.

Kashe Formulas tare da cika cika

1. Gano sassa B6 da C6 a cikin takardun aiki
2. Sanya maɓallin linzamin kwamfuta a kan kusurwar baki a cikin kusurwar dama na dakin tantanin halitta D6 - maɓin zai canza zuwa alamar "
3. Danna kuma ka riƙe maɓallin linzamin hagu na hagu sannan ja jawo mai cika zuwa C9 cell
4. Saki da maɓallin linzamin kwamfuta - Kwayoyin C7 zuwa C9 ya kamata a ƙunsar sakamakon sakamakon cirewa da Kwayoyin D7 zuwa D9 da Net Salary dabara

07 na 08

Aiwatar da Magana Tsarin a Excel

Hanyoyin Shirye-shiryen Hoto na Excel

Tsarin lambobi yana nufin adadin alamomin alamomi, alamomi na ƙasa, alamomin alamomi, da sauran alamomin da zasu taimaka wajen gano irin bayanan da ke cikin kwayar halitta kuma don sauƙaƙe don karantawa.

Ƙara Alamar Girbin

1. Zaɓi cell C3 don haskaka shi
2. Danna kan shafin shafin shafin rubutun
3. Danna kan Zaɓin Janar don buɗe maɓallin Zaɓuɓɓukan Lambobi
4. A cikin menu, danna kan Zaɓin kashi don canza tsarin darajar C3 a cikin C3 daga kashi 0.06 zuwa 6%

Ƙara alama alama

1. Zaɓi Kwayoyin D6 zuwa D9 don haskaka su
2. A kan shafin shafin rubutun, danna kan Zaɓin Janar don buɗe maɓallin Zaɓuɓɓukan Lambobi
3. Danna kan Kudin a cikin menu don canja tsarin tsara dabi'u a cikin kwayoyin halitta D6 zuwa D9 zuwa waje tare da wurare biyu na decimal

08 na 08

Aiwatar da Tsarin Cell a Excel

Tsarin Sanya Sanya

Shirye-shiryen siginar yana nufin tsara zaɓuɓɓuka - kamar yin amfani da matsin lamba ga rubutu ko lambobi, canza daidaiton bayanai, ƙara iyakoki zuwa sel, ko amfani da haɗin da kuma tsakiyar cibiyar don canza bayyanar bayanan a cikin tantanin halitta.

A cikin wannan koyo, za a yi amfani da samfurori da aka ambata da aka ambata a wasu takamaimai a cikin takardun aiki don ya dace da aikin ɗimbin da aka gama a shafi na 1 na tutorial.

Ƙara Bold Format

1. Zaɓi salula A1 don haskaka shi.
2. Danna kan shafin shafin shafin rubutun .
3. Danna kan Zaɓin Tsarin Bold kamar yadda aka gano a cikin hoton da ke sama zuwa m bayanai a cell A1.
4. Maimaita jerin samfurin da ke sama don ƙarfafa bayanai a cikin kwayoyin A5 zuwa D5.

Canza Gudun Bayanan Data

Wannan matakan zai canza tsoffin hagu na hagu na kwayoyin da yawa zuwa cibiyar daidaitawa

1. Zaɓi cell C3 don haskaka shi.
2. Danna kan shafin shafin shafin rubutun.
3. Danna maɓallin alignar Cibiyar kamar yadda aka gano a cikin hoton da ke sama don tattara bayanan a C3 cell.
4. Yi maimaita matakan da ke sama zuwa cibiyar daidaitawa cikin bayanan A5 zuwa D5.

Haɗa da Cibiyar Cibiyar

Haɗa da Cibiyar zabin hada haɗin da aka zaɓa a cikin tantanin halitta guda ɗaya kuma yana ci gaba da shigar da bayanai a cikin hagu mafi yawan ƙwayoyin halitta a fadin sabon salon haɗi. Wannan mataki zai haɗa da kuma kafa maƙallin aikin aiki - Ƙididdigar Ƙididdiga ga ma'aikata ,

1. Zaɓi Kwayoyin A1 zuwa D1 don haskaka su.
2. Danna kan shafin shafin shafin rubutun.
3. Danna kan Hanya & Cibiyar kamar yadda aka gano a cikin hoton da ke sama don haɗar Kwayoyin A1 zuwa D1 kuma ya kafa take a fadin waɗannan sel.

Ƙara Ƙananan Borders zuwa Cells

Wannan mataki zai ƙara ƙananan iyakoki ga sel a dauke da bayanai a cikin layuka 1, 5, da 9

1. Zaɓi hanyar haɗin ciki A1 zuwa D1 don haskaka shi.
2. Danna kan shafin shafin shafin rubutun.
3. Danna kan gefen ƙasa kusa da Zaɓin Border kamar yadda aka gano a cikin hoton da ke sama don buɗe jerin abubuwan da ke kan iyaka.
4. Danna kan zaɓi na Bottom Border a cikin menu don ƙara iyaka zuwa kasan tantanin halitta.
5. Yi maimaita matakan da ke sama don ƙara iyakar ƙasa zuwa sassan A5 zuwa D5 kuma zuwa kwayoyin A9 zuwa D9.