Excel VBA - The Complete Excel VBA Course for Beginners
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 12h 15m | 2.96 GB
Instructor: Alan Murray
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 12h 15m | 2.96 GB
Instructor: Alan Murray
Learn Excel VBA and take your spreadsheets to the next level.
What you'll learn
- Write powerful Excel VBA code to automate processes
- Identify real world situations where you can apply your new VBA skills
- Understand, test and debug VBA errors
- Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support
- Fun and effective lessons including 'real world' Excel VBA projects to complete
- Projects and challenges to practice your skills
Requirements
- An intermediate to advanced knowledge of Excel
- The course is taught in Excel 2010, but the lessons will work in any version unless stated
- No prior programming skills are necessary. The course starts with the basics
Description
Want to take your Excel skills to the next level and learn Excel VBA? Well, you have come to the right place.
This course covers everything you need to become proficient in Excel VBA. In just a few hours you can be writing your own macros to perform complex tasks and automate reports.
Areas covered include:
- Learning the basics of the VBA language.
- Using loops to perform repetitive tasks.
- Interacting with users via userforms and message boxes.
- Working with built-in VBA Functions.
- Accessing directories and files.
- Automating report generation and saving as PDF.
- Creating your own Excel functions and Add-Ins.
Ok, no more time for waffle. Grab a coffee and let's get cracking.
Who this course is for:
- You want to learn VBA to take your skills to the next level
- You want to automate reports and save time on repetitive and boring tasks
- This course is probably not for those with VBA experience who are looking for advanced VBA.