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.
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.
Author Name: Don Robins
Author Description:
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. Certified as a Platform II Developer and an award winning Salesforce Instructor, he’s presented and taught at annual Dreamforce conferences since 2010. He delivers Salesforce developer classes and workshops around the US and abroad, and manages a team of instructors … more
Table of Contents
- Course Overview
1min - Setting the Stage: Objective and Overview
12mins - Navigating to the VBA Environment
19mins - Basic VBA Programming Elements
35mins - Understanding Psuedo Code
10mins - Putting It Together: Project #1
27mins - Putting It Together: Project #2
17mins - Summary and Recap
3mins
User Reviews
Be the first to review “Play by Play: Obliterate the Tedium – Practical VBA for the Excel Practitioner”
Related Products
Describe monitoring tools in Azure
This module covers tools that you can use to monitor your Azure environment.
Describe features and tools for managing and deploying Azure resources
This module covers tools that help you manage your Azure and on-premises resources.
Introduction to Copilot for Microsoft 365
This module explores the intricacies of Microsoft 365 Copilot, offering insights into its functionality and Microsoft's dedication to implementing AI responsibly and ethically.
Describe cloud computing
This module introduces you to cloud computing. It covers things such as cloud concepts, deployment models, and understanding shared responsibility in the cloud.
Introduction to Bash
Use Bash to manage IT infrastructure.
Microsoft Azure Fundamentals: Describe Azure management and governance
New to the cloud? Microsoft Azure fundamentals is a three-part series that teaches you basic cloud concepts, provides a streamlined overview of many Azure services, and guides you with hands-on exercises to deploy your very first services for free. Complete all of the learning paths in the series if you are preparing for Exam AZ-900: Microsoft Azure Fundamentals. This is the third learning path in the series, Azure Fundamentals: Describe Azure management and governance. The other learning paths in the series are Part 1: Describe cloud concepts and Part 2: Describe Azure architecture and services.
There are no reviews yet.