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.
50+ Project Management Templates Pack
Excel PowerPoint Word
Advanced Project Plan & Portfolio Template
Ultimate Project Management Template
20+ Excel Project Management Pack
20+ PowerPoint Project Management Pack
10+ MS Word Project Management Pack
In This Section:
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.
|Excel VBA Reference||Project Management Reference|