Loading...

Course Description

Microsoft Macros and VBA Level 2 continues from Level 1 exploring the advanced features of VBA programming.

Students will learn how to write programs that control Microsoft Excel. You will receive dozens of example macros that will provide you with practical, business-oriented tools that you can use right away to improve your productivity.

Course Details

Instructional Delivery

  • Face-to-face in a lab

Registration

Registrations within 24 hours of course start time must be made by phone (403-220-2866).

Course Content

Course Level Learning Outcomes

Upon successful completion of this course, you will be able to:

  • Create user form controls, populate controls with data and validate data into ActiveX controls
  • Fill data in to a list box or combo box using loops
  • Create a multipage control in user form
  • Validate the user inputs using methods and functions
  • Parse control values back to a spreadsheet and parse range values to the user form controls
  • Use option buttons and check boxes in forms
  • Apply different types of decision structures in VB coding
  • Launch forms using procedures
  • Control pivot tables using ActiveX controls
  • Debug and analyze the various types of errors associated with code design

Topics of Instruction

Forms

  • Work with Forms and Controls
  • Understand Controls
  • Add Functionality to Forms
  • Work with Control Appearance
  • Set the Tab Order
  • Populate a Control
  • Add Code to Controls
  • Launch Forms from Procedures

Understanding Conditional Loops

  • Working with Do-While loops
  • Working with Do- Until Loops

Workbook, Worksheets and Databases

  • Using Worksheets, Workbook Objects in VBA: Example on how to save a copy of Worksheet
  • Consolidate Multiple Workbooks in to one using VBA [21 min]
  • Delete Blank Cells & Sort a List using VBA
  • Generating Multiple PDF Reports using VBA

Working with Pivots

Debugging and Error-handling

  • Errors
  • Debugging

Sharing Workbooks

  • Programming Automatic Events
  • Running Automatic Procedures
  • Automatically Starting the Workbook and basic dashboards.

Notes

Required Tools

  • Online and in class students need access to Microsoft Office 2016 outside lab/class time to work on assignments, projects, or other course work. This software may be downloaded from Microsoft.

Textbooks

Attendance

It is strongly recommended that students attend every class. It is the responsibility of the student to communicate potential absenteeism to the instructor.

Prerequisites

Proficiencies

You should be a relatively experienced Excel user able to comfortably perform the following tasks:

  • create workbooks, insert sheets, save files
  • navigate through a workbook
  • use the Excel Ribbon user interface
  • enter formulas
  • use Excel's worksheet functions
  • name cells and ranges
  • use basic Windows features
  • understand file management techniques

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Class
Days
Sa
Time
8:30AM to 4:30PM
Dates
May 23, 2020 to May 30, 2020
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $625.00
Reading List / Textbook
No Required Textbook
Section Notes

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .