| Well-structured information is the key to making the most of Excel. Each different data type should appear in its own column. Generally, it’s best to think of each row as a record (client names, sales records, inventory items, etc), with the columns containing information [attributes] on those records (eg First Name, Surname, Post Code). The information is easier to understand and easier to manipulate. You can do this horizontally, rather than vertically, but, the powerful Filter tools are not available; the tables are much more difficult to read; and you are greatly restricting the number of records. |
Contact me now for
Excel Specialist Advice >>