Loading...

Course Description

Take full advantage of Microsoft Office suite by automating routine tasks. No matter which application you're using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.

This course shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes.


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).

Top of Page


Course Content

Course Level Learning Outcomes

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

  • Use Visual Basic Editor to write simple codes in VBA
  • Understand properties of different Excel objects
  • Create modules and procedures
  • Write code in VBA using variables and functions
  • Apply and understand the scope of variables and procedures
  • Write code for managing objects of Excel application
  • Write code using decision structures and loops

Topics of Instruction

Getting started with the Visual Basic Editor

  • Visual Basic for Applications
  • Properties and modules
  • The Code window

Programming basics

  • Working with variables and functions
  • Scope of variables
  • Scope of procedures

Word objects

  • Programming with objects

Understanding Objects in Excel

  • Objects
  • Application object

Control Structures

  • Using decision structures
  • Using loop structures

Top of Page


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.

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.

Top of Page


Prerequisites

  • There are no prerequisites for this course, however, students must have significant experience with Microsoft Excel and Access in order to successfully complete this course.
  • Students must also meet the recommendations and requirements in the Notes section along with any proficiencies identified below.

Top of Page


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

 

Top of Page


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
Apr 18, 2020 to Apr 25, 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 .