Create Excel or Python App in 15 minutes using Virtual Forms

4 Chapters 15 Lessons

About this course

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

Start Course

Course Structure

Introduction 1 Lesson

Introduction: Create Excel Apps in 15 minutes using Excel & Virtual Forms

Available in Solo & Team Plans

Create Excel Desktop apps using Virtual Forms with no coding 10 Lessons

Overview of the final Excel application, which we will create

Resources used in course (Virtual Forms Setup, Excel workbooks & Python code)

For the latest version of Virtual Forms Framework setup go here:

Download Page

Here is the download with old version of Virtual Forms Framework, but you can use the examples, templates and other files from this download:

Download link

MyExcelAPP.zip

VFFilePython.zip

Preparing the environment, Virtual Forms Framework installation

Preparing the Excel Blank Tamplate and VF Definition file

Open the Virtual Forms Designer within Excel Blank template

Create your first Virtual Form for Excel using Virtual Forms Designer

Open your first Virtual Form in Excel

Create your second Virtual Form in Excel

Create a LOOKUP Virtual Form in Excel

Create a MASTER DETAIL Virtual Form in Excel

Available in Solo & Team Plans

Create Python desktop apps using Virtual Forms & MySQL 3 Lessons

Intro to Python and Excel using Virtual Forms Framework

Python - 6 lines of Python code to run Virtual Forms in Python

Python - Create Virtual Form in Designer and call it in Python

Available in Solo & Team Plans

Conclusion 1 Lesson

Conclusion & Thank You

Teacher

Davor Geci

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.