Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Saving Spreadsheet Data1:33 with Michael Watson
One simple best practice that will save you lots of grief: save often, and make file backups.
Example Google Spreadsheet
Save your files beginning with a date formatted like this YYYYMMDD. For example: 20171020-myspreadsheet.xlxs (.xlxs is for Excel spreadsheets). This way you'll have your spreadsheets in chronological order on your computer.
It's a beautiful thing that Sheets automatically saves work for you.
Unfortunately, not all your spreadsheet software will.
Remember to save your work regularly.
It's an awful feeling when you lose work because your machine crashes, and
the last time you saved was four hours ago.
Here in Sheets we can see that the last edit was made seconds ago, and
if I make a change right up there in that same area, Fun,
it saves automatically.
Sometimes when you're working with a spreadsheet, you make a mistake but
don't catch it.
That's why it's best practice to use Save As for
spreadsheet software that isn't Sheets.
The formatting I like to use is year, month, date.
this will keep things in chronological order on your machine.
Don't see what I'm talking about?
Pause this video and go create a bunch of different files in a folder on
your computer with different date syntax, and see what happens.
It's not pretty.
[SOUND] This is what I do for saving files.
For example, I have the same file, and I've saved it a bunch of different times.
And what I'll do is I'll do the year, The month and the date, and then the version.
So if I'm working with a file over the course of the same day,
I might have multiple different versions on that day.
This isn't as important when working with Sheets, but it's a super important and
foundational best practice when working with spreadsheets.
Ask your colleagues if there's a preferred file naming syntax where you work.
It's important to be on the same page.
You need to sign up for Treehouse in order to download course files.Sign up