Sunday, 14 August 2016

MS EXCEL IS A SPREADSHEET PROGRAM THAT IS USED TO MANAGE ANALYASICE AND PRESENT DATA .

IMPORTANT USE OF FORMULA IN EXCEL
                           OF IMAGE
           MS OFFICE OF APPLICATION
                        MS-EXCEL 2013

  • MS-EXCEL 2013 EXTENTION NAME   ,XLSX 

 STARTING DATA
  1. RIGHT CLICK ON DATA -EXCEL WORKSHEET 
  2. WIN+R= EXCEL
  3. START - ALL  PROGRAM- MS OFFICE 2013-MS EXCEL
  4. AN EXCEL FILE IS CALLED A WORKSHEET BOOK  NEW WORK DOOK BOOK SHEET CONTAIN ONE BLANK WORKBOOK SHEET .    
  •                            FORMULA OF  MOST  IN EXCEL
  • vlookup  formula with Exaple 
  • percentage 
  • rounding 
  • med
  • min
  • insert chart 
     












No comments: