Excel VBA Programming - The Complete Guide (Udemy.com)
Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome
Created by: Boris Paskhaver
Produced in 2021
What you will learn
- Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
- Utilize the objects in the Excel Object Model to emulate user actions in Excel
- React dynamically to user events like entering a cell value or opening a workbook
- Feel comfortable with the fundamentals of computer programming
Quality Score
Overall Score : 94 / 100
Course Description
VisualBasic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures calledmacros thatperform automated actions.
Anything that you can do inExcel, you can automate withVBA!
Over the course of more than 18 hours of content, we'll cover VBAfrom the ground up, beginning with the fundamentals and proceeding to advanced topics including:
The ExcelObject ModelThe VisualBasic EditorObjects and MethodsVariables and Data TypesWriting Your Own ProceduresThe Workbooks and WorkbookObjectsThe Worksheets and Worksheet ObjectsRange ReferencesRange ActionsConditionalLogicIterationAlertsConfiguring ExcelFunctionalityCustom FunctionsArraysDebuggingEven ProceduresUser Forms
In addition to the video content, thecourse is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress.
No programming experience is required -- complete beginners are more than welcome! VBAis a great language to start with because you can master the fundamentals of programming in a familiar work environment.
No extra software is necessary -VBAis bundled with all modern versions of Excel.
Excel isthe world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons,VBAcan help you remove the redundancy in your workflow and accelerate your productivity drastically!
Thanks for checking out the course!
Who this course is for:
Spreadsheet users who want to automate their daily workflowBusiness analysts who want to remove redundancy from their common tasksExcel users who are curious about exploring programming in a familiar work environment
Instructor Details
- 4.7 Rating
298 Reviews
Boris Paskhaver
Hi there!I'm a New YorkCity-basedsoftware engineer, author, and consultant who's been teaching on Udemy since 2016.
Like many of my peers, I did not follow a conventionalapproach to my current role as a web developer. After graduating fromNew YorkUniversity in 2013with a degree inBusiness Economics and Marketing,I worked as a business analyst, systems administrator, and data analyst for a variety of companiesincluding a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles,I was fortunate enough to be challengedto build severalprojects withPython and JavaScript.
There was no formal computer science education for me;I discovered coding entirely by accident. A small work interest quickly blossomedinto a passionate weekend hobby. Eventually, I left my former roleto complete AppAcademy, a rigorous full-stack web developmentbootcamp in NYC.The rest is history.
I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that breakdown the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting o
More courses by Boris Paskhaver
Testing Ruby with RSpec: The Complete Guide (2021)
4.5 (97 Reviews)
Provider: Udemy
Time: 7.5h
$11.99
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
18h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
