Visual Basic for Applications - Excel VBA - The full course (Udemy.com)

Learn how to do macros in EXCEL VBA and applications to automate Microsoft Excel with Visual Basic for applications

Created by: Daniele Protti

Produced in 2019

icon
What you will learn

  • create your own macro in Excel
  • program in VBA
  • understand Visual Basic for Applications
  • create automated reports in Excel
  • develop your applications and tools in Excel

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 68 / 100

icon
Course Description

The course is composed of more than 200 videos. Each lesson is composed of one of more videos. The videos are created by experts developing applications using Visual Basic for Application (VBA) for MS Excel or MS Access for small, middle and large companies as consultants and as managers and coach for internal processes. These experts have created complex tools to create the reporting structure and manage the business processes. An extended version will include also real examples to be used directly in working and office processes.You will learn from the basic concepts to the principles to build your own applications in Excel using VBA.You will understand and digest the concept of object oriented programming and remove your barriers from being scared to see programming code.You will be able to retrieve data from databases or other files and present them in Excel files.You will create automated procedure to format data, display information and create complex reports and graphs.Who this course is for:
  • software developers
  • accounters
  • employees in HR, Finance, Accounting
  • Business Analysts
  • Business Intelligent developers
  • Project manager
  • Quality managers

icon
Instructor Details

placeholder

I have 20+ years experience in IT project management, software development and software architecture.
I have led several teams of software developers as project manager, quality manager and as team leader in different companies and different countries in sectors e.g. telecommunication, research & development, travel business, Internet marketing and Internet business, consultancy and services.
I have been responsible to collect the requirements of projects, applications and processes, design the databases and specify the final objects.
During my career I have accumulated a lot of experiences dealing with processes of any kind and the need to define the tools to manage them and collect the information.
Most of my tools have been written in VB, VBA, C++, C#, Java, PHP, Javascript using databases e.g. Informix, Postgres, Oracle and MySql.
I have organized all my experiences in courses which are not only a list of functions and methods but contain also my practical experiences and considerations about how to cope with the different situations and which solutions to suggest.

icon
More courses by Daniele Protti

How to create your own software company

$11.99

icon
More visual basic .net courses

Basic C# Clearly Explained

$11.99

Let's Code: VB.Net Exercises for Beginners

$11.99

Learn To Program Tic-Tac-Toe with C# and Visual Studio

$11.99

What's New in C# 6, C# 7 and Visual Studio 2017

$11.99

Beginners Guide To C# With Visual Studio 2017

$11.99

VB.NET Introduction

$11.99

icon
Reviews

3.4

128 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Julio Cesar Costa Beber on 12/20/2020

Ainda no tenho todos elementos para fazer uma avaliao

By Nagendra Shivaswamy on 10/11/2020

Volume for initial 2 modules are too low. Video quality can be better. Session can be more energetic.

By Vijay Singh on 10/1/2020

Excellent course.Due to this course I got a job as a VBA Developer in a Big MNC...

By Seth Wudel on 5/24/2020

its early

By Ogden Mitchell on 5/20/2020

Tutorial is very good and thorough but it would be good to add in a few more 'why' explanations. Example: We jump right into the on open objects but we don't talk for 30 seconds about why we would want to take action on open. These explanations plant the seed on when to use a given object. Just learning the object without as much context is not as helpful

By Peter Hirsch on 5/10/2020

Kurs nicht hilfreich. Sprache schlecht verstndlich. Zu hektisch

By Chandra Shekhar Joshi on 4/22/2020

good

By Xiangping xu on 4/19/2020

Very good!

By Klajdi Hysa on 4/3/2020

No till now no ,i expected more

By christopher Boyd on 3/22/2020

The course is chaotic.
Many leaps assuming either more or less knowledge of the subject, introducing ideas without explanation and using multiple versions of Excel for the various lessons.

By Christina on 3/1/2020

I like this course and look forward to learning more

By Eduardito Martinez on 2/11/2020

I am new and this instructor is very thorough