MS-Excel / General Formatting

What is Table

A table is simply a rectangular range of structured data. Each row in the table corresponds to a single entity. For example, a row can contain information about a customer, a bank transaction, an employee, a product, and so on. Each column contains a specific piece of information. For example, if each row contains information about an employee, the columns can contain data such as name, employee number, hire date, salary, department, and so on. Tables typically have a header row at the top that describes the information contained in each column.

A table is well, a list. For example, take a look at the table shown below. In column A, for example, the table names the country/city where you might purchase the bags. In column C, this expanded table gives the quantity of some item that you need. In column D, this table provides a rough estimate of the cost.

Table
[Contents] [Next]

In this tutorial:

  1. Excel Table
  2. What is Table
  3. Create Tables
  4. Converting a Table to a Range
  5. Sorting Table Record
  6. Filtering Data in a Table
  7. Advanced Filter Command
  8. Working with the Total Row
  9. Applying a new style to a table
  10. Removing Duplicate Rows from a Table
  11. Selecting Table Areas
  12. Table Calculation
  13. Inserting, Moving and Deleting Table Rows and Columns