udemy

Build Professional GUI apps with VBA Excel : Zero to mastery


  • flag Udemy
  • student All Levels
  • database eLearning
  • earth English
  • clock 2h

About

Automate Complex Tasks with Excel VBA - Create easy to use graphical programs ( GUI ) - Real projects are given.

Covered topics:

  • Build professional graphical apps with vba excel.
  • Learn VBA programming concepts to create dynamic^ re-usable code.
  • Directly apply the Excel VBA provided scripts included to your projects.
  • Learn concepts by a concise presentation ^ then practise with excercices.
  • Learn how to connect Excel with a database using VBA ODBC .
  • Easily adjust VBA code you find to fit your projects .
  • You will be able to work as a freelancer VBA developper
  • Explore the powerness of using VBA solutions.
  • Real life projects scripts are provided in complement.

Description

Join me in this course and take control of , Excel VBA ^ you will master the process of automating common tasks through the use of , Macros and Excel VBA scripts .


I ll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow^ save time and automate your current Excel projects.


My course is manually subtitled &, has mainly two parts :


  • A theoritical presentation with slides : You will discover the fundamental concepts , and syntax - I m providing only , useful VBA codes you can directly use for your work - My scripts are already runned &, verified !


  • Practical excercices : , You will enhance the knowledge you acquired by a number of usefull excercices that contains also some kind of course comlements. Here you will learn how to create a VBA graphical program ( Forms ^ Buttons ^ etc ) with crud operations ( Add ^ modify ^ delete ^ display data ). , You will get familiar with loops and conditions ^ understanding and resolving a problem ^ managing of files ^etc . , The scripts for each section are provided with comments.


Go from Beginner to Microsoft Excel VBA Expert!


Don’t waste your time

Don t waste your time on poor quality videos and confusing explanations. In this Excel VBA course^ complex topics are taught in a simple manner by the instructor . The content has been carefullyorganized. The videos are high quality and they are fully subtitled . Most importantly you will learn VBA by doing. The presentation explains clearly the concepts in a pedagogic manner. Each excercice has 1 video to understand the problem and how to solve it.

In this course I used my knowledge that i acquired during my studies at engineering school^ as well as my own touch as a developer.

During my educational^ I have learned that programming is the key to implement any industrial solution. It doesn’t suffy to find a solution for an industrial problem^ the firm usually need to automate algorithms.

I have collaborated with professionals during my trainings^ and I succeeded in providing realistic solutions for different situations. I used programming especially in my graduating project^ I remember implementing a vba graphical interface to improve quality of a database called (plan for every part) as a phase in reducing the “transport order exceptions and premium freight”. In addition ^ i created a vba interface for printing customized labels in a real industrial problem.

Recently ^ i learned how to realize interactions between VBA and R language using Bert .

Now I’m working as a freelancer developer in parallel with teaching programming languages to individuals. My PhD subject is about developing a fast neural network method for data classification using self-mapping cards.

I spend most of my time researching how to make hard concepts easy to understand. In this &, upcomming courses^ you ll find pedagogic explanations with animations to make sure everything is easy for participants. I m using mainly slides and live coding .


What you can look forward to in this course ,  ,:


  • Understand how to use the right syntax in VBA

  • Clear and consice presentation of concepts , clear syntax .

  • All Scripts are verified and provided ^ concerning the presentation just copy &, past them in vba editor.

  • The course is subtitled with high quality ( manually ) .

  • Useful Excel VBA codes you can directly use for your work with comments.

  • 1 video for each excercice .

  • Working with the Visual Basic Editor

  • errors handling .

  • Different methods to access ranges and cells properties.

  • Different options for loops and conditions.

  • How to work with data types

  • Basically all the knowledge you need to automate tasks in Excel.

  • In complements ^ you will be provided with articles tutorials to create a database ( using phpmyadmin ) and to access a database like mysql , ( with ODBC ). Also ^ you will be provided with scripts for handling pictures in vba . Other lists of unkown vba tips and functions will be also provided soon.


NB:

· If this training does not satisfy you then you can get a refund within 30 days.

· Once you have joined the training^ you have access to it for life.

· You also have free access to any updates I bring to this training.

· You can send me personal messages with any questions or suggestions regarding the training.

· Have a look at content plan.


So^ don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel

to your work for you.


After enrolling the course :


1/ Desactivate the udemy subtitles ^ My subtitles are already in the videos .

2/ Choose the Full screen mode .

3 / Raise up the volume to be at high at possible .

4 / Last ^ i prefer using headphones or even earphones to improve your listening excperience .