Question & Answar About Excel

(1) Name wise balance?
Sorted by name, data-subtotal-name-sum-bill.

(2) Sales of particulars?
Sorted by particular data -subtotal particular sum unit.

(3) Date wise report?
Sorted by date, data -subtotal date- sum- bill.

(4) Every particular sale to every person?
Data sort by particular then by name.
Data- subtotal name- sum –unit- bill.

(5) Date wise sales of every person?
Data sorted by name then by date.
Data- subtotal date- sum- bill.

(6) Report of every date/persons/particulars?
Date sorted by particular/person/date.
Data- subtotal-date –sum- unit- bill.

(7) One item report of every person?
Sorted by name.
Auto filter by one particular.
Data- subtotal- name- sum –unit, bill.

(8) One person report of every item?
Sorted by particular.
Auto filter by name.
Data -subtotal –particular- sum –unit, bill

(9) One date report of one particular of every person?
Sorted by name, data auto filter date, particulars.
Data –subtotal- name- sum -unit -bill.

(10) Top ten unit report of one particular?
Data auto filters by particulars.
Units top ten.

(11) Minimum unit sales of every particular?
Sorted by particular
Data -subtotal –particulars- minimum- unit.