What You'll Get
Microsoft Excel Macros and VBA
Using video tutorials and written course materials, GoSkills brings the Microsoft Excel Macros and VBA program to teach students the ins and outs of the software. With the help of 41 practical tutors, students—from intermediate to advanced—zoom in to Microsoft Excel to get a closer look at what it means to be knowledgable and efficient with marcos and VBA, and how to use these tools as effectively as possible. Here’s more about what to expect:
- The differences between macros and VBA
- Run macro from the Macro dialog, keyboard shortcut or worksheet button
- Understand syntax and structure that make up a macro
- The relation between VBA objects and the objects model
- Using step vs run in entry level debugging.
- How to create variables and assign strings, values or objects
- Implementing logic tests
- Set up looping
- Create VBA message boxes
- Set up an error trap in VBA
- Create User Defined Function (UDF)
The Fine Print
Promotional value expires 90 days after purchase. Amount paid never expires. Limit 1 per order. Online only. Must activate by expiration date on your voucher; course access expires 12 months from activation date. Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
About GoSkills
Career advancement is often about having the right skills, and GoSkills.com helps you acquire just the right ones based on your personal goals. The site's courses cover skills used in almost every business, including Excel spreadsheets, PowerPoint presentations, effective business writing and project management, relaying the essentials of each topic through an in-depth, personalized curriculum.
In each course, a series of learning modules cycles through exercises, quizzes, and high-definition video tutorials that last no more than six minutes. Along the way, GoSkills maps your strengths and weaknesses to cater lessons to where you need instruction most. You can take a skills assessment before, during, and after the course to monitor your progress from start to finish. Upon completion, you receive an accredited certificate to include with your CV or résumé (accredited by CPD UK).