In this session the instructor will discuss the following:

• Introduction
• Macros
• Recording 1st Macros
• Visual Basic Editor

The case study for this session is >> Copying This Week QTY To Previous Week QTY

In this session the instructor will discuss the following:

• The Object model,
• Reference to Ranges Reference to Worksheets & Workbooks, and
• What is Variables.

The case study for this session is >> Automatically Opening, Copying & Closing Workbooks

In this session the instructor will discuss the following:

• For … Next Loop
• Do loop
• Find Method
• Arrays & IF Statement

In this session the instructor will discuss the following:

• Report 1 : P6 Progress Coloring Report,
• Report 2 : P6 Lookahead Coloring Report.

The case study for this session is >> Coloring Layouts using Excel VBA

In this session the instructor will discuss the following:

• Check if File or Folder Exists
• Selects & open Files
• Loop Through a Folder
• Working with PDF

The case study for this session is >> Opening Photos & Copying it to excel

• Creating an excel VBA Form,
• Adding Controls to the Form, and
• Changing Control and Form Properties.

In this session the instructor will discuss the following:

• Report 4 : Bi-Weekly Planning Report, and
• Report 5 : Dynamic Dashboard.

In this session all topics from session 01 to session 08 will be summarized.

In this session the instructor will create a Tool to Minimize the time in Creating P6 Resource Dictionary From BOQs