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.
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.
Courses : 1
Specification: Create Excel apps with MySQL & Virtual Forms & Excel VBA
13 reviews for Create Excel apps with MySQL & Virtual Forms & Excel VBA