Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Excel vba - The journey begins...|
|Section 2: Let's start - covering the basics of vba|
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
Lost something? MS Excel vba will find it!Preview
open programms with vba
|Section 3: Form Controls and Userforms|
Form controls - A Microsoft Excel VBA TutorialPreview
Userforms - an introduction
Save data using userforms
create your own function in vbaPreview
|Section 4: File Dialog|
|Section 5: The filesystem object library|
create folders with vba
another approach to copy files
Creating textfiles with vba
How to open textfiles and copy the content in excel
|Section 6: MS Word and VBA|
Create your worddocument and paste content with vba
Save your new word document
find and select data in word with vba
|Section 7: Powerpoint and Excel VBA|
Create your powerpoint presentation with vba
Copy data from excel into your presentation
Write Text in your presentation with vba
Finally save your presentation
|Section 8: Access and VBA (update 17.08.2015)|
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
create an awesome hyperlink-page for your excel workbook
How to get data from a website into excel? Here's how!
|Section 10: Bonus|
The environ function - a helpful tool
|Section 11: The End?|
Words from your instructor
|Section 12: Teaser from my other Excel Course|
vlookup with 3 different tables
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"