Tables

• I skipped tabs in the last chapter because they are not, in my opinion the best way to accomplish the task.
• Tables are much more useful.
• A table is a grid of columns and rows. Tables are built of cells or the intersections of columns and rows.
• Tables are inserted from the Insert tab, table group.
• Multiple ways to do this.
• After you create a table, there are two special table tabs.
• You can
  • Insert/delete rows and columns.
  • Merge/split cells.
  • Adjust row and column heights.
  • Format individual cells, or an entire table using table styles on the design tab.
• The second section introduces computing in a table.
  • I'm not sure this is the best idea, it is fairly primitive.
  • Excel is a much more effective tool for this type of work.
  • But
    • Use the Formula function on the Data group of the Layout tab.
    • =SUM(arg)
    • =AVEAGE(arg)
    • COUNT, MAX, MIN
    • arg = ABOVE, BELOW, LEFT, RIGHT
• Convert text to table is sometimes convenient.
• You can also sort on a table.