Tabbas, ƙididdiga a cikin Excel sun kasance kuma sun kasance ɗaya daga cikin manyan kayan aikin, amma wani lokacin, cikin sauri, zai zama mafi dacewa don yin lissafin ba tare da su ba. Akwai hanyoyi da yawa don aiwatar da wannan.
Manna na musamman
A ce muna da kewayon sel masu yawan kuɗi:
Wajibi ne a juya su zuwa "dubu dubu rubles", watau raba kowane lamba ta 1000. Kuna iya, ba shakka, tafi hanyar gargajiya kuma ku yi wani tebur mai girman girman kusa da shi, inda za ku iya rubuta hanyoyin da suka dace (= B2/1000, da dai sauransu)
Kuma yana iya zama mai sauƙi:
- Shigar da 1000 a kowace tantanin halitta kyauta
- Kwafi wannan tantanin halitta zuwa allon allo (Ctrl + C ko danna dama - Copy)
- Zaɓi duk sel masu yawan kuɗi, danna-dama akan su kuma zaɓi Manna na musamman (Mana Musamman) ko danna Ctrl + Alt + V.
- Zaɓi daga menu na mahallin Da dabi'u (Dabi'u) и Don raba (Raba):
Excel ba zai saka 1000 a cikin duk sel da aka zaɓa ba maimakon jimla (kamar yadda zai kasance tare da manna na yau da kullun), amma zai raba duk jimlar ta ƙimar da ke cikin buffer (1000), wanda shine abin da ake buƙata:
Yana da sauƙi a ga cewa wannan ya dace sosai:
Ƙididdige kowane haraji tare da ƙayyadaddun ƙima (VAT, harajin shiga na mutum…), watau ƙara haraji zuwa adadin da ake da shi ko cire shi.
Juya sel masu yawan kuɗi zuwa "dubu", "miliyan" har ma da "biliyan"
Canza jeri tare da adadin kuɗi zuwa wasu agogo a ƙimar kuɗi
Canja duk kwanakin da ke cikin kewayon zuwa baya ko gaba ta ƙayyadadden adadin kalanda (ba kasuwanci ba!) kwanaki.
Matsayin matsayi
Mai arha, mai fara'a kuma sananne ga mutane da yawa. Lokacin da aka zaɓi kewayon sel, ma'aunin matsayi yana nuna bayanai akan su:
Mafi qarancin sanannun shine idan kun danna-dama akan waɗannan jimlolin, zaku iya zaɓar waɗanne fasalulluka don nunawa:
Mai sauƙi kuma mai dacewa.
kalkuleta
Maɓallin madannai na yana da maɓallin keɓe daban don saurin isa ga daidaitaccen lissafin Windows - abu ne mai matuƙar amfani a wurin aiki. Idan maballin ku ba shi da ɗaya, to kuna iya ƙirƙirar madadin a cikin Excel. Don wannan:
- Danna-dama akan Toolbar Samun Sauri a saman kusurwar hagu kuma zaɓi Keɓance madaidaicin Toolbar Samun Sauri (Kaddamar da Toolbar Samun Sauri):
- A cikin taga da yake buɗewa, zaɓi Duk ƙungiyoyi (Dukkan Dokokin) a saman zazzagewar maimakon Umurnin da ake amfani da su akai-akai (Shaharar Dokokin).
- Nemo maɓallin kalkuleta(Kalkuleta) kuma ƙara shi zuwa panel ta amfani da maɓallin Add (Ƙara):
- Haɗa ginshiƙan bayanai tare da saka na musamman
- Yadda za a ƙirƙiri tsarin al'ada na ku (dubun rubles da sauran waɗanda ba daidai ba)
- Yadda ake juya layuka zuwa ginshiƙai da akasin haka