You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel.
Translation is available in the review tab of the ribbon in MS Excel. You can quickly translate cell into different language with this option.

Performing Translation Step by Step

• Select the content, which you want to translate to a different language.
• Choose review tab » translation.
• It will open the pane from which you can select the language to which you need to translate.
• You need to have an internet connection for performing translation. It will translate using the Microsoft Translator.
• Click on Insert to apply translation changes.

Workbook Security in Excel

Workbook Security

We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel’s protection-related features fall into three categories.
• Worksheet protection − Protecting a worksheet from being modified, or restricting the modifications to certain users.
• Workbook protection − Protecting a workbook from having sheets inserted or deleted, and also requiring the use of password to open the workbook.

Protect Worksheet

You may want to protect a worksheet for a variety of reasons. One reason is to prevent yourself or others from accidentally deleting the formulas or other critical data. A common scenario is to protect a worksheet, so that the data can be changed, but the formulas can’t be changed.
To protect a worksheet, choose Review » Changes group » Protect Sheet. Excel displays the Protect Sheet dialog box. Note that providing a password is optional. If you enter a password, that password will be required to unprotect the worksheet. You can select various options in which the sheet should be protected. Suppose we checked Format Cells option then Excel will not allow to format cells.

When somebody tries to format the cells, he or she will get the error as shown in the screenshot below.

To unprotect a protected sheet, choose Review » Changes group » Unprotect Sheet. If the sheet was protected with a password, you’re prompted to enter that password.

Protecting a Workbook

Excel provides three ways to protect a workbook.
• Requires a password to open the workbook.
• Prevents the users from adding sheets, deleting sheets, hiding sheets, and unhiding sheets.
• Prevents users from changing the size or position of windows.

Requiring a Password to Open a Workbook

Excel lets you save a workbook with a password. After doing so, whoever tries to open the workbook, must enter the password. To add a password to a workbook, follow these steps.
• Choose File » Info » Protect Workbook » Encrypt With Password. Excel displays the Encrypt Document dialog box.
• Type a password and click OK.
• Type the password again and click OK.
• Save the workbook.

To remove a password from a workbook, repeat the same procedure. In Step 2, however, delete the existing password symbols.

Protecting Workbook’s Structure and Windows

To prevent others (or yourself) from performing certain actions in a workbook, you can protect the workbook’s structure and windows. When a workbook’s structure and windows are protected, the user may not Add a sheet, Delete a sheet, Hide a sheet, unhide a sheet, etc., and may not be allowed to change the size or position of a workbook’s windows respectively.
To protect a worksheet’s structure and windows, follow the below mentioned steps.
• Choose Review » Changes group » Protect Workbook to display the Protect Workbook dialog box.
• In the Protect Workbook dialog box, select the Structure check box and Windows check box.
• (Optional) Enter a password.
• Click OK.

So, this brings us to the end of blog. This Tecklearn ‘Translate Worksheet and workbook Security in Excel’ blog helps you with commonly asked questions if you are looking out for a job in Microsoft Excel. If you wish to learn Excel and build a career in Business Intelligence domain, then check out our interactive, Microsoft Power BI Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Microsoft Power BI Training

Microsoft Power BI Training

About the Course

Microsoft Power BI Training at Tecklearn will help you achieve expertise in business analytics Our best online training course teaches you all important concepts like Power BI Desktop, Mobile, Power Query & Power Pivot, Data modelling, visualization, creating dashboards and reports, DAX, etc. As part of this program, you will work on real-world projects. Also, our Power BI course curriculum will equip you with all the key skills that are required to clear the Microsoft Power BI Certification exam (70-778).

Why Should you take Microsoft Power BI Training?

• The average annual pay for a Power BI Professional is $114,000 . -PayScale.com.
• Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc, Brillio and 45,000 MNCs across 185 countries use Power BI and it has a market share of around 7% globally.
• Microsoft Power BI has been ranked at No.1 position in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for 13 consecutive years.

What you will Learn in this Course?

Introduction to Microsoft Power BI
• Microsoft Power BI Introduction
• Power BI Products
• Power BI Architecture
• Installing Power BI
• Connecting to Data Sources
Power BI Workflow
• Key features of Power BI workflow
• Power BI Vs MSBI
• History of Power BI
• Power BI Products
• Data modelling and relationships
Power Query for Data Transformation
• Power Query for Data Transformation
• Learning about Power Query for self-service ETL functionalities
• Working with Excel data
• Introduction to Query Editor
• Data transformation
• Pivot and UnPivot
• Merge Join, relational operators, date, time calculations, working with M functions
• Summary Tables
• Writing custom functions and error handling
• M advanced data transformations
Filters and Drill Down Report
• Visualization Filter
• Page Level Filter
• Report LEVEL Filter
• DRILL Through Filter or Report
• BookMark Report
Power Pivot for Data Modelling
• What is SSAS
• Data Modelling
• Star Schema
• Snowflake Schema
• Introduction to MDDB and Tabular
• Data Access Modes
• Tabular with DAX
• Power BI with DAX
• DAX Functions
Data Analysis Expression – DAX Queries
• TABULAR with DAX
• Power BI with DAX
• Calculated Members, Row, Filter & Evaluation Context
• Cumulative Charts
• Calculated Tables, ranking and rank over groups
• DAX advanced features
Power BI Desktop & Administration
• Reports and Visualization
• Learning about data modelling and data relationships
• Deploying data gateways
• Reports and Dashboards
• On Premises Data Gateway
• Gateway Clusters
Introduction to Power Q & A
• Power Service
• Power Q & A best practices
• Integrating with SaaS applications
• Gateway

457