UofC Navigation

ICT 428 Microsoft Macros and VBA Level 2

 Email this information to yourself or a friend
 Remind me of this course at a later date



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

Coming Soon


Prerequisites

Instructional Delivery

  • Face-to-face in a lab

Registration

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

Top of Page


Course Content

Course Level Learning Outcomes

  • Coming Soon

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.

 

 

Top of Page


Notes

Required Tools

  • Online and in class students need acess 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.

Top of Page


 

Prerequisites

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)




Sections

  ICT 428 - 026 Macros and VBA Level 2  
  Fall 2016   Status:  Available
 
Class:   Thu 8:30AM - 4:30PM
24 Nov 2016 to 01 Dec 2016
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $625.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks.This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

ICT 427 Macros and VBA Level 1

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 
  ICT 428 - 027 Macros and VBA Level 2  
  Spring 2017   Status:  Available
 
Class:   Tue 8:30AM - 4:30PM
06 Jun 2017 to 13 Jun 2017
Number of Sessions: 2 Sessions
Hours: 14.00
Course Fees:   Flat Fee non-credit    $625.00
 
Campus: Main Campus
Delivery Options:  Class
Instructor(s): Somasundari Sankaragomathi
  Section Notes:  

COURSE SCHEDULE AND DELIVERY

This course has 2 classes scheduled once per week for 2 weeks.This course is delivered in an in class format. Classes are held in a classroom lab.

PREREQUISITES

ICT 427 Macros and VBA Level 1

TRANSFER AND WITHDRAWAL FEES

A $25 fee applies for course withdrawals and transfers. For our standard Refund, Withdrawal and Transfer Policy visit conted.ucalgary.ca/refund

  
 


Search ContEd