SYLLABUS
Module I
Spreadsheet,Features of spread sheet, MS Excel, Features of MS Excel,, Functions in Excel,, Financial Functions, NPV,IRR,PMT,IPMT, Statistical Functions AVERAGE, MEAN, MEDIAN, AVEDEV CORREL, STDEV,CORREL, STDEV, RANK ,Database Functions DAVERRAGE, DMAX, DMI, DSUM , Graphics in Excel, Business application of Excel, Managerial decision making, Model development, Financial analysis, Break even analysis ,Budgeting & Ratio analysis ,Inventory management, Investment appraisal with Excel, Goal seek ,Pivot table ,Scenario management
Module II
MS Access, Features of MS Access ,Database Design, Creating table in design view ,Creating table with wizard, Creating table by entering data, Form design with access query ,Design query in design view, Query design with wizard, Report design, Report design with wizard ,Report design with design view, Using MS access for business decisions
Module III
Internet, Features of internet, www, E-mail ,telnet ,FTP, News groups ,Search engines ,Portals ,Business application of internet ,Security issues in e-commerce, Security tools and Risk management ,IT act 2000 ,Digital signature, Digital signature certificates ,e-governance ,Electronic records ,Verifying authorities ,Network, appellate ,tribunal ,penalties
