Latest Courses
DigitalOcean Cloud Platform FundamentalsCheck course
Vue and Laravel AuthenticationCheck course
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
Learn to create a 2D Idle Miner Tycoon Game in Unity 2020Check course
How to Create a WebApp using Google Apps Script webPagesCheck course
Docker for .Net and Angular DevelopersCheck course
Scala Programming From Scratch To DepthCheck course
ASP.NET Core MVC - Up and Running Part 1 (.NET 5)Check course
DigitalOcean Cloud Platform FundamentalsCheck course
Vue and Laravel AuthenticationCheck course
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
- 86% Create Excel apps with MySQL & Virtual Forms & Excel VBA

Create Excel apps with MySQL & Virtual Forms & Excel VBA

$94.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 1
Add to compare
9.0/10 (Our Score)
Product is rated as #6 in category Excel

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 FormsYou 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

Davor is a veteran programmer with 20 years of being a professional programmer and 15 years of building companies as CEO or helping others as an HR consultant in employee recruitment. Specialties: VB, VBA, Error Handling, Google Analytics, Azure Application Insights, SQL, Databases, Excel, Access, MySQL, MSSQL. Currently: CEO & Founder at WinPIS Recent projects: Virtual Forms for Microsoft Excel VBA (NEW UserForms for Excel VBA) VBA Telemetry (connect VBA & Google Analytics or (and) Microsoft Azure Application Insights) Recent projects in detail: Virtual Forms for MS Excel VBA: Simple but powerful Userform control for Excel VBA so that anyone can use it, even without a single line of Excel VBA code! Create few sheets in Excel Workbook, or create few tables in the database like MySQL. Tell the Virtual Form Designer which fields you want that UserControl will use. And you re done. ##################################### VBA Telemetry: Log & Track Events, Metrics & Errors from VBA (Excel, Access, Word, Powerpoint, ...) projects in real-time using Google Analytics or (and) Microsoft Azure Application Insights. VBA TELEMETRY: Allows us to log and track events, metrics and errors from VBA in real-time. Track usage of your VBA (Excel workbooks, Access projects) from around the world. Example: You have created a killing Microsoft Excel Workbook or Access project. Then you distribute this Excel Workbook or Access project to your users or customers. But how do you know if there are any errors, what parts of your VBA project is used the most, which function, routine or part of the code is executed faster or slower on your users or customers computers, or is it used at all? Now you can, with help from VBA Telemetry and Google Analytics or (and) Microsoft Azure Application Insights. IN A NUTSHELL: Add online Error Tracking, Usage Tracking of your Excel Workbooks, Access projects or any VBA project, from around the world.

Specification: Create Excel apps with MySQL & Virtual Forms & Excel VBA

Duration 8.5 hours
Year 2020
Level Intermediate
Certificate Yes
Quizzes Yes

13 reviews for Create Excel apps with MySQL & Virtual Forms & Excel VBA

4.6 out of 5
9
3
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    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!!!

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Jon A

    Excellent teaching approach.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    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!

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Warren Hall

    Good pace, thorough, sufficient detail. Easy to follow. Enormous amount of information presented, but with complete detail.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Johan Lambrechts

    Very interesting.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Danish Ali

    wonderful experience, Learned some new things that are explained in this course in simple and easy steps.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Antonio Tiu

    Easy to understand

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Miguel Villegas

    Excellent choice for beginners.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Probyncope

    early yet

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Moreida

    Very easy to follow really excited!!!

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    Michele Smith

    You are wonderful! You explain everything very easy and make it easy for me to follow along. Thank you so much!

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Create Excel apps with MySQL & Virtual Forms & Excel VBA
    Create Excel apps with MySQL & Virtual Forms & Excel VBA

    $94.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare