Learn microshoft excel

MS-Excel 

Introduction

Ms-Excel is one of the DBMS Software. It manipulates and manages the database in very well manner. It provides the sophisticated tool for calculating, projecting and analyzing numeric data & presenting the result in professional quality documents & chart.

Excel, for that matter any spreadsheet essentially comprises of row & column. Inter section of row & column is called cell.

Work Book: - A work book is the main document of excel. By default a work-book has three work-sheet, we can add more work-sheets.

Work sheet:-A work-sheet is the working document of excel. It has an electronic sheet where calculation & operation are performed. The worksheet has 256 column & 65536 rows.

How to open Ms-Excel ?

• Go to start menu

• Click on program

• Click on Microsoft Excel

Home menu

To setting print area

• Select required cell range

• Go to file menu

• Click on print area

• Click on set print area

• Click on clear print area to remove print area

To remove sheets element.

• Select required cell range

• Go to edit menu

• Click on clear

Then display dialog box,

• Choose all to remove whole element

• Choose formats to remove formatting effect

• Choose Comments to remove comment text.

To Delete Cell.

• Keep cell pointer in target cell

• Go to edit menu

• Click on delete

• Choose any

• one option what your requirement

To Jump defined place of sheet.

• Go to edit menu

• Click on Go to command

• Type particular address

• Click on OK

To Show page with page effect.

• Go to view menu

• Click on page break preview

Formula Bar :- To show/hide formula bar from screen

• Go to view menu

• Click on formula bar

Comment :- To show/hide comments from sheet.

• Go to view menu

• Click on comment

Custom View :- This command is used to define particular cell range.

• Select required cell range

• Go to view menu

• Click on Custom view

• Click on add button

• Type required name

• Click on OK

Fill :- This command is used to fill data, value, contents of sheet.

• Select required cell from target cell

• Go to edit menu

• Click on fill, then appear small dialog box

• Choose series 

• Type the starting or stop value

• Click on OK

Clear :- This command is used to remove particular effect, value from selector cell.

• Select cell range

• Go to edit menu

• Click on clear 

• Choose all to remove whole data from cell

• Choose format to remove only formatting effect

• After define effect click on OK

Delete :- Remove selected cell from sheet.

• Keep the cursor in particular cell

• Go to edit menu

• Click on delete

• Choose any one option what you want 

• Click on OK

Delete Sheet :- Using this command you can remove selected sheet from work book.

• Select Sheet

• Go to edit menu

• Click on delete sheet

Move or Copy sheet :- This command allows changing sheet position & creating 

• Duplicate sheet.

• Select sheet

• Go to edit menu

• Click on move or copy sheet

• Then display a dialog box,

• Choose Sheet & its location

• Click on OK

Insert Menu

Cells :- To add cell in the work sheet.

• Keep the cell pointer in required place

• Go to insert menu

• Click on cells

• Then display dialog box,

• Choose any one option

Rows :- To insert row in the work-sheet.

• Select row where you wanton add cell

• Go to insert menu

• Click on rows

Columns :- To add column in particular place of sheet

• Select column

• Go to insert menu

• Click on column

Work-Sheet :-This option allows inserting more worksheet in the work book.

• Go to insert menu

• Click on work-sheet

Chart :- Using this command you can insert different type of chart depending upon data

• Prepare data select it 

• Click on insert menu

• Click on chart, then display dialog box

• Choose any chart format

• Click on next tab

• Click on series tab & define series name

• Choose axis tab & define grid line

• Click on finish

Function :- This option allow you to apply formula in your calculation.

• Keep the cell pointer in required place

• Go to insert menu

• Click on function 

• Choose any types of formula

• Select required formula

• Click on OK

Comment :- This command is used to add comments about particular cell object.

• Keep the cell pointer in required place

• Go to insert menu

• click on comment

• Type required text.

• Click outside the box.

Format Menu

Cells:- I helps to change cells format & also change font, font color, border, number 

• format, alignment of the cell.

• Go to format menu 

• Click on cell

• Choose number tab & select any one number format

