Master excel vba –Yes, You can!

Become a VBA programmer in no time
4.2 (14 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.
928 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 43
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

Students who enroll in this course 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.

I use 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.


What are the requirements?

  • MS Excel 2013 (other versions are possible too)
  • MS Excel 2007 or 2010 or 2016 also possible

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel vba - The journey begins...
Einleitung
Preview
01:15
Section 2: Let's start - covering the basics of vba
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
Lost something? MS Excel vba will find it!
Preview
05:43
open programms with vba
02:23
Arrays()
05:51
Section 3: Form Controls and Userforms
Form controls - A Microsoft Excel VBA Tutorial
Preview
03:20
Userforms - an introduction
06:45
Save data using userforms
06:17
create your own function in vba
Preview
02:45
Section 4: File Dialog
open files
07:56
Section 5: The filesystem object library
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
Section 6: MS Word and VBA
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
Section 7: Powerpoint and Excel VBA
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
Section 8: Access and VBA (update 17.08.2015)
08:36

Access database and code are attached to download

Section 9: VBA code Tutorials - build excel vba macros yourself
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
Section 10: Bonus
The environ function - a helpful tool
03:34
Section 11: The End?
Words from your instructor
01:16
Section 12: Teaser from my other Excel Course
vlookup with 3 different tables
04:49

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniel We, Traveller

Daniel is a 28 year old entrepreneur and consultant. He has a master degree in Finance and Acounting as well as several additional qualifications and work experience in the finance and consulting industry.

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"

Ready to start learning?
Take This Course