Excel 2016 VBA

This course is included (as well as over 200 others) in every subscription!
Description
Materials

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.

Excel 2016 VBA Beginner

Sign up to view this video Video Description
  • Introduction
  • What is VBA?
  • Object Oriented Programming Languages
  • Turning on the Developer Tab
  • The Macro Recorder
  • Using Relative References
  • Recording Simple Macros
  • Multi-Step Macro Recording
  • Sort and Filter Macro Recording
  • Protecting and Formatting Sheets with the Macro Recorder
  • VBA Interface Setup
  • Recorder Code vs. Manual Code
  • Introduction to Editing Macros
  • Debugging Macros
  • Grammar in VBA
  • Macro Scripting Basics
  • Range
  • Selection & Color
  • Value and Clear
  • ActiveSheet, Sheets, and Name
  • CurrentRegion
  • Practice
 

Excel 2016 VBA Intermediate

Sign up to view this video Video Description
  • Variables
  • Variable Rules
  • For Next Loop Basics
  • For Next Loop Doubled
  • For Next Loop Triple
  • For Each Loop
  • Exit For Statement
  • Do While Loop
  • Do While Not Empty Loop
  • Do Until Loop
  • Do Loop UNTIL
  • Count and Offset
  • End, Address, Call Statement
  • Practice
  • Using the FIND Tool in a Macro
  • Message Boxes
  • Input Boxes
  • Code Continuation Character and vbCrLf Constant
  • If Then, ElseIF, and Else
  • Select Case
  • Multiple Variables
  • Practice
 

Excel 2016 VBA Advanced

Sign up to view this video Video Description
  • Worksheets Methods
  • DateSerial and Format
  • Sheet Template Generator
  • Move
  • PrintOut and PrintPreview
  • Practice
  • Custom Functions
  • Wrapping Up
 
No Practice Files

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102