Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, you will learn how to personalize your use of this program through the Excel Options. We will show you how to setup your own username, how to customize the office background and theme, how to modify the user interface options, how to set a default file location, and how to add and change editing languages.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

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

Welcome back to our course on Excel 2016.
In this section we’re going to look at the very important subject of Excel Options. And Excel Options are used basically to customize and personalize your installation of Excel and your use of Excel. Now in the very early stages of learning Excel many of these options won’t really mean very much to you so we will come back to them from time to time later on and I’ll explain the options you need as we go through the balance of the course. But before we really get started with Excel you need to make sure that a few basic options are setup in the way that you need them to be.
Now although Excel Options will appear at various points during your use Excel 2016 the conventional way to access them is from Backstage View. So the first thing I’m going to do is to go into Backstage View and one of the pages is Options. It’s the second one from the bottom here. And that brings up the Excel Options dialogue.

Now this dialogue is made up of a number of pages and the first page is General, I’ll come back to that in a moment, then we have Formulas, Proofing and so on. And most of these pages we won’t really be looking at at all until later stages of the course. But we are going to start with two or three of them and in particular we’re going to start with the General page.
Now I’m going to cover the items on the General page in a sort of haphazard order but there is a reason for doing them in the sequence that I’m going to go through them.

So I want to start with this section, Personalize Your Copy of Microsoft Office, and this selection will actually affect the whole of Microsoft Office, not just Excel. First of all your username. Now your username will be particularly important if, for example, you are working with others on documents and you’re adding comments, you’re annotating, workbooks, etcetera and you want to keep a track of who has made whatever comment or even who has made changes to a workbook then these can be identified using the username that you’ve set up here. By default it gets the username associated with the account that you’re running Excel under but you can change that name. Some people use a nickname rather than their real name here.

Note the checkbox under there to say always use these values regardless of sign in to Office. So if you want to use those values whichever account you’re signing into Office with then you just check that box.


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