Day 2 DICT Replay Link and Topics Discussed on Excel Automation with VBA | 5 Day Free Webinar for Teachers

In this post, we are sharing with you the topics and activities performed and replay link of the Day 2 Session of DICT 5 Day Free Webinar  for Teachers on Excel Automation with VBA.

The purpose of this information is for you to be able to watch the replay of the Day 2 Session and also for you to be able to access the attendance form if the admin still allow you to fill-out the form.

Day 2 Session:

August 17, 2021 | 9-12 NN.

Excel Automation with Visual Basic for Applications (VBA)

Coping with Repetitive Task of Online Learning

Topics Discussed and Activities:

1. Review of Day 1 (running the macros created)

Running the Macros created during the Day 1 Session:

Examining the Macros. 

For Day 1 Session please watch the Replay Here:

>>https://fb.watch/7q-dy8Jh9a/

Day 2 New Topics:

Topic 2: Excel Programming Environment

1. A quick overview of its Tools and Features:

The Visual Basic Environment

i. Working with Worksheet Cells and Ranges

ii.Working with Rows and Columns

iii. Working with Workbooks and Worksheets

2. Excel VBA Fundamentals

i. Excel Objects, Properties and Methods

ii. Writing Simple and Complex VBA Statements

3. Introducing Data Types

4. Using Variables

i. Understanding the Scope of Variables

5. Using Constants

6. Using Static Variables in VBA Procedures

For Day 2 Session please watch the Replay Here>>https://web.facebook.com/DICTWVRO/videos/1494936747540572

NOTE: You can also check the link for the attendance using the replay link.

Source: Official FB Page of DICT Region 6 @ https://web.facebook.com/DICTWVRO/