MS Excel for the financial and banking sector – advanced level

MS Excel for the financial and banking sector – advanced level

Course presentation

MS Excel is one of the most used applications in business, thanks to the facilities they offer for managing and analyzing data, the friendly and intuitive mode of operation. As a result of the permanent link with the financial and banking environment and analysis of the demand made by employees in the sector, RBI provides an interactive course, with many models and case studies relating to the current activity of an organization. Participants will acquire advanced techniques for working with formulas, functions, databases, pivot tables, data analysis and use of collaborative facilities offered by the Excel environment.

Target group

The course is aimed at people who use applications to specific companies that want to use the Excel product at a professional level, managers and employees from all departments.

Minimum admission requirements

Participation in this course assumes basic knowledge of operating with MS Excel.

Objectives

  • identification of problems in the current activity that can be solved with the help of Excel instruments;
  • presentation techniques for analysis and synthesis of data for the purposes of performance reports;
  • the use of audit instruments to verify the data and formulas in the spreadsheets;
  • using scenarios for substantiation of decisions;
  • automation of routine operations using macros;
  • the use of Excel in multiuser environments.

Content

  • Data Editing: using references and names of cells and fields, advanced data formatting, conditional formatting, creating and updating links between data from spreadsheets, creating and using templates;
  • Excel Functions: date and time functions, mathematical, statistical, financial, text search and reference, logical databases; nested functions;
  • Data management: sorting and filtering, splitting a column into parts, removing duplicates;
  • Validation and data audit;
  • Synthesis and data analysis: simple and nested subtotals, data consolidation, pivot tables and pivot charts;
  • What-if analysis: data tables, scenarios, solving a problem with a result set using the Goal Seek;
  • Graphics: choosing the right type of graphical data representation, advanced formatting, graphs, data analysis using graphical representations;
  • Automating routine operations using macros;
  • Working collaboratively in the Excel environment: sharing files, comparing and merging files in a single copy, change tracking, data protection, and Excel files.

Duration and period

The course has a duration of 16 hours of practical/theoretical instruction and takes place in:

 September 16 – 19, 2019,between 16:00 – 20:00

Lecturer

Luciana BERCEAN is an authorized trainer with more than 8 years experience in delivering IT courses, specialized in Microsoft Office suite programs: Word, Excel, Access, PowerPoint and Outlook. She has important certifications in the field: Microsoft Certified Trainer (MCT), Microsoft Office Specialist Expert Excel 2016, ECDL expert.

Duration and period

The course has a duration of 16 hours of practical/theoretical instruction and takes place in:

October 9, 10, 16, 17, 2019, between 16:00 – 20:00

Lecturer

Luminiţa CIOCARU – Coordinator of the ECDL Test Center within the Romanian Banking Institute since 2015.

Graduated the Bucharest University – Physics Faculty, post-graduate studies, specialization: Computer Science/Informatics, Data Bases master degree, accredited examiner in IC3-Certiport-Microsoft, mentor and accredited formator. She has over 10 years’ experience as IT formator; she is also author of books and training programs in the Information Technology. She has numerous certifications in this domain: ECDL examiner permit, Expert ECDL, Oracle formator – Database Desing & Programming with SQL/PLSQL.

Certification

At the end of the course, participants will be given a certificate, issued by RBI (under the aegis of the founding members: NBR and RBA).

Students who also want an international certification may opt out at the end of the course for the ECDL testing (European Computer Driving Licence), the Excel module, within the accredited ECDL Test Centre of the RBI, by paying an additional fee.

Contact person

Roxana IVAN
Administrator formare, IBRemail: roxana.ivan@ibr-rbi.rotel: 0748 886 839
 

Name*

Institution

Department

Position

Phone number*

Fax

E-mail*

Course*

Comments


Formular de contact

Name*

Institution

Department

Position

Phone number*

Fax

E-mail*

Course*

Comments