graphic1

Organizing Data with Tables

One of the unique functions of a computer is to organize information into Rows and Columns. Microsoft Excel does Rows and Columns: specifically Tables. Tables can be little reference lists that are named and used in a formula. One good example is a Lookup table. By definition, vLookup has the data in Columns (vertical). Hlookup has the data in Rows (horizontal).  The Advanced Guide to Excel begins with Tables and Table Tools.

Start Microsoft Excel. When the Welcome screen appears, open a new, blank workbook. What do you see from the top of the screen? Is there a Home Ribbon? And the Insert, Page Layout, Formulas, Data. Review and View Ribbons as well? Yes. Then you are ready to go.