Free
Course

VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access

Master VBA in Excel for pivot tables, charts, and financial data. Learn to automate tasks in MS Access, run SQL queries, and set up event handlers.

  • Skill level

    Advanced
  • Time to complete

    Approx. 2 hours
  • Certificate of completion

    Yes

About this course

Leveraging VBA with Excel has many useful capabilities, including the creation and management of pivot tables and charts, and the automation of tasks in MS Access, the lightweight relational database. In this course, you'll learn how to create and edit pivot tables and different chart types, such as bar charts and line charts, using VBA in Excel. You'll then save these Excel charts as images, again using VBA. Next, you'll use Excel's stock datatype to access financial data. Moving on, you'll learn how to use VBA to automate tasks in MS Access, accept user input, validate it, and insert it into an MS Access database. You'll also learn how to run simple SQL queries against that database. Finally, you'll set up event handlers in Excel using VBA and illustrate their purpose.

Learning objectives

  • Discover the key concepts covered in this course
  • Use vba to create a pivot table and work with that pivot table both through vba and directly via excel
  • Use vba to create a simple chart on a new sheet and manipulate the data that it contains

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: Leveraging VBA to Work with Charts, Stocks, & MS Access 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: Leveraging VBA to Work with Charts, Stocks, & MS Access today!

Start

Looking for something else?

Browse more topics

View full catalog

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.