
Microsoft Excel & Microsoft Power BI are the most popular and used tools for analyzing and visualizing data.
BUT, Microsoft Excel is not created for gathering data, especially in gathering relational data like master–detail structures.
One basic, simple Excel example. You want to gather (or track) Orders in Excel and then for this Orders you want to track Order Details and, for example, Order Payments and all that using Excel.
Not to mention, to do this in a multi–user environment also in Excel
Boy, .., You will have a tough time to do this with Excel, because Excel is simply not created for challenges like this, to gather master–detail data and also in a multi–user environment within the normal Excel environment.
But in this course Create Excel VBA apps using MySQL database & Virtual Forms , You will learn how you can do this by using Excel VBA as a front end and MySQL database as a backend, whether the MySQL database is on your local machine, your local network, or on the web server. We will do this with help of a small tool called Virtual Forms.
Hello,
I m Davor Geci the CEO and the Lead Developer of WinPIS, the company that s behind a popular tool that brings to Excel what Access developers are having for decades.
Instructor Details

Courses : 1
Specification: Create Excel apps with MySQL & Virtual Forms & Excel VBA
|
13 reviews for Create Excel apps with MySQL & Virtual Forms & Excel VBA
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.

Price | $12.99 |
---|---|
Provider | |
Duration | 8.5 hours |
Year | 2020 |
Level | Intermediate |
Language | English |
Certificate | Yes |
Quizzes | Yes |

$94.99 $12.99
Wiola –
Love this course. It is useful guide how to work with virtual form. I met first time with this tool on udemy and I think it is great solution for excel GUI. Good job codesigners!!!
Jon A –
Excellent teaching approach.
Santiago C. Gloria –
It’s somehow exciting and what a great experience! Indeed, this would help me significantly in Managing our logistical & Statistical data in our office. What Great a inputs!
Warren Hall –
Good pace, thorough, sufficient detail. Easy to follow. Enormous amount of information presented, but with complete detail.
Wendell Keithan –
Not to far in to but already feel i am learning a lot. great teacher with a down to earth way about him. if you love excel and databases as i do thinking you will love this course. thanks you Davor i finished the course the only thing is sad i did Davor you are a great teacher. i am now going tru again to see what i might have missed. and practice and use it to remake some of my other programs better.
Johan Lambrechts –
Very interesting.
Ben Narbutas –
Couldn’t get MySQL to extract as a program. It extracted as a folder and couldn’t work out how to run it as a program file. Eventually went to another website and downloaded as a program file and ran.
Danish Ali –
wonderful experience, Learned some new things that are explained in this course in simple and easy steps.
Antonio Tiu –
Easy to understand
Miguel Villegas –
Excellent choice for beginners.
Probyncope –
early yet
Moreida –
Very easy to follow really excited!!!
Michele Smith –
You are wonderful! You explain everything very easy and make it easy for me to follow along. Thank you so much!