Excel 2016 VBA Advanced

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.

Topics

Excel 2016 VBA Advanced - Part 1

  • Worksheets Methods
  • DateSerial and Format
  • Sheet Template Generator
  • Move
  • PrintOut and PrintPreview
  • Practice

Excel 2016 VBA Advanced - Part 2

  • Custom Functions
  • Wrapping Up

Contact Us

Unit G1 Hoxton Works, 128 Hoxton Street, London, N1 6SH, England
Phone: +44 (0)20 7613 3444

Follow Us