Master excel vba –Yes, You can!
4.1 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,154 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master excel vba –Yes, You can! to your Wishlist.

Add to Wishlist

Master excel vba –Yes, You can!

Become a VBA programmer in no time
4.1 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,154 students enrolled
Created by Daniel We
Last updated 12/2015
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Microsoft Excel vba training
  • learn to code vba
  • Learn excel vba online easy
  • being confindent in working with vba
  • Increase your Excel productivity
  • Excel VBA Tutorials to work more efficiently
  • MsExcel vba - how to master it
  • create own progams and functions
  • learn excel vba in 1 week
  • save time through smart coding
  • increase speed in working with excel
  • Apply vba in the workplace
View Curriculum
  • MS Excel 2013 (other versions are possible too)
  • MS Excel 2007 or 2010 or 2016 also possible

Become a VBA Expert in 1 DAY! Take the challenge and master a new skill which helps you during your career. What you are still waiting for

If you enroll in this course you will learn the fundamentals of programming in vba as well as applying them in a smart way. The Excel VBA Tutorials are easy to follow and we create interesting and useful macros and learn vba programming during the lectures.

I designed the course in a way which offers students with different excel vba knowledge the perfect environment to increase their skills and become proficient with one of the most important tools microsoft has to offer. We cover basics in VBA Code as well as sophisticated tasks. Moreover we create own vba macros / vba codes together.

The course is based on Excel 2013 but other versions of excel ( Excel 2010 VBA, Excel 2016 VBA, Excel 2007 VBA) could be used to. The course is structured in several lectures with almost 3 hours of valuable content. Any student can decide on his/her own how fast he or she wants to complete the course.

Whether you want to work in the banking sector, in consulting, in an industrial company or as an entrepreneur - learn how to program in excel vba can be part of your entry ticket and this course offers the best way to hone your skills.

If the course is not helpful to you than you can use a 30 day money back guarantee. But I promise you find what you are looking for. Let's learn Excel vba together.

I am looking forward to working with you. See you in the first lecture.

Who is the target audience?
  • If you really want to learn programming in excel vba
  • If you want to create your own programs and functions
  • If you need vba for your future job
  • If you want to work more efficiently with excel
  • If you want to excel in MsExcel VBA / Microsoft Excel vba
Compare to Other Excel VBA Courses
Curriculum For This Course
43 Lectures
Excel vba - The journey begins...
1 Lecture 01:15
Let's start - covering the basics of vba
19 Lectures 01:02:50
The developer tab


Are you in the mood for coding?

Greetings from Excel

How to get the last row of a sheet? Here's how!

How to get the last row? A second way

Let's highlight the selected cell

Lonely? Excel will talk to you

Loops - saving time using the for loop

Don't like the for loop? Use the while loop instead

Different options? Then select the case


save our worksheet as a pdf

create a button to open a website

How to copy a range - quick an easy

How to copy with inputboxes

open programms with vba

Form Controls and Userforms
4 Lectures 19:07

Userforms - an introduction

Save data using userforms

File Dialog
1 Lecture 07:56
open files
The filesystem object library
4 Lectures 22:16
create folders with vba

another approach to copy files

Creating textfiles with vba

How to open textfiles and copy the content in excel
MS Word and VBA
3 Lectures 12:58
Create your worddocument and paste content with vba

Save your new word document

find and select data in word with vba
Powerpoint and Excel VBA
4 Lectures 16:05
Create your powerpoint presentation with vba

Copy data from excel into your presentation

Write Text in your presentation with vba

Finally save your presentation
Access and VBA (update 17.08.2015)
1 Lecture 08:36

Access database and code are attached to download

Need to copy data from access into your excel workbook? Do it!
VBA code Tutorials - build excel vba macros yourself
3 Lectures 19:49
get all files from a folder and save them in excel

create an awesome hyperlink-page for your excel workbook

How to get data from a website into excel? Here's how!
1 Lecture 03:34
The environ function - a helpful tool
2 More Sections
About the Instructor
Daniel We
4.5 Average rating
235 Reviews
5,863 Students
21 Courses

Daniel is a 28 year old entrepreneur ,data scientist and web analyst consultant. He holds a master degree as well as other major certificates from Google and others.

He is committed to support other people by offering them educational services to help them accomplishing their goals and becomming the best in their profession.

"In order to do the impossible you need to see the invisible"