Making a solid data table is a crucial skill to have when using Google Sheets. I will show you how I like to make my tables in Google Sheets.
Step #1: Add a Header Column and Row
The first thing that I do is add a "Header Row" and a "Column Row". These two parts of your graph are important because they control the x and y plane of your charts.
The more organized you can make the data table ahead of time, the easier it will be to fill in the data later on.
Step #2: Fill in the Columns
Now that you have the columns organized, the next step will be to fill them out. Depending on the context of the column, the cells will be filled in with a variety of possible items. However, the units should always be the same within that specific column.
Step #3: Add Borders
Next, I like to add borders to the data table. Bordering the range of the data table provides a good contrast between the cells and makes it stand out and become easier to analyze the data.
Step #4: Add Filters
Next, I like to add filters to the columns. When you do this, every column will be able to be filtered and sorted as is needed.
Step #5: Alternating Colors
Lastly, I like to add Alternating Colors to my graph to really make it pop and catch the viewers eyes. It is a great technique to really make your data stand out, especially in group settings or in the event of a presentation.
And there you have it; my step by step process for making a great data table. Feel free to apply any or all of these steps to your data tables and make your work really stand out for your next project!
