Setting up your data
In this task, you are going to use data from the ASX for a Company that sells shark repellent systems and prepare it for charting. The first step is to tidy up and format the data.
This exercise is part of the course
Data Visualization in Google Sheets
Exercise instructions
- Remove the blank row and standardize your decimal places such that the numbers in columns
B:Ehave three decimal places. - Change the format of the date in
I1so that it has the same format as the dates inColumn A.- To do so you will need to select 'Format', and then 'Number' from the menu bar (or alternatively, you can use the '123' dropdown menu from the toolbar).
- Depending on options available to you, you may need to select additional date formats by selecting 'More Formats', and then 'More date and time formats'. This menu will provide you with advanced formatting options.
- Your new format should have the month, day, and year as an integer, separated by a hypthen!
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise