Free
Course

VBA: Getting Started with VBA in Excel

Leverage Excel’s VBA tool for operations, macros, and debugging. Learn to format cells, manage sheets, and utilize FormatConditions object.

  • Skill level

    Beginner
  • Time to complete

    Approx. 2 hours
  • Certificate of completion

    Yes
  • Prerequisites

    None

About this course

Excel's VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you'll begin by using subroutines in VBA to perform operations. You'll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you'll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You'll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you'll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.

Learning objectives

  • Discover the key concepts covered in this course
  • Customize excel menus to display developer features, enter the vba console, identify the default macro settings in the trust center, create an auto-open macro, display a message-box from vba, associate the auto-open macro with an excel workbook, and save that workbook as a macro-enabled (.xlsm) workbook
  • Create an auto-close macro, contrast the working of the auto-open and auto-close macros, compare functions and sub-routines in vba, create a function that accesses the user name using the excel object model, invoke that function from a worksheet cell, access and modify the contents of the active cell from vba, use cell references with cell addresses from vba, and invoke subroutines using the macros>run menu

How it works

Expert-led videos

In this course, you'll watch videos created by industry-leading experts for some of the biggest tech companies in the world. They'll cover key concepts, go through sample applications, prepare you for industry certifications, and more. Watch on any device — whenever and wherever you want — to learn at your own pace.

VBA: Getting Started with VBA in Excel course reviews

  • Very well put together as usual. I learn so much from each experience with Codecademy. I can't explain how satisfied I am with this institution.
    David W
    Verified Learner
  • Everything Codecademy offers is useful for all software developers.
    Fidan M
    Verified Learner
  • I thought that I would never be able to learn to code but Codecademy has made it very easy. I just love it!
    Adyan H
    Verified Learner

Our learners work at

  • Google Logo
  • Meta Logo
  • Apple Logo
  • EA Logo
  • Amazon Logo
  • IBM Logo
  • Microsoft Logo
  • Reddit Logo
  • Spotify Logo
  • Uber Logo
  • YouTube Logo
  • Instagram Logo

How To Tell If You’re “Proficient In Excel” & How To Get Better

Cory Stieg
May 30, 2024

Seeing “proficient in Microsoft Excel” listed on a job description can be confusing, even if you regularly use the Microsoft spreadsheet software. Considering the vast uses for Excel, how can you tell if you’re truly “proficient” enough to be considered for a role?

For starters, read the job description closely. If Excel proficiency is listed as a “required” technical skill, then it’s safe to assume it’s an Excel-heavy role with little room to fake it or learn on the job. But if the job description categorizes it as a “preferred” or “desired” skill, then you might be more qualified than you think.

“What it means to be ‘proficient’ is going to depend on what you need to use Excel for,” explains Ada Morse, Associate Curriculum Developer at Codecademy. For example, a Business Intelligence (B.I.) Analyst might rely on Excel to manage budgets and financial forecasts, while a project manager might use it to build an organized schedule or calendar.

The beauty of Excel is that it’s a powerful but flexible program with tons of potential use cases. “Like with a lot of programming languages, there’s thousands and thousands of functions in Excel for different things — and no one’s going to know them all,” Ada says.

Our course Learn Microsoft Excel for Data Analysis will teach you some key Excel functions, like how to import and manipulate data and create visualizations, so you can confidently claim proficiency. If you’re heading into a job interview or wondering if you have what it takes to apply to a position that involves Excel, here’s what you need to know.

Continue reading

Join over 50 million learners and start VBA: Getting Started with VBA in Excel today!

Start

Unlock additional features with a paid plan

  • Portfolio projects

    Create professional projects you can share with recruiters to showcase your skills and experience.
  • Job-readiness checker

    Evaluate how well you meet the requirements for any job description based on your skills and experience.
  • Certificate of completion

    Earn a document you can share with your network to prove that you’ve completed this course.