Introduction to Excel Interface and Objects

Home/Excel/Introduction to Excel Interface and Objects

We have seen what is Excel and what we can achieve using Excel in the previous section. In this section we will see what are the different objects in Excel to do our jobs. And we also see the pictorial representation of Excel Interface.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


In This Section:

When we start a new Excel File, we can see the following Excel environment:

Introduction to Excel Interface:
Excel environment is explained here, click on the image to maximize:

Menu Bar or Ribbon: Here you can find different verities of utilities to deal with Excel to do our jobs

Address Bar: We can see the active Cell, Range or Object Name here. You can type any name of the object to activate it

Formula Bar: We can write a formula in Cell or Object using Formula Bar

Application or Windows Button: We can use this to minimize, maximize or close the application

Status Bar: Where you can see the status of the Application task, we can print status using VBA

Zoom: We can increase or decrease the zoom levels of the worksheets

Quick Access Tool Bar: We can assign any utility to quickly access it

What are the Objects in Excel?
Excel Objects are explained here, click on the image to maximize:

Workbook: It is the main file, which we can give name and store it in desired folder. All other objects are part of this workkbook

Worksheet: It is a the space where we can enter our data and format. A workbook is a collection of worksheets

Cell: Cell is the part of the worksheet, where we enter the data, formulas.

Range: It is a collection of Cells in excel worksheet.

Rows: These are records (1,2,3,4…) in excel worksheet.

Columns: These are Fields (A,B,C,D,…) in excel worksheet.

LIMITED TIME OFFER
By |May 8th, 2013|Excel|2 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

2 Comments

  1. Martina February 19, 2014 at 1:46 PM - Reply

    Hi, i would like to know which excel version you are describing here. Is that excel 2013 oder a mac version? Is excel 2013 worth getting? I wan to get excel, but im not sure which version (prize point is a factor too). I found anotehr guide describing the 2010 version of the so far, and that seems ok. Any huge improvements for 2013, besides the usual marketing informations?

    • PNRao February 19, 2014 at 11:16 PM - Reply

      Hi Martina,

      I use Excel 2010 and 2013 for Windows; I found 2013 is rich visualized. You can get Excel 2010 or 2013 32 bit.

      Thanks-PNRao!

Leave A Comment


Related pages


vba string variabledelete rows excelcost estimate excel templatevb function syntaxtick box in excel 2010excel macro tipsredim vbaautofilter field vbasql tutorial for beginners with examples pptexcel vba paste rangecharting in excelexcel tips and shortcutsadodb odbc connection stringvba excel select rowhow to eliminate rows in excelunlock password protected excel 2010worksheet unprotectvba select rowsgenpact aptitude questionsexcel tasks templatedelete blank rows exceldesign tab excelhow to use a pivot table in excel 2010unlock excel cells without passwordexcel buble chartlookup excel functioncombobox additemhow to add a blank row in excelwrite vba codeexcel formulas with exampleexcel vba copy sheet to another workbookabout excel macrosuserform in vbahow to do carriage return in excelms access find record vbavba showalldataunlock excel workbookmerge cells in excel 2013vba change row colorcapacity model template excelmacro functions in excelapplication vbacopy excel workbook to another workbookwriting a macro in excel 2007update sql vbahow to convert column to row in excelhow to edit the protected excel sheetactivesheet.cellsexcel vertical lookupvb calculator codeexample of vlookup function in exceladvanced ms excel tutorialgantt chart template wordexcel consolidateclearcontents vbalock worksheetexcel macro offsetscripting.filesystemobject opentextfilevba thisworkbookexcel cells vbadashboard in excel tutorialproject portfolio management template excelhow can i unprotect an excel sheet without the passwordhow to use sum if formulaexcel kpi dashboard examplesms excel project plan templateexcel macro option buttonhide sheets in excel vbaexcel vba forms advancedvba protect sheetmsofiledialogfilepickerhlookup excel 2007pivot table on excel 2010lock sheet excelsql sorted bymacro tutorial exceliferror formula excelminute meeting template wordmacro in excel example