The “Office” Button

When we click the “Office” button, we see the folowing commands on the left side of the window:
“New”, “Open”, “Save”, “Save As”, “Print”, “Prepare”, “Send”, “Publish”, and “Close”.
On the right side we find the recently opened documents.

Click on the “Excel Options” button and a dialog box appears.

Using the options in this dialog box, we can customize the environment of Excel.
On the left side we find various tabs.
On the right side we have the settings.

Let me go through these settings.

In the first tab “Popular”, we have:

1. ” Show Mini Toolbar on selection”:
   When this option is checked, a pop up will appear with an explanation of the button when you move the mouse pointer over it.
   This is useful for those who have never worked with Excel.
   For those who are accustomed to working with Excel, this may get on your nerves and can uncheck this optiion.
2. ” Enable Live Preview”:
   This option shows an example of how the worksheet will look like when we choose a command.
   This is very interesting.
   In previous versions of Excel, you have to first save the information and then view it.
3. “Show Developer tab in the Ribbon”:
   This displays an additional tab above the “Ribbon”. This tab is used for those who work with “Visual Basic”.
4. In the second part we have a number of formatting options, such as “Use this font” the standard font that you want to use, the “Font size”, the “Default view for new sheets” and “Include this many Sheets”, which gives the number of worksheets that you want in each new workbook. The default setting is set to three, but if you usually need only one, you can change it to 1.
5. The third part is self explanatory.

In the second tab, “Formulas”, we have “Calculation Options”, “Working with Formulas”, “Error Checking” and “Error Checking Rules”.  For those who are accustomed to work with Excel can customize it.  For the newbies I recoment to leave these settings as they are.

The third tab is , “Proofing”, which helps to improve our text when you type errors.

Under the fourth tab, “Save”, you have the choice of file extension that you want to include for saving.
“.Xlsx” for “Excel 2007”, “.xls” when you wish to open the files in earlier versions of Excel.
If you wish your file to save automatically after every x minutes, check “Save Auto Recovery Information every”.
This option is very useful for those who are new to computers.

Under the fifth tab, “Advanced”, you have some options which you can use when you’re used to working with Excel.
For example, the direction that the cursor goes when the Enter key is pressed, the layout etc.
There are lots of options you chould go through once you are used to working with Excel.

Under the sixth tab, “Customize”, we can customize the buttons for the “Quick Access” toolbar.
We will learn more on this in the later lessons.

The seventh, eighth and ninth tab are for more advanced users of Excel, and not in scope of this course.

“Add Ins” allows us to add additional plugins

“Trust Center” provides some security options.

And under the “Resources” tab we have methods which allow us to check for updates, diagnose, and help you to get in touch with Microsoft Office.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats