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
AdvancedTime to complete
Approx. 2 hoursCertificate 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. Reviews from learners
- 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 WVerified Learner
- Everything Codecademy offers is useful for all software developers.Fidan MVerified 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 HVerified Learner
Our learners work at
How To Tell If You’re “Proficient In Excel” & How To Get Better


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.
Join over 50 million learners and start VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access today!
StartLooking for something else?
Related courses and paths
- Free course
VBA: Building User Interfaces with Forms in VBA & Excel
Create complex Excel user interfaces with VBA. Learn form validation, complex controls usage, and secure email sending via VBA.Intermediate1 hour - 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.Beginner Friendly2 hours - Free course
Visualize Data with Excel
Learn how to create and customize pie charts, bar graphs, and other data visualizations with Microsoft Excel.Beginner Friendly1 hour
Browse more topics
- Data analytics2,626,781 learners enrolled
- Code foundations7,666,830 learners enrolled
- Computer science6,129,488 learners enrolled
- Web development5,138,381 learners enrolled
- Data science4,665,587 learners enrolled
- Python3,766,094 learners enrolled
- For business3,533,935 learners enrolled
- JavaScript2,942,537 learners enrolled
- IT2,581,368 learners enrolled
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.