Table of Contents Edit this course

• Chapter 1. Introduction to macros and basic mathematical functions. (~25 Minutes)

  Concepts:
  • 1. Introduction (~7 Minutes)
  • 2. Basic macro math (~7 Minutes)
  • 3. Types of macros (~7 Minutes)

• Chapter 2. Macro programming tools (~17 Minutes)

  Concepts:
  • 1. Loops and Conditions (~7 Minutes)
  • 2. Ranges, Rows and Columns (~7 Minutes)

• Chapter 3. Identifying errors and macro recording (~37 Minutes)

  Concepts:
  • 1. Breakpoints (~6 Minutes)
  • 2. Error handling (~7 Minutes)
  • 3. Comments (~6 Minutes)
  • 4. Variable declaration using the keyword 'Dim'. (~7 Minutes)
  • 5. Recording Macros (~7 Minutes)

• Chapter 4. Excel formulas with VBA (~23 Minutes)

  Concepts:
  • 1. VBA Formulas (~7 Minutes)
  • 2. Trim Function (~4 Minutes)
  • 3. Left and Len functions (~1 Minutes)
  • 4. Instr, Mid and Right functions (~7 Minutes)

• Chapter 5. Macro Protection and Forms (~17 Minutes)

  Concepts:
  • 1. Protecting Macros and Spreadsheets (~7 Minutes)
  • 2. Forms (~7 Minutes)

About the Curator

Dhruv Sampat

Sr. Director of Operations and Analytics at Course Hero.