Posts

Showing posts from November, 2021

Exercise 8: Pivot Table an Pivot Chart

Image
  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: ~ ~ ~ ~ ~

Midterm Bonus Points

Image
  Midterm Bonus Points By: Aurora Romasanta Like and Subscribe: Comment: Video Link: https://youtu.be/D9T5g9pSqUU ~ ~ ~ ~ ~ 

Exercise 7: Payroll

Image
  "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 6: Chart, sorting, filter, subtotals

Image
  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: ~~~~~