In this video, learn how to quickly restore a business budget model in Excel to an earlier version if you've made a mistake.
- [Instructor] Okay we've all had that sinking feeling…when we've made a change to a workbook, closed it,…and want to revert back to how it used to look.…Did you know that Excel auto saves changes?…You can tell by seeing the auto save radial button…at the very top lefthand side of the screen.…But don't stress, luckily Excel has in-built version…history capabilities making it easy to restore a file…to how it used to look.…If you'd like to follow along with me,…have my business budget version open and make sure that…you're on the model overview worksheet.…
Let's go ahead and make a couple simple changes…to this file.…What I'm going to do is select the text here and change…the font from black to red.…I'm then going to close the file by selecting the cross…at the very top righthand side of the screen.…Now you'll notice in OneDrive now that the file was…updated just a few seconds ago and this is what we wanted…to see appear.…If we click on the tick to the lefthand side of the file…and then at the very top of the screen select…
- Identify why it is a good idea to use Excel when creating a business budget.
- Examine the importance of revenue drivers when putting together a business budget.
- Recognize how to calculate staff costs when creating a business budget.
- Explore the elements of preparing a concise report.
- Break down the fundamentals of enhanced reporting.
- Determine the best ways to utilize efficient updates.