Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Play by Play: Obliterate the Tedium - Practical VBA for the Excel Practitioner

via Pluralsight

Overview

In this course, you’ll learn how to automate data preparation using short programs in VBA, the native programming language bundled into Excel.

Play by Play is a series in which top technologists work through a problem in real time, unrehearsed, and unscripted. In this course, Play by Play: Obliterate the Tedium - Practical VBA for the Excel Practitioner, Ryan Hinkle and Don Robins demonstrate that with less than 50 lines of code you can create powerful programs for any highly repetitive process to automate tasks, including moving among sheets, rows, and columns to retrieve and output data in exactly the format you seek. Learn the basics of configuring the Developer Environment in Excel, various programming elements required to script simple yet powerful macros, and how to design and construct pseudo code. By the end of this course, you’ll have a clear understanding of just what you can accomplish with VBA macros in Excel, and you’ll come away with some tools and samples to apply to your own transformation tasks, leveraging the powerful capabilities of the embedded programming environment.

Topics:
  • Course Overview
  • Setting the Stage: Objective and Overview
  • Navigating to the VBA Environment
  • Basic VBA Programming Elements
  • Understanding Psuedo Code
  • Putting It Together: Project #1
  • ​Putting It Together: Project #2
  • Summary and Recap

Taught by

Ryan Hinkle

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Play by Play: Obliterate the Tedium - Practical VBA for the Excel Practitioner

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free