Tags

, ,

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

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

Name-table

Learn how to use named ranges

named-ranges

Advertisements