Kana iwe uchida kuti Excel iratidze marekodhi chete anosangana nemamwe maitiro, saka shandisa sefa. Nokuda kweizvi:
- Dzvanya pane chero sero mune dataset.
- Pa Advanced tabo Data (Data) tinya firita (Sefa). Miseve inoonekwa mumisoro yembiru.
- Dzvanya pamuseve uri padyo nemusoro nyika.
- Dzvanya pamutsetse Sarudza zvose (Sarudza Zvese) kudzima mabhokisi ekutarisa ese, wozotarisa bhokisi USA.
- dzvanya OK.Result: Excel inongoratidza US data data.
- Dzvanya pamuseve uri padyo nemusoro kota.
- Dzvanya pamutsetse Sarudza zvose (Sarudza Zvese) kudzima mabhokisi ekutarisa ese, wozotarisa bhokisi Qtr 4.
- dzvanya OK.Result: Excel inongoratidza kota yechina data yekutengesa US.
- Kukanzura kusefa, pane tab Data (Data) tinya zvakachena (zvakajeka). Kuti ubvise sefa zvachose, kureva kubvisa miseve, dzvanya bhatani zvakare firita (Sefa).