Tsallake zuwa abun ciki
WPS OfficeKwarewar Pivot table

Fayil na asali da za a iya gyarawa

Kwarewar Pivot table

Kware a raba tallace-tallace ta yankin da samfur tare da saitin bayanan misali mai tsabta. Yi amfani da starter a cikin WPS Spreadsheets don gina Pivot table kuma bincika sakamakon tare da taƙaitaccen dabara.

Sauke WPS OfficeDon Windows · Manhajar WPS Office

An haɗa asalin XLSX starter. Gyara a cikin WPS Spreadsheets; samammun fasali na ci gaba ya bambanta ta nau'i da dandamali.

Duba yadda yake aiki
Kwarewar Pivot table — Duban farko na fayil ɗin misali na Turanci
Duban farko na fayil ɗin misali na Turanci
Wuri mai farawa da za a iya gyarawaJadawalin bayanai

Game da wannan tsari

Juya layukan ma'amala zuwa taƙaitaccen bayani mai amfani

Yi amfani da WPS Spreadsheets don yin aiki a kan fayil ɗin, duba bayanan kuma ajiye sakamakon a cikin tsari mai dacewa.

01

Tebur tushe mai tsabta

Kowane layi yana wakiltar tallace-tallace ɗaya tare da yankin, samfur da adadi.

02

Sakamakon da za ka iya bincika

Kwatanta jimillar da aka raba tare da misalin SUMIFS da aka bayar.

03

Kwarewar bayar da rahoto da za a iya amfani da ita

Canza filayen raba ba tare da canza bayanan tushe ba.

Tsarin fayiloli
XLSXPDF
Gyara a WPS Office. Ajiye kwafi don rabawa.

Amfani da WPS Office

Yadda za a fara

Shigar da WPS Office, sannan bi waɗannan matakan a cikin manhajar. Wannan shafin yanar gizon baya gyara ko jujjuya fayilolin ku.

Kwarewar Pivot table — Duban farko na fayil ɗin misali na Turanci
Duban farko na fayil ɗin misali na Turanci

Binciki layukan tusheBincika manyan lakabi, adadi da tsarin rikodin-daya-a-kowane-layi.

Fayil na asali da za a iya gyarawa

Sauke fayil mai farawa

Asalin littafin aikin horar da pivot table tare da bayanan misali da umarnin gyara.

XLSXZazzage XLSX starter

Wannan samfurin da za a iya gyarawa yana cikin Turanci. Buɗe shi a WPS Office kuma maye gurbin abubuwan misali da naka. Fayil ɗin farawa yana da banbanci da saukar da manhajar WPS.

WPS Office

Takardu, ma'ajiyar bayanai, gabatarwa da PDF

Yi aiki tare da fayilolin ofishin ku na yau da kullum a cikin manhaja guda. Riƙe fayil mai tushe wanda za a iya gyarawa kuma zaɓi tsarin rabawa da masu sauraron ku ke buƙata.

Bincika wannan ikon na WPS
WWPS WriterTakardu da daftari
SWPS SpreadsheetsLamba da tsare-tsare
PWPS PresentationHotunan nuni da labarai
PDFPDFBita da rabawa

Taimako da bayani

Tambayoyin da ake yawan yi

Wannan shafin yana sauke WPS Office. Siffofi suna bambanta ta dandamali, sigar da shiri.

Shin an riga an haɗa da asalin Pivot table?

Fayil ɗin ya ƙunshi bayanan tushe da taƙaitaccen bayani na dabara. Ƙirƙiri PivotTable na asali a cikin WPS ta amfani da umarnin don haka zaka iya zaɓar naka filayen.

Me ke cikin farkon kwarewar Pivot table?

Asalin misalin XLSX mai gyarawa tare da ID na tallace-tallace, yankin, samfur, raka'a, farashin raka'a usd da umarnin ayyuka. Sabunta PivotTable bayan gyara tushensa. Taƙaitaccen dabara da aka bayar ba cache na pivot na asali ba ne.

A ina zan gyara littafin aikin?

Zazzage starter kuma buɗe shi a cikin WPS Spreadsheets. Gyaran yana faruwa ne a cikin app; wannan shafin ba ya sarrafa ko loda littafin aikinka. Ajiye kwafin XLSX don ci gaba da aiki, ko fitar da ra'ayin da aka bita azaman PDF.

Me ke faruwa lokacin da na zaɓi maɓallin saukewa?

A Windows ko macOS, WPS tana fara saukar da manhajar. A Linux, kwafi umarnin shigarwa ko zaɓi kunshin hannu. A iPhone, iPad, Android ko Chromebook, ci gaba zuwa kantin sayar da manhaja mai dacewa. Wannan shafin baya loda, jujjuya ko gyara fayilolin ku.

Fara da WPS Office

Sauke WPS Office

Sauke WPS Office

Samu WPS Office don Windows.
An haɗa asalin XLSX starter. Gyara a cikin WPS Spreadsheets; samammun fasali na ci gaba ya bambanta ta nau'i da dandamali.