• Choose alignment tab & select alignment

• After finishing format click on OK

Rows :- Using this command we can change rows height, hide/unhide row

• Keep the cell pointer 

• Go to format menu

• Click on rows

• Choose height to determine row height

• Click on OK

Column :- This command helps to determine the column width, Auto fit, hide/unhide & also fixed standard width.

• Go to format menu

• Click on column

• Choose any one option

• Choose its value

• Click on Ok

Sheet :- It helps to change sheet name, hide/unhide sheet, define sheet, and define background color.

• Go to format menu

• Click on sheet 

• Choose rename & type its name 

• Choose background to change background effect

• Click on OK

Auto Format :- This option is used to apply automatic style in to the required sheet.

• Prepare data & select it 

• Go to format menu

• Click on auto format, then appear dialog box with different style

• Choose any one style

• Click on OK

Conditional Formatting :- This option is used to set data in selected condition format.

• Fill data & select it

• go to format menu

• Click on conditional format

• Choose any condition as you like

• Click on format option

• Choose any format

• Click on OK

• Click on OK, & then appear data in selected format

Tool Menu

Spelling :- This command is used to check spelling of work-sheet.

• Keep the cell pointer in the beginning of the cell

• Go to tool menu

• Click on spelling, then display spelling dialog box

• Choose any correct word & Click on change button

• After finishing checking spelling click on OK.

Protecion :-

Protect Sheet :- This option is used to secured work-sheet. In this mode Excel cannot allow modifying document.

• Go to tools menu

• Click on protection

• Click on protect sheet

• Type password for protect sheet

• Retype same password to conform password

• Click on OK

Protect Work-book :- Using this command we can protect a work-books structure & window. In this mode excel cannot allows to delete sheet, rename sheet & insert.

• Go to tools menu

• Click on protection 

• Click on protect work –sheet

• Type password to protect work –book

• Retype same password to conform password

• Click on Ok

Goal Seeks :- Goal seek command allows to adjust the value in a specific cell until the formula that is dependent on that cell reaches a target value.

• Keep the cell pointer on the result where must be apply formulas

• Go to tools menu 

• Click on goal seek

• Type target value on ‘to value’ criteria

• Type cell name which value you want to change on ‘by changing cell’

• Click on OK

Formula Auditing :- It helps to auditing the required cell where must be apply formula.

• Place cell pointer where formula apply

• Go to tools menu

• Click on auditing, then display small dialog box

• Choose trace precedents, then show arrow key up to formula

• Choose trace dependents, then show arrow key up to first value cell

• Click on remove arrow to clear arrow

Data Menu

Sort :- This is used to arrange data in ascending or descending order in the selected column of the work-sheet.

• Select required data

• Go to data menu 

• Click on sort, then display sort dialog box

• Choose column & select order

• Click on OK

Filter :- Using this command we can display only defined data of the column.

• Select required cell range

• Go to data menu

• Click on filter & select auto filter

• Then appear drop down arrow on the selected top of the row

• Click on ^^ arrow & choose required value.

Form :- Using this command we can convert selected table data in to form. We can also fill data & delete other unnecessary data.

• Select require data

• Go to data menu 

• Click on form, then display data on form

• Now fill your data

• Click on close

Windows Menu

Split :- This command is used to break windows in to two or more parts. Split command allows working easy in to the large sheet at a time.

• Select entire row where you want to break window

• Go to window menu

• Click on split

• Then display sheet in to two window

• If you want to remove splitting window click on remove split window.

Freezing Window :- This command is used to fix(unmovable) of the some rows & columns of work-sheet. In this mode we can fill data in large table with easily.

• Keep the cell pointer where you want to freeze sheet

• Go to window menu

• Click on freezing window

• If you want to remove this effect, click on unfreeze panes.

Some Mathematical Operations 

• * (asterisk) :- Used for Multiplication

• /(slash) :- Used for division

• +(plus) :- Used for addition

• –(minus) :- Used for subtraction

• >(greater than :- Used for compression

• ∑(Summation) :- Auto sum.