BUSINESS MODELING WITH EXCEL & VBA (VISUAL BASIC)

VBA (Visual Basic for Applications) is a very powerful tool developed by Microsoft which can help you to automate any work within Microsoft Office programs. Over years Microsoft Excel has become the greatest software in the field of electronic spreadsheets. It’s strength meets demands of huge numbers of users worldwide. However despite of it’s advancements there’s an ever-increasing demand of modern business environment most of which can be solved only by VBA.


Your benefits

By the end of the course, participants will be able to:

  • Work with Developer Tab;
  • Understand Excel Macros;
  • Work with VBE (Visual Basic Editor);
  • Record and improve recorded macro;
  • Apply macro to ranges (cells, columns, sheets);
  • Use variables;
  • Manipulate strings;
  • Interact with the user with the help of message boxes and input forms;
  • Use conditions;
  • Loop through complicated data;
  • Work with arrays and optimize speed of execution;
  • Create user-defined functions;
  • Create event macros;
  • Handle errors.

Tutor

 

Emin Asadov (CQF)

He graduated full higher education program, equivalence of master's degree on Mathematical Methods in Economics of Plekhanov Russian Economic University.

 Also he got CQF (Certificate in Quantitative Finance) at Fitch 7 city learning in London.

 He had experience as an Analyst of Games Demand Model working on large, multi-sport event - BEGOC (Baku European Games Organizing Committee). Additional, has over 5 year experience of financial risk management, project management and business analytic, mainly involved automation of reports, modeling and analytics. His background is a mix of Finance, Programming and Mathematics.

 He has been awarded a well-known global certification in Quantitative Finance. There are various fields that are included of his achievements:

 - Winner of International Chess Tournament (France, Cannes);

- Winner of Baku City Chess Championship among juniors;

- Winner of Baku City Olympiad in Mathematics;

- PRM (Professional Risk Manager) Exam II (Mathematical Foundations of Risk Measurement).

Couse Details

  • Training Language: Azerbaijani
  • Duration: 24 hours
  • Start Date: 25.06.2016


Course fee:


  • For Individuals: 240 AZN
  • For Corporate Clients: 270 AZN


What is included:

  • Coffee Break
  • Instruction by an expert facilitator
  • Specialized manual, spreadsheets, sample codes and course materials
  • Personalized certificate of completion


Venue:

  • Samad Vurgun Street, World Business Center 14th floor