The IELTS Co-Owner Lost 94% of Its Value. The Reason: Visas.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

Excel VBA Foundations and Object Model

via Coursera

Go to class Write review

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Build a strong foundation in Excel VBA by learning to automate tasks, create macros, and navigate the Visual Basic Editor. Gain essential skills to streamline your workflow and unlock the power of Excel automation. This course introduces learners to the fundamentals of Excel VBA, including macro creation, the Visual Basic Editor, and the Excel object model. You will learn how to record and modify macros, understand the structure of VBA code, and begin using Copilot AI to generate code. By the end of the course, you will be able to automate repetitive tasks and confidently navigate the VBA environment. Through a combination of clear explanations, practical examples, and interactive quizzes, this course guides learners step-by-step from basic macro recording to understanding the core elements of VBA programming. The course emphasizes real-world applications to help you immediately apply your new skills in Excel. This course is part one of a three-course Specialization designed to build a complete and cohesive understanding of the subject. While it offers valuable skills on its own, you'll gain the most benefit by progressing through all three courses as a structured learning journey. This course is based on Microsoft 365 Excel VBA Programming For Dummies, by Dick Kusleika. From Microsoft 365 Excel VBA Programming For Dummies Copyright © 2025 by John Wiley & Sons, Inc. All rights reserved, including rights for text and data mining and training of artificial technologies or similar technologies. Used by arrangement with John Wiley & Sons, Inc.

Syllabus

  • Getting to Know VBA
    • This module introduces the fundamentals of VBA, covering its capabilities, limitations, and practical applications in automating Excel tasks. Learners will gain an understanding of how VBA can enhance productivity and customization within Excel environments. It also provides essential background knowledge necessary for effective VBA programming.
  • Building Simple Macros
    • This module teaches learners how to create, run, and modify VBA macros in Excel, focusing on automation techniques and best practices for managing macro security and functionality.
  • Working in the Visual Basic Editor
    • This module provides an in-depth overview of the Visual Basic Editor (VBE), guiding learners through its key components, how to work with modules, and how to customize the environment for efficient VBA development. It covers both direct code entry and macro recording techniques, helping users build practical skills in VBA programming.
  • Introducing the Excel Object Model
    • This module introduces learners to the Excel Object Model, focusing on how to interact with Excel's structure through objects, properties, and methods. It covers the fundamental concepts of object-oriented programming within Excel VBA, enabling users to control and manipulate data efficiently. Learners will gain hands-on skills to automate tasks and enhance productivity using VBA.
  • VBA Sub and Function Procedures
    • This module introduces learners to the fundamental concepts of VBA Sub and Function procedures, including their roles, naming conventions, and execution methods. It covers how to create and use these procedures for efficient task automation and complex calculations. Learners will gain practical skills in writing and managing VBA code for real-world applications.
  • Using the Excel Macro Recorder
    • This module teaches learners how to effectively use the Excel macro recorder to automate repetitive tasks. It covers key concepts such as recording macros, choosing between relative and absolute modes, and optimizing the generated VBA code. Learners will gain practical skills to improve efficiency in Excel automation.
  • Generating Code with Copilot
    • This module introduces learners to the process of generating and refining VBA code using AI tools like Copilot. It covers how to interact with Copilot's suggestions, modify code effectively, and apply AI assistance to real-world Excel tasks. Learners will gain practical skills in leveraging AI for coding efficiency and problem-solving.

Taught by

Wiley Skills Network

Reviews

Start your review of Excel VBA Foundations and Object Model

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.