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

This video tutorial talks about how to use Excel Options, which is probably the most important feature of Microsoft Excel 2013 in terms of setting up the way that you work to suit your preferences. Learn how to access Excel Options and find out how some of the options work, such as the general settings, save settings, and language settings. Watch this tutorial to learn more.

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 -)

Hello again and welcome back to our course on Excel 2013. In this section, we’re going to look at Excel Options which is probably the most important aspect of Microsoft Excel, certainly in terms of setting up to suite the way that you work and to suite your own installation. If you’re new to Excel there’s what may seem like a baffling array of options that you make decisions about. But in fact with Excel Options, provided you’ve got one or two of the simplest ones in place first and I’m going to point those out to you now. Then, the others you can deal with as you come to them and during the rest of the course I’ll refer you back to Excel Options. So first of all, let’s look at how we access the Excel Options.

Well let’s go into Backstage View and in Backstage View right down at the bottom, Options. Now the Excel Options is really a big dialog box and you should know by now that if you want some help at any point, you’ve got the link through here, the question mark that takes you through to Help. And the dialog box is arranged into a set of Pages. So we have a General Page, we have a Formulas Page, Proofing, Save, Languages, and so on. Now some of these I’m going to talk about later on in the course, but I want to talk about a few of the main straightforward settings to get you started. And let’s go back to the General Page first.

Now three-quarters of the way down that page there’s a section marked “Personalize your copy of Microsoft Office” and in there you should have your own user name. This user name will be used to annotate the workbooks that you create. And it can be used in a number of other situations to do with making changes to workbooks and so on. But either put your own name or a sort of code name or something in there. And the other thing you can do here, I’m not going to go into this in detail now but you might like to look into it, is that you can choose the Office Theme and Office Background that you want to use. Now these basically relate to a common approach, a common Theme throughout your use of many of the Office 2013 components. I’ve got mine set here at the defaults.

Now when we talked about Help earlier on, I didn’t really talk about what are called screen tips. Let me hover over one of the rows in the first section on the General Page of the Excel Options and what pops up there is what’s called a screen tip. It says “Show mini toolbar on selection.” That’s Bold. That’s the tip. And then below that the other text is referred to as a deature description. Now this can be very useful to have these screen tips and feature descriptions appearing whenever you’re using Excel, particularly when you’re new to Excel it will tell you what a particular command, what a particular button does, and then also give it a little bit more of a detailed description of what it does. Now after you’ve been using Excel for a while, you may not need those screen tips and this first section on the General Page let’s you switch them off or partially off. If you look at this drop down it says, Screen Tip Style. Show feature descriptions in screen tips.

That’s the sort of full on version of screen tips. If you said I don’t want the feature descriptions, you’ll only get the tip, the title if you like. And if you select don’t show screen tips, you won’t get anything at all. Now I’m going to choose the middle option, so don’t show feature descriptions. Any changes you make in Excel Options only actually get executed when you click the OK. So let’s click on OK. I’ve got a little workbook open here.

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