With MS Excel Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.
A Style can consist of settings for up to six different attributes −
• Number format
• Font (type, size, and color)
• Alignment (vertical and horizontal)
• Borders
• Pattern
• Protection (locked and hidden)
Now, let us see how styles are helpful. Suppose that you apply a particular style to some twenty cells scattered throughout your worksheet. Later, you realize that these cells should have a font size of 12 pt. rather than 14 pt. Rather than changing each cell, simply edit the style. All cells with that particular style change automatically.

Applying Styles

Choose Home » Styles » Cell Styles. Note that this display is a live preview, that is, as you move your mouse over the style choices, the selected cell or range temporarily displays the style. When you see a style you like, click it to apply the style to the selection.

Creating Custom Style in MS Excel

We can create new custom style in Excel. To create a new style, follow these steps −
• Select a cell and click on Cell styles from Home Tab.
• Click on New Cell Style and give style name.
• Click on Format to apply formatting to the cell.

• After applying formatting click on OK. This will add new style in the styles. You can view it on Home » Styles.

Using Themes in Excel

Using Themes in MS Excel

To help users create more professional-looking documents, MS Excel has incorporated a concept known as document themes. By using themes, it is easy to specify the colors, fonts, and a variety of graphic effects in a document. And best of all, changing the entire look of your document is a breeze. A few mouse clicks is all it takes to apply a different theme and change the look of your workbook.

Applying Themes

Choose Page layout Tab » Themes Dropdown. Note that this display is a live preview, that is, as you move your mouse over the Theme, it temporarily displays the theme effect. When you see a style you like, click it to apply the style to the selection.

Creating Custom Theme in MS Excel

We can create new custom Theme in Excel. To create a new style, follow these steps −
• Click on the save current theme option under Theme in Page Layout Tab.
• This will save the current theme to office folder.
• You can browse the theme later to load the theme.

Using Templates in Excel

Using Templates in MS Excel

Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks.

Viewing Available Templates

To view the Excel templates, choose File » New to display the available templates screen in Backstage View. You can select a template stored on your hard drive, or a template from Microsoft Office Online. If you choose a template from Microsoft Office Online, you must be connected to the Internet to download it. The Office Online Templates section contains a number of icons, which represents various categories of templates. Click an icon, and you’ll see the available templates. When you select a template thumbnail, you can see a preview in the right panel.

On-line Templates

These template data is available online at the Microsoft server. When you select the template and click on it, it will download the template data from Microsoft server and opens it as shown below.

Using Templates in MS Excel

Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks.

Viewing Available Templates

On-line Templates

These template data is available online at the Microsoft server. When you select the template and click on it, it will download the template data from Microsoft server and opens it as shown below.

So, this brings us to the end of blog. This Tecklearn ‘Using Styles, Themes and Templates 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

581