Excel VBA Programming Course
VBA, OOP, Excel, Programming, Beginning-Advanced
Office Productivity,Microsoft,Excel VBA
Lectures -143
Resources -139
Duration -26 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course is dedicated to everyone who wants to learn how to use VBA in Excel. You will learn how to create complex applications and perform automations in Excel environment.
In this course we will start from total basics, so you don’t need any programming experience at all to participate and learn how to code in Excel.
We will mostly focus on practical and just a little on theoretical aspect of programming in Excel. I will show you best programming techniques I have learnt myself.
We will cover topics such as enabling developer section, recording the macro, reading the recorded code, code debugging, creating user interfaces (UI), creating applications, usage of classes and objects in excel VBA.
This course is split into 6 sections in which we will discuss each of mentioned topics. We will use gained knowledge to create 3 applications in Excel.
These applications will be Life Game, Minesweeper Game and Diet Application. Each of them will present different level of task complexity. By creating these applications, we will learn different project approaches and programming techniques.
To each programming lesson there will be an attachment with excel file and code created in current lecture so it will be easier for you to follow along with the course and find bugs by comparing the code you have created, with the one from the course.
Goals
Goal of this course is to learn how to become an Excel VBA programmer starting with basic topics, ending on complex ones related to object oriented programming.
Prerequisites
- A computer installed with Windows/Linux /OS X
- Microsoft Office 2013 or newer
![Excel VBA Programming Course Excel VBA Programming Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/19986/course_19986_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction 01:27 01:27
Recording Macro
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Life Game
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Minesweeper Game
26 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Class Module & OOP
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Diet Application
87 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Summary
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Krzysztof Micko](https://www.tutorialspoint.com/assets/profiles/1384335/profile/200_1835980-1721193112.png)
Krzysztof Micko
IT, Analyst, ProgrammerHello, my name is Krzysztof Micko.
I work as an analyst and I use excel in my daily basis.
I’m also graduated programmer, I got master degree in computer science field of designing computer softwares & networks.
I like to automate pretty much every task using available universes & different programming languages.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)