ONLINE Business Excel VBA Training | Automation in Excel | Optimization

VBA in Business Microsoft Excel – ONLINE

[Online] 2nd, 3rd, 4th and 5th of June
ABOUT TRAINING

Why is Microsoft Excel using VBA useful in the actual context?

Companies are repositioning their operations in order to adapt to the changes generated by the spread of coronavirus. Nobody knows how the situation will evolve in the following period, but for sure the economical decrease due to quarantine period will make it's presence felt.

Process automation is a clever way to save resources without making budget cuts. Business Microsoft Excel using VBA training offers users specific know-how that empowers them to automate Excel tasks that imply a large data quantity and require important time spans to be processed.

In this course the participants will learn what is, how and when VBA is used, along with a series of practical examples and key technical notions (the concept of object and object collection, macros, variables and constants, data types, the use of arrays data, control of program flow and decision making, defining and running UDF user-defined functions, managing and dealing with VBA errors, interacting with the user through UserForms, using text boxes, command buttons, combo boxes and other controls).

Microsoft Excel Business using VBA training is suitable for advanced Excel users who want to take advantage of the present moment in order to go to the highest level of automation of activities and processes that are carried out repetitively or frequently in Excel.

BENEFITS

What do you gain as a participant in the first module?

   ✓ Automate actions performed repeatedly or frequently in Excel by defining VBA procedures and functions.
   ✓ Optimization of data analysis and reporting through automatic procedures.
   ✓ Acquiring the skills to control the execution of the VBA code, by using decisive and repetitive structures.
   ✓ Getting started with using VBA in Excel, Excel object model, object concept and object collection.
   ✓ Recording and running the first macro - the Visual Basic Editor (VBE).
   ✓ Defining and running user defined functions (UDFs) with one or more arguments in VBA.
   ✓ Error management in VBA, types of errors and methods of preventing them.
   ✓ Using dialog boxes, events and methods, designing UserForms.
   ✓ Using text boxes, control buttons, combo boxes and other controls.
   ✓ Case studies, concrete and applicable examples, individual and group exercises, customized solutions to participants' requirements.
 

What do you gain as a participant in the second module?

   ✓ Advanced automation of actions performed repeatedly or frequently in Excel through VBA procedures and functions.
   ✓ Analysis of how participants implemented VBA in their own activity.
   ✓ Development of applications for the automation of advanced business processes.
   ✓ Advanced VBA programming techniques.
   ✓ Managing files and collections of worksheets in VBA.
   ✓ Optimization of data analysis and reporting through automatic procedures.
   ✓ Generating and processing pivot tables in VBA.
   ✓ Interactions with other applications in VBA.
   ✓ Consultancy from the trainer on the implemented techniques.
   ✓ Case studies and concrete and applicable examples, individual and group exercises, customized solutions to participants' requirements.
TESTIMONIALS
INVESTMENT AND ORGANIZATION

Trainer - Alexandra Cernian

Alexandra is a lecturer at the Faculty of Automation and Computers ("Politehnica" University of Bucharest) since 2007 and holds a doctoral degree in Systems Engineering. He has gained significant experience in teaching and research programs in various fields, such as: Artificial Intelligence, RPA, Information Technology, Business Intelligence, Data Mining and Machine Learning. Through her teaching style, Alexandra manages to transform complex and technical digital applications into an interesting learning journey, easy to discover and oriented towards concrete results, while also providing participants with tools that could be easily applied in different corporations.

Alexandra is an expert evaluator in the field of digital innovation for the European Commission under the Horizon 2020 Small and Medium Business Instrument Program. She has participated in numerous national or international projects. Alexandra has over 10 years of experience in training and consulting for process optimization and digital transformation of organizations. As an instructor for functional skills, he has collaborated with more than 75 companies in which he has conducted more than 500 training sessions/workshops. In the Brightway team, Alexandra is the project coordinator that involves the development of digital skills, process automation and the use of software for business intelligence.

 

Investment

The investment is 580 EUR + VAT and includes both modules. Individuals receive the VAT value as a discount. The investment is recovered with the first working processes optimized following the course.  

** The fee includes: support for e-mail implementation after training for 3 months, the workbook, 4 lunches, 8 coffee breaks, buffet with pastries.
** To participate you must have a laptop with Microsoft Excel (version 2010, 2013 or 2016) installed.
** We recommend the use of a laptop with Windows operating system during the course.
 

Time & Location

The training is held on the 25th-26th of March (the first module) and on the 29th-30th of April (the second module), between 09:00 and 18:00, at Hanul cu Tei, Lipscani Street, no. 63-65, Bucharest.

 

REGISTER FORM
Individual authorized person
Legal entity
Select number of persons:
I declare that I agree with the collection of my personal data (according to the GDPR regulations) by Brightway (Inspire Business Solutions SRL) in order to use them in the registration process and in all the activities related to this process.
I would like to receive new information regarding future events, available offers and other personal and professional development opportunities.
SUBSCRIBE NOW TO
OUR NEWSLETTER
Stay connected with us and receive the news that interests you.
SUBSCRIBE
Facebook LinkedIn Instagram Twitter
Brightway.ro
Programe de dezvoltare organizațională și soluții inovatoare care te ajută să câștigi timp, bani și înțelepciune.
Strada Popa Nan, nr. 171, Bucuresti
0745 755 484
BUCURESTI
030584
ROMANIA
mihai.arghire@brightway.ro
  1. VBA in Business Microsoft Excel – ONLINE