TUTORIALS

Basic Concept of Excel 

Cell Names

Pressing Tab moves the cursor to the next cell on the right, Enter moves it to the next cell down, Shift + Tab moves it to the next cell on the left. You can also shift the cursor with the arrow keys and the Home, End, Page Up, and Page Down keys. Use the Ctrl key with the arrow keys to move the cursor the maximum distance. You can also move the cursor into a new cell by typing the cell address in the Name Box. Double-clicking on a cell wall moves you to the edge of a row or column of data.

Entering Characters, Dates, and Numeric Data 

Select a cell. Enter text or numbers by typing in the cell, or in the formula bar that is centered directly above the worksheet. Enter dates as mm/dd or mm-dd for the current year. Enter the date as either mm/dd/yyyy or mm-dd-yyyy for other years.

 Auto Sum Formula    (click)

                                         

     -Sum 
     -Average
     -If
     -Hyperlink
     -Count
     -Max
     -Min
     -Sin
     -Sum If
     -Pmt    


  Financial Formula (Click)
     -Accrint
     -Accrint
     -Amordegrc
     -Amorlinc
     -Coupdaybs
     -Coupdays
     -Coupdaysnc
     -Coupncd
     -Coupnum
     -Couppcd
     -Cumipmt
     -Cumprinc
     -Db
     -Ddb
     -Disc
     -Dollarde
     -Dollarfr

  Logical Formula (Click)
     -And
     -False
     -If
     -Iferror
     -Not
     -Or
      
  Text Formula (Click) 
     -True
     -Bahttest
     -Char
     -Clean
     -Code
     -Concatenate
     -Dollar
     -Exact
     -Find
     -Fixed
     -Left
     -Len
     -Lower
     -Mid
     -Proper
     -Replace
     -Rept
     -Right
     -Search
     -Substitute
     -T
     -Text



 Date And Time Formula(Click)
    -Date
    -Datevalue
    -Day
    -Days360
    -Edate
    -Eomonth
    -Hour
    -Minute
    -Month
    -Networkdays
    -Now
    -Second
    -Time
    -Timevalue
    -Today
    -Weekday
    -Weeknum
    -Workday
    -Year
    -Yearfrac



 Lookup And Reference Formula (Click)
    -Address
    -Areqs
    -Choose
   -Columns
   -Getpivotdata
   -Hlookup
   -Hyperline
   -Index
   -Indirect
   -Lookup
   -Match
   -Offset
   -Row
   -Rows
   -Rtd
   -Transpose
   -Vlookup



   Math And Tring Formula (Click)
  -Abs
  -Acos
  -Acosh
  -Asin
  -Asinh
  -Atan
  -Atans
  -Atanh
  -Ceiling
  -Combin
  -Cos
  -Coh
  -Cosh
  -Degrees
  -Even
  -Exp
  -Fact
  -Factdouble
  -Floor
  -Gcd
  -Int
  -Lcm
  -Atan2
  -Ln
  -Log
  -Log10
  -log10
  -Mdeterm
  -Minverse
  -Mmult
  -mod
  -Mround
  -Multinomial
  -Odd
  -Pi
  -Power
  -Poduct
  -Duotient
  -Radians
  -Rand
  -Randbetween
  -Roman
  -Round
  -Rounddown
  -Roundup
  -Seriessum
  -Sign
  -Sin
  -Sinh
  -Sqrt
  -Sqrtpi
  -Subtotal
  -Sum
  -Sumif
  -Sumifs
  -Sumproduct
  -Sumsq
  -Sumx2my2
  -Sumx2py2
  -Sumxmy2
  -Tan
  -Tanh
  -Trung
  -Trunc