Course details
Objectives :
- At the end of excel training course , trainees will be able to:-
- Create and use Names in workbooks.
- Use If statement functions , AND, OR, NOT.
- Use Lookup functions.
- Use Database functions.
- Use Goal Seek and Scenarios, Solver, Advanced Filtering.
- Use Data consolidation.
- Use Validation.
- Use Pivottables.
- Use Charts .
- Use Macros.
Contents :
- NAMES: Defining Names, Creating Names Automatically, Managing Names, Using Names, Go To, Names In Formula, Applying Names .
- FUNCTIONS: If Statements, AND, OR, NOT .
- Other useful functions: ISERROR , IFERROR, COUNTIF, AVERAGEIF , AVERGEIFS, SUMIF, SUMIFS, COUNTIFS , upper , lower case , left , mid, right, round, concatenate, text to columns .
- LOOKUP functions.
- LookupVector Lookup, Hlookup , Vlookup , Nested Lookups .
- Data consolidation.
- Goal Seek and Scenarios, Solver, Advanced Filtering.
- Validation, List, Custom .
- Database Functions.
- Pivottables (create, delete, modify).
- Charts.
- Auditing, Tracers - Precendents and Dependants, Watch Window.
- Macros.
Course Location
About Institute of Banking Studies
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- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- JOD 35Duration: 1 To 2 Months
- Microsoft Teams for Managers One EducationJOD 18
JOD 397Duration: Upto 2 Hours
