Description

An introduction to variables and looping procedure, the building blocks of effective and efficient Excel VBA coding. Walk through building looping procedures and their application to automating tasks in Excel.

Learning Objectives

---

1. Use variables and looping procedures to enable quicker analysis and automation using Excel VBA.
2. Build looping procedures to automate tasks in Excel.
3. Use For, Each, Next statements in Excel.
4. Use If, Then, Else statements in Excel.
5. Use For, Next statements in Excel.
6. Use Do loops statements in Excel.
7. Use Select case statements in Excel.