excel for mac 2016- get to the backstage area

It’s a little bit easier if I change from Colorful to White as my Office Theme.

It’s a bit difficult to see with the Colorful setting. You might just about see there some fishes and various other underwater creatures appearing there.

Just take a look at the top right hand area of the screen when I click on Okay. So I’m currently set on Underwater Colorful. And in fact whatever changes you make when you are adjusting the Excel Options are only activated when you click Okay. You won’t see any particular change happening. One very important point here, let’s suppose that I change the Background to say Underwater. My settings are primarily set that way in order to make it as easy as possible for you to see what’s on the screen but you may choose to go for something a little bit more dynamic than this. Now I currently have the Background set to No Background and the Office Theme set to Colorful. That’s the Office Background and the Office Theme. Now there are then two settings which also relate to Office in general. So if you want to use those values whichever account you’re signing into Office with then you just check that box. Note the checkbox under there to say always use these values regardless of sign in to Office. Some people use a nickname rather than their real name here. By default it gets the username associated with the account that you’re running Excel under but you can change that name. 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. 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. 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. But we are going to start with two or three of them and in particular we’re going to start with the General page. And most of these pages we won’t really be looking at at all until later stages of the course. 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 that brings up the Excel Options dialogue. It’s the second one from the bottom here. So the first thing I’m going to do is to go into Backstage View and one of the pages is Options. Now although Excel Options will appear at various points during your use Excel 2016 the conventional way to access them is from Backstage View. 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 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.

And Excel Options are used basically to customize and personalize your installation of Excel and your use of Excel. In this section we’re going to look at the very important subject of Excel Options.

Like what you see? Get our complete Microsoft Excel 2016 training courses for beginner, intermediate and advanced learners.

Microsoft Visio 2010 – 9 Hours Video Training.

Power Pivot, Power Query and DAX in Excel.

Adobe Photoshop Elements 11 – 12 Hours Video Training Course.

Excel for mac 2016- get to the backstage area