Macro & VBA

Macro & VBA

₦150,000.00

SKU: TFA-00016 Categories: , , ,

Description

Using VBA and macros gives you a great deal more power. You can tell Excel exactly what to do and how to do it. You also get access to a lot more functions and capabilities. If you use Excel regularly, it’s worth learning how to create VBA and macros.

Learning Objectives:

Participants will be able to:

  • Record and Run Macros Easily
  • Write VBA Code Manually using Microsoft Excel
  • Perform Loops, Controls and Error Handling in Excel Macros
  • Create User forms and Sheet Controls in Excel 2016
  • Use Events to trigger specific VBA code.
  • Write Useful Applications That Boost Productivity and Reduce Time on Routine Activities.
  • Utilize Excel to achieve the best possible programming results
  • Create their own macros, use and define variables, and work with a variety of objects

Program Outline

  • VBA & Macro Introduction
  • Types of Macros
  • Command Macros
  • Function Macros
  • Macro Formatting
  • Run a Pre-Recorded Macro
  • VBA
  • Accessing VBA Editor
  • VBA – Excel Macros
  • Event Handling
  • VBA – Events
  • Worksheet Events
  • Workbook Events
  • Functions
  • Functions Overview
  • Calling a Function
  • User Defined Functions
  • ERROR Statements
  • Error Statements Overview
  • Terms of Error Statements
  • Untrapped Errors
  • Forms
  • Messages and Variables
  • Simple IF Conditions
  • Loop
  • While Wend Loops
  • Do While Loops
  • Do Until Loops
  • Recording Macros and Buttons
  • The Excel Object Model
  • Debugging and Error Handling
  • Error Handling Routine
  • Handling Errors

Target Audience

Those who are consistently performing repetitive actions on worksheets.

Data Analyst

 

Prerequisite

You must have good Microsoft Excel skills and understand key concepts of spreadsheets. It is not necessary to have prior programming knowledge.

You must know basic Excel functionality.

Reviews

There are no reviews yet.

Consulting

Training

Software Development

Project Management

TERIBITE CONSULTING

We are a privately-owned business incorporated by the Corporate Affairs Commission of Nigeria to provide ready made and tailored I.T., Management, Financial and Branding Consulting services and solutions to a broad spectrum of clients.

Opening Hours

Monday – Friday: 8:00 am – 5:00 pm

Saturday, Sunday: Closed

CONTACT

Email: info@teribiteng.com
Telephone: (+234) 0803 358 8649, 0908 069 9264
Address: 3, Allen Lane, Capable People Africa Building Allen, Ikeja, Lagos, Nigeria

TOP