Objectives :

  • Enable participants to discover the application's capabilities while working through exercises to create simple worksheets.
  • Learn how to use functions efficiently in work.
  • Learn how to automate common tasks.
  • Learn new skills & techniques and how to solve your problem in multi different ways.

Contents :

  • Sort.
  • Filter.
  • Sum , sum-as-running-total.
  • Autosum shortcut key.
  • Average.
  • If.
  • And.
  • Count, counta , countblank , countif , countifs
  • Sumif , sumifs
  • Vlookup , Hlookup .
  • Lookup (vector).
  • Sumproduct.
  • Concatenate.
  • Match.
  • Index.
  • Right , left.
  • Mid , len , upper
  • Lower.
  • Proper.
  • Min , max .
  • Round , rounddown , roundup .
  • Trim.
  • Trunc.
  • Month , year.
  • Now , today.
  • Pivot table.
  • Show all formula.

The Central Bank of Jordan began in 1965 to study the necessary means of setting up a team for theoretical and practical training aimed at promoting human cadres of the banking and financial sector and study its employees needs and satisfy their desires to advance their scientific and practical abilities . These efforts culminated in the creation of the Institute of Banking Studies in accordance with Article (37) Paragraph (d) of the Central Bank of Jordan Law and in accordance with the Institute,s Articles of Association No. (69) issued on 1970. The Institute   was   officially   inaugurated on   October 9, 1971 and was housed then at the Central Bank,s premises.

In the early 1990,s , the  Institute  witnessed a new stage ; the construction of the Institute,s permanent   headquarter   in  Tla,a  Al  Ali ,  a suburb of the capital  Amman . The complex was constructed on an eight dunums plot of land and comprised of administration units, academic and training activities halls, library, laboratories, cafeteria, health clinic and a multipurpose hall. Also , the Institute has two branches, one in Irbid and the other in Aqaba.  The purpose of  these  branches is to widen the distribution of academic and training activities conducted  by the Institute to cover the various regions of the Kingdom.

See all Institute of Banking Studies courses

Contact information not available.

Courses you can instantly connect with...
Advanced Excel 2010 Institute of Banking Studies Banking and Financial Applications of MS Excel and Eviews Institute of Banking Studies Advanced Excel 2007 Institute of Banking Studies

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or