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!
Start
Looking for something else?
Related courses and paths
- Create complex Excel user interfaces with VBA. Learn form validation, complex controls usage, and secure email sending via VBA.
- Intermediate.1 hour
- Leverage Excel's VBA tool for operations, macros, and debugging. Learn to format cells, manage sheets, and utilize FormatConditions object.
- Beginner Friendly.2 hours
- Learn how to create and customize pie charts, bar graphs, and other data visualizations with Microsoft Excel.
- Beginner Friendly.1 hour
Browse more topics
- Data analytics3,144,087 learners enrolled
- Code foundations8,429,067 learners enrolled
- Computer science6,919,179 learners enrolled
- Web development5,653,895 learners enrolled
- Data science5,245,166 learners enrolled
- Python4,239,851 learners enrolled
- For business4,040,765 learners enrolled
- JavaScript3,174,903 learners enrolled
- IT3,092,060 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.