MS Excel provides a feature of Word Processing program called Spelling check. We can get rid of the spelling mistakes with the help of spelling check feature.

Spell Check Basis

Let us see how to access the spell check.
• To access the spell checker, Choose Review ➪ Spelling or press F7.
• To check the spelling in just a particular range, select the range before you activate the spell checker.
• If the spell checker finds any words it does not recognize as correct, it displays the Spelling dialogue with suggested options.

Exploring Options

Let us see the various options available in spell check dialogue.
• Ignore Once − Ignores the word and continues the spell check.
• Ignore All − Ignores the word and all subsequent occurrences of it.
• Add to Dictionary − Adds the word to the dictionary.
• Change − Changes the word to the selected word in the Suggestions list.
• Change All − Changes the word to the selected word in the Suggestions list and changes all subsequent occurrences of it without asking.
• AutoCorrect − Adds the misspelled word and its correct spelling (which you select from the list) to the AutoCorrect list.

Zoom In/Out in Excel

Zoom Slider

By default, everything on screen is displayed at 100% in MS Excel. You can change the zoom percentage from 10% (tiny) to 400% (huge). Zooming doesn’t change the font size, so it has no effect on the printed output.
You can view the zoom slider at the right bottom of the workbook as shown below.

Zoom In

You can zoom in the workbook by moving the slider to the right. It will change the only view of the workbook. You can have maximum of 400% zoom in. See the below screen-shot.

Zoom Out

You can zoom out the workbook by moving the slider to the left. It will change the only view of the workbook. You can have maximum of 10% zoom in. See the below screen-shot.

Special Symbols in Excel

If you want to insert some symbols or special characters that are not found on the keyboard in that case you need to use the Symbols option.

Using Symbols

Go to Insert » Symbols » Symbol to view available symbols. You can see many symbols available there like Pi, alpha, beta, etc.
Select the symbol you want to add and click insert to use the symbol.

Using Special Characters

Go to Insert » Symbols » Special Characters to view the available special characters. You can see many special characters available there like Copyright, Registered etc.
Select the special character you want to add and click insert, to use the special character.

So, this brings us to the end of blog. This Tecklearn ‘Perform Spell Check, Zoom In-Out and Use Special Symbols 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

512