Fyuluta yapamwamba kwambiri

Anonim

Fyuluta yapamwamba kwambiri

Mwinanso, ogwiritsa ntchito onse omwe amagwira ntchito nthawi zonse ndi Microsoft Excel amadziwa za ntchito yothandizayi monga kusefa kwa data. Koma si aliyense amene akudziwa kuti pali zinthu zomwe zimapatsidwa kuchokera ku chida ichi. Tiyeni tiwone zomwe zimatha kupanga zosefera zapamwamba za Microsoft ndi momwe mungagwiritsire ntchito.

Kugwiritsa ntchito kusefa kawiri

Sikokwanira kuti muyambitse zosefera zapamwamba - mufunika kumaliza mkhalidwe wina. Kenako, tikambirana za machitidwe azomwe ziyenera kutengedwa.

Gawo 1: Kupanga tebulo ndi malo ogona

Kukhazikitsa zosefera zapamwamba, choyamba mwa zonse zomwe muyenera kupanga tebulo lowonjezera ndi zomwe mwasankha. Chipewa chake ndi chofanana ndi chinthu chachikulu chomwe ife, chodziwikiratu. Mwachitsanzo, tinalimbikira tebulo lowonjezera pamwamba pa maselo ake ndikupaka maselo ake mu lalanje. Ngakhale ndizotheka kuziyika pamalo abwino komanso pa pepala lina.

Chowonjezera cha Card Cap mu Microsoft Excel

Tsopano lembani zambiri zomwe mukufuna kuziganiza patebulo lalikulu. Pankhani yathu, kuchokera pamndandanda wamalipiro omwe amaperekedwa ndi antchito, tinaganiza zosankha zofunikira za anthu akuluakulu achimuna a Julayi 25, 2016.

Zidziwitso zowonjezera pa Microsoft Excel

Gawo 2: Kuyambira sefa

Pakangopanga tebulo lowonjezerapo, mutha kupita ku chisewerero chowonjezereka.

  1. Pitani ku "data" ndi nthiti mu "mtundu ndi zosefera" chida, dinani ".
  2. Kuyambitsa kusefa kawiri ku Microsoft Excel

  3. Zenera lofananira limatseguka. Monga mukuwonera, pali mitundu iwiri yogwiritsa ntchito chida ichi: "Sankhani mndandandawo" ndi "kopetsani zotsatira kukhala malo ena." Poyamba, ku Fsefee udzapangidwa mwachindunji patebulo loyambirira, ndipo wachiwiri - padera mu maselo omwe mumadzinenera nokha.
  4. Ma squed osefera pafupipafupi mu Microsoft Excel

  5. M'munda wa "gwero" wotsogola, muyenera kutchula maselo osiyanasiyana a tebulo la gwero. Izi zitha kuchitika pamanja ndikuyendetsedwa ndi maofesi kuchokera pa kiyibodi, kapena kuwunikira maselo osiyanasiyana omwe amagwiritsidwa ntchito pogwiritsa ntchito mbewa. Mu gawo la "Expment", muyenera kulowa m'mitundu ya tebulo lowonjezera ndi chingwe chomwe chili ndi mikhalidwe. Nthawi yomweyo, ziyenera kudziwidwa kuti palibe mizere yopanda tanthauzo m'njira iyi, apo ayi palibe chomwe chingagwire ntchito. Zikhazikiko zikamalizidwa, dinani Chabwino.
  6. Kukhazikitsa ma cell owonjezera mu Microsoft Excel

  7. Pagerosi yoyambira, ndi matanthawuzo omwe tidaganiza zosefera.
  8. Kuchulukitsa kumabweretsa zotsatira za Microsoft Excel

  9. Ngati njira yasankhidwa ndi zotsatira zake kupita kumalo ena, m'malo "gawo lazomwe zimachitika munthawi ya" mundawo, fotokozerani mitundu yomwe deta yomwe yasefedwa idzawonetsedwa. Mutha kutchula khungu limodzi. Pankhaniyi, idzakhala khungu lamanzere la tebulo latsopano. Tsimikizani kusankha ndi batani la "Ok".
  10. Fyuluta yapamwamba yokhala ndi mitundu yotulutsa zotsatira zabwino mu Microsoft Excel

  11. Pambuyo pa izi, tebulo la gwero lidasinthidwa, ndipo zomwe zasefedwa zimawonetsedwa patebulo lina.
  12. Kutulutsa kwa zosefera zochulukitsa kumabweretsa microsoft Excel

  13. Kuti mubwezeretse zosefera mukamagwiritsa ntchito malo omwe mndandandawo pamalopo, pa tepi mu bokosi la "Mtundu wa Zida, dinani batani la" Chotsani ".
  14. Sungani zosefera zowonjezera mu Microsoft Excel

Chifukwa chake, zitha kunenedwa kuti zosefera Zazikulu zimapereka zinthu zambiri kuposa zomwe zimasefa zinthu. Koma ndizosatheka kudziwa kuti ntchitoyi ndi chida ichi sichabwino kwambiri kuposa ndi fyuluta wamba.

Werengani zambiri