VBA coding(1 Day Course)
WHAT IS THIS COURSE ABOUT?
We can explain to you that you will get an certification, or SETA or any other accreditation you can think off. But we are not here to simply give you a paper. We believe that there is a great gap in todays working environment where we use so much of excel, but know so little.
In this course we show you how VBA coding works and take you through a few interest codes.
WHO SHOULD ATTEND THIS COURSE?
You should have a good understanding of formula use in excel. Good practical knowledge is must before attempting this course
Anyone, in any business can attend. Engineers, financial and admin people see a great improvement in their work after this course.
CONTENT OF THIS COURSE?
Here is a list of the topics covered in this course;
- Basics of VBA coding
- Where to start
- How to write your own codes by using macro recording
- Buttons
- Shortcuts
- Userforms
- Making your spreadsheets look like a program
- Protection and unprotection through macros
- Extracting information from multiple files in multiple locations
- How to help yourself
PRICING
Becuase of the complexitiy of this course, we can only attend this on a Saturday. There is not a lot of people in South Africa that has this knowledge so we can only book this on a Saturday. The price for this course is R2,000.
OTHER
We also encourage you to bring along you spreadsheets so that we can go through them to see where you can apply what you have learned
By the end of this day, you will so much tools to improve yourself. You can go test and make your work great and let other people think you are amazing. You can also let your employees do what you employed them for.
Please send us any problems and questions you have after the workshop. We will gladly assist you for free.
Please discuss with us before if you want to anything to be added to the content.
BOOKING
If you are interested or need more details regarding this workshop please fill in the form below and we will contact you. Alternatively email us: Heinrich@31bestofexcel.com
Other Courses
- Basic course
- Intermediate course
- Advance course
- Modelling course
- Convert from excel 2003 to 2007
- Spreadsheet development/fixing
- Reconciliations course
- One-on-One tutoring
