Master excel vba –Yes, You can!
4.1 (15 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,123 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 (15 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,123 students enrolled
Created by Daniel We
Last updated 12/2015
English
Current price: $10 Original price: $30 Discount: 67% off
20 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • MS Excel 2013 (other versions are possible too)
  • MS Excel 2007 or 2010 or 2016 also possible
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 43 Lectures Collapse All 43 Lectures 03:00:31
+
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
00:48

Hello...
02:01

Are you in the mood for coding?
06:07

Greetings from Excel
02:59

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

How to get the last row? A second way
02:27

Let's highlight the selected cell
03:29

Lonely? Excel will talk to you
01:35

Loops - saving time using the for loop
02:38

Don't like the for loop? Use the while loop instead
02:34

Different options? Then select the case
03:17

Constants
02:00

save our worksheet as a pdf
03:01

create a button to open a website
03:43

How to copy a range - quick an easy
03:29

How to copy with inputboxes
05:44


open programms with vba
02:23

Arrays()
05:51
+
Form Controls and Userforms
4 Lectures 19:07

Userforms - an introduction
06:45

Save data using userforms
06:17

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

another approach to copy files
04:08

Creating textfiles with vba
05:38

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

Save your new word document
02:15

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

Copy data from excel into your presentation
02:53

Write Text in your presentation with vba
05:00

Finally save your presentation
02:26
+
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!
08:36
+
VBA code Tutorials - build excel vba macros yourself
3 Lectures 19:49
get all files from a folder and save them in excel
05:30

create an awesome hyperlink-page for your excel workbook
06:45

How to get data from a website into excel? Here's how!
07:34
+
Bonus
1 Lecture 03:34
The environ function - a helpful tool
03:34
2 More Sections
About the Instructor
Daniel We
4.4 Average rating
77 Reviews
4,119 Students
8 Courses
Traveller

Daniel is a 28 year old entrepreneur and consultant. He has a master degree in Economics as well as several additional qualifications and work experience in the finance and consulting industry. His passion is Data & Analytics and Machine Learning.

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.

"Life is a journey, and I will give my best to help you on your way to your goals"