I am introducing some students to Excel and have produced this brief style guide to producing more readable code which I think gives you 80% of everything you need to know.
The strategy is to use Excel’s built-in ability to name sets of cells.
Please add your comments.
All tabular data must be in a table
Select a cell in the data (usually top left) and click Insert > Table
Name your tables
Name your tables using the Table Tools tab a good name for a table containing email addresses would be table_emailAddresses