LIVING IN IT ERA

 CREATING A MAIL MERGE VOICE OVER AND PRESENTATION BY GWYNETH TRIXIE C. TUBIO BMMA01

  BONUS ACTIVITY SUBSCRIBE COMMENT LIKE

PIVOT TABLES HOW TO CREATE A PIVOT TABLE 1. Select Cells that you want to create a pivot table from. 2. Select Insert > Pivot Table 3. Choose the data you want to analyze, Select a table or range. 4. In table/range, Verify the cell range. 5. Choose where you want to place the Pivot Table, New worksheet or Existing Worksheet. 6. Select Ok.   PIVOT CHARTS HOW TO CREAT PIVOT TABLE TO CHARTS 1. Select a cell in your table. 2. Select PivotTable Tools > Analyze > PivotChart  3. Select a chart 4. Select OK.

 

EXERCISE 8: CHART, SORTING, FILTER, SUBTOTALS 1. Printscreen Sort the data by ID A-Z smallest-highest 2. Printscreen Sort  by Name A-Z sort Ascending 3. Printscreen Sort by Loan Amount Z-A sort Highest to lowest 4. Printscreen Filter by Item Type-Sporting Goods 5. Print Screen Create and Customize a book sales chart

  Steps To Complete this Spreadsheet: Budget and Format Supplies: 1. Create the Company Logo and Title. 2. Format as Table, choose your color. 3. Format price per unit and line total. 4.Compute Line total and total supplies. Total Monthly Bills too. 5. Change the tab or sheet name and table color. 6. Printscreen the Final Output.                Steps to Complete this Spreadsheet: Customer Invoice 1. Create the Company logo and title. 2. Format as table, choose your color. 3. Format price per unit and line total. 4.Compute. 5. Change the tab or sheet name to customer invoice and change the tab color. 6. Printscreen the final output.