Part 2 – Make a table of all lists in Excel…looks good and makes updates simple

Well, here’s the second part of this 2 part series on using tables for your data. You can read Part one here.

I’ve decided to use the same data again from this  file but in this video below you can see how I’ve (1) cleaned up the data a bit and you can also see how I’ve referenced the table in a formula.

[fvplayer src=”https://s3-eu-west-1.amazonaws.com/the-excel-expert/tables+-+part+two.mp4″]

You can download the file here:  tables_dummy_data