Microsoft Excel kayan aiki ne masu ƙarfi waɗanda ke da halaye marasa yarda da amfani ga kowane nau'in masana'antu manya ko ƙananan. Microsoft ta haɓaka don Windows, macOS, Android da iOS yana taimakawa cikin lissafi, sarrafa bayanai, tsarawa, kiyayewa da fassara.
Tun daga 1985, ana amfani da Microsoft Excel a aikace-aikacen kwamfuta don tattarawa, tsarawa, adanawa da nazarin bayanai yadda yakamata a cikin tsarin jadawalin. Charts, dabara da sauran kayan aikin suna taimakawa cikin nazarin, sarrafawa da sarrafa duk mahimman bayanai a cikin Microsoft Excel. Ba da daɗewa ba, Microsoft Excel ya zama ɗayan mahimman bayanai da bayar da rahoto game da sarrafa software don masu amfani.
Kara karantawa:
Me zaku iya cimmawa a cikin takardar Excel? Wannan dan wasan kasar Japan yana da amsa.
20 tayi fice gajerun hanyoyin mabuɗin don ƙara yawan aiki
Ana samun yawancin gajerun hanyoyin madannin Excel ta amfani da ALT, Ctrl, Shift, Maballin aiki da Mabuɗin Window.
1. Gida
Danna maɓallin 'Home' yana dacewa mai amfani ya dawo farkon jere tare da dannawa ɗaya kawai. Hakanan ta latsa Ctrl + Home, yana motsawa zuwa farkon takardar aiki da Ctrl + End don motsawa a ƙarshen takardar aiki.
2. F2
Danna kan F2 wanda zai iya shirya kwayar aiki ta yanzu kuma ya inganta wuri sakawa a ƙarshen abubuwan da ke cikin kwayar. Maballin F2 shima yana taimakawa wajen matsar da batun sanyawa cikin Bar ɗin Fulawa. Hakanan mutum zai iya nuna yankin samfoti na bugawa akan shafin bugawa ta hanyar haɗa maɓallan Ctrl da F2.
3. F4
Danna maɓallin F4, yana maimaita umarnin ƙarshe da aka yi amfani da shi a takardar aiki na Excel. Wannan yana aiki da kusan kowane aiki, misali: tsarawa. Mutum zai iya kammala ayyuka masu tsayi cikin sauƙi ta amfani da mabuɗin F4 don sake maimaita aikin tsara fasali yadda ya dace.
4. F6
Maɓallin F6 ya zo wurin ceto, lokacin da mai amfani ya zubar da takaddar aikin kuma dole ne sau da yawa ya canza tsakanin takaddar aiki ta yanzu, aikin zuƙowa cikin aiki da sarrafawar zuƙowa ko don zaɓar wasu ayyuka daban-daban cikin sauƙi.
5. F12
F12 hanya ce ta gajeren hanya ta Microsoft Excel wacce ke taimakawa wajen adana bayanan da aka shigar akan maƙunsar bayanan. Wannan maɓallin yana kawo adanawa azaman zaɓi don fayil ɗin, mutum zai iya ajiye fayil ɗin cikin sauƙin amfani da wannan gajeren hanyar.
6. Alt
Maballin Alt yana da amfani sosai yayin da yake nuna maɓallan maɓalli ko duk sababbin gajerun hanyoyi a kan haƙurin Microsoft Excel. Lokacin da kuka danna maɓallin Alt, yana buɗe dukkan zaɓuɓɓuka kamar H don gida, P don Shafi da M don Tsarin da sauransu Kuma idan kun danna Alt + P sai Layout ɗin ya buɗe.
7. Karshen
Ana duba maɓallin inarshe a ƙasan kusurwa na maƙunsar bayanan Excel, ana amfani dashi don kunna ko kashe Yanayin Endarshen. Hakanan ana amfani da maɓallin toarshe don zaɓar umarnin ƙarshe a kan menu lokacin menu.
8. Shigar
Bayan kammala aiki ko shigarwa a cikin tantanin halitta, mai amfani zai iya zaɓar Shigar da gajerar hanya don matsawa zuwa sel na gaba. Hakanan an haɗa maballin shiga tare da maɓallai daban-daban don ƙirƙirar maɓallin gajeren maɓallin keɓaɓɓen maɓalli na musamman Kamar, Alt + Shigar za a yi amfani da shi don ƙirƙirar sabon layi a cikin wannan tantanin halitta.
9. F1
Ana amfani da gajerar hanya ta hanyar keyboard ta F1 Excel don samun ko samun Taimako na Excel. Yana buɗe zaɓi na taimako yana da akwatin bincike inda mai amfani zai iya samun taimako ta hanyar layi da layi.
10. Esc
Ana amfani da maɓallin Esc akan Microsoft Excel don samun kuɓuta ko tserewa daga wani yanayi, yana taimakawa rufe menu, ƙaramin menu, saƙo ko duk abin da ya buɗe akan maƙunsar bayanan ku tare da dannawa kawai.
11. Shift + Spacebar
Ana amfani da maɓallin Shift + Spacebar akan Microsoft Excel don zaɓar jere na musamman don aiki. Ta amfani da Shift + Space yana sa aikin ya zama mai sauƙi kamar yadda za a iya amfani da canje-canje ga duk layin a tafi ɗaya. Hakanan, don zartar da canje-canje zuwa wani shafi na musamman mutum na iya amfani da babbar hanyar gajiyar hanya mai maɓalli - Ctrl + Spacebar.
12. Ctrl + Alt + V
Ana amfani da maɓallin Ctrl + Alt V don liƙa abin da aka yanka ko wanda aka kwafa, rubutu ko ƙunshin salula a wurin da ake so a maƙunsar bayananku. Wani fasali mai ban mamaki na wannan gajerar hanya shine za'a iya liƙa abun cikin a cikin wani shirin. Hakanan mutum zai iya amfani da Ctrl + V don saka abubuwan da aka kwafa a ko'ina a cikin maƙunsar bayananku.
13. Ctrl + Shigar
Wannan gajeriyar hanyar Microsoft Excel tana taimakawa wajen cika keɓaɓɓun ƙwayoyin salula tare da abubuwan da ake so. Mutum na iya fitar da wannan tantanin tantanin halitta ta atomatik zuwa wasu zaɓaɓɓun ƙwayoyin.
14. Ctrl + F1
Wannan gajeriyar hanyar Microsoft Excel tana taimakawa wajen ɓoye kintinkiri yayin danna wannan hanyar gajeren kuma rubutun zai sake bayyana. Wannan gajeriyar hanyar tana da amfani yayin da mai amfani ya shagala a filin aikin sa.
15. Canjawa + F10
Maɓallin Shift + F10 akan Microsoft Excel yana da irin waɗannan kaddarorin na danna-dama akan linzamin kwamfuta. Wannan gajeriyar hanyar tana ba ku damar buɗe amfani, inda mai amfani zai iya amfani da maɓallan kibiya don matsar da menu kuma zaɓi zaɓin da ya dace da ake buƙata.
16. Ctrl + 5
Ana amfani da wannan gajeriyar hanyar a cikin Microsoft Excel don gama aikin ko jerin abubuwan da ake yi na mai amfani da kyau. Wannan maɓallin yana buɗe jerin abubuwan yi don mai amfani, inda mai amfani zai iya rubuta mahimmin aikin da za a yi kuma da zarar an kammala aikin a cikin tantanin halitta, duka siyarwar na iya zama yajin aiki ta latsa maɓallin Ctrl + 5.
17. Ctrl +
Ana amfani da gajeriyar hanyar Ctrl + * a cikin Microsoft Excel don kwafa ko share duk yankin da ke kusa da kwayar aiki mai aiki. Da zarar latsa wannan gajerar hanya, yana taimaka wajen zaɓar yanki na yanzu ko kewayon cikin tantanin halitta tare da cikakkun bayanai don zama kwafi ko sharewa. A cikin fasalin 2016 na Microsoft Excel sau ɗaya zai iya amfani da wannan gajeren hanyar don zaɓar duka bayanan PivotTable a cikin ingantaccen takardar aiki.
18. Ctrl + Shafin Sama & Kasa
Ana amfani da wannan gajeriyar hanyar ta Microsoft Excel a cikin hawan igiyar ruwa mai sauƙi da sauri a cikin dukkan takardun aiki masu kyau. Mai amfani zai iya yin hawan saƙo daga ɗayan takardar aiki zuwa wani ta kawai latsa Ctrl + Page UP, yana motsawa zuwa takaddar da ta gabata kuma Ctrl + Page ƙasa yana motsawa zuwa takardar aiki ta gaba. Wannan gajerar hanya tana da sauki kuma tana adana lokaci.
19. Ctrl + Kibiya Makullin
Ana amfani da maɓallan Ctrl + Arrow a cikin Microsoft Excel don matsar da sel ɗaya zuwa sama, ƙasa, hagu, ko dama a cikin takardar aiki mai kyau. Wannan gajeriyar hanya tana taimakawa wajen gungurar shafuka da sauri kamar Ctrl + Down Arrow Key taimako don matsawa zuwa layin karshe akan takardar aiki yayin da Ctrl + UP Arrow Key ke motsa mai amfani zuwa layin farko a cikin takardar aiki kuma Maɓallan dama da Hagu suna ba da irin wannan aikin.
20. Ctrl + Shift + [Maɓallin da ake Bukata]
Maballin Ctrl + Shift a cikin Microsoft Excel na taimaka maka ka saka ayyuka daban-daban a cikin takardar aikin ka ba tare da wata matsala ba. Kuna iya saka waɗannan ayyukan tare da maɓallin Ctrl + Shift don yin aikin cikin sauƙi.
Ctrl + Shift + = zai buɗe zaɓin ƙwayoyin sakawa
Ctrl + Shift + W zai nade rubutun
Ctrl + Shift + 7 zai zaɓi iyakar
Ctrl + Shift + # zai yi amfani da tsarin kwanan wata tare da rana, wata da shekara
Ctrl + Shift +; zai saka lokaci na yanzu
Kammalawa:
Microsoft Excel na da matukar amfani ga ɗalibai da sauran ƙwararrun masu aiki don yin sigogi don gabatarwa a cikin aikin ilimi / rayuwar yau da kullun, tsara bayanai na manyan kundin da kuma fassara abubuwan da ke faruwa a nan gaba. Microsoft Excel shirin yafi amfani dashi don dalilai na kuɗi da lissafin kuɗi. Hakanan, ana amfani da waɗannan shirye-shiryen a cikin sashen Ma'aikatar Humanan Adam don sauƙaƙewa, tsarawa da bincika bayanan ma'aikaci da rikodin yadda ya kamata. Mafi kyawun fasalin Microsoft Excel shine za'a iya samunta da amfani dashi tare da na'urori da yawa kamar Allunan, wayoyin komai da ruwanka da dai sauransu.
Ina fatan wannan labarin ya taimaka muku don haɓaka ƙimar ku a cikin Microsoft Excel.
Kara karantawa:
Yadda za a Yi amfani da Facebook daga Maƙunsar Bayani ta Microsoft Microsoft
