Pivot Table and Pivot Chart By: Aurora Romasanta Creating data for the Pivot Table Creating a Pivot Table: Choosing a field: Choosing a Pivot Chart: Chosen Pivot Chart: The Final Output: ~ ~ ~ ~ ~
"Payroll" By: Aurora Romasanta Basic Salary: SSS, PHIL HEALTH, PAG IBIG, AND TAX RESULTS AND FORMULAS Total Deductions and Net Pay: Number of Employees: Average Data: Highest and Lowest Values: Final Output: ~~~~~
Exercise 8 Chart, sorting, filter, subtotals By: Aurora Romasanta Sort by ID A-Z Smallest-highest: Sort by Name: Sort by Loan Amount: Filtering: Filtering by Item type (Painting Materials): Creating a booksale chart: Final booksale chart: ~~~~~