Microsoft Excel - Macros and VBA

( 0 Reviews )

Created by: Ken Puls

Produced in 2017

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Ken Puls's Microsoft Excel - Macros and VBA? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course, you will learn to create powerful macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have your daily spreadsheets running like clockwork to save you hours of time and boost your productivity.Highlights:41 practical tutorials.Understand the differences between macros and VBA.Run your macro from the Macro dialog, a keyboard shortcut or worksheet button.Understand the syntax and structure that make up a valid macro.How VBA Objects and the Objects model relate to each other.Using step vs run in entry level debugging.How to create variables and assign strings, values or objects.Implementing logic tests in VBA.Set up looping with Do loops and Do While loops.Create a VBA Message Boxes.Set up an error trap in VBA to handle errors.Create a User Defined Function (UDF).

Beginner Level

Time: 4h

Instructor Details

Ken Puls

0.0 Rating
0 Reviews

Ken is a Certified Management Accountant (CMA) in Canada, who never remembers life without spreadsheets and computers! Since the late 1990s, he has spent his career in the hospitality and tourism industry, in the finance and IT fields. Ken is currently the Director of IT at a resort on Vancouver Island.