Course Name

Microsoft Excel 2016: Programming in Visual Basic

  • Duration: 5 Day(s)
  • Date: 14 Oct, 2024
  • Price: R8, 427.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

This course focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it will show you how to write programs that automate various tasks in Excel.

Course Objectives

This course covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.

You will:

  • Analyse an Excel application development and have a complete understanding of the introduction to VBA.
  • Learn techniques needed to create Excel applications, both large and small.
  • Learn how to use VBA to navigate the Excel interface and format worksheets.
  • Learn tips, tricks, and techniques for expanding Excel’s capabilities with VBA.

Course Content

  • Module 1
    • Recording Macros
    • Absolute and Relative Macros
    • Assigning Macros to Custom Buttons
    • Assigning Macros to Images
  • Module 2
    • Excel Charting for the Uninitiated
    • Working with Chart Series
    • Formatting and Customising Charts
    • Components that show
  • Lesson 3
    • Introducing the VBA Editor
    • VBA Language Elements
    • Variables and Data Type Declaration Buttons
    • Assignment Statements
    • Array and Object Variables
  • Module 4
    • Built-in Functions
    • Defining New Functions Procedures
  • Module 5
    • Manipulating Objects and Collections
    • Controlling Code Execution
  • Module 6
    • Manipulating Excel Range Objects
    • Programming with Worksheet and Worksheet Objects
    • Event Handler Procedures
  • Module 7
    • Using Form Controls
    • Using ActiveX Controls
    • Working with User Forms
  • Module 8
    • Specialised Tools in VBA
    • Programming with PivotTable Objects
    • Programming with Chart Objects
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

This course focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it will show you how to write programs that automate various tasks in Excel.

Course Objectives

This course covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.

You will:

  • Analyse an Excel application development and have a complete understanding of the introduction to VBA.
  • Learn techniques needed to create Excel applications, both large and small.
  • Learn how to use VBA to navigate the Excel interface and format worksheets.
  • Learn tips, tricks, and techniques for expanding Excel’s capabilities with VBA.

Course Content

  • Module 1
    • Recording Macros
    • Absolute and Relative Macros
    • Assigning Macros to Custom Buttons
    • Assigning Macros to Images
  • Module 2
    • Excel Charting for the Uninitiated
    • Working with Chart Series
    • Formatting and Customising Charts
    • Components that show
  • Lesson 3
    • Introducing the VBA Editor
    • VBA Language Elements
    • Variables and Data Type Declaration Buttons
    • Assignment Statements
    • Array and Object Variables
  • Module 4
    • Built-in Functions
    • Defining New Functions Procedures
  • Module 5
    • Manipulating Objects and Collections
    • Controlling Code Execution
  • Module 6
    • Manipulating Excel Range Objects
    • Programming with Worksheet and Worksheet Objects
    • Event Handler Procedures
  • Module 7
    • Using Form Controls
    • Using ActiveX Controls
    • Working with User Forms
  • Module 8
    • Specialised Tools in VBA
    • Programming with PivotTable Objects
    • Programming with Chart Objects

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US