Viewing: excel 2011

How to use Goal Seek in Excel

Microsoft Excel has a Goal Seek feature which can be used to derive value of a cell based on the result set for the cell containing a formula. Let us see this with an example that does a simple addition. In the below screenshot, you should notice that the sum of A3 to E3 is […] Read More

How to enable display of four digit year in Excel 2011 for Mac

This short excel tutorial covers the steps required for displaying the year entered in Excel 2011 as four digit instead two digit. The default date format in Excel 2011 for Mac is set to display only 2 digit year. For example, in the below screenshot excel 2011 display the year as “14” instead of “2014" […] Read More

Change the background colour of cell based on text in Excel 2011 for Mac

In this tutorial, we will see the steps required to change the background colour of cell based on text entered in another cell using conditional formatting in Excel 2011 for Mac. Let us considered the following sample data with name of students and their Grade. Now based on the text entered under grade, you want […] Read More

Change the AutoRecover time in Excel 2011

This tutorial is about the steps required increase or decrease auto recover time in Excel 2011 for Mac. Auto Recovery Auto Recovery is a feature will automatically try to recover unsaved work during unexpected or accidental shutdown or after crash of the application. And for this purpose, Excel periodically takes backup of the current work. […] Read More

How to customize Office Ribbon in Excel 2011

Excel 2011 for Mac like the other Office versions provides option to customise Ribbon. Listed below are the various Ribbon customisation that can be done in Excel 2011. Click the Excel menu and select Preferences from the menu list. In the Excel Preferences window, navigate to Sharing and Privacy section and click Ribbon option. Turn […] Read More

How to remove duplicates values in Excel 2011

Excel 2011 for Mac has a feature that automatically removes duplicate values from the selected rows and columns. For this example, let us take the below sample data Now you can see in the table that couple of rows are getting repeated. You can remove these duplicate values by using the Remove Duplicates option available […] Read More

How to change default number of worksheet in Excel 2011 Mac

The number of worksheet associated with a new workbook in Excel 2011 for Mac is 1. And if your work requires adding a worksheet then you can click the plus sign to insert new sheet. If you always require minimum of 3 worksheet in your new workbook then it is recommended to change the default […] Read More

How to change the default file location in Excel 2011

This tutorial provides the steps required for changing the default file location in Excel 2011 for Mac. Users can set their preferred file location using the Excel Preferences. Click the Excel menu and select Preferences from the menu list. Click the General option available under Authoring section. In the General Preferences window, navigate to Preferred […] Read More

Change decimal places in Excel 2011 for Mac

This articles is about the option available to change the decimal places in Excel 2011 for Mac. Excel by default automatically inserts decimal point after two digits but it allows users to change the default option using the Preferences.Click the Excel menu and select Preferences from the displayed menu list. In the Excel Preferences, click […] Read More

How to password protect workbook in Excel Mac 2011

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list. This would display the following File Passwords window with different password option. You can set a password for opening the excel workbook using […] Read More

Get your free copies of the following tech guides by joining the Digital Answers mailing list.