Excel VBA - Advanced Seminar - Conducted in English


Seminar Objective
The seminar is a continuation of the seminar Introduction to Macros & VBA in Excel - Be more Efficient in Excel and is for those of you who would like to learn more VBA than at the introductory seminar. The pace is high and there is focus on more advanced VBA topics, so basic VBA features cannot be expected at this seminar. The seminar gives you inspiration for how to use VBA to streamline your daily work.

The seminar is for Windows PC users - NOT Mac. You must bring a laptop with Microsoft Excel 2016, 2013 or 2010 installed and an extension lead. The instructor uses the UK version of Excel, but you can use a DK version.

Seminar Outline

Using Userforms
• Creating Userforms
• Controlling elements - ActiveX

Arrays
• Dynamic arrays
• Table arrays Variant
• Optimising arrays and memory
• Multi-dimensional arrays

Examples of optimisation with VBA code
• Optimisation of Loops
• System Optimisation
• Using arrays
• Link to other Methods/Procedures

Integration with other Office programs
• PowerPoint and Word
• File system
• Using FileDialogs

Automatic Import of data
• From text (CSV) files
• From Excel files
• Automatic Processing of Imported data

Knowledge Required
You will either have attended our seminar Introduction to Macros and VBA in Excel - Be more Efficient in Excel or have knowledge of VBA at the level of this seminar. We expect you to have basic VBA in place and have knowledge of the following features: Using and Sizing Variables, Using IF and CASE sentences, as well as Using Loops such as For-Each, Do-While, and For-Next. These features will be used at the seminar and your knowledge assumed. It would also be a great advantage if you have worked with VBA after participating in the introduction seminar.

Email
Remember to state your email in connection with the registration. Your email will be given to Jelgren Consult. Your email will only be used in connection with the transmission of educational material.

Catering
There will be served ice water, fruit, sandwiches, mixed soda, coffee / tea and cake

Seminar Provider
Jelgren Consult

If any questions about the contents of the seminar, you can contact Lone Jelgren, Jelgren Consult, phone No. 22 24 00 75 or email lj@jelgrenconsult.dk

Information
  • When

    12. nov. 2018 17:00 - 21:30
  • Where

    Comwell Aarhus, Værkmestergade 2, 8000 Aarhus C

  • Registration Deadline

    9. nov. 2018 - 23:59

  • Organizer

    IEF-Fonden

  • Available Seats

    15

  • Event Number

    327856