My tables are ugly. How can I fix them?

Hi Paul,
It is very hard to tell how to get great looking tables and charts. The samples look great, but the key is the data you have and the story you want to tell.
Depending on the data you have, there are many build in tools in excel to make it look great. Conditional formatting will do the colouring automatically for you based on the bands you set and colours you want. There are also many charts to choose from. Each chart type has different styles to give it your look and feel, colour scheme etc.
Again, depending on your raw data, you may need to do some conversion or use 'helper columns'.
For dashboards, there is a saying: Information > transformation > presentation.
If you can upload some 'cleaned non confidential' sample data, I may be able to suggest something more concrete.

You have uploaded a file with links to another (not provided) file. This can make things difficult, as other members cannot see how things reference to each other?

No, it appears that you have a link to a file...
=IF(F2<>"",VLOOKUP(F2,'*****\VA Test Score Template 101419 - Linked.xlsx'!Table2[#Data],2),"")

Lets start with the raw data;
Try to avoid empty rows. Is there a specific reason why your table in column J:K has empty rows? If not, remove them.
Your columns should have a 'header' so the user knows what they are. Headers can also used for charts.
Again, is there a reason why you have empty columns between your data set; C, E, G ?
Observation: Column F has an in consisted formula. -100, from D8 onwards -10. This may be on purpose.

One quick tool to format your date: Highlight the data you want to apply the changes to. Click: "Ctrl+ Q" (Quick Analysing).
There you have a number of tools: Formatting, Charts, Totals, Tables, Sparklines. Each will show you different option. Click on it for a preview. You can set different Formatting for each column, or multiple formatting, but that can make the data messy.

Hi again,
In the attached file I have added a couple of sheets.
One with your date a bit 'cleaned up'. I also inserted a couple of screenshots in the file to help you how to do it yourself.
On the other a few sample charts from your date. I put your data into a Pivot table, counting the number of IQ Percentile by description and created 3 different charts via Insert Pivot Chart.
Trust this gives you some ideas.