Excel University: Excel Automation Skills 2

Overview

Excel University Masters 2 teaches Macros and VBA (Visual Basic for Applications). It demonstrates how to use VBA to automate manual tasks. Plus, VBA allows you to see and control Excel like never before. This course uses case studies to simulate real-world workbooks and projects. Check out the first video from the course below to learn more.

Prerequisites

None

Objectives

In this course, you will learn to:

• Recognize that Application is the top object in the Excel object model 
• Recall that the Visual Basic Editor enables you to read, write, and edit VBA code 
• Identify that VBA stands for Visual Basic for Applications  
• Recall that the Macro recorder translates your actions into VBA code and can be helpful when you know how to complete a task in Excel but not with VBA 
• State which Excel tab contains the commands related to programming and VBA
  

Highlights