Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications 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 Certification Network & Security Hardware Operating Systems 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 Design Thinking 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 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 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 Yoga Mental Health Dieting 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 Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel VBA

Ultimate Excel VBA

Programming for the Business Professional
Rating: 4.6 out of 54.6 (3,107 ratings)
12,105 students
Created by Mark Talbert
Last updated 8/2013
English
English, Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Course Goal: You will obtain practical fluency in Visual Basic for Applications (VBA) specifically as it applies to Microsoft Excel.
  • Course Objectives: 1) You will learn to automate and extend Excel by adding VBA projects to your workbooks. 2) You will learn to enhance, customize and extend the Excel user interface through modifications to the Excel environment, the creation of custom user forms, and the use of ActiveX controls. 3) You will learn how to respond to workbook, worksheet and application events to automate macro execution. 4) You will learn how it is possible to reach outside of Excel by way of VBA, in order to perform cross-application tasks.
Curated for the Udemy for Business collection

Requirements

  • Microsoft Excel (2007-2013)

Description

This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. This course is based on the instructor's semester-long college courses which have produced thousands of graduates in the fields of business, finance, health care and public policy. Designed for busy professionals who need to take their Excel abilities to the next level, you will not waste time on topics which you are unlikely to use, and you will receive extra attention to the often confusing or overlooked details that will make the most difference to your ultimate understanding. Over 8 hours of instruction!

Who this course is for:

  • This is an introductory programming course, so no previous programming experience is assumed. The student should be at least moderately comfortable with Excel. The more prior exposure to Excel you have the more you will get out of the course, but you do not need to be an Excel expert to take the course.

Course content

6 sections • 36 lectures • 8h 34m total length

  • Preview10:20
  • Macro Recording Basics
    13:52
  • The VBA Editor
    13:01
  • Macro Recorder and the VBA Editor
    5 questions

  • VBA & The Object Library
    09:03
  • Objects and Properties
    15:10
  • Objects and Methods
    13:50
  • More about Objects and Properties
    10:16
  • Referencing a Range
    19:10
  • Important Range Properties
    17:35
  • The Worksheets Collection
    12:59
  • The Workbooks Collection
    18:05
  • Exploring the Object Library
    14:13
  • The Excel Object Library
    5 questions

  • Simple Input & Output
    11:39
  • Variables & Data Types
    21:06
  • Object Type Variables
    16:00
  • VBA & Worksheet Functions
    11:37
  • User-Defined Functions
    15:22
  • Branching: IF...THEN
    18:09
  • Branching: SELECT...CASE
    13:02
  • Looping: DO...LOOP
    16:01
  • Looping: FOR...NEXT
    11:29
  • Looping: FOR...EACH
    17:51
  • Variable Scope
    11:44
  • Error Handling
    15:05
  • Project 1 - The VBA Language
    14:25
  • The VBA Language
    5 questions

  • Macro Launching Shortcuts
    13:01
  • Modifying the Ribbon
    05:58
  • Workbook & Worksheet Events
    19:17
  • Application Events
    13:39
  • Project 2 - Event Handling
    09:31
  • Launching Macros: Events & Shortcuts
    5 questions

  • Enhanced Message Box
    07:58
  • ActiveX & The Worksheet (No Code)
    17:19
  • ActiveX & The Worksheet (With Code)
    13:17
  • Basic User Forms
    17:24
  • Project 3 - User Forms & ActiveX
    19:14
  • Modifying the User Interface
    5 questions

  • Reaching Beyond Excel
    16:31

Instructor

Mark Talbert
Educator and Consultant
Mark Talbert
  • 4.6 Instructor Rating
  • 3,107 Reviews
  • 12,106 Students
  • 1 Course

Mark Talbert has been using Excel aggressively since version 1.0, and writing Excel macros both before and after the introduction of the VBA language. He has introduced several college-level courses over 15+ years on Excel modeling and VBA programming, which have together produced thousands of graduates who now work across a wide range of industries. His most frequent email subject line from former students is "Thank God I took your course!" followed closely by "I really wish I would have taken your course!"

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.