Table Manipulation


In this topic, we will look at Table Manipulation.


Steps:

  1. Design Tab:

     

    This tab will only display when a table is active.

     

    Step 1
  2. Properties Group:

    Step 2
  3. Properties Group:

     

    Table Name: Give the Table a name if you plan to use it in future formulas.

    Step 3
  4. Name this table: "Table2".

    Step 4
  5. Resize Table: 

     

    Add / Remove columns and rows.

    Step 5
  6. Select OK or Cancel.  In this example, click cancel.

    Step 6
  7. Tools Group:

    Step 7
  8. Summarize with PivotTable:

     

    Pivotal tables make it easy to arrange and summarize complicated data and drill down on details.

    Step 8
  9. Select OK or cancel.  In this example, click cancel.

    Step 9
  10. Remove Duplicates:

     

    Removes duplicate rows from a sheet.

    Step 10
  11. You can specify which columns should be checked for duplicate information.

     

    Select OK or Cancel.  In this example, click cancel.

    Step 11
  12. Convert to Range:

     

    You can convert the table into a normal range of cells.   All of the data is preserved.

    Step 12
  13. Select Yes or No.  In this example, click No.

    Step 13
  14. Table Style Options:

    Step 14
  15. Header Row:  A header row formats the top row of the table specially.

    Step 15
  16. Total Row:  is a row at the end of a table which displays totals for each column.

    Step 16
  17. Banded Rows:   When you display banded rows, even rows are formatted differently from odd rows.  This banding can make tables easier to read.

    Step 17
  18. First Column:   Displays special formatting for the first column of the table.

    Step 18
  19. Last Column:  Displays special formatting for the last column of the table.

     

    Step 19
  20. Banded Columns:   When you display banded columns, even columns are formatted differently from odd columns.   This banding can make it easier to read a table.

    Step 20
  21. Table Styles:

    Step 21
  22. Table Styles:

     

    Change the color styles of the table.

    Step 22
  23. Click the Table Style Medium 5 list item.

    Step 23
  24. Totals Row:  

    Step 24
  25. Turning on the Totals Row:

     

    Left click to select the last row of your table.

    Step 25
  26. Right click

    Step 26
  27. Click Table.

    Step 27
  28. Click Totals Row.

    Step 28
  29. The row has been totaled.

    Step 29
  30. This row provides access to summary functions so that you can quickly calculate your data.

    Step 30

After completing this topic, you are familiar with Table Manipulation.