LIVING IN IT ERA

  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