August 2019
Intermediate
17h 19m
English
Closed Captioning available in English
Overview
In this comprehensive 17-hour course, you will delve into the world of Excel VBA programming. Starting from the basics and progressing to advanced topics, this course teaches you to harness the power of VBA for automating repetitive tasks and mastering Excel's Object Model to develop efficient macros.
What I will be able to do after this course
- Understand and apply the basics of VBA programming to automate repetitive Excel tasks.
- Master the use of the Excel Object Model to interact programmatically with Excel elements.
- Develop the skills to create custom functions and user forms for more advanced solutions.
- Leverage conditional logic and iteration to create robust automated workflows.
- Gain proficiency in debugging VBA code and identifying solutions to complex problems.
Course Instructor(s)
Boris Paskhaver, an experienced Excel VBA developer and educator, has been teaching professionals to optimize their Excel workflows for years. His teaching philosophy emphasizes understanding core concepts thoroughly, illustrated with practical examples, helping students of all levels to succeed.
Who is it for?
This course is ideal for business analysts seeking to eliminate repetitive Excel tasks, skilled spreadsheet users wanting to unlock the potential of VBA, and individuals looking to explore programming within a trusted application environment.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.