Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Learning Programming with Microsoft Excel Macros and VBA

By: Tom Associates Training  

Lagos State, Nigeria

13 - 17 Jun, 2022  5 days

Follow Event

  

NGN 195,000

Venue: 5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos, Lagos State, Nigeria 05 - 09 Sep, 2022 NGN195000

Kick start programming journey with Macros in Excel, while learning Objects programming, Looping, Variables, Data Types, Conditional Statements, etc. This course will explore the MS Excel program capabilities with Macros and VBA offerings, emphasising foundational features of the VBA. Avoid boring and repetitive routine tasks in MS Excel with Macros recording and execution. Discover how to programmatically approach tasks in Microsoft Excel by manipulating objects in-depth and performing repetitive mundane tasks with VBA codes.

Course Contents

Day One

The VBA Anatomy

  • What is VBA?
  • Recording macros
  • Testing macros
  • Examining macros
  • Modifying macros
  • Saving workbooks containing macros
  • Understanding macro security

The Visual Basic Editor (VBE)    

Day Two

The Excel Object Model Anatomy

  • EXCEL is an object
  • The object hierarchy
  • Collections
  • Referring to objects
  • Navigating the objects hierarchy
  • Object Properties
  • Object Methods
  • Object Events
  • The VBA Help system
  • The Object browser
  • Automatically listing Properties & Methods.

The VBA Sub and Function Procedures

  • Sub vs Functions
  • The Sub Procedures
  • The Function Procedures
  • Executing Sub Procedures
  • Executing the Sub Procedures directly
  • Executing procedure from Macro dialog box
  • Executing a macro with shortcut key
  • Executing procedure for button, shape, or icon
  • Executing Function procedures
  • Calling the Function from a Sub procedure
  • Calling a Function from a worksheet formula.

The Excel Macro Recorder

  • Recording basics
  • Recording in relative mode
  • Recording in absolute mode
  • Recording options.

Day Three

Essential VBA Language Elements

  •   Using comments
  •   Understanding variables
  •   VBA data types
  •   Declaring and scoping variables
  •   Working with constants
  •   Working with strings
  •   Working with dates
  •   Assignment statement.

Range Objects

  •   Ways of referring to a Range
  •   Cells property
  •   Offset property
  •   The Value property
  •   The Text property
  •   The Count property
  •   The Columns & Rows property
  •   The Address property
  •   The HasFormula property
  •   The Font property
  •   The Interior property
  •   The Formula property
  •   Working with some Range Object Methods
  •   The Select method
  •   The Copy and Paste method
  •   The Clear method
  •   The Delete method.

Day Four

Controlling Program Flow and Making Decisions

  •   Understanding the Flow
  •   The GoTo Statement
  •   The IF-Then Structure
  •   The Select Case Structure
  •   For-Next loop
  •   Do-While loop
  •   Do-Until loop
  •   For Each-Next loop.

Day Five

Using VBA Worksheet Functions

  •   Understanding functions
  •   Using VBA built-in functions
  •   VBA function examples
  •   VBA functions that do more than return values
  •   Using worksheet functions in VBA
  •   Using custom functions.
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos Jun 13 - 17 Jun, 2022
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos, Lagos State, Nigeria 05 - 09 Sep, 2022
NGN 195,000.00(VAT Inclusive)
(Convert Currency)

Tolu Jegede 08178591654

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.

Related Courses

Monitoring and Evaluation (M and E) of Projects Monitoring and Evaluation (M and E) of Projects

5 days, 25 - 29 Jul, 2022 

2022-07-25 12:07:00 2022-07-25 12:07:00
Lagos State, Nigeria

Tom Associates Training

This programme can run as an online or classroom training (Available also for Customised Training by Duration, Venue and Fee) The country is as exposed as any country to the growing pressures on ...

Optimal Management of Working Capital Optimal Management of Working Capital

2 day, 21 - 22 Jun, 2022 

2022-06-21 12:06:00 2022-06-21 12:06:00
Lagos State, Nigeria

Tom Associates Training

This course teaches participants the significance of Working Capital Management as the tool or managerial accounting strategy to always guarantee the efficiency of the business and its short-term ...

The Emerging Functions and Tasks for the HR Professionals The Emerging Functions and Tasks for the HR Professionals

5 days, 06 - 10 Jun, 2022 

2022-06-06 12:06:00 2022-06-06 12:06:00
Lagos State, Nigeria

Tom Associates Training

Human Resources Management, like other professions, keep evolving as changes emerge in the circumstances of businesses that HR Management is established to support. A case in point is the ...

Delivering Happiness through Customer Experience Management (CXM) Delivering Happiness through Customer Experience Management (CXM)

3 days, 03 - 05 Aug, 2022 

2022-08-03 12:08:00 2022-08-03 12:08:00
Lagos State, Nigeria

Tom Associates Training

Customers, truly, provide the sources of the lifeblood for any business. But truly also, not all customers of any business are created equal. Some require more attention than others. By gaining ...