ICMS Computer College The Oldest and Largest Computer Education Institute in Mirpur

Special Course: MSExcel under Windows

MS EXCEL

(MICROSOFT EXCEL)

 ICMS COMPUTER COLLEGE         ICMS COMPUTER COLLEGE

(DIRECTOR, COMPUTER DIVISION.

* WHAT IS MS-EXCEL ?   

   =>  MICROSOFT EXCEL (MS-EXCEL) IS A ONE KIND OF SPEED SHEET ANALYSIS  PROGRAMME . IT ALSO CALLED ONE KIND OF ACCOUNTING SOFT WARE.           

 * HOW MANY COLUMN AND ROW IN A WORK SHEET ?

   => IN MS-EXCEL  PROGRAMME THERE ARE 256 COLUMNS AND 16384 ROWS IN A WORK SHEET.                                                                                          

*  HOW MANY SHEET ARE THERE IN A WORK SHEET ?

     => NORMALY THERE ARE 16 SHEETS IN A WORK SHEET .

HOW TO START MS. EXCEL

TYPE  WIN  AS FOLLOW

C:\> WIN

SELECT  MS.EXCEL THEN  PRESS  ENTER   OR   DOUBLE CLICK

 OR CHOOSE FROM START MENU, OR CHOOSE FROM YOUR DESKTOP ICONS.

   A                         B                         C                            D                                       E

ITEM                H.PRICE       B.PRICE         VAT(5%)                       PROFIT

COMPUTER      25000               35000               =C2*10% (Press Ent.)    =C2-B2-D2  (Press  Enter.)

PRINTER          12000                16000

FAN                   15000               30000

SONY TV.(21")  27500               35000

SONY  VCP.     20000                25000

SONY  VCR.     28000                35000

NOTE:-H.PRICE =HOLE SALE PRICE

             B.PRICE =BUYING PRICE

Put Cursor  in"E1" Cell, Then

Edit                  = Click

Copy                = Click

Block the Cell  which you would like to Copy formula  then

Edit                  = Click

Paste                = Click

File                   = Click

Save                 = Click

Type a file Name (ANIK)

Ok                    = Click

Ok                    = Click

File                     = Click

Close                  = Click

File                     = Click

Exit                     = Click

Flie                     = Click

Exit windows     = Click

Ok                      = Click.

A                   B                 C                  D                   E                          F

ITEM            QNTY.      U.PRICE      S.TOTAL      DAMAGE         G.TOTAL

 Pen               200           300               = b2*c2  ¿        20                        = (B2-E2)*C2 ¿

 Book             400              350                   = b2*c2  ¿        30                        = (B3-E3)*C3 ¿

 Ink                700              600                   = b4*c4  ¿        40                        = (B4-E4)*C4 ¿

NOTE:    QNTY. = QUANTITY.          U.PRICE  =UNIT PRICE.                S.TOTAL = SUB TOTAL. 

G.TOTAL= GRAND TOTAL.

PLACE THE CURSOR WHICH   COLUMN YOU WANT TO WIDTH     THEN

Format              = Click

Column             = Click

Width               = Click

Ok                    = Click  (Normal  Size  8.43)

OR,

Move the Cursor in the joining point Column  A and B  / B and C/  C and D  Etc, then drugging  the Mouse

PLACE THE  CURSOR  WHICH    ROW  YOU  WANT  TO HIGHT     THEN

Format              = Click

Row                 = Click

Hight                = Click

Ok                    = Click  (Normal  Size  12.75)

                                                                       ¯

BLOCK The Text  by Pressing  Shift + ®  ¬ Arrow Key  

                                                                     ­

  †jLvi cÖ_‡g Kvm©vi †i‡L Shift †P‡c hZUzKz Block Ki‡ev  Zvi †k‡li Cell  G  Mouse Click  Ki‡j ZZUzKz  Block n‡e |

  PLACE THE  CURSOR  WHICH    COLUMN YOU  WANT  TO HIDE     THEN

Format              = Click

Column = Click

Hide                 = Click

Format              = Click

Column             = Click

Unhide              = Click

PLACE THE  CURSOR  WHICH    ROW  YOU  WANT  TO HIDE     THEN

Format              = Click

Row                 = Click

Hide                 = Click

Format              = Click

Row                 = Click

Unhide              = Click

First Block The Text then

Edit                  = Click

Copy                = Click

Then Move The Cursor where you want to copy

Edit                  = Click

Paste                = Click

First Block The Text  then

Edit                  = Click

Cut                   = Click

Then Move The Cursor  where you want to move

Edit                  = Click

Paste                = Click

A               B              C              D                   E                       F

NAME     BASIC     HRENT   MEDICAL   TAX                 SALARY

Sunny           6000      =b2*.4¿     =b2*.1¿        =b2*.1 ¿        =Sum(b2:d2)-e2¿

Rony           6500                                                                                                              

Mitu            7000               

Titu             7500

Himu            8000

Sony             7500

Sweety          5500

Block the Text

Format              = Click

Cells                 = Click

Custom             = Click

Select    Format codes

0.00                  = Click

Ok                    = Click

Block the Text

Format              = Click

Cells                 = Click

Format  codes

General             = Click

Ok                    = Click

First Block The Text

Format                           = Click

Cells                               = Click

Font                               =  Click

Color                             = Click   (Select any Color )

OK                                 = Click

TO CALCULATE ( SUM / SUBTRACT / INTO / DEVIDED )

‡hvM Kiv:

A           B        C         D

22        55            50            56

23        34            40            60

12        26            59            75

======================

†h Column Gi †jLv †hvM    Kie †mB  Column Gi bx‡Pi Cell G CURSOR ‡i‡L= A1+A2+A3 ¿

A_ev

 A

 34

 37

 58

 65

 70

 85

====

 Place the Cursor Pointer here then        S = Click  from toolsbar

wbw`©ó wKQy msL¨vi †hvMdj †ei Kiv

A

10

12

15

16

20

25

28

===

Place the Cursor Pointer here then        =Sum( A1,A3:A5,A7)  ¿

we‡qvM Kiv: 

   B

 950

 320

===

Place the Cursor Pointer here then        =B2-B3  ¿

¸b Kiv :

   B

200

  50

====

Place the Cursor Pointer here then        =B2*B3  ¿

fvM Kiv :

  B

550

  11

===

Place the Cursor Pointer here then        =B2/B3 ¿

Tools                = Click

Protection            = Click

Protect sheet     = Click

Enter  Protection Password       : ICMS

Ok                    = Click

Re-enter Protection Password  : ICMS

Ok                    = Click  

Tools                = Click

Protection            = Click

Unprotect Sheet = Click

Enter unprotect password : ICMS

OK                   = Click 

Name               Basic               Basic               Name               Basic

ADDITA          7800                 6000

ADRITA          5000

SUDIPTA        6000

SUDIP               6000

SUPTI                5000

SUSMITA        6000    

SHAMEEM      5600    

NAHID            6000

ANIK                 8000

BADHAN              6000

ANAMIKA            8000

ANAL                     8000

AMIO                     6000

SUZANA                7800

Data                             = Click

Filter                             = Click

Advance Filter              = Click

Copy to another Location  = Click

List Range                    = A1:B14

Criteria Range               = C1:C2

Copy to                         = D1:E1

OK                               = Click

File                   = Click

Page Setup             = Click

Landscape            = Click 

FILEOPEN

File                   = Click

Print Preview            = Click

Print Preview  ‡_‡K ‡ei n‡Z n‡j

Close                = Click

View                       = Click

Zoom                      = Click

75% or 100%         = Click

OK                         = Click

†jLv‡K  Block  Kiv

Format             = Click

Cells                 = Click

Font                   = Click (Size ¯­ ‡P‡c  msL¨v Select  K‡i

OK                   = Click

cÖ_‡g GKwU Salary Sheet OPEN K‡i  Block K‡i wb‡Z n‡e

Insert                = Click

Chart                = Click

On This Sheet            =Click

Chart Wizard Menu 

Next                 = Click

3-D Column            = Click(select any One )

Finish                = Click

wewfbœ fv‡e Chart ‰Zix

Chart  ¯  Click

Format              = Click

Row                 = Click

Height              = Click

Row Height            = 20 Type

Ok                    = Click

Row   ¯^vfvweK Aem_vq Avb‡Z n‡j

Format              = Click

Row                 = Click

Auto Fit                        = Click

Format              = Click

Column             = Click

Width               = 8.43   Gi ¯’‡j 30 wj‡L

Ok                    = Click

Column  ¯^vfvweK Ae¯’vq Avb‡Z n‡j

Format              = Click

Width               = Click

Standard Column Width = 8.43

Ok                               = Click

cÖ_‡g  1 wj‡L hZUzKz RvqMvq msL¨v PvB ZZUzKz K‡i wb‡Z n‡e | Zvici

Edit                  = Click

Fill                    = Click

Series               = Click

Step Value            = 1

Stop Value            = 20

Column / Row            = Click

Ok                    = Click

            A                                             B

(1) Amount                                          5000

(2) Year                                                5

(3) Interest                                          15%

(4)

(5) Amount                                          Interest

(6) 5000                                              + B1*B2*b3

(7) 6000                                                           

(8) 7000

(9) 5000

(10) 9000

A6   ‡_‡K    B10   ch©bZ Block  K‡i

Data                             = Click

Table                            = Click

Column Input Cell      = B1

Ok                                = Click

            A                                 B                      C                     D                     E            F

(1) Amount                              6000               

(2) Year                                   6

(3) Interest                              18%

(4)

(5) Amount                              Year

(6) +B1*B2*B3                          6                    10                  20                  30            40

(7) 7500

(8) 8000

(9) 6000

(10) 12000

A6   ‡_‡K   F10   ch©bZ Block   K‡i

Data                             = Click

Table                            = Click

Row Input Cell              : B2  wj‡L Tab †P‡c

Column Input Cell      : B1

Ok                                = Click

BLOCK THE DATA   THEN

Data                               = Click

Sort                              = Click

†h †Kvb  Field Select K‡i

Ascending                     = Click

Or

Descending                   = Click

Ok                                = Click

†h †Kvb Kjvg‡K  Screen-G a‡i ivL‡Z PvB‡j cÖ_‡g †h KjvgUv a‡i ivL‡Z PvB Zvi cv‡ki N‡ii cÖ_g †iv‡Z (2ND COLUMN 1ST ROW ) Kvm©vi †i‡L wb‡æv³ KgvÛ w`et-

Window                        = Click

Freeze Panes`               = Click  

Avevi hw`  †Kvb †iv‡K a‡i ivL‡Z PvB Zvn‡j cÖ_g Kjv‡gi wØZxq †iv‡Z Kvm©vi †i‡L -

Window                        = Click

Freeze Panes                = Click

hw` Freeze Kiv †iv A_ev Kjvg‡K  Unfreeze Ki‡Z PvB Zvn‡j wb‡Pi KgvÛ e¨envi Kie t-

Window                        = Click

Unfreeze Panes                        = Click    

[Back to Contents Page]

What's New   | News  | Programmes  | Courses  | Projects  | Publications  Join Us  | Contact Us  |Home|