Getting started with Virtual Forms (version 2) & Microsoft Excel

This course is for legacy version 2 of Virtual Forms for Excel, but most of the content in this course is still current for the NEW version 3.

For the new features in version 3 please register for the Webinar on the homepage.

Video on how to start and create your desktop Microsoft Excel Apps  with  Virtual Forms without coding .

Here you can watch the video and download the related examples and resources.

FREE Professional & Paginated Excel Reports without Power BI

This course is for legacy version 2 of Virtual Forms for Excel, but most of the content in this course is still current for the NEW version 3.

For the new features in version 3 please register for the Webinar on the homepage.

How to create and show Professional & Paginated Excel Reports without Power BI using Virtual Forms free Report Viewer control for viewing & Microsoft Report Builder for SSRS for creating Paginated Excel Reports.

Paginated reports or "pixel perfect" reports are long the standard report format in SQL Server Reporting Services and they are now also available in Power BI.

But starting from April 2020. the paginated reports or pixel-perfect reports are also available to Excel, Access, Powerpoint and Word users, Python developers and any other development environment that supports ActiveX technology thanks to the free Virtual Forms Control.

This means that you do not need any license to create or use and display paginated reports.

Create your paginated reports or pixel-perfect reports with free Microsoft Report Builder and display them to your users with the help of the free Virtual Forms Control component that contains the Report Viewer control.

You don't need Power BI or any subscriptions to be able to display your paginated reports in Excel or Python (we can say that this are power bi paginated reports without premium).

All you have to do is install the Virtual Forms Framework, which contains a free Virtual Forms Control that will allow you to display your pixel-perfect paginated reports.

Interested?

Then this video course is just for you.

I'm Davor Geci the author of Virtual Forms.

See us inside the course.

12 Lessons

Progress

Not started

Create Excel apps with MySQL & Virtual Forms (version 2) & Excel VBA

This course is for legacy version 2 of Virtual Forms for Excel, but most of the content in this course is still current for the NEW version 3.

For the new features in version 3 please register for the Webinar on the homepage.

  • 7.5 hours on-demand video
  • 42 downloadable resources
  • 2 articles
  • Full lifetime access

 

Step-by-step Masterclass: Create quickly Excel VBA desktop apps using MySQL & Virtual Forms & VBA Excel 2010, 2013, 2016

 

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.

It is the ability to  create CRUD Forms in Excel , forms to  create read update  and  delete records  that are stored in databases like  MySQL MSSQL Access  (On-premise or on the web) and use the data within Excel VBA and all that  in minutes .

It is similar to what Access can do, but you could also port this Virtual forms  from Excel VBA to Visual Studio 2017 (C# or VB.NET), Python,... .

You can not do this with Access VBA or natively with Excel VBA !

So, you just need to create a database and tell the Designer which fields you want on your form that is opened from Excel VBA code.

Once created Virtual Forms can be also used as  LookUp forms in Excel VBA  with no extra work, just as you would do  VLOOKUP  an  HLOOKUP  in Excel functions & formulas.

All the controls that are generated on this Virtual forms can be accessed with Excel  VBA  (or if you use Visual Studio 2017 with   C#  or  VB.NET ).

Virtual form control also fires events, so it allows us to interact with it, in a similar way normal  UserForms in Excel VBA  do. But in a more data-centric way.

Before you dive in, it’s probably a good idea to just check out the structure of the course “Create Excel VBA apps using MySQL database & Virtual Forms”.

In this course,  You will learn how to quickly create database applications using Microsoft Excel VBA and a MySQL database  that is hosted somewhere on the internet or in your building (so-called on-premise) and all that with help of the Excel VBA & a small tool called Virtual Forms.

In the first part of this course , You will learn how to  create your first database app  that will use  Excel VBA  as a front end, and a  MySQL database  as the back end. You will also learn how to install a MySQL server on your machine or anywhere in your network and use it as a data source. Also, in the first part of the course, you will learn how to install and use MySQL Workbench that help us to create and maintain MySQL databases.

Don’t worry, I will go slow!

Not only you will learn how to create your  Excel Virtual Forms  and write a few lines of Excel  VBA  code to master them,

you will also learn how you can make money with your Excel apps  by leveraging an affiliate program from a 3rd party web hosting company where you will host MySQL database.

And then, you will also  learn how to transform your Excel VBA  database applications with MySQL database as the datasource  to C# or VB.NET  with almost no change to the Excel VBA code.

We will also create Excel apps with other datasources, like Microsoft Access database and Microsoft Excel Workbook.

So, enroll now, try it out, learn new things in  Excel VBA  and  MySQL , have fun with me and create your  Microsoft Excel VBA apps in minutes. 

Join me inside NOW!

Davor

71 Lessons

Progress

Not started

Create Excel or Python App in 15 minutes using Virtual Forms (version 2)

This course is for legacy version 2 of Virtual Forms for Excel, but most of the content in this course is still current for the NEW version 3.

For the new features in version 3 please register for the Webinar on the homepage.

  • 39 mins on-demand video
  • 3 downloadable resources
  • 2 articles
  • Full lifetime access

 

Create quickly Excel GUI (no code) or Python GUI (6 lines of code) Windows desktop apps using Virtual Forms

 

You will learn the Basics of creating a Professional Excel GUI or Python GUI Windows desktop database application in under 15 minutes without coding in Excel or with just 6 lines of code in Python using a tool called Virtual Forms Framework in this Excel & Python tutorial course.

We will create a simple Virtual Form that is able to (CRUD):

  • Create new 

  • Read

  • Update

  • Delete records from database

  • Filter records in the Grid control with build in Filter functionality

No code in Excel or only 6 lines of code in Python

You need to see this!

If you want to impress your boss, colleagues, clients and also impress yourself with Excel and (or)  Python , Enroll in this course NOW !

See us inside,

Davor

15 Lessons

Progress

Not started
Pen