Posts

Showing posts from 2021

Activity 9 Pivot Table and Pivot Chart

Image
 2. 3.  4. 5. 6 and 7. 8.  Create Pivot Chart with Sales Person and Order Amount  9.  Create Pivot Chart with Region , Sales Person and Order Amount 10.  Create Pivot Chart with Sales Person, Month and Order Amount

Exercise 8 Chart, Sorting, filter, Subtotals

Image
 1. Print screen Sort the data by ID A-Z smallest-highest. 2. Print screen Sort by Name A-Z sort ascending 3. Print screen Sort by Loan Amount Z-A Sort Highest to Lowest. 4. Print screen Filter by item type– Sporting goods. 5. Print screen - Create and customize a book sales chart.

Exercise 6: Budget and Supplies & Customer Invoices

Image
 Budget and Supplies Budget and Supplies with Formula Customer and Invoices Customer Invoices with formula

4th Week MS Word Manual

Image
 1. Header and Footer 2. Cover Page 3. Table of Contents 4. Table of Figures

Exercise 2 Mail Merge

Image
MAIL MERGE PORTFOLIO  INSERT MERGE FIELD: RECIPIENTS LIST FINISHED AND MERGED