Chimodzi mwazinthu zosangalatsa kwambiri mu pulogalamu ya Microsoft Excess Excorl ndikupeza yankho. Nthawi yomweyo, ziyenera kudziwika kuti chida ichi sichingafotokozedwe kwambiri pakati pa ogwiritsa ntchito mu ntchito iyi. Ndipo pachabe. Kupatula apo, izi, pogwiritsa ntchito deta yoyamba, pozimitsidwa, imapeza yankho labwino kwambiri kuchokera ku zonse zomwe zilipo. Tiyeni tiwone momwe mungagwiritsire ntchito yankho la yankho mu Microsoft Excel.
Yambitsani ntchito
Mutha kufunafuna nthawi yayitali pa riboni, pomwe yankho limapezeka, koma osapeza chida ichi. Mwachidule, kuti muyambitse izi, muyenera kuzipeza mu pulogalamuyi.
Pofuna kuyambitsa kusaka mayankho mu Microsoft Excel 2010, ndipo pambuyo pake, pitani ku "fayilo" tabu. Kwa 2007, muyenera dinani batani la Microsoft ku Office pakona yakumanzere kwa zenera. Pazenera lomwe limatsegula gawo la "magawo".
Zosankha zenera, dinani pa "zipsinjo". Pambuyo posintha, pansi pazenera, patsogolo pa gawo lowongolera, sankhani "excel kuwonjezera" pamutu, ndikudina batani "Pitani".
Zenera limatsegulidwa ndi zisudzo. Tinaikapo chofupika motsutsana ndi mayina a owonjezera - "Yankho Yothetsa Yankho". Dinani pa batani la "OK".
Pambuyo pake, batani kuti muyambe njira yosakira idzaonekere pa tepi yapamwamba mu tabu ya data.
Kukonzekera patebulo
Tsopano, titayambitsa ntchitoyi, tiyeni tiwone momwe zimagwirira ntchito. Ndiosavuta kugonjera chitsanzo chapadera. Chifukwa chake, tili ndi gome la olemba ntchito ya Enterprise. Tiyenera kuwerengera mphotho ya wogwira ntchito aliyense, yemwe ndi malipiro omwe amawonetsedwa pamtundu wina, ku zokongoletsa zina. Nthawi yomweyo, ndalama zonse zomwe zimaperekedwa chifukwa cha mphotho ndi ma ruble 30000. Selo yomwe ndalamazi zilipo ndi dzina la chandamale, chifukwa cholinga chathu ndikusankha chiwerengerochi.
Kuchulukitsa komwe kumagwiritsidwa ntchito kuwerengetsa kuchuluka kwa mphothoyo, tiyenera kuwerengetsa pogwiritsa ntchito chisankho. Selo yomwe ilipo imatchedwa wofunidwa.
Chovala chofufumitsa komanso chofunidwa chiyenera kuphatikizidwa ndi wina ndi mnzake pogwiritsa ntchito formula. Pankhani yathu, mawonekedwewa ali mu maselo ozungulira, ndipo ali ndi mawonekedwe awa: "= C10 * $ g $ 3 ndi adilesi yonse ya cell yomwe mukufuna, ndi" C10 "- The kuchuluka kwa malipiro omwe ndalamazo kumawerengeredwa antchito a Enterprise.
Thamangani Chida Choyenera
Pambuyo patebulopo imakonzedwa kukhala mu "deta", dinani batani la "Yankho", lomwe limapezeka pa tepi mu "chidule" chida.
Khomo la parament limatsegulidwa pomwe iyenera kuwonjezeredwa. Mu "kukweza chandamale" gawo, muyenera kulowa adilesi ya cell yandamale, pomwe ndalama zonse za antchito onse zidzapezeka. Izi zitha kuchitika kapena kusindikizidwa ndi magwiridwe apakati panu, kapena kudina batani la batani lomwe lili kumanzere kwa gawo la deta.
Pambuyo pake, zenera la paramu lidzafika, ndipo mutha kusankha khungu lomwe mukufuna. Kenako, muyenera kukanikiza batani lomweli kumanzere kwa mawonekedwe omwe ali ndi deta yomwe idalowetsanso zenera.
Pansi pawindo ndi adilesi ya cell yandamale, muyenera kukhazikitsa magawo a zinthu zomwe zidzakhalamo. Izi zitha kukhala zochepa, kapena mtengo wake. Kwa ife, idzakhala njira yomaliza. Chifukwa chake, timasinthiratu ku "Mtengo", ndi m'munda kumanzere kwake, monga momwe tikukumbukirira, ndiye kuchuluka kwa zomwe zimapanga ndalama zonse za ogwira ntchito bizinesi.
Pansipa pali njira yosinthira gawo la foni ". Apa mukufunika kutchula adilesi ya foni yomwe mukufuna, pomwe, monga tikukumbukira, pali zokwanira, kuchulukitsa kwa malipiro akuluakulu kudzawerengeredwa mphotho. Adilesiyi ikhoza kuperekedwanso njira zomwezo monga momwe tidachitira ndi khungu lomwe likuchokera.
Mu "malinga ndi zoperewera", mutha kukhazikitsa malire ena pazidziwitso, mwachitsanzo, zogwirizana ndi ziwerengero kapena zosatsutsa. Kuti muchite izi, dinani batani la "Onjezani".
Pambuyo pake, zenera lowonjezera la onjezerani litseguka. Mu "cholumikizira kwa gawo la" timalembetsa maselo a maselo omwe amagwirizana ndi zomwe zimakhazikitsidwa. Kwa ife, iyi ndiye khungu lomwe lingafune ndi zogwirizana. Kenako, ikani chizindikiro chomwe akufuna: "Zocheperako kapena zofanana", "Zowonjezera kapena zofanana M'malo mwathu, tisankhe chikwangwani kapena chofananira "kuti mupange zolimba. Momwemonso, gawo la "lemekezani", lingalirani nambala 0. Ngati tikufuna kusinthitsa choletsa china, ndiye kuti tadina batani lowonjezerapo. Mosakayikira, kanikizani batani la "OK" kuti musunge zomwe simumayambira.
Monga tikuwona, zitachitika izi, zoletsedwa zimawonekera m'munda woyenera wa njira yosakira. Komanso, gwiritsani ntchito zosinthika, mutha kukhazikitsa cheke pafupi ndi gawo lolingana pansipa. Ndikofunikira kuti patsamba akhale pano samatsutsana ndi amene mudalembetsedwa pazolephera, apo ayi, kusamvana kumachitika.
Zikhazikiko zowonjezera zitha kukhazikitsidwa podina batani la "magawo".
Apa mutha kukhazikitsa kulondola kwa kuletsa ndi malire a yankho. Mukakhala kuti deta yomwe ikufunidwa imalowetsedwa, dinani batani la "Ok". Koma, kwa ife, simuyenera kusintha magawo awa.
Pambuyo makonda onse akhazikitsidwa, dinani pa batani "Pezani".
Kenako, pulogalamu ya Excel mu maselo imawerengedwa. Nthawi yomweyo ndi kutulutsidwa kwa zotsatira, zenera limatseguka momwe mungasungire yankho lomwe lapezeka, kapena kubwezeretsa mfundo zomwe mwakonzanso mwa kusinthana. Mosasamala kanthu za njira yosankhidwa, kukhazikitsa cheke bokosilo "kubwerera ku bokosi la dialog", mutha kupitanso ku njira zosakira. Pambuyo pamabokosi ndi zotupa zakhazikitsidwa, dinani batani la "OK".
Ngati pali chifukwa chilichonse chofufuzira sichikukukhutitsani, kapena mukawerengera pulogalamuyi, pulogalamuyi imapereka cholakwika, kenako, tikubwerera pamwambapa, m'bokosi la dialog. Konzanso zonse zomwe mudalowa, chifukwa ndizotheka kwina kolakwika. Ngati cholakwika sichinapezeke, kenako pitani "Sankhani njira yosinthira". Zimapereka mwayi wosankha njira imodzi yowerengera: "Sakani ntchito yopanda ntchito yopanda ntchito", Mwa kusala, njira yoyamba imagwiritsidwa ntchito. Timayesetsa kuthetsa ntchitoyi, kusankha njira ina iliyonse. Pankhani ya kulephera, timabwereza kuyesa kugwiritsa ntchito njira yomaliza. Zochita za Algorithm ndi zomwezo zomwe tidafotokoza pamwambapa.
Monga mukuwonera, ntchito kusaka njira yothetsera vuto ndi chida chofunikira chomwe, ndikugwiritsa ntchito moyenera, kumatha kupulumutsa nthawi yomwe wogwiritsa ntchitoyo amawerengera. Tsoka ilo, sikuti aliyense amene amadziwa za kukhalapo kwake, osanenanso ufulu wogwira ntchito ndi izi. Mu chinthu china, chida ichi chimafanana ndi ntchitoyo "kusankha kwa parameter ...", koma nthawi yomweyo, ali ndi kusiyana kwakukulu ndi izo.