Programming Microsoft Excel Using Macros

For Engineers

Overview:

We start by reviewing the basics to fill possible gaps in your knowledge. We then build through simple uses to complex examples, using typical engineering problems. We also introduce the advanced feature of programming macros in Visual Basic.

This is an intensive 2 day working course
Accredited with the Engineering Council of South Africa

Who is For?

Experienced Excel users who now wish to be able to program their own applications.should attend and will certainly benefit from this intensive working training webinar

Advanced Level

Date:

20-21 April 2023

Time:

8:30 – 16:30

Points:

2 CPD Points- ECSA

Days:

2 Days

Course objectives:

• Introduction to Macros: Recording a Macro, Running a Macro, the Visual Basic Editor,
• Modifying Visual Basic Code
• Programming Basics, The Sequential Program vs. Eventdriven Programming, Program
• Structure.
• Procedures: Subprograms and Functions.
• Variable Types, Declaring Variables, Arrays, Naming Variables, Scope and Lifetime of Variables
• Program Flow Control: Structured Programming
• Talking to the User: Message Box and Input Box
• Error-Handling
• The Visual Basic Editor in detail
• Projects, Forms and Modules
• Using Help
• Debugging and Testing Code
• Break Mode and Breakpoints; The Debug Window
• Formulae and Built-in Functions; Format, Immediate IF
• Visual Basic and Excel Objects
• Properties, Events and Methods
• Running Code from a Worksheet: Forms Buttons, Toolbar Buttons and ActiveX Buttons,
• Attaching Visual Basic Code to a Button, Other Controls.
• Visual Basic Forms as Dialog Boxes, Working with UserForms
• File Handling.

About:

Overview

Course Overview

  • Introduction to the Technical Report Writing course
  • Outcomes
  • The purpose of Technical Reports
  • The importance of Readability
  • Pre-assessment Exercise
  • The Fog Index
  • The Fog Index Exercises
  • Self-evaluation of Readability Grade Level
  • The value of good Report Writing
  • The Central C’s of great Report Writing
  • Construction of good Sentences
  • Exercise – constructing good Sentences
  • Construction of good Paragraphs
  • Exercise – Breaking passages up into Paragraphs
  • Exercise – constructing good Paragraphs by sequencing of Sentences
  • Bulleting Styles and the correct use of Bullets
  • The Technical Communication Style
  • Overview of the Technical Communication Process
  • Different phases of the Report-writing process
  • The Structure of the Technical Report
  • The importance of putting forward a ‘Hypothesis’ or ‘Argument’
  • ‘Brainstorming’ and ‘Mind mapping’ Techniques
  • Discussion and Categorisation
  • Determining the Reader Profile

How Much?

Early Bird: R 5490 + vat
Standard: R 5999 + vat

When?

Date: 20-21 April 2023
Time: 08:00am 16:30pm (CAT Daily)

Discounts?

3-5: 5% off
6-11: 10% off
+11: 15% off

FAQ:

This course is a 3-module, interactive online workshop.

What Do I Need?

Each delegate will need the following to attend:

  • Steady Internet connection for the duration of the training
  • Laptop / PC / Smart Phone and Power supply (Charger)
  • Zoom Meeting Software installed onto your laptop /
  • PC / Smart Phone
  • Quiet Space

Preferable but not compulsory:

  • Headset / Ear Phones to clearly hear the facilitator

About The Trainer?

ick Ruibenheimer graduated in 1975 from the University of the Witwatersrand with a B.Sc.(Eng)(Civil). He received prizes for the best reinforced concrete design and qualified as a Professional Engineer (Pr. Eng.). In May 1982, he joined WLPU Consulting Engineers (now Knight Piésold) in Braamfontein and was later promoted to Principal Engineer. After working on a variety of Civil Engineering design projects, he gravitated towards the computer section and worked on an HP1000 minicomputer as a joint System Manager. In 1986, he worked on Hewlett Packard desktop computers and PCs. He also conducted in-house PC training for WLPU on topics such as introduction to PCs, DOS, Multimate, GW-BASIC, and Lotus 1-2-3.

Terms & Conditions

Payment Terms:

  • Payment is required within five (5) working days on receipt of tax invoice.
  • Following completion and return of the registration form, full payment is required within five (5) working days from receipt of tax invoice.
  • We reserve the right to refuse admission and withhold CPD points and certificate if payment is not received on time, a payment or an official purchase order must be received prior to the conference or training seminar.

Fees:

  • Fees are exclusive of VAT
  • Bulk discounts are not calculated on early bird price. Invoiced amounts need to be paid on or before the early bird date to receive the rate.

Cancellation Policy:

  • All cancellations must be sent in writing at least 10 working days prior to the event.
  • Cancellations within 10 working days before the event starts will not receive any refund and will be liable for the full invoiced amount, however, a substitution of the delegate will be allowed.

Indemnity:

  • Should for any reason outside the control of BEST Training events, the dates or speakers change, or the event is cancelled due to an act of terrorism, extreme weather conditions or industrial action, BEST Training shall endeavour to reschedule but the client hereby indemnifies and holds BEST Training harmless from and against any and all costs, damages and expenses, including attorney’s fees, which are incurred by the client.
  • The construction, validity and performance of this agreement shall be governed in all respects by the laws of South Africa and to the exclusive jurisdiction of whose courts the parties hereby agree to submit.

No-shows:

  • Registrants who do not attend the event, without written notices as per the cancellation policy will be liable for 100% of the invoiced amount.

Important Notice:

  • The booking form below constitutes as a legal binding contract.
    Whilst every reasonable effort will be made to adhere to the advertised brochure(s), BEST Training reserves the right to change dates of events if the need arises.

GET IN TOUCH WITH US

We want to hear from you. The team at BEST Training has experience in the Built Environment and offers a range of various courses and webinars when you need it most.

If you have ANY questions, contact us.