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

In this course, you’ll learn about ways to automate data preparation using short programs in VBA, the native programming language bundled with and built into Excel.
Course info
Rating
(14)
Level
Beginner
Updated
April 6, 2018
Duration
2h 8m
Table of contents
Description
Course info
Rating
(14)
Level
Beginner
Updated
April 6, 2018
Duration
2h 8m
Description

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.

About the author
About the author

Don Robins is a well known Salesforce MVP, instructor, author, and speaker. A custom business application developer for more decades than he cares to admit, he focuses on Salesforce technical instruction and knowledge sharing.

More from the author
More courses by Don Robins
About the author

Ryan is a Managing Director at Insight Venture Partners, a leading software investor. Ryan led Insight's investment in Pluralsight and has served on the board of directors since 2012.