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.
· 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 .
Plz download presentation support (.pptx ) in this session .
A brief introduction for using relational databases !
You will get familiar with mysql !
In this part, you’ll learn how to create a database with tables in phpmyadmin (graphical mode).