La Maƙunsar bayanai ta zama mahimmin kayan aiki kuma mai ban sha'awa ga mutane da yawa. Gone shine sanannen rahoton asusun da aka yi tare da keken rubutu ko tare da Notepad kuma aka ƙara shi tare da ƙididdigar Casio.
Wannan tsohuwar ruwa ce wacce Excel da ayyukanta suka mamaye ta. Amma abin takaici ba kowa ne yake iko ko sanin cikakken damar wannan shirin Microsoft ba kuma ajiyar lokacin da wannan na iya samarwa yayin aiki tare da wannan shirin.
A wannan yanayin mun yi amfani da shi Excel 2013 don tunani. Sigar da mutane da yawa sun riga sun yi kuma ta dace da sigar nan gaba, don haka ana iya amfani da dabaru a cikin Excel 2013 da kuma daga baya.
Saka kwanan wata a cikin Sel.
A cikin Excel 2013 za mu iya saka kwanan wata cikin hanzari ta amfani da hadewar madannan masu zuwa: "CTRL +;". Wannan maɓallin maɓallin yana ba ku damar shigar da kwanan wata wanda tsarin yake a cikin tantanin halitta kuma yana yin hakan a tsaye. Haɗin amfani idan muka yi amfani da maƙunsar bayanan a matsayin rahoto ko takarda.
Yi sauri tafiya tsakanin littattafai da zanen gado
Hanya mafi kyau don haɓaka sararin samaniya da asusun a cikin Excel shine amfani da takardu daban-daban da littattafai waɗanda za mu iya ƙirƙirawa. Wannan matsala ce idan muna son matsawa tsakanin su da sauri, aƙalla yana da matsala idan muka kwatanta shi da samun duk bayanan a cikin takardar ɗaya.
Wata 'yar dabara da za a matsa tsakanin littattafai ita ce a yi amfani da madannin "CTRL + TAB" kuma idan muna son matsawa tsakanin zanen gado dole ne mu yi amfani da waɗannan abubuwan masu haɗuwa: CTRL + PAGE DOWN, don ciyar da shafin da CTRL + PAGE RE don komawa baya .
Dataoye bayanan tantanin halitta a cikin Excel 2013
Ya zama ruwan dare gama gari yi fom da gwaji wanda ya danganta da abin da muka rubuta, wasu ƙwayoyin suna cikewa ta atomatik ko cike da wasu bayanai. Wannan yana da matukar amfani amma wani lokacin ayi shi muna buƙatar ɓoye wasu dabaru ko bayanai.
Aƙalla don kada mai amfani ya gyaggyara shi ko don kawai kayan kwalliya. Don samun wannan, da farko dole ne mu zabi tantanin halitta tare da bayanan da muke son boyewa. Sannan zamu danna tare da maɓallin dama kuma zamu tafi zuwa ga «Format Cells».
Zaɓi rukunin al'ada kuma rubuta ";;;" Mun adana shi kuma yanzu babu alamar kuskure ko bayanai masu kama da haka zasu bayyana, zai bayyana ne kawai kamar kwayar ba ta da komai.
ƙarshe
Akwai ƙarin dabaru a cikin Excel 2013 don sa mu zama masu tasiri. Zai yiwu akwai daruruwa ko dubbai, amma a cikin kowane hali, waɗannan ukun suna da ban sha'awa, aƙalla ga waɗanda suke aiki tare da Excel a cikin ƙwarewar sana'a. Shin, ba ku tunani?