Posts

Showing posts from 2021

Exercise 9: Pivot Table

Image
  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.

Bonus point

Image
  Orquina, Caye Renee G. BEEd 1st Yr. Link:https://www.youtube.com/watch?v=X3XH6To35Yc

Exercise 7: Payroll

Image
  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

Image
  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

Exercise 6: budget and supplies & customer Invoice (Orquina, Caye Renee G.) BEEd 1st Yr.

Image
 
Image
Orquina, Caye Renee G.  BEEd 1st Yr.                                                                 https://www.youtube.com/watch?v=6yfJ1olR9zg

Exercise 4-5 MS WORD MANUAL (Orquina, Caye Renee G.)

Image
                                                   

Exercise 3 Smart Art (Orquina, Caye Renee G.) BEEd 1st Yr.

Image
 

Excercise 2 Mail Merge (Orquina, Caye Renee G.)

Image
Alexandro Paolo Tueres President Alegria Business Associates Manila   Subject: Business Event Invitation Dear Mr. Tueres: It would be a pleasure to have you at the Anniversary Celebration of Orquina Rural Banking, Inc. The event will be held on the 10th of September 2021 at 245 DaangHari, Cavite City, at 8:00 p.m. As one of Orquina Rural Banking, Inc.’s esteemed business associates, it would be our honor to have your presence at this auspicious event. It is also a golden chance to thank you and Mr. Bien Nalog for the splendid business partnership that both companies have enjoyed over the past seven years. The event will have all the jazz with extraordinary performances by various artists, followed by an eclectic and lavish dinner. We would be grateful if you could get your families along with you, to have a gala time. I do hope that you will be able to confirm your attendance to this invitation on or before 5th September by email at reneelious2001@gmail.com or b...