Welcome to IFTA Computer Learning Academy

T1,3rd Floor,Navlakha Complex, Above Chate Class,Near Tiranga Hotel,Paud Road,Kothrud,Pune-38

 


Advance Excel

Course Name: Advance Excel Duration: 15 Days.
  • Advance Excel is designed with the intention of providing advance use of excel and use of maximum formulas and functions in Excel.
  • You will be perform all Management Reporting and deriving financial and analytical reports.
Prerequisite
  • Basic Excel
Course Content
  • Excel Pivot Table.
  • Excel Cell Validation.
  • Excel Creating Chart.
  • Excel Goal Seek.
  • Excel Macros.
  • Excel Page Break Preview, Page layout.
  • Excel With Column and Row Freeze.
  • Excel protect sheet, protect work Book
  • Excel Functions
  • Text Functions
  • UPPER
  • LOWER
  • PROPER
  • EXACT
  • TRIM
  • RIGHT
  • MID
  • FIXED
  • FIND
  • REPLACE
  • SUBSTITUTE
  • Mathematical Functions
  • INT
  • MOD
  • ROUND
  • POWER
  • PRODUCT
  • EVEN
  • QUOTIENT
  • ODD
  • SUM & SUM IF
  • SUM PRODUCT
  • COMBINE
  • ROUND UP
  • EVEN
  • TRUNK
  • MROUND
  • ABS
  • SIGN
  • PI
  • MEDIAN
  • Date Functions
  • DATE
  • DATE IF
  • DATE VALUE
  • 360
  • EDATE DAY
  • DAYS
  • EO MONTH
  • HOUR
  • MINUTE
  • MONTH
  • NETWORK  DAYS
  • NOW
  • SECOND
  • TIME
  • TIME VALUE
  • TODAY
  • WEEKDAY
  • YEAR
  • YEARRAC
  • Financial Functions:
  • PMT
  • PV
  • FV
  • IPMT
  • PPMT
  • RATE
  • DB
  • IRR
  • NPV
  • ROI
  • Data based
  • DAVERAGE
  • DCOUNT
  • DGET
  • DMAX
  • DMIN
Note
  • We will cover additional features and functions in excel apart from mentioned above as it is not possible to enumerate the complete list of functions
  • Additional features and formation of Project report only from point of view of Excel Function will be covered in this syllabus.

TEAM IFTA LOGIN

News and Announcements

Recent Visit of Mr Pohare To IFTA Computer Learning Academy, Pune Click here