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