| Connect us with   Facebook    Youtube    Twitter
|Subscribe & Get Free Excel Shortcut Keys Book|Learn excel,word,powerpoint,html tutorials..etc in Kannada| ಕನ್ನಡದಲ್ಲಿ ಕಲಿಯಿರಿ excel,word,power point,html ಮತ್ತು ಎಲ್ಲಾ tech updates ಗಾಗಿ ನಮ್ಮ ಚಾನೆಲ್ ನ್ನು subscribe ಮಾಡಿ.

LEARN EXCEL: INTRODUCTION TO MICROSOFT EXCEL/LAYOUT

What Is Microsoft Excel?

Before Start learning Excel Turorials you should know Excel layout. when we open excel it shows a blank screen. now you are going to know various options which are available on the screen. in our website, we discussed basic formulas,Vlookup, Functions & Charts, PivotTables, Page setup, etc. in left side menu we mentioned all that formulas & functions one by one. it helps to you grab which one you need. Before starting step by step Excel Tutorials you should know Excel Design or Layout.

TITLE BAR:

The Title bar is located above the Excel window. The title bar displays the name of the workbook. in the below image it shows Title bar name as Book1. if we change the workbook to another name then it shows as per new name only.

Excel Title Bar

QUICK ACCESS TOOLBAR:

Above 2010 version only one quick Access toolbar available in excel. in the previous version, there were more toolbars in excel. QAT(Quick Access Toolbar) located above the ribbon. and it contains the Save, Undo, Redo Button. if you want to add other most used commands you can add it to QAT. it helps the user to access those commands easily.

Excel Quick Access Bar

EXCEL RIBBON:

The Ribbon contains Tabs like File, Home, Insert, PageLayout, Formulas, Data, Review, View, Developer. if you double click on any Tab, Ribbon gets hidden. if you double click once again, the Ribbon comes back.

Excel Ribbon

TABS, GROUPS, ROWS, COLUMNS IN EXCEL:

TABS IN EXCEL: Each menu subdivisions are called Tabs in Excel. There are many Tabs available in excel. like File, Home, Insert, PageLayout, Formulas, Data, Review, View, Developer. and each Tab consists of groups.

Columns & Rows have a major role in Excel. The column is a Vertical series of cells in Excel. And Row is a Horizontal series of cells in Excel. Below given example shows columns & rows in Excel. Column Letters labeled with A, B, C, D Etc and Row labeled with1,2,3,4 Etc numbers.

A cell is a rectangular box which stores one piece of information or data.

Excel Ribbon Groups

NAMEBOX | FORMULA BAR | OTHER INFORMATION

Name box shows the location of the cell.

Formula bar shows the information on the cell & also it allows you to create a new formula or view formula.

Excel Ribbon Groups
IF YOU LIKE OUR TUTORIALS PLEASE DON'T FORGET TO SHARE

-

LIKE ME ON FACEBOOK