Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Drop Servicing

Office ProductivityMicrosoftExcel VBA

Excel VBA: The VBA Beginner's Blueprint to Programming Excel

You're Minutes Away From Learning How To Program Excel!
Rating: 4.7 out of 54.7 (358 ratings)
3,377 students
Created by IsáBel .
Last updated 12/2021
English
English [Auto]

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.


In This Course You Get:

  • Free Downloadable Workbooks - makes it easy to follow along & practice after class.
  • Test Your Skills - exercises to get you engaged & reinforce what you have learned.
  • Code Snippets - with common code bites.
  • VBA Glossary - talk the talk



This is a VBA beginner's course that will get you on the road to being in that elite group of VBA programmers.

Learning to program can seem daunting at first, but I'm going to make it as easy as possible.

With that said, VBA is a huge topic, and yes, there are a lot of lectures in this course.

But don't stress out.

What I do go over will get you from, "I don't even like looking at VBA", to, "I can do this!"



NOTE: There are multiple ways to get the same result in VBA.

So the way I write a procedure or two might be slightly different than your co-workers code, or yours, and that's O.K.  


If you're ready to cut your workload, automate your tasks, and learn a desirable skill while your at it, click the Take This Course button on the top right, and I will help start programming your Excel workbooks with VBA.


Who this course is for:

  • This course is for the everyday Excel user, who wants to extend the functionality of their spreadsheets using Visual Basic for Applications (VBA), but who is not yet familiar with VBA.
  • This course is designed for beginners to VBA. Intermediate, and Advanced VBA users will find this course a great review, but this course is not designed for advanced users of VBA.

Instructor

IsáBel .
Microsoft Certified IT Professional. Trainer of 21 Years
IsáBel .
  • 4.6 Instructor Rating
  • 3,462 Reviews
  • 30,759 Students
  • 13 Courses


Would You Like to Get the Tips, Tools, and Exercises You Need
for the Technical, Business, and Software Skills You Want?
IsáBel Will Show You How.


ABOUT

Since 1999 IsáBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel.

Technical courses in everyday language are offered in her Udemy portfolio.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.



COURSES ON UDEMY.COM

SQL:

- Microsoft Access SQL: SQL for Non-Programmers

- SQL Made Simple: SQL Server Queries for Non-Programmers


Microsoft Office:

- Excel Pivot Tables: The Power of Pivot Tables... Made Easy

- Excel: Time Saving Tips That Will Boost Your Productivity ✔

- Excel VBA: The VBA Beginner's Blueprint to Programming Excel

- Access: Time Saving Tips That Will Boost Your Productivity ✔

- Access Macros: Automate Your Access Databases

- Microsoft Access: Beyond the Basics of Access Bundle

- Access VBA: The Beginner's Blueprint to Programming Access

- Microsoft Word: Forms, Mail Merge, and Field Code Rules

- Microsoft Word Time Saving Tips To Boost Your Productivity ✔

- Microsoft Office: Word, Excel and Access Productivity Bundle


SharePoint:

- SharePoint 2010: Survey Creation for SharePoint Admins

- SharePoint 2013: Survey Creation for SharePoint Admins



RESOURCES:

▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters.


Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.