Kupanga mu Excel

Mu Excel, mutha kusanja deta ndi mizati imodzi kapena zingapo. Kusanja kumatha kuchitika mokwera kapena kutsika.

Mzere umodzi

Kuti musanthule deta ndi gawo limodzi, chitani izi:

  1. Sankhani selo iliyonse yomwe mukufuna kusanja.
  2. Kuti musanjidwe mu dongosolo lokwera, tsegulani tabu Deta (Deta) ndikudina pazithunzi NDI I (THE).Kupanga mu ExcelChotsatira chomaliza:Kupanga mu Excel

Zindikirani: Kuti musankhe motsika, dinani chizindikirocho ЯA (KWA).

Zigawo zingapo

Kuti musanthule deta potengera magawo angapo, tsatirani izi:

  1. Pa Advanced tabu Deta (Deta) dinani Kusankha (Sungani).Kupanga mu ExcelBokosi la zokambirana lidzatsegulidwa Kusankha (Sungani).
  2. Mu mndandanda wotsitsa Sanjani potengera (Sankhani ndi) sankhani gawo loti musinthe (muchitsanzo chathu ndi Dzina lomaliza).Kupanga mu Excel
  3. atolankhani Onjezani mlingo (Onjezani Level).
  4. Mu mndandanda wotsitsa Kenako ndi (Ndiye ndi) sankhani gawo lotsatira kuti musinthe (timasankha Sales).Kupanga mu Excel
  5. Press OK.Zotsatira: Zolemba zimasanjidwa poyambira Dzina lomaliza, kenako ndi gawo Sales.Kupanga mu Excel

Siyani Mumakonda