Activity 9: Video Tutorial Lesson

 

https://youtu.be/rviPVHXpgJM

Exercise 9 Pivot Table and Pivot Chart

 Creating Pivot Table and Pivot Chart

A. Create Pivot Chart with Sales Person and Order Amount 

B. Create Pivot Chart with Region , Sales Person and Order Amount

C. Create Pivot Chart with Sales Person, Month and Order Amount

Bonus Points

 

https://www.youtube.com/watch?v=D9T5g9pSqUU&list=PLN2vGEJFAtTelSzQSh0mRUJP_pgWlhQRc&index=6

Creating Graphic Design

Illustration

Exercise 8: Functions - Sum, Average, IF, V-Lookup

 PAYROLL

Figure 1. Payroll original

Figure 2. Part 1 show formula

Figure 3. Part 2 show formula

Exercise 7: Charts, Subtotal, Filter and Sorting

 Chart, Sorting, Filter, Subtotals

Figure 1. Original Content

Figure 2. ID lowest to highest

Figure 3. Customer Name ascending

Figure 4. Amount Loan highest to lowest

Figure 5. Filter by Item Type

Figure 6. Sales Chart

Activity 4: Text Design

Greeting Cards

 Happy Birthday Card

Halloween Card

Christmas Card

Valentine's Card

Congratulations Card

Exercise 6: Compute Sales Invoice and Inventory and Supplies

Excel: Supplies and Budget

Figure 1. Without showing the Formula.

Figure 2. With showing the Formula.

Excel: Customer Invoice

Figure 3. Without showing the Formula.

Figure 4. With showing the Formula.

Reaction to Advertisement Video

 

https://www.youtube.com/watch?=J76Ihk5wuXI&list=PLN2vGEJFAtTfzxRgnq0bx9MaGr3WYQVxQ&index=2&t=102s

Project/Activity 3: Animation

https://youtu.be/WUWdYE4GJ0Y

Exercise 4: Creating, Header, Footer, Cover Page, Footer, and Bibliography

   MS Word Manual

 Inserting Header and Footer

1. Go to Insert and Add Header. Choose whatever Header you desire. 

Since the style of Header I chose which the even page is different from odd page. This is what I did.

2. Put title on your Header, then go to Format to add Shape Fill onto it. Choose your desired color.

3. Create your desired logo.

4. Next, go to Insert then click the Footer. Then design it whatever you like.

Inserting Cover Page

5. After that, go to Insert and find the Cover Page then create your desired Cover page.

        

Applying Headings 1, 2 and 3

6. Go to Home then find Heading 1 and apply it to all the bigger title on your document. You can also modify the Font Style and Font Size on what you desire.

7. Still in Home, but now find the Heading   2. Again, you can also modify Font Styles and Font Size on what you desire.

Do it again in Heading 3.

        Inserting Table of Contents

8. Next, go to References and find the Table of Contents. Click the Automatic Table of Contents.

Applying Image Caption

9. Now go to References and find the Insert Caption. Add caption to the figure then click OK.

Inserting List of Figure

10. After naming all the figures, still in References find the Insert List of Figures.

Adding Footnote

11. Add Footnote by clicking the Insert Footnote, still in References.

Creating and Applying Citation

12. Now we'll proceed in Citation. Still in References then fine the Insert Citation. Fill up the blanks according to what is needed then click OK. Create your list of citations.

Inserting Bibliography

13. Finally, find the Bibliography then click it to apply the list of citations you create. Then you're done!