Exercise 11: Video Tutorial (Orquina, Caye Renee G.) BEEd 1st Yr.
Orquina, Caye Renee G. BEEd 1st Yr. Exercise 11-The Video Tutorial Link: https://www.youtube.com/watch?v=hkHfeLiE7Co
Posts
Exercise 10: Lesson Presentation
Orquina, Caye Renee G. BEEd 1st Yr. Video link: https://youtu.be/-rogV19UpEk
Exercise 9: Pivot Table
Orquina Caye Renee G. BEEd 1st Yr. 2. Data information 3. What is the amount sold by each salesperson? Select Region and Order Amount. 4. In the rows area , remove Region with Salesperson and Order Amount. 5. Add Region with Salesperson , Month on Column and Order Amount to Columns area. 6. Change the number format of cells to Currency. 7. The result of No. 6 8. Pivot Chart with Salesperson and Order Amount. 9. Pivot Chart with Region, Salesperson and Order Amount. 10. Pivot Chart of Month, Salesperson and Order Amount.
Exercise 7: Payroll
Orquina, Caye Renee G. BEEd 1st Yr. Payroll The Output Data Formulas on Cells-1 Formulas on Cells-2
Exercise 8: Charts , Sorting, Filter, Subtotals
Orquina, Caye Renee G. BEEd 1st Yr. PrintScreen sort by ID PrintScreen sort by Name PrintScreen sort by Loan PrintScreen- subtotal-Item type-Loan amount PrintScreen-filter-Itemtype-Sporting Goods Creating and customizing chart Book Sales Chart-Final Output
