excel

excel

1. what is excel?

   • Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

2. what is it used for?

   • It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications.
     • Manage data records
     • Analyse data
     • Create forms and consolidate results
     • Corporate Budgeting

3. excel function examples

   • DAVERAGE Returns the average of selected database entries
   • DATE Returns the serial number of a particular date
   • BESSELI Returns the modified Bessel function In(x)