Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get a free 3 hour Excel 2019 course from Simon Sez IT ️ https://www.simonsezit.com/four-free-courses

If you want to learn how to protect your files when using Excel 2013, watch this video to know more about creating backup copies and using autosave and autorecover features. When working with workbooks that are valuable to you, making sure that they have backup copies is a must. This video talks about backup, autosave, and autorecover in Excel 2013--three features that are very useful in most of the files you are working on. If you don't have an effective backup regime yet, it would be best if you get one in place soon. Learn more about these in this video!

Get the full course on Excel 2013 course here: https://www.simonsezit.com/course-category/excel/

Stay in touch:
Facebook: http://on.fb.me/14m8Rwl
StreamSkill.com: https://StreamSkill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)

Welcome back to our course on Excel 2013. In this section, I’d like to quickly cover Backup and Recovery or more specifically Auto-Recovery in Excel 2013. And, first of all, let me talk a little bit about Backup.

When you are working with workbooks in Excel 2013, you’re basically working with files, probably mostly kept on your own computer although you could be keeping them on SkyDrive or on a Network Drive. But wherever you’re keeping those files, wherever you’re keeping those workbooks, it is very important that they’re part of a backup regime. You should make sure that you regularly take copies of all of the workbooks that have any value to you at all, which is probably the vast majority of them, and make sure that that copy is somewhere else, not on the same device as the original.

Now I’m not going to talk in this section about setting up a backup regime that should be part of how you look after the digital media that you create and maintain anyway. But this is by way of a reminder to say the Excel 2013 Workbooks that you create and maintain need to be part of whatever your backup regime is. If you haven’t got an effective backup regime I suggest that you get one in place soon.

Now having said that I would like to quickly point out one little feature in Excel 2013 that is a sort of backup feature, but it’s not really what I’m talking about here. Let’s suppose you’ve created in this case Book 1, you’ve put some numbers in, and you want to save this particular workbook and you go into File, Save As. I’m going to save on My Computer, go into that Folder, etc. When you do a Save As, there is an option there’s some Tools options here. We’re going to look at some of this later on. But amongst the options their General Options include one that says “Always create backup.” Now what this really means and I’m not going to go into it in detail here, but what it really means is when you save this particular workbook an additional copy will be saved but it will be saved in the same place.

So you’re not talking about doing some sort of off-site backup somewhere else. It’s an additional copy of the same file with a slightly different file extension on it. It’s normally an XLK File. And that keeps an additional copy. That means if you accidentally delete the original, the backup copy is there. Now the point I’m making here is that that isn’t the same as having a backup regime. With a backup regime, you have a copy of the files kept somewhere else.

Now the idea of the backup regime is to keep a copy of your important files to cover situations like one where your computer gets stolen, your computer breaks down, or everything just gets accidently wiped. But that isn’t the only situation you need to cater for. And another situation which happens too frequently, perhaps not as frequently as it used to but it still happens, is that Excel itself fails, your computer fails, the power goes, something happens whereby partway through working on a particular workbook everything goes wrong and potentially you’re going to lose all of the work that you’ve done say in the last hour or two. Now Excel provides a very specific facility to deal with this and it’s called Autosave and Auto-Recover.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.