Thursday, 29 December 2016

Lesson 1 - Introduction

Microsoft excel is a spreadsheet software and is used for mathematical calculation and accounts.

I will be using Microsoft Excel 2007 for these lessons.

When you open Excel you will see a sheet and it is composed of different parts. Following are the details of the spreadsheet.



Office Button:
When clicked, open its menu that contains common commands such as open, save print etc

Quick Access Tool bar:
It contains useful command used often. You can click arrow beside right side of this bar to add or remove commands from here.

Title Bar:
It is top most bar and contains Application name & the file on which you are working. if file is not yet saved the default file name "book1" may appear.

Commands Tabs:
These are the command tab, clicking on any tab will bring sub commands under tabs.

Column Labels:
These are the columns name and are used for reference cells.(These are A,B,C etc)

Row labels:
These are the row number and are used for reference cells.(These are 1,2,3 etc).

Name Box:
It shows the name of the active cell in which data will be entered.

Formula Bar:
It shows the value or formula of the active cell.





Sheet Navigator:
When there are more sheets than the space allocated for these you can click different buttons to view sheets that are not visible.

Sheet Tabs:
Click on the sheet tab to switch between sheets.

Status Indicator:
It shows which is being done in the current cells. Normally it says Ready.

Horizontal Scroll Bar:
It is used to scroll the window left or right when sheet is greater than the screen.

Vertical scroll bar:

It is used to scroll the window Up or down when sheet is greater than the screen.

Page view:
It shows 3 types of views:
Normal:  As you see it when excel started.
Page Layout:   Shows page layout, margins etc.
Page Breaks:    Shows where page starts and ends. You can change where to start page and end it.