• Course
  • Vendor

Students will learn concepts used to build custom solutions with Microsoft Excel VBA Macros. The participant will become familiar with macro techniques for recording, writing, running, and maintaining a macro.

  • Course Start Date: 2019-03-21
  • Time: 09:00:00 - 16:00:00
  • Duration: 2 Days
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led
$450.00
March 21st
2 seats left!
or make an offer
need-to-train-a-group-banner

Course Outline

Pre-Requisites

Excel Level III or extensive knowledge of the product and the use of named ranges.

Lessons

Students will learn concepts used to build custom solutions with Microsoft Excel VBA Macros. Topics covered in this class will help the participant become familiar with basic macro techniques for recording, writing, running, and maintaining a macro. Particular attention is payed to the design and layout of a user form and controls in order to create a customized dialog box. Students will learn key concepts used to build custom solutions with Microsoft Excel VBA Macros. Topics covered in this class will help the participant become familiar with basic macro techniques for recording, writing, running, and maintaining a macro. Particular attention is payed to the design and layout of a user form and controls in order to create a customized dialog box to simplify data entry. As well as learning to enhance source code with variables, constants, and logical operators.

Course Content
Building Solutions
  • Course Overview
  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Programming Concepts
Macro Basics
  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros
VBA Programming Basics
  • Understanding Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help References
VBA User Form Basics
  • Planning User Forms
  • Designing User Forms
Deployment Basics
  • Preparing for Deployment
  • Code Security
  • Creating Custom Toolbars
  • Creating Custom Marco Buttons
  • Attaching Toolbars
Customizing Macros
  • Prompting for User Input
  • Automating Data Entry
  • Recording Absolute vs. Relative References
  • Protecting VBA Source Code
Enhancing VBA Code
  • Writing Source Code
  • Variables and Constants
  • Writing Tips
  • Logical Operators
  • Flow Control
Handling Errors
  • Handling Errors
  • Syntax Errors
  • Logical Errors
  • Run-Time Errors
Accessing External Data
  • External References
  • ActiveX Data Objects Concepts
  • Connecting to a Database
  • Retrieving Records from a Database
Excel Automation
  • Automation Concepts
  • Working with Object Models
  • Excel€(TM)s Object Model
  • Automating Excel with VBScript

Cancellation Policy

10 business days cancellation or full course fee will be charged

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada   

About Technology Training Centre

x

Technology Training Centre is THE place for computer software training in Alberta.
This is where you come to learn how to get more from the computer or the mobile device in front of you.
Register for courses on Microsoft Office and the Adobe Creative Suite along with customized one on one or group training.
Come to the heart of the University of Alberta campus to learn from our instructors. These highly skilled professionals will also travel across the province to deliver exceptional training for you and your company.
We have your MS Office needs covered, including training on upgrading to a newer version of the software. We offer courses in Microsoft Word, Excel, PowerPoint, Access, SharePoint, Publisher, SQL, Visio, Project, Outlook, OneNote, and InfoPath.
Our graphic designers will train you in Adobe Photoshop, InDesign, Illustrator, Dreamweaver, Acrobat, Lightroom, and Visual Design. If you need training for your digital camera, we’ll provide that as well.

You will also receive:
•    6 months of email support on courses.
•    The option to retake courses within 6 months at no additional charge.
•    Training from instructors that use each of the software packages they teach and have the ability to go beyond what is covered in the outline.
 

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 196 reviews.

No comment

Reviewed Feb 2019

The course was excellent, the instructor Rachel was great.

Reviewed Nov 2018

No comment

Reviewed Nov 2018

No comment

Reviewed Sep 2018

Was a very informative course.

Reviewed Aug 2018

No comment

Reviewed Feb 2018

My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.

Reviewed Feb 2018

I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL

Reviewed Jan 2018

No comment

Reviewed Dec 2017

No comment

Reviewed Nov 2017

No comment

Reviewed Oct 2017

The information learned in this course will assist me in my current role. Enjoyed the class.

Reviewed Sep 2017

No comment

Reviewed Jun 2017

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unf ... Read more
x

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unfortunately all my notes are in the beginning of the book as we, only looked it once, when a student asked what page we were on.

Reviewed May 2017

No comment

Reviewed May 2017

More useful contents can be fit in and taught in this class definitely.

Reviewed Feb 2017

No comment

Reviewed Feb 2017

Worthwhile training that provided me with the skills needed to use Onenote.

Reviewed Nov 2016

No comment

Reviewed Jun 2016

No comment

Reviewed Jun 2016

Course Reviews

This course has an overall avarage rating of 3.86 out of 5 based on 13 reviews.

Previous

Cheryl Johnson attended this course Dec 2015

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Cheryl Johnson attended this course Dec 2015

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Cheryl Johnson attended this course Jan 2015

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Cheryl Johnson attended this course Dec 2014

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Cheryl Johnson attended this course Dec 2014

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Helen Williams attended this course Mar 2013

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Becky Bergley attended this course Jan 2013

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Becky Bergley attended this course Jan 2013

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Annie Nguyen attended this course Dec 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

The instructor was great - he made the material interesting and fun. The course is a beginners step into VBA which is useful, but you will n... Read more
x

The instructor was great - he made the material interesting and fun. The course is a beginners step into VBA which is useful, but you will need to take more if you plan to work vigorously with this application.

Konstantine Neikours attended this course Dec 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Maria Lim attended this course Jul 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Nancy Er attended this course Jul 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

Denis Stolypin attended this course Feb 2012

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment
Next

More Courses from Technology Training Centre

Project 2013 - Level 2

TECHNOLOGY TRAINING CENTRE
2019-03-13
Edmonton

SharePoint 2010 Level 1

TECHNOLOGY TRAINING CENTRE
2019-06-04
Edmonton

Excel 2016 - Level 1

TECHNOLOGY TRAINING CENTRE
2019-03-01
Edmonton

Access 2016 - Level 1

TECHNOLOGY TRAINING CENTRE
2019-05-29
Edmonton
VIEW ALL

More Courses in 'Microsoft Excel Training' Category

Excel 2013 - Level 1

TECHNOLOGY TRAINING CENTRE
2019-06-24
Edmonton

Excel 2010 - Level 1

TECHNOLOGY TRAINING CENTRE
2019-09-17
Edmonton

Excel 2016 - Level 2

TECHNOLOGY TRAINING CENTRE
2019-02-20
Edmonton

Excel 2013 - Data List Management

TECHNOLOGY TRAINING CENTRE
2019-05-27
Edmonton
VIEW ALL