Ms excel and it’s function

Ms excel and it’s function

• 1.
  MS
• 2.
  INDEX  What isMs excel ?  Uses and it’s basic functioning.  How a function can be performed?  Different types of functions available in Ms excel  Financial  Date & time  Maths & trigonometric  Statistical  Lookup& references  Database  Text  Logical  Information  Engineering
• 3.
  Ms Excel isan electronic spreadsheet progr  Excel is an electronic spreadsheet program storing , organizing and manipulating data.  It is basically made for making ,analyzing a data which is in the table format.  it’s screen look like a rectangular table o  small rectangular blank boxes are known  The types of data that a cell can hold inclu formulas.  Just as in math class, formulas are used for involving data contained in other cells.  Excel and other electronic spreadsheets in built in formulas used for common tasks kno
• 5.
  A key forcebehind Microsoft Excel's capabilities is a powerful programming language called Visual Basic for Applications (VBA)which comes standard with Microsoft Excel. Using Microsoft Excel and VBA, a professional can accomplish important tasks like: Rapid analysis and charting Advanced modeling including numerical simulation Automated report generation Problem optimization using Solver and Crystal Ball Software design Team and model integration Database communication and control Project command and control Project constraint monitoring Information command and control Multi-language programming with FORTRAN and C code (DLL's) Real time integration with other applications Data sorting and analysis
• 8.
  USING FUNCTIONS DIALOGUEBOX
• 11.
  Financial Function Financial functionshelp us to calculate complicated problems and interpret huge data. It help to calculate tax rate , income tax , sensex, nifty etc. Following are some important function:  ACCRINT  AMORDEGRC  AMORLINC  COUPDAYS  COUPNCD  CUMIPMT  DDB  DOLLARFR  FV  EFFECT  INTRATE, etc.
• 13.
  Date & TimeFunction Date and time is another category of function that is designed for changing time according to place, it also gives us variety of types in which a Can be written. Following are some of the function under the type ‘date& time’:  DATE  DATEVALUE  DAY  DAYS360  EDATE  EOMONTH  HOUR  MINUTE  MONTH  NETWORKDAYS  NOW  SECOND  TIME, etc….
• 15.
  Maths and trigonometricfunction help us to perform Different functions which may be time consuming in Calculation.