Tsarin sharadi a MS Excel - da kadan-san gefen rare falle

The iyali na ofishin kayayyakin na Microsoft Corporation a karkashin Excel sunan ne jerin iko falle sarrafawa ne Popular duka biyu ga talakawa sirri kwamfuta masu amfani da kuma kwararru kunkuntar profile ga wanda wannan iko sa na software kayan aikin yi dogon zama ba makawa kayan aiki a cikin aikin na ilmin lissafi, graphics , da sauran ilimin kididdiga data.

Wannan software samfurin ne wani bayani fasahar tsara don sana'a aiki na manyan data sets. Excel ba ka damar sanya aiki da kai kuma a fili formalize da aiwatar da wani m iri-iri kama computations, kazalika da yin sarrafa lamba da kuma matani bayanai a babban kundin.

Alal misali, yin azumi, daidai da ingantaccen bincike na kudi, samun kudin shiga haraji, da dai sauransu Key siffofin da wannan iko software ya dade da aka kyau karatu da dukkan masu ruwa da tsaki. Amma Excel yana da yawa na asirin da dabaru da aka sani kawai zuwa kunkuntar da'irar kwararru. Daya daga cikin wadannan m jam'iyyun ne Tsarin sharadi. Wannan aiki na samar da wani sosai fadi da kewayon m fasali.

A kayan aiki, da ake kira da "Tsarin sharadi" ya sa ya yiwu a cimma musamman mai ban sha'awa da sakamakon da wani mai ban mamaki na gani kwarewa] in data sets. The yiwuwar yin amfani da wannan aikin don magance matsaloli daban-daban da kuma suke da matukar bambancin. Tsarin sharadi damar gabatar da wani wasu cell format bisa ga abinda ke ciki a lokacin da qaddara yanayi. Wannan irin Tsarin ne dace da kuma musamman lucid a nazarin manyan data sets.

Tsarin sharadi zuwa Excel, ba tare da ƙari, shi ne mai iko kayan aiki da cewa yana buɗewa unprecedented yiwuwa ga aiki tare da maƙunsar kuma bada izinin a sabo ne look at cikin tsararru na bushe Figures. Musamman m wannan sabon abu damar duba a dukan gabatar takardunku. Tasari Formats yi shi da sauki a samu daban-daban ban, distracting daga sauran jerin data. Muhimman abubuwa ne ma ba bace daga Analyst ta view. Wannan zai iya zama musamman da amfani a cikin aiki da ilimin kididdiga data. Tsarin sharadi a Excel 2007 yana da wasu ban sha'awa ci-gaba fasali, kamar launi gradients, daban-daban shading data Lines, musamman icons cewa an kara zuwa Kwayoyin kuma ba ka damar da sauri gano sadarwa tsakanin daban-daban Manuniya.

Amfani Tsarin sharadi ne ma sauki - kamar 'yan linzamin kwamfuta akafi. Bari mu ce ka ƙirƙiri wani tebur a wasu Kwayoyin cewa yana dauke da wasu sigogi. Kana bukatar ka canza cell cika launuka daidai da canji na lamba data dabi'u kunshe ne a cikin su. Alal misali, idan tantanin halitta na dauke da wani mummunan lambar, za ta atomatik cika launi ne ja, kuma idan m - kore.

Don yin wannan, kawai bukatar amfani da "Format" menu, danna abu a cikin abin da "Tsarin sharadi". A wannan cell, wanda wajibi ne a kafa da ake so format, shi ya kamata a alama. A cikin maganganu akwatin "Tsarin sharadi" dole ne ka saka da yanayin karkashin abin da cell da kuma canza launi da ku ƙoshi. Tare da button "Format" na wannan maganganu akwatin don bayyana so bayyanar.

Idan kana bukatar ka canza da Tsarin na daya cell zuwa wani, dangane da bayanai, sa'an nan wajibi ne a koma ga "dabara" na hagu drop-saukar list akwatin matukar Formats. A nisa tsakanin sel ba kome. Da dabara kuma iya zama wani: ko da yake lissafi na ilimin kididdiga muhimmanci, ko da yake da darajar depreciation da kadarori. Alal misali, idan kana son ka, a lokacin da cell A1 ne mahara na hudu, da takamaiman cell ko mahara Kwayoyin samu wani rawaya cika, sa'an nan, a matsayin yanayin, shigar da wadannan dabara: "= Mod (A1, 4) = 0." Sa'an nan amfani da "Format" button to saka da ake so cika launi. Bugu da ari, ta kwashe da pasting Tsarin da aka canjawa wuri zuwa da ake so cell ko kewayon.