C.E.K. - Centro Educacional KBee

COURSE

Excel VBA is widely used to automate repetitive tasks in Excel. Excel is used in business in a large number of applications, including creating graphs from a database entry or creating and formatting reports from a raw set of unformatted data.
This course aims to help you automate routine tasks through Visual Basic for Applications (VBA code) for Microsoft Excel.
And because macros are a threat in information technology, this course has an educational component and takes an approach to how we can adopt to protect systems.
With this tool it is possible to create methodologies that allow to secure the data and with that to prevent attacks.

Recipients

This course is intended for those who wish to acquire advanced knowledge in Excel through programming in Visual Basic for Applications and to learn the techniques of security.

Prerequisites

You do not need prior knowledge of Excel or Visual Basic for Applications (VBA) macros. However we recommend that you already have some knowledge of Excel.
Note: This course is designed to focus on the programming aspects of Excel, especially macro and Visual Basic for Applications (VBA).

Program

Know Excel VBA; Procedures; Use variables; Functions in VBA; Use Excel objects; Programming Techniques; Create Custom Forms; Schedule UserForms; Automatic initialization; Handling of errors; Why macros can do potentially dangerous things; Macro viruses in action; How Microsoft Office protects against macro viruses.

Duration/Dates/Hours

Duration: 20 hours of training
Dates: Upon request
Time: On Request

Price

180 Euros + IVA

Certification

Professional Training Certificate

Notes

The courses are confirmed with a minimum of 4 participants, maximum of 8.

Sign up!

Because Knowledge is the key
to Security!

Thanks for getting in touch with us, we will respond soon!

Name*

last name*

Email*

Phone*

Training Shift*
Morning
Post work

Mensagem

Note: In accordance with Data Protection Regulation (EU) 2016/679, the above information will only serve the purpose described: it will be possible to provide information on the request intended by the digital channel to individuals and companies. In addition to pressing the submit button, the user, as owner of the information, grants the ScorpionBonus controller the data processing for the purposes indicated above. Any request to update or remove your personally identifiable information may be required by contacting the company directly or by using the contact form on the ScorpionBonus website, indicating the subject "change or removal of personal data".

MACROS & VBA Programming with COMPUTER SECURITY methodologies

Sign up!