Excel VBA: The VBA Beginner's Blueprint to Programming Excel (updated 6/2021)
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.05 GB | Duration: 7h 4m
What you'll learn
If you plan to use Excel in your job, than learning VBA has its advantages!
Enroll in this course to automate, and customize your Excel 2007, 2010, 2013, 2016, 2019, or 365 files with hours of Video Lectures, 40+ Articles, and 90+ Supplemental Resources.
UNDERSTAND why you would want to use VBA in Excel
KNOW the difference between Macros and VBA
CREATE Macros in Excel
MODIFY your Macros
NAVIGATE comfortably in the Visual Basic Editor
LEARN the essentials of writing Excel VBA code
MODIFY your Workbooks using VBA
CREATE Decision Structures in your VBA code
LOOP your VBA code to have it run more than once
CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes
CREATE User Forms from scratch
DEBUG your VBA code
LEARN how to handle errors
CREATE New Worksheet Functions
Requirements
To get the most out of this course, you should have working knowledge of Microsoft Excel.
Excel 2010, 2013, 2016, 2019, 365
Description
Become an Excel Programmer and You Can Finally Put Your Work On Autopilot!
Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should.
Or the day will come when you say, "Oh, I wish there were a better way to do this!"
The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications.
