The goal of the training is to deliver skills and knowledge on the automation of operations by using macros.
Training is designed for those, who are already using MS Excel on advanced level and wants to broaden their knowledge on more advanced functions and macros creation. This training is especially recommended for people without programming background, but want to learn the basic of Visual Basic for Applications ( VBA ) programming language. Participation on our course will influence the work efficiency by eliminating manual operations on most frequent actions repeated in MS Excel. Within the training program we included: creating simple functions and forms, events handling, advanced built-in functions and their use in everyday work.
One of the most important topics discussed on the course is coding simple macros with the help of recording tool and use of the commands associated with macros coding in VBA environment.
Intermediate level is a participation condition for this training.
Training is held in the form of computer workshops, during which participants exercise the basic VBA functions , by creating macros.
The necessary supplements of the training are given training materials:
- Script, prepared by AkKom specialists, which covers the description of presented issues.
- Set of specially prepared VBA exercises.
Advanced MS Excel
- MS Excel customization
- Keyboard shortcuts
- Creating custom toolbars
- Advanced Paste Special functions
- Custom lists in Excel
MS Excel data connection with other MS Office applications
- References between applications
- Data import and export in MS Excel
Advanced Excel functions
- Logical, financial and array functions
- Data analyzing with pivot tables
- References between sheets
- Worksheet and sheet protection
- Templates creating
- Inspection tools
Simple macros
- Simple macros recording with the macros recorder
- Macro edition in VBA environment
- Adding macros on toolbars
- Adding macros to buttons
VBA in MS Excel
- VBA interface in MS Excel
- Project explorer
- Code editor
- Command window
- Basic VBA environment functions overview
- Toolbars and their usage
- Application working models
Introduction to programming
- Macros - syntax, macros appliance overview
- Function syntax
- Data types and their usage (text, number, logical data)
- Conditional statements
- Case instruction
- For and Do loops
- For - next loop
Handling the macros
- Basic operators
- Applications object
- Workbook object and Workbooks collection
- Worksheet object and Worksheets collection
- Range and selections objects, Cells - Use of the objects for data input on sheets
- Columns and rows properties
- Creating own functions and their use in the sheet
- Dialog boxes
- Code protection, limiting edition and preview
- Errors handling
Zapisz się na interesujący Cię termin szkolenia
There are currently no training dates
