Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Advanced Excel: New Data Entry Forms - start without VBA

via Udemy

Overview

Excel with this A-Z Guided Excel Course. Easy way to create Excel User Forms with MySQL database. Start without VBA.

What you'll learn:
  • Create Modern and Impressive Excel User Forms Without a Single Line of VBA Code.
  • Become one of the Top Excel users in your team and Leave Your Boss Speechless.
  • You Will Get the Virtual Forms for Excel for FREE from the creator of the tool himself as a gift for buying the course.
  • Make your work-life easier with Excel VBA advanced techniques, tips and tricks to Skyrocket your Productivity in Excel.
  • Transform your Excel Database to a Relational Excel Database.
  • Learn how to easily create MySQL databases using Free MySQL Workbench, cutting out the useless fluff and filler.
  • Create Professional Excel Lookup Forms and Master-Detail Forms Without Coding.
  • Impress with Professional & Paginated Pixel-perfect Reports created with Microsoft Report Builder right from Excel.
  • Get Access to a Professional Trainer with 20+ years of experience in programming and database development.

______________________________________________________________________________________________

November 2021 announcement:

Starting in November 2021, I started recording all the videos from scratch and replacing section by section with new videos and materials.

New videos and materials are based on the new version 3 of Virtual Forms for Excel which along with the new modern design also simplifies certain processes and adds new and advanced functionalities.

Take this course and you will receive educational emails when I post new videos and materials and when I replace existing ones.

Within the course resources, you can download for free a fully functional version 3 of Virtual Forms for Excel which is not limited in any of the features. Since I am the creator of the Virtual Forms for Excel tool, this is my gift to you when you buy this course.

______________________________________________________________________________________________


6 Courses in 1

Covering 6 major Excel & Databases topics - this course is "incredible value for money!" as one student said.

We'll cover:

  1. Excel Advanced Tips, Tricks & Techniques.

  2. Excel VBA Advanced Techniques.

  3. How to create MySQL databases Step by Step.

  4. Create New Modern Excel Data Entry Forms with Virtual Forms.

  5. How to create Master-Detail (Parent-child) & Lookup Forms in Excel without Coding (using Virtual Forms).

  6. How to convert Virtual Forms from Excel VBA to Visual Studio .NET to remove the dependency on Excel.


Microsoft Excel&Microsoft Power BIare 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 likemaster-detail structures.

One basic, simple Excel example.You want to gather (or track) Orders in Excel and then for these Orders you want to track Order Details and, for example, Order Payments and all that using Excel as the Excel database.

Not to mention, to do this in amulti-user environment also in Excel.


Boy,….., You will have a tough time doing this withExcel, 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,You will learnhow you can do this byusing Excel VBAas a front end andMySQL databaseas a backend, whether the MySQL database is on your local machine, your local network, or on the webserver.We will do this with help of a small tool calledVirtual 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 tocreate CRUD Excel VBA Forms, forms tocreate,read,updateanddelete recordsthat are stored in databases likeMySQL,MSSQL,Access(On-premise or on the web), and use the data within ExcelVBAand all thatin minutes.

It is similar to what Access can do, but you could also port these Virtual formsfrom Excel VBA to Visual Studio (C# or VB NET)


You can not do this with Access VBA ornatively with Excel VBA!


So, you just need to create a database and tell the Designer which fields you want on your form.

Once created, Virtual Forms can be also used asLookUp forms in Excel VBAwith no extra work, just as you would doVLOOKUPandHLOOKUPin Excel functions &formulas.


All the controls, that are generated on these Virtual forms, can be accessed with ExcelVBA(or if you use Visual Studio withC#orVB NET).

Virtual form control also fires events, so it allows us to interact with it, in a similar way normalUserForms in Excel VBAdo. 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.

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


In the first part of this course, You will learn how tocreate your first database app (Excel VBA forms)that will useExcel VBAas the front end, and aMySQL databaseas 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!


And then, you will alsolearn how to transform your Excel VBAdatabase applications with MySQL database as the data source,to C# orVB NETwith almost no change to the Excel VBA code.


If you ever get stuck with something in the course, (likeExcel VBA code or MySQL databases) just post a message in the Q&A of this course and I will respond as soon as I can to help you out.


I do everything I can to make this a 5-star course and I hope you like it too and leave a review.

Feel free to take a look at preview lectures and the course description before making a decision to buy.

And yes, this course is covered withUdemy30-day money-back guarantee.

You don’t have anything to lose.


So, enroll now, learn new things inExcelVBAandMySQL, have fun with me and create yourMicrosoft Excel VBA appsin minutes.


Join me inside NOW!

Davor

Taught by

Davor Geci

Reviews

Start your review of Advanced Excel: New Data Entry Forms - start without VBA

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.