Kuwerengera popanda mafomu

Zachidziwikire, mafomula mu Excel akhala ndipo akhalabe chimodzi mwazida zazikulu, koma nthawi zina, mwachangu, zingakhale zosavuta kuwerengera popanda iwo. Pali njira zingapo zochitira izi.

Matani apadera

Tiyerekeze kuti tili ndi ma cell angapo omwe ali ndi ndalama zambiri:

Ndikofunikira kuwasandutsa "ma ruble chikwi", mwachitsanzo, gawani nambala iliyonse ndi 1000. Mukhoza, ndithudi, kupita njira yachikale ndikupanga tebulo lina la kukula komweko pafupi ndi izo, kumene mungathe kulemba mafomu ofanana (= B2 / 1000, etc.)

Ndipo zitha kukhala zosavuta:

1. Lowetsani 1000 mu cell iliyonse yaulere
2. Koperani selo ili pa bolodi (Ctrl + C kapena dinani kumanja - Koperani)
3. Sankhani ma cell onse okhala ndi ndalama zambiri, dinani pomwepa ndikusankha Matani apadera (Paste Special) kapena dinani Ctrl + Alt + V.
4. Sankhani kuchokera ku menyu yankhani Makhalidwe (Makhalidwe) и Kugawa (Gawani): 

Excel sidzayika 1000 m'maselo onse osankhidwa m'malo mwa masamu (monga momwe zimakhalira ndi phala wamba), koma idzagawaniza ndalama zonse ndi mtengo wa buffer (1000), zomwe ndi zofunika:

Ndizosavuta kuwona kuti izi ndizothandiza kwambiri:

• Werengetsani misonkho iliyonse ndi mitengo yokhazikika (VAT, msonkho wa ndalama zomwe munthu amapeza ...), mwachitsanzo, onjezani msonkho kundalama zomwe zilipo kapena kuchotsa.

• Sinthani ma cell okhala ndi ndalama zambiri kukhala "chikwi", "miliyoni" ngakhalenso "mabiliyoni"

• Sinthani masinthidwe okhala ndi ndalama kukhala ndalama zina pamtengowo

• Sinthani madeti onse m'nthawi yamasiku akale kapena am'tsogolo ndi masiku a kalendala (osati a bizinesi!).

Malo omenyera

Zotsika mtengo, zansangala komanso zodziwika kwa ambiri. Maselo angapo akasankhidwa, mawonekedwe a bar amawonetsa zambiri pa iwo:

Chodziwika bwino ndichakuti mukadina kumanja pazophatikiza izi, mutha kusankha zomwe mungawonetse:

Zosavuta komanso zosavuta.

Calculator

Kiyibodi yanga ili ndi batani lodzipatulira lapadera lofikira mwachangu pa chowerengera chokhazikika cha Windows - chinthu chothandiza kwambiri pantchito. Ngati kiyibodi yanu ilibe, mutha kupanga ina mu Excel. Za ichi:

1. Dinani kumanja pa Quick Access Toolbar pakona yakumanzere yakumanzere ndikusankha Kusintha Mwamakonda Mwamakonda Anu Mwachangu Mwachangu (Sinthani Mwamakonda Anu Chida Chofikira Mwachangu):



2. Pazenera lomwe limatsegulidwa, sankhani Magulu onse (Malamulo Onse) mu dropdown pamwamba m'malo Malamulo omwe amagwiritsidwa ntchito pafupipafupi (Malamulo Odziwika).
3. Pezani batani Calculator(Chiwerengero) ndi kuwonjezera pa gulu pogwiritsa ntchito batani kuwonjezera (Onjezani